Dates off when moving between OOo 3.2 and 3.3

[ian_macf]

When I create a spreadsheet on OO 3.2 with 12/30/1899 as the date base, then date fields display the same date when I take the spreadsheet to another PC also running OO 3.2 (true for PCs running Windows XP and Windows Vista).
However If I then take the spreadsheet to a PC running OO 3.3 (running Windows XP), the date fields immediately change to a different date, 4 years and 1 day earlier, as soon as the spreadsheet is open. If I use 'default formatting' on the date fields, it shows that OO 3.3 is actually changing the underlying numbers in the date fields. By the way Options shows the date base is still set to 12/30/1899. This sympton of dates being changed as soon as a spreadsheet is opened appears to be consistent for all spreadsheets that I have taken from an OO 3.2 machine to my OO 3.3 machine where the spreadsheet has 12/30/1899 as the date base. If I then move the spreadsheet back to an OO 3.2 PC, then the date displayed is now the same date as that displayed on the OO 3.3 PC, that is 4 years and a day earlier than the date originally enetered in the spreadsheet using OO 3.2, because OO 3.3 has actually changed the underlying number in the date field.
If I set 01/01/1904 as the date base for the spreadsheet, then moving it from OO 3.2 to OO 3.3 (or vice versa) has no effect on the date being displayed in the date fields, that is the date stays the same every time.
It appears some part of OO 3.3's date processing is not correctly handling the date base of 12/30/1899

[thomasjk]

Can you attach a sample file here? See http://user.services.openoffice.org/en/ ... =74&t=8289

[ian_macf]

Test files attached. Please be aware I am resident in Australia so my dates are of the format dd/mm/yyyy. In each of the cells that contain a date, the date is originally entered as 19/03/2010 (aka 19 March 2010). The date base for the spreadsheets is 30/12/1899 or as OO says, 12/30/1899, which is the stated OO default.

OO 3.3 = OpenOffice 3.3.0 OOO330m20 (Build : 9567)

OO 3.2 = OpenOffice.org 3.2.0 OOO320m12 (Build : 9483)

file test-1-OO32. Created by OO 3.2. Cell A3 was created with date 19/03/2010.

file test-1-OO33 was created by using Windows to copy the file which was then renamed. It was then opened on OO 3.3. Cell A3 date changed. Cell B3 was created with date 19/03/2010. File closed.

file test-1-OO33-B was created by opening test-1-OO33 again on OO 3.3. The dates in both cells A3 and B3 changed. The resulting spreadsheet was saved as test-1-OO33-B.

Ian

[Cambirder]

I tried to replicate the problem by doing exactly what you did but my dates stayed fixed.

[Villeroy]

I tried to replicate the problem by doing exactly what you did but my dates stayed fixed.

Nevertheless, I've seen this problem description two or three times without ever beeing able to reproduce it.

[Hagar Delest]

Maybe a similar topic: [Solved] Calc changing dates after save.

[ian_macf]

Well, this problem is not SOLVED for me. It recurs consistently unless I use 01/01/1904 as the date base for the spreadsheets on OO 3.2. This in spite of OO 3.2 and 3.3 saying 12/30/1899 is the default. What the problem means is that all my spreadsheets created on OO 3.2 using the default date base are (what I perceive to be) corrupted if I open them on OO 3.3.
It happened with real spreadsheets but I was able to recreate with trivial test spreadsheets, see attached to my post above.
If I can supply any more info about what is happening, please specify and I'll do what I can to provide it.

[Villeroy]

I managed to reproduce some problem with new documents in LibreOffice, but not in OOo 3.3. So far I could not find any existing document where the date differs.

Since years I always used to use a default template where calculation options are turned off (except "match whole cell") and day zero is 1899-12-30. Apart from that, the template includes dozends of cell styles and some named formula expressions.
I start LibreOffice 3.3.1, File>Templates>Organize... [Command Button]>Reset template for spreadsheet (do not use any of my templates automatically for a new spreadsheet)
Then I start a new spreadsheet from scratch (File>New>Spreadsheet...) and =YEAR(0) returns 1904. This does not happen when I do the same in OOo 3.3 where the day zero remains 1899-12-30.