To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=115263 Issue #|115263 Summary|date format changed when opening an xls file Component|Spreadsheet Version|OOo 3.2.1 Platform|PC URL| OS/Version|Linux Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|formatting Assigned to|spreadsheet Reported by|matteosistisette
------- Additional comments from matteosistise...@openoffice.org Tue Oct 26 19:53:56 +0000 2010 ------- I had some files saved from OpenOffice Calc 3.2.0 in XLS format, with a lot of dates all in the format 31/12/2010 I used to open, edit and save those XLS files with Calc 3.2.0 on a daily basis without issues. Now I've upgraded to version 3.2.1 and a very weird thing happens: 1) I open one such file. All dates are shown correctly. If I select some cell with a date and choose "format cells" I can see its format is "31/12/2010" 2) As soon as I enter ANYTHING in ANY cell (provide there is some date in another cell in the same line), ALL the existing dates in the document suddenly become numbers, such as 40472. Now, if I click on a cell with a date and click "format cells", i see its format is "35625,56789..." By the way I'd like to raise the priority, since such a bug makes the whole program completely useless, but I don't know whether "P1" is a higher or lower priority than "P2" --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org