Bug 103576 - The decimal separator is a comma instead of a point in the canada french local
Summary: The decimal separator is a comma instead of a point in the canada french local
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Localization (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Decimal-Separator-Key
  Show dependency treegraph
 
Reported: 2016-10-29 15:02 UTC by tech
Modified: 2017-10-27 09:06 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description tech 2016-10-29 15:02:04 UTC
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
Comment 1 Aron Budea 2016-10-30 09:52:25 UTC
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
Comment 2 Wolfgang Jäger 2017-01-13 14:43:51 UTC
(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?
Comment 3 Aron Budea 2017-01-13 22:50:26 UTC
(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).
Comment 4 Wolfgang Jäger 2017-01-14 11:52:51 UTC
(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.
Comment 5 QA Administrators 2017-07-27 12:06:28 UTC Comment hidden (obsolete, spam)
Comment 6 halima 2017-08-23 00:09:18 UTC
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
Comment 7 Buovjaga 2017-09-02 17:09:06 UTC
Reporter never provided any sources for their claim. Closing.