Dates off when moving between OOo 3.2 and 3.3

Discuss the spreadsheet application

Dates off when moving between OOo 3.2 and 3.3

Postby ian_macf » Tue Feb 22, 2011 1:43 am

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
OpenOffice 3.3 on Windows XP SP3
ian_macf
 
Posts: 3
Joined: Tue Feb 22, 2011 1:12 am

Re: Dates off when moving between OO 3.2 and 3.3

Postby thomasjk » Tue Feb 22, 2011 3:15 am

Can you attach a sample file here? See viewtopic.php?f=74&t=8289
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4403
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Dates off when moving between OO 3.2 and 3.3

Postby ian_macf » Tue Feb 22, 2011 7:36 am

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
Attachments
test-1-OO33-B.ods
(8.1 KiB) Downloaded 100 times
test-1-OO33.ods
(8.11 KiB) Downloaded 93 times
test-1-OO32.ods
(7.83 KiB) Downloaded 97 times
OpenOffice 3.3 on Windows XP SP3
ian_macf
 
Posts: 3
Joined: Tue Feb 22, 2011 1:12 am

Re: Dates off when moving between OOo 3.2 and 3.3

Postby Cambirder » Tue Feb 22, 2011 1:29 pm

I tried to replicate the problem by doing exactly what you did but my dates stayed fixed.
OOo 3.3 on Windows 7 & 3.2.1 on Mint 10
User avatar
Cambirder
Volunteer
 
Posts: 647
Joined: Thu Nov 22, 2007 1:01 am

Re: Dates off when moving between OOo 3.2 and 3.3

Postby Villeroy » Tue Feb 22, 2011 1:34 pm

Cambirder wrote: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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26852
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Dates off when moving between OOo 3.2 and 3.3

Postby Hagar Delest » Tue Feb 22, 2011 1:36 pm

AOO 4.1.6 on Xubuntu 19.04 and 4.1.5 on Windows 7 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28495
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Dates off when moving between OOo 3.2 and 3.3

Postby ian_macf » Sun Feb 27, 2011 9:48 am

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.
OpenOffice 3.3 on Windows XP SP3
ian_macf
 
Posts: 3
Joined: Tue Feb 22, 2011 1:12 am

Re: Dates off when moving between OOo 3.2 and 3.3

Postby Villeroy » Sun Feb 27, 2011 2:42 pm

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.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 26852
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Calc

Who is online

Users browsing this forum: Google [Bot], RPG, statiyo and 35 guests