User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:48.0) Gecko/20100101 Firefox/48.0 Build Identifier: LibreOffice 5.1.5.2 I use the Russian versions of Wondows 7 and LibreOffice. I've noticed that in Calc the coma is used as decimal mark. I've checked the Parameters... (I'm not sure that it is right English title of menu string. In my version it is "Параметры...")/Language Settings(Настройки языка)/Local Settings(Локальные настройки). It was Default-Russian (Стандарт-Русский). According the help in this case the setting should be taken from an operating system. But in my Windows settings the decimal mark is dot, and all other programs use the dot as decimal mark. After changing to English(USA) the dot was used as the mark, and after change to Default-Russian again the coma became the decimal mark. Reproducible: Always Steps to Reproduce: 1. In Russian version of Windows 7 with changed decimal separator set the Local Settings to Default-Russian. 2. 3. Actual Results: The decimal mark become coma Expected Results: The decimal mark should be like in Windows settings [Information automatically included from LibreOffice] Locale: ru Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: yes Reset User Profile?No
kompi: I heard you might have information about this. Is there maybe an existing bug report..?
I tried this with Hungarian (default separator: comma (,)), switch it to period (.), and Calc wasn't picking up the change. Similar test can probably be carried out with any locale. I'm a bit confused what the behavior should be. It would be logical to use the decimal separator set in system locale, but to me the help is a bit ambiguous, is it only supposed select the OS locale, or all the settings with it as well?
@Kompilainnen, Do you reproduce it?
@Ruslan, Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ? I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Dear Xisco Faulí, I've installed the latest version of Libre Office and try to reproduce the bug. AS I see the new checkbox "Decimal separator:" (I'm ask to excuse me if I use wrong terms because it translation from Russian) "from local setting" is appeared. The symbol in parentheses (the comma or the point) is defined correctly as it is set in local setting of Windows when I chose the local setting as "Standard - Russian". But unfortunately regardless of whether the box set or not the decimal separator becomes a comma. I would like mention that the symbol in parentheses should be refreshed after the changing of the local setting like it happens for currency and dates, but it is not now.
If the help system tells that for "Default - *" choice, the settings for different options are taken "from system", then the documentation is wrong. In no case does LibreOffice take e.g. decimal separator from system; the only thing it takes from there when you choose "Default - *" is the locale itself (so for Windows, it would automatically take active MUI language, or localized version's language). All other related settings (including decimal/thousand separators) are taken from LibreOffice own built-in set for the given locale. So this bug should be either closed as NOTABUG, or changed to documentation issue.
(In reply to Mike Kaganski from comment #6) > If the help system tells that for "Default - *" choice, the settings for > different options are taken "from system", then the documentation is wrong. > In no case does LibreOffice take e.g. decimal separator from system; the > only thing it takes from there when you choose "Default - *" is the locale > itself (so for Windows, it would automatically take active MUI language, or > localized version's language). > > All other related settings (including decimal/thousand separators) are taken > from LibreOffice own built-in set for the given locale. > > So this bug should be either closed as NOTABUG, or changed to documentation > issue. In the online help (https://help.libreoffice.org/6.1/en-US/text/shared/optionen/01140000.html)there are next sentences: ******************************************************************************* Locale setting Specifies the locale setting of the country setting. This influences settings for numbering, currency and units of measure. The "Default" entry selects the locale setting that is selected for the operating system. ******************************************************************************* Should I read it that from operating system only the locale number (or locale name) is taken but not settings?
(In reply to Ruslan from comment #7) > Should I read it that from operating system only the locale number (or > locale name) is taken but not settings? Yes.
But sure, the wording could be made more explicit.
(In reply to Mike Kaganski from comment #9) > But sure, the wording could be made more explicit. Thanks
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/help/+/50a0079ea82e87e1ce9f6ad744d04a106d43a773%5E%21 tdf#102014: clarify that only locale name is taken from system for Default
A polite ping to Mike Kaganski: Is this bug fixed? if so, could you please close it as RESOLVED FIXED ? Otherwise, Could you please explain what's missing? Thanks