To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=97669 Issue #|97669 Summary|Calc wrongly changes dates Component|Spreadsheet Version|OOo 2.4.0 Platform|All URL| OS/Version|All Status|NEW Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P2 Subcomponent|open-import Assigned to|spreadsheet Reported by|sweigel
------- Additional comments from [email protected] Tue Dec 30 19:06:14 +0000 2008 ------- After saving and closing a spreadsheet that contains dates, change the start date (day zero) in Tools|Options|Calc|Calculate. Then reopen the document. The dates in the document will change but day zero of the document is the same. This means data corruption. Found this bug in OOo 2.4.0 as well as in DEV300_m38 (1) Open a new spreadsheet. (2) Have a look at Tools|Options|Calc|Calculate|Date (should be set to "12/30/1899 (default)"). (3) Enter a date into a cell of the spreadsheet. Remember that date. (4) Save and close this spreadsheet. (5) Open another new spreadsheet. (6) Change Tools|Options|Calc|Calculate|Date to "01/01/1900 (StarCalc 1.0)" (7) Close the spreadsheet, no matter if you save it or not. (8) Reopen the first spreadsheet. (9) Compare the date in the cell to the date you remember. The date that is showing up now is two days before the date you had entered. (10) Have a look at Tools|Options|Calc|Calculate|Date (it´s still set to "12/30/1899 (default)"). The date changed by error. (11) Do some changes to the spreadsheet, but don´t touch the date. For example type some text in any other cell. (12) Save and close this spreadsheet. (13) Reopen the spreadsheet. Whenever you repeat steps (11) to (13) the date will change by another two days. Whenever you save your document the dates in your spreadsheet change. --------------------------------------------------------------------- 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]
