To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=103213 Issue #|103213 Summary|Custom locale settings are ignored Component|Spreadsheet Version|OOo 3.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|open-import Assigned to|spreadsheet Reported by|yurikhan
------- Additional comments from [email protected] Tue Jun 30 11:22:39 +0000 2009 ------- == Background == On Windows, many locale settings, including, but not limited to: decimal separator, list separator, date separator, date format, time separator, time format, currency decimal separator, currency format -- are configurable independently of the general "which country are you in and what language do you speak" locale setting. One can have Russian locale and customize decimal separator to dot, list separator to comma, and date format to yyyy-MM-dd. OpenOffice ignores these customizations, taking only the base locale into account. I am filing this in Spreadsheet/open-import, but really it is a global lack of feature affecting all of OpenOffice on Windows. == To reproduce == 1. Control Panel | Regional and Language Options 2. Regional Options tab: Standards and Formats group: Select an item to match its preferences: [Russian] 3. [Customize]: Decimal symbol: [.], List separator: [,] 4. [OK], [OK] 5. Open Spreadsheet 6. Tools | Options dialog, Language Settings | Languages category, Locale setting: [Default] == Expected == * The Decimal separator key: [x] Same as locale setting ( . ) checkbox label displays dot as the detected default decimal separator. == Observed == * The label reads: Same as locale setting ( , ) == Impact == * Numbers entered with the local decimal separator (dot) are interpreted as strings, and in specific cases as dates. * Strings consisting of digits and containing a comma are interpreted as decimal numbers. * Dates entered in the local format (ISO 8601) are interpreted as strings. * CSV import seems to be *the* favorite issue here. * In Writer, formula fields display their results using comma. --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
