Apache OpenOffice (AOO) Bugzilla – Issue 8375
Dates off by one day
Last modified: 2003-09-08 16:55:29 UTC
Dates in cells in build 643 loaded from prior versions appear one day less than originally entered.
I began to think that this was perhaps related to some problem with timezone, so I checked again. It's displayed exactly 24 hours less using 643 than under OOo 1.0.1. Therefore, I don't believe it's timezone related.
Easy-to-reproduce scenario without requiring file from previous OOo versions: set the value of a cell ot =TODAY(). It too will be one day less than it should.
double *** This issue has been marked as a duplicate of 8281 ***
double->closed