Re: [libreoffice-users] Calc - Invalid name error - help request

2017-07-28 Thread jorge Rodríguez
Hi again: I suggest to do this in the Language-Language settings: *User Interface: Select English US *Locale Settings: English (Canada) *Decimal Separator Key: uncheck *Default Currency: Default CAD (English or French) *Default Language for

Re: [libreoffice-users] Calc - Invalid name error - help request

2017-07-28 Thread jorge Rodríguez
Hi: In LO Preference (Menu-Tools-Options-Language settings), you can find some ways to customize your settings. I hope this help, Jorge Rodríguez El 28/07/2017 a las 16:11, bunk3m escribió: Thank you Jorge. I have checked this. The Mac settings are OK. It works with Excel fine

Re: [libreoffice-users] Calc - Invalid name error - help request

2017-07-28 Thread Regina Henschel
Hi, bunk3m schrieb: 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

Re: [libreoffice-users] Calc - Invalid name error - help request

2017-07-28 Thread bunk3m
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

Re: [libreoffice-users] Calc - Invalid name error - help request

2017-07-28 Thread jorge Rodríguez
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

[libreoffice-users] Calc - Invalid name error - help request

2017-07-28 Thread bunk3m
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".