To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=116791 Issue #|116791 Summary|Calc cells' default date format is not the locale date | format Component|Spreadsheet Version|OOo 3.3 Platform|Unknown URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|dotancohen
------- Additional comments from [email protected] Thu Feb 3 19:19:03 +0000 2011 ------- Steps to reproduce: 1) On a new OOo install, go to Tools -> Options... -> Language Settings -> Languages -> Locale Setting and set the locale as English (Canadian). 2) In a black cell type this: "2005-9-2". What happens: The cell displays "05-09-02". What the user expects to happen: The cell should display "2005-09-02" as per the configured locale. English (Canadian) is yyyy-mm-dd, and clicking on the cell it can be seen that the Formula Bar does in fact correctly show "2005-09-02". --------------------------------------------------------------------- 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]
