Dear all; this is something which comes from OpenOffice. If you are using Italian as your language, then there's no way to set the period rather then the comma as the decimal separator. The only workaround seems that of setting Italian (Swiss) instead of Italian (Italy) as the language. Also, if you do so, your dates in your spreadsheet get screwed up (for instance I had some dates starting from 2012 and somehow after this small change they started from 2010…). Thank you very much for your time and for your efforts. Best regards Lorenzo
You can change the default settings - Tools>Options>Language Settings>Languages>Decimal separator key. From the LibreOffice Help: Decimal separator key - Same as locale setting Specifies to use the decimal separator key that is set in your system when you press the respective key on the number pad. If this checkbox is activated, the character shown after "Same as locale setting" is inserted when you press the key on the number pad. If this checkbox is not activated, the character that your keyboard driver software provides is inserted.
Sorry, seems it doesn't solve your problem - just found this at bug 42533 comment 1: "This option defines only what character is inserted when you press the decimal separator key on the numeric keypad. It does not define the decimal separator for your locale."
(In reply to comment #0) > Dear all; > this is something which comes from OpenOffice. > ... so version should be "inherited from OOo"
This is an old report with no version details and limited information about UI/language configuration settings. I have just tested versions 4.1.5, 4.2.1 & 4.2.2.1 on Win XP, 7 & Linux (64) RPM, with an Italian UI & language settings and the thousands separator (.) and decimal point (,) default to the correct Italian usage. If the UI is set to English with Italian language settings, a warning message does appear to say that the number separators will default to the UI language. Considering the age of this report I suggest that it be closed as FIXED or WON'T FIX and (if considered necessary) a RFE be opened for an option to set the number separators when a different UI language is in use.
Waiting for feedback , so I put in NEEDINFO
actually setting NEEDINFO, as wanted by Julien.
*** Bug 73482 has been marked as a duplicate of this bug. ***
Honestly, I still cannot get it to work as I would… If Italian is selected as "Locale setting" there's no way to get a period as separator, regardless of "Same as locale setting" checked or not. On the other hand, if English (USA) is selected as "Locale setting" there's no way to have a comma as separator… Using LO 4.3.5.2 on Mac OSx 10.10.1 with System Language set to Italia and period as decimal separator. Please let me know if I can provide additional information.
@lore I'm italian too. probably you cannot use the "period" instead of the "comma" as a decimal separator in italian since this is a rule of italian typography. so it seems you are willing to use LibO against typographycal rules of italian language, isn't it?
Yes, I think that's the case. In my opinion you should be able to select the separator regardless of the language you are using… Regards Lorenzo
> Yes, I think that's the case. In my opinion you should be able to select the > separator regardless of the language you are using… > > > Regards > > Lorenzo I have mixed feelings about this. should we allow users to do what they want (setting the decimal separator regardless of the language) even if this is against some countries typographic rules? I'm afraid that such a change could generate interoperabilty conflicts among users of the same locale but using different settings. let's hear what the UX-advise guys thinks about this.
Andras: thought you might be interested in this one since it's about i18n
Two comments: 1. I think users should be able to select whatever separator they wish (as in excel). 2. If the separator is inherited from locale anyway, what's the purpose of "Same as locale setting" 's checkbox?
I think help is clear about the option: https://help.libreoffice.org/scalc/cui/ui/optlanguagespage/decimalseparator?Language=en-US&System=WIN&Version=4.4#bm_id2873012 " Decimal separator key - Same as locale setting Specifies to use the decimal separator key that is set in your system when you press the respective key on the number pad. If this checkbox is activated, the character shown after "Same as locale setting" is inserted when you press the key on the number pad. If this checkbox is not activated, the character that your keyboard driver software provides is inserted. " Maybe changing it at OS level is the way.
Thanks for the instructions. Unfortunately, as already said, my system decimal separator is already set to period, yet, I couldn't find any way to set the period in LO while keeping the language setting to Italian. As I'm on a laptop, I don't have any number pad.
Reading again I have seen comment #2. I don't know in Mac but in Win there is a MS keyboard layout creator http://msdn.microsoft.com/es-es/goglobal/bb964665.aspx, to customize the keyboard. Maybe something similar in Mac and Linux what I think can help to solve the issue with all program, setting up what character any key may returns, works fine for me changing dot for comma with numeric keypad in Win
Not sure I'm following… are you suggesting to somehow assign the period to the comma key?
If that solves what you want, why not.
Because the issue here is not to press a comma instead of a period. The issue here is that if you calculate =3/2 LO returns 1,5 no matter what and there's no way that I know of to get 1.5 instead. At the same time, there's no way to get 1.5 (entered directly in a cell) recognized as a number instead of text.
Created attachment 111720 [details] Sample file If you want the cell formatted with dot as decimal separator select a language with dot as decimal separator in the cell format, number's tab.
Thanks for this trick! In any case, that doesn't look to me like a real solution to the problem here. Besides, it'll work as long as you don't enter the value by hand: if your cell language is set to english, you still have to write 12,2 to get 12.2…
(In reply to tommy27 from comment #11) > should we allow users to do what they want (setting the decimal separator > regardless of the language) even if this is against some countries > typographic rules? Yes. Calc is generally not about fancy typography.
This seems to be a duplicate of bug 46448. Reporter, can you confirm?
It might, yes.
*** This bug has been marked as a duplicate of bug 46448 ***