Apache OpenOffice (AOO) Bugzilla – Issue 7434
Customized OS regional settings not make it to OpenOffice components
Last modified: 2013-08-07 15:00:48 UTC
Under Windows's Control Panel / Regional Settings, user can change country defaults such as number/currency formatting. Example: US default regional setting will print: 1,000,000.00 FR default regional setting will print: 1 000 000,00 When user changes the defaults: modified FR regional setting will print: 1,000,000.00 changed to look like US formatting for example) Then the changes will not make it to OpenOffice, resulting in errors in the cells of the spreadsheet if, for example a "." is used instead of a "," while original country defaults of the OS were different. I have reproduced the problem with the FR build of OpenOffice 1.0.1 and also with the FR build of OpenOffice 1.0.0
Jean-Marc, thank you for your post. Does this only happen when you are using the spreadsheet application? Regards, Charles Schulz.
Hello Charles, I understand the problem also affects the other OpenOffice components although it is not very easy to demonstrate! I think this also causes problem to OpenOffice Math application, I will tell you how. Example: I have applied currency format to the blue column. In this case, it is the French version of Windows and OpenOffice 1.0.1 The default settings would give numbers formatted as follow: 100 000,00 In Windows's control panel / regional settings, I have changed the defaults to format the number as follow: 100,000.00 Now in OpenOffice Calc, if for example I apply the currency formatting to a column and enter numbers, only those entered with the original OS defaults will be treated as numbers (automatic symbol appended, calculation in combination with other numbers will also work etc.). When numbers are entered with the new regional settings then they are treated as text strings (no ? symbol appended) and will cause error messages when attemting to use in calculations. With OpenOffice Math, I have noticed that numbers entered with original OS defaults (like 100,32) will appear in normal chars while numbers entered with new regional settings will appear in italics, suggesting the number is not treated as a number but as a string of chars. I hope this helps! Regards, Jean-Marc
Jean-Marc, I tested and reproduced this issue on a Win 98 with OpenOffice.org 1.01 French version. I reassign it to the L10n project (localization). Thank you for your feedback.
Hi Charles, Thank you too, looking forward to seeing the fixed version of OpenOffice :) Best regards, Jm.
DL->Jean Marc: Currently we don't support the OS settings. We have to address it in the future.
DL> Hi DL, Such OS settings support was implemented and working with StarOffice 5.x, unfortunately this appears to be missing in OpenOffice, at least for the mean time :( 'hope to see this feature back in OpenOffice soon ;) Thanks, Regards, Jean-Marc
can someone link this http://qa.openoffice.org/issues/show_bug.cgi?id=54230 with the current bug, it's the same! this bug persists throughout the entire app and is quite bad design imho!
closed the issue 54230 as it is a duplicate of the present issue. --> DL: do we have a target milestone or an estimation of a timeframe for this issue to be fixed? Thanks.
just for the record, this is still present in 2.0.3
my bug's a dupe too http://qa.openoffice.org/issues/show_bug.cgi?id=58530
reopen issue, since RESOLVED/LATER does not make sense.
DL->ER: could you please check the effort to solve this?
Issue 51662 has far more votes. *** This issue has been marked as a duplicate of 51662 ***
Closing dup.