Apache OpenOffice (AOO) Bugzilla – Issue 42802
OO does not accepts Windows decimal separator as its own
Last modified: 2005-06-17 15:16:49 UTC
The bug http://www.openoffice.org/issues/show_bug.cgi?id=1820 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.
double to Issue 31663 *** This issue has been marked as a duplicate of 31663 ***
closed double
This issue is not the same as http://www.openoffice.org/issues/show_bug.cgi?id=31663. 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 number.
Hi, 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. Frank *** This issue has been marked as a duplicate of 31663 ***