Description: In option > language there is two options. The interface and the local parameter. In the local parameter french canada. The decimal separator is supposed to be a decimal point "." but it's a comma "," Please correct this because it's a major bug!!! Steps to Reproduce: 1.in option >language parameter > language > user interface Select french france and local parameter select french canada 2.Type any number in calc with a decimal 22.50 is not recognized as number but as text. 3. Actual Results: 1.in option >language parameter > language > user interface Select french france and local parameter select french canada 2.Type any number in calc with a decimal 22.50 is not recognized as number but as text. 3. Expected Results: The 22.50 is supposed to be recognized as number not as text! The local parameter decimal in french canada is the point "." not the comma "," Reproducible: Always User Profile Reset: yes Additional Info: If The local parameter french Suiss is selected. The decimal is a point. User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0
When selecting French (Canada) in Windows Regional settings, comma is the decimal separator. It's the same according to Wikipedia [1]. Do you have any sources claiming otherwise? [1] https://en.wikipedia.org/wiki/Decimal_mark#Countries_using_Arabic_numerals_with_decimal_comma
(In reply to Aron Budea from comment #1) > When selecting French (Canada) in Windows Regional settings, comma is the > decimal separator. It's the same according to Wikipedia [1]. > > Do you have any sources claiming otherwise? > > [1] > https://en.wikipedia.org/wiki/ > Decimal_mark#Countries_using_Arabic_numerals_with_decimal_comma Don't you (Aron Budea) think that tech@inqb.com complained about actually getting the point as the decimal separator for 'French (Canada)' in LibO despite the fact that it schould be the comma as you state yourself?
(In reply to Wolfgang Jäger from comment #2) > Don't you (Aron Budea) think that tech@inqb.com complained about actually > getting the point as the decimal separator for 'French (Canada)' in LibO > despite the fact that it schould be the comma as you state yourself? The first paragraph of the description suggests otherwise, and I think I checked back then, but the reporter is very welcome to clarify (or someone else can double check).
(In reply to Aron Budea from comment #3) ... > > Don't you... > > The first paragraph of the description suggests otherwise, and I think I > checked back then, but the reporter is very welcome to clarify (or someone > else can double check). Reading the original report again I can no longer understand my reasons for my first comment here. I now think - as you obviously do - the original reporter was wrong concerning his expectations. Sorry for commenting when in fever.
Dear Bug Submitter, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping-20170727
I confirmed. For French[Canada], the decimal separator point is not considered as a number but as a text only comma is recognized. But the bug is not present for French [Switzerland] the separator is point and its considered as a number LO Version: 5.4.0.3 (x64) Build ID: 7556cbc6811c9d992f4064ab9287069087d7f62c
Reporter never provided any sources for their claim. Closing.
Some more resources for reference: https://icu4c-demos.unicode.org/icu-bin/locexp?d_=en&_=fr_CA https://unicode-org.github.io/cldr-staging/charts/latest/by_type/numbers.symbols.html