Re: [libreoffice-users] Calc - Invalid name error - help request
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 El 28/07/2017 a las 18:14, jorge Rodríguez escribió: 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 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
Re: [libreoffice-users] Calc - Invalid name error - help request
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 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
Re: [libreoffice-users] Calc - Invalid name error - help request
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 -- 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
Re: [libreoffice-users] Calc - Invalid name error - help request
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
Re: [libreoffice-users] Calc - Invalid name error - help request
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
[libreoffice-users] Calc - Invalid name error - help request
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