To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=85362 Issue #|85362 Summary|Calc: Default Formatting ruins dates Component|Spreadsheet Version|OOo 2.3.1 Platform|All URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|dotancohen
------- Additional comments from [EMAIL PROTECTED] Fri Jan 18 12:53:49 +0000 2008 ------- When a date is entered into a Calc cell and then Default Formatting is selected, the date turns into an integer. For example, entering "2008-7-7" and then selecting Default Formating causes the cell to display "39636". I do realize that Calc stores dates as integers internally, but if that is the case then the Default Formating for cells that are displayed as dates should be to display the data as a date. The current behaviour is confusing and worrying as it causes users to believe that data is corrupted. --------------------------------------------------------------------- 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]