Page 1 of 1

AOO Calc formulas and links don't work in Office 365

Posted: Wed Jan 23, 2019 3:13 am
by smiths
Hi.....
I using openoffice calc with some formula and spreadsheet created together.
The problem is when I use Microsoft Office 365 to open the openoffice calc file............the formula and spreadsheet link is not function.
Any solution or patches from openoffice need to install?

Title Edited. A descriptive title for posts helps others who are searching for solutions and increases the chances of a reply (Hagar, Moderator).

Re: FORMULA AND LINK SPREADSHEET OPENOFFICE CALC

Posted: Wed Jan 23, 2019 3:40 am
by robleyd
Possibly this is due to a difference in the argument separator used by the two software. Of course this is a guess on my part as you haven't given much information to work with.

What is your OS? What is the value for Locale setting in Tools | Options | Language Settings | Languages; replace Tools | Options with OpenOffice | Preferences if you are using a Mac. Can you provide a specific example of a formula that fails, together with the error you get?

Re: AOO Calc formulas and links don't work in Office 365

Posted: Wed Jan 23, 2019 1:28 pm
by Lupp
-1- You shouldn't expect a cooperative attitude of MS Office 365 concerning free competitors.

-2-
smiths wrote:...the formula and spreadsheet link...
I am afraid you won't get useful replies as long as you don't tell what formula (kind of formula) and what "spradsheet link" you are talking of.

Attach a reduced example of an .ods you run into this problem with.