https://bugs.documentfoundation.org/show_bug.cgi?id=170242
Bug ID: 170242
Summary: Calc does not follow what is set as a decimal symbol
in Windows
Product: LibreOffice
Version: 25.8.4.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Calc does not follow what is set as a decimal symbol in Windows.
If one set dot as decimal sign in Windows Settings/Time and languages/Languages
and Region, other software follow that settings and use dot as decimal sign
regardless of which language is defined in the system, except LibreOffice.
In my case, I am using Serbian (Latin) as system language, but decimal sign is
dot, not comma what is usual in Serbian Language.
Calc don't recognize dot as decimal sign, but text or thousand separator, so if
one type 45.65 in cell it will be used as text, not number so calculation will
be impossible.
Second bug is that at same time Libreoffice Basic will use dot as decimal sign,
not comma as rest of LibreOffice suite.
Steps to Reproduce:
1. Set Serbian (Latin) as default language in Windows
2. Change decimal symbol to be DOT in Windows Settings/Time and
languages/Languages and Region, and digit grouping symbol to be COMMA
3. Start LibreOffice and set Languages and Locales/General/Formats/Locale
setting to Serbian Latin (Serbia)
4. Type 45.55
Actual Results:
45.55 will be text
Expected Results:
45.55 needs to be number
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 25.8.4.2 (X86_64)
Build ID: 290daaa01b999472f0c7a3890eb6a550fd74c6df
CPU threads: 20; OS: Windows 11 X86_64 (build 26200); UI render: Skia/Raster;
VCL: win
Locale: sr-Latn-RS (sr_RS); UI: en-US
Calc: CL threaded
--
You are receiving this mail because:
You are the assignee for the bug.
