Issue 42802 - OO does not accepts Windows decimal separator as its own
Summary: OO does not accepts Windows decimal separator as its own
Status: CLOSED DUPLICATE of issue 31663
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: 680m77
Hardware: PC All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2005-02-15 08:39 UTC by bigserpent
Modified: 2005-06-17 15:16 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description bigserpent 2005-02-15 08:39:51 UTC
The bug is closed. But the
problem with Windows do not only concerns the numeric pad, but the decimal
separator OO Calc uses at all. The maintaners of 1820 asked to file a new bug.

I have '.' as the decimal separator in Windows and Russian locale. Many Russian
users have the same combination. So all the programs on my PC deal with "." as
the decimal separator. OO Calc (M77) treats "." from the keyboard as date
separator, not the decimal if the default settings are selected. The checkbox of
the same... does not matter. The program still thinks '.' is date separator.

So the OO is the one program which requires different decimal separator than all
other programs do. It is wrong behaviour.
Comment 1 frank 2005-02-15 11:23:33 UTC
double to Issue 31663

*** This issue has been marked as a duplicate of 31663 ***
Comment 2 frank 2005-02-15 11:23:53 UTC
closed double
Comment 3 bigserpent 2005-06-17 14:37:12 UTC
This issue is not the same as 
The problem is not in the default number formatting. The problem does not
concern numeric keypad (issue 1820). The problem is in difference between OO
decimal separator and Windows decimal separator. 

There is clearly a misunderstanding of the problem. The problem is not in the
usage of the dot as the decimal separator while typing it at the numeric pad by
interpreting the dot into comma. The problem is to *use* dot at the decimal
separator in OO. To type 1.2 in a spreadsheet and to *see* it there as 1.2. Not
1,2. And to have OO understood it as a number, not text.

I'd try to explain it.
1. I have dot as Windows decimal separator (the majority of Russian Windows
users have the same and have the same problem with OO). 

2. If I have Russian locale settings in OO it uses *comma* as *its* decimal
separator regardless system settings and the known check box. The only job the
check box does is to interpreter or not the dot from the numeric keypad
_into_its_own_COMMA_. And all the other Windows programs provide and require dot
as the decimal separator. This makes common usage of OO with correct locale (Ru)
and other data manipulation programs almost impossible.

3. The result Russian users need is: 0. to have Russian locale set. 1. to type
1.1 at the main keyboard. 2. To see 1.1 in OO. 3. To have OO understood it as a
Comment 4 frank 2005-06-17 15:16:25 UTC

this is clearly a double to Issue 31663. Please have a look at the latest
ccomment from ER .

And also have a look at Issue 31963. Someone from Russia told us that the comma
is the decimal separator. Normally I've to close this Issue as wontfix or double
to Issue 31963.

Sorry for no better reply.


*** This issue has been marked as a duplicate of 31663 ***
Comment 5 frank 2005-06-17 15:16:49 UTC
closed double