Apache OpenOffice (AOO) Bugzilla – Issue 115028
ISO date is different with different versions of Calc
Last modified: 2013-01-29 21:43:33 UTC
I copied ISO dates to Calc Spreadsheet from WWW page using test version of OO.o (3.3) in Ubuntu. Now when I open those files with official OO.o 3.2.1 dates are changed so that 2010-10-01 is 2006-09-30. Strange thing is that INT function of that cell gives different results in different versions so it seems like numbers is changing when loading the file to Calc. In both cases the base date of Calc is same 12/30/1899 (default). I hope this is only in Ubuntu (or maybe between GO-OO and OO.o) but one user complaint a bit same kind of phenomenon when his Windows 7 was updated. Dates was changed. So it is also possible that whole date program of Calc is a bit messed up.
Created attachment 72018 [details] Spreadsheet where ISO dates are different with different versions of Calc
If I can remember correctly the attached file is created with 3.3 but updated with 3.2.1. So dates was correct after copying from www page with 3.2.1 but they are not any more.
@ristoi: Please check your Tools->Options->Calc->Calculate->Date setting _before_ loading the document and set it to 1899-12-30 if it wasn't, then the dates should be correct again. Apparently there's a bug if the setting was something different, in your case 1904-01-01, and a file with a different default setting is loaded.
@er I wrote: "In both cases the base date of Calc is same 12/30/1899 (default)." How you understand that?
@ristoi: I can reproduce this only if the date was 1904-01-01 (or 1900-01-01 for a two day offset) before loading the document. Note the _before loading_, not when the document is loaded.
Now I have checked (also in Vista) and it really seems be like er says: only if the base date is BEFORE opening of the spreadsheet non-default 1.1.1904 (last option) dates on the spreadsheet are changed four years backward. So may be the bug is not at all hiding in the spreadsheet but there is some mysterious function which change base date when user is doing something with Calc. My intention was never change that base date. Unfortunately I can't find and reproduce that "mysterious" function which change base date as a side effect.