Hi William, On Sat, Aug 12, 2006 at 10:49:26 -0400, William Case wrote:
> > Excuse my intrusion in this, and this could be a red herring. But looking > > at > > the timestamps on your messages makes me wonder about which timezones you > > are > > in. If the origin of the date is midnight at the start of Dec 30 UTC, then > > west of GMT that will be shown as still 29 Dec. > > > > Never even thought of Timezones or Daylight saving time. I am on > Eastern Standard Time. As you're not the only OOo user in that very timezone ;) and we didn't receive reports for your issue so far, chances are not very high that the timezone is related. However, I wouldn't call it impossible. One more test: in 4 cells enter the time values 0 3:59 4:00 4:01 and format all cells with the number format code YYYY-MM-DD HH:MM:SS You then should see display strings 1899-12-30 00:00:00 to 1899-12-30 04:01:00 If in your save-scenario only the first two values get modified, the problem is certainly timezone related. If all 4 values, especially the last 4:01 are modified, it may be something else, but still timezone related if the offset is -4 hours, your timezone's offset from UTC. > That would certainly explain why the date display changes after a save > but not after a recalculation. During a save, system clock time > updating would be intervening but not necessarily during a OOo based > recalc. Speculation, but I don't think that would be the reason. > How can I check? If true, isn't this a bug? It sounds like one.. Eike -- OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
