Calc - Invalid name error - help request

users
#1

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.

#2

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

#3

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.

#4

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 versions??

Would you know if there are any override settings in the LO Preferences?
I can't find it if it exists.

There exists the setting in Tools > Options > Language Settings > Languages, where you can determine the decimal separator key.

In addition there is a setting "Ignore system input language", but I don't know, what effect it has.

Another setting is in the cell properties in Format > Cells. On the tab "Numbers" you find top right a "Language" drop-down list. You can determine the language for numbers independent from UI. Do not use the "Default - xyz" but select the correct language explicitly.

That the places I know, which might influence it.

Kind regards
Regina

#5

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

#6

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 Documents: A English Canada or French

         *Ignore system input language: check

         I did this in my LO, and restart LO, and then LO accept " . " as decimal separator key

I hope this help,

Jorge Rodríguez