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

Discuss the spreadsheet application

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

Postby smiths » Wed Jan 23, 2019 3:13 am

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).
OpenOffice 4.1.6
Posts: 1
Joined: Wed Jan 23, 2019 3:01 am


Postby robleyd » Wed Jan 23, 2019 3:40 am

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?
Apache OpenOffice 420m2(Build:9821) - Slackware 14.2 - 64 bit
LibreOffice - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
Posts: 3516
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

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

Postby Lupp » Wed Jan 23, 2019 1:28 pm

-1- You shouldn't expect a cooperative attitude of MS Office 365 concerning free competitors.

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.
On Windows 10: LibreOffice 7.0 and older versions, PortableOpenOffice 4.1.7 and older, StarOffice 5.2
Lupp from München
User avatar
Posts: 2930
Joined: Sat May 31, 2014 7:05 pm
Location: München, Germany

Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests