Thank you Jorge.
I have checked this. The Mac settings are OK. It works with Excel fine
and Apple Numbers. Mac settings are to show decimal as "."
I have some LO Calc sheets that were created a few years ago that are
OK. It seems to be some change in the last few versions??
Would you know if there are any override settings in the LO Preferences?
I can't find it if it exists.
Thanks again.
B.
On 28.07.2017 17:46, jorge Rodríguez wrote:
Hi :
I don't have a Mac, I use GNU / Linux Ubuntu...but usually that
kind of issues are define with the Operative System. Try to find how is
it define it in you Mac. Probably is as " , " and you have to change to
" . " as you use it in Canada.
Regards,
Jorge Rodríguez
El 28/07/2017 a las 14:50, bunk3m escribió:
I'm having a struggle with Calc. I trying to migrate over from Excel
but have a problem.
When I type [=1+1.5] into a cell, I get "Invalid Name" error. If I
save the file as an xlsx and open in Excel it calculates OK and give
2.5. If I then open the xlsx in LO, it still says "Invalid Name".
If I put [=1+1,5], I get ERR: 509. This makes sense since I'm in
Canada and we use "." to separate decimals.
If I put [=1+1] LO correctly calculates "2" with no error.
I have older LO spreadsheets that calculate OK. Every new CALC
spreadsheet has this problem.
I'm not sure how to figure out why I get this error and why LO won't
calculate such a basic equation.
What should I be looking at?
Mac OSX 10.10.5
LO 5.3.4 & 5.4
I'm on daily digest mode so please cc me when you reply to the list.
Thank you in advance.
B.
--
To unsubscribe e-mail to: users+unsubscr...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
