On Saturday 12 August 2006 15:49, William Case wrote: > Hi Andy and thanks; > > On Sat, 2006-12-08 at 14:55 +0100, Andy Pepperdine 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. > > 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. Hmmm ! > > How can I check? If true, isn't this a bug?
I'm just a user, and I've never used time and date functions in a spreadsheet, but I do know how difficult it is to specify what the results are for time and date functions, especially when mixed. Perhaps it's time to copy in the developers list on this one if you think it might help. If internally the data is held as a UTC time to the second, then it will depend on how the conversions are defined when using them as operands to functions, which are subsequently converted back to a format, that could be a date. But I've no idea whether that is relevant. -- Andy Pepperdine On this mailing list help is provided by volunteers. Please subscribe to the mailing list to see all the replies to a query, and reply only to the mailing list. For FAQ, userguide, see: http://documentation.openoffice.org/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
