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

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

Re: FORMULA AND LINK SPREADSHEET OPENOFFICE CALC

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?
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2643
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.

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


Return to Calc

Who is online

Users browsing this forum: Zizi64 and 13 guests