To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=58598 Issue #:|58598 Summary:|Dates entered as MM/DD/YY violating global settings Component:|Spreadsheet Version:|OOo 2.0 Platform:|PC URL:| OS/Version:|Linux Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|formatting Assigned to:|spreadsheet Reported by:|jamadagni
------- Additional comments from [EMAIL PROTECTED] Mon Nov 28 18:31:19 -0800 2005 ------- Platforms: SUSE Linux 10.0 / KDE 3.5RC1 and Windows XP Pro SP 2 Context: I live in India and all my global settings are set to display dates etc in Indian format. Accordingly, both on Linux and Windows all applications have the default date format as DD-MM-YYYY. Steps to reproduce bug: In a cell in OOo Calc, type a date as 2005-11-28 (ISO format). Actual Result: OOo displayed the entry in the American format 11/28/05. Expected Result: OOo should display the entry in the format of the locale - in this case 28-11-2005. MS Excel does this. Comments: The OOo Tools > Options > Language Settings > Languages menu has both User Interface and Locale Setting at "Default". Logically this should mean "Use the system default" which is for me DD-MM-YYYY. It was argued that OOo works on multiple environments on Linux (KDE, GNOME etc) and therefore OOo will take only the Linux locale setting, which on my system is admittedly set to en_US: $ locale LC_TIME="en_US.UTF-8" But non-geeks do not think about the kernel locale settings. They work in a graphical environment like KDE and expect whatever setting they have provided to KDE for the locale to be reflected in *all* applications running on KDE, whether they are specifically KDE applications or not. Hence if OOo has been using the kernel locale setting (or whatever you call the setting that is shown by the bash locale command) then it should start using the locale format that is supplied by the environment, which is what MS Excel is doing (correctly). --------------------------------------------------------------------- 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]
