To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=106789 Issue #|106789 Summary|Date decrements by 4 yrs 1 day Component|Spreadsheet Version|OOo 3.1.1 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|configuration Assigned to|spreadsheet Reported by|ian3880
------- Additional comments from [email protected] Tue Nov 10 23:56:18 +0000 2009 ------- My partner & I use a common spreadsheet to record data of our travels, etc. The date is formatted as dd mmm yy and data is usually entered as dd-mm then Enter. Calc correctly interprets this to be 2009 and correctly displays the date as required. It appears that while ever the file is closed/opened and new data entered on the ORIGINAL computer, the date remains correct. HOWEVER, when transferring Calc files between two computers with identical OS (WinXP SP3) and identical Open Office (OO 3.1.1 in default settings mode) dates in the spreadsheet decrement by 4 years 1 day EACH time the file is transfered. This is NOT a formatting problem. The numeric value for the date is actually decremented by 1461. I have encountered this problem consistently since I started using OO when it was still 1.x This problem has been reported in the forums, but the thread degenerated into a personal slanging match and there was no resolution. (See http:// www.oooforum.org/forum/viewtopic.phtml?t=75683&highlight=date+changes+ +years) It seems also that it is possible to change the date reference (Tools > Options > Calc > Calculate) from the OpenOffice default of 12/30/1899 to 1/1/1904. I have done this, too, but it is annoying that it has to be done. My issue is: Why isn't the default setting working in the first place? This is an extremely annoying problem that I had hoped would have been sorted by now. --------------------------------------------------------------------- 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]
