Apache OpenOffice (AOO) Bugzilla – Issue 106789
Date decrements by 4 yrs 1 day
Last modified: 2017-05-20 09:52:59 UTC
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.
invalid. As you wrote yourself: The default is 1899-12-30 If a user sets another value, how can it be OOo's fault? OOo's own file format writes the chosen date into the fileformat, if one choses a non-default date: <table:null-date table:date-value="1900-01-01"/> in content.xml And it also respects those when reopening. If you're not using ODF format, this information cannot be saved, as excel for example doesn't supports it.
closing. It is not the default setting that is not working, but a different than the default setting. Complain at the user who did set a non-standard zero date. You should not do that unless you know what you're doing. Also: Use odf format, then this can be respected/read back from the file in question.
This one is a DUP of "Bug 95710 - Date object pasted from another workbook sheet with different date base changes value" *** This issue has been marked as a duplicate of issue 95710 ***