On Saturday 12 August 2006 11:37, Andreas Saeger wrote: > > As you suggested I created a test sheet. My first entry was A1=N(0) > > > > formatted NN MMM D YY. A1 at first showed Sat Dec 30, 99. Then a few > > seconds later when Calc auto-saved. A1 then showed Fri Dec 29, 99. A1 > > remained equal to =N(0). > > > > To test it, I deleted the A1 value and re-entered it, =N(0) and got Sat > > Dec 30, 99 back. I immediately used F9 to recalculate and got no > > change. I then waited for the automatic save and A1 changed again to > > Fri Dec 29, 99. > > This is weird. I can't reproduce this behaviour using =N(0) and > auto-save with official build OOo2.0.2 on SuSE9.x. > Why not put a plain constant zero into $A$1 ?
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. -- 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]
