On 10/02/2007 07:08 PM, Sudheer Satyanarayana wrote: > Hello, > > No comments? > > On some of the cells, the date displayed is Sep 30, 07. When I place the > cursor on the cell with date Sep 30, 07, the date displayed on the > formula bar is 10/01/07. The date displayed on the formula bar is > correct. Also, when I place the cursor on the cell and press F2 and then > Esc key, the date is correctly displayed both on the cell and as well as > the formula bar. When I switch to another window and come back to the OO > Calc window, again the display is mangled. > > Has anybody else experienced similar problems? If yes, how have you > fixed them? >
Last month Clive Bowley experienced the exact same problem using a windows version (search the archives for "Date format + Clive Bowley". He sent me his spreadsheet of list and I was not able to reproduce in: OOo 2.3 (linux): cannot reproduce OOo 2.1 (linux): cannot reproduce StarOffice 8 (linux): cannot reproduce OOo 2.1 (Windows): cannot reproduce StarOffice 8 (Windows): cannot reproduce MS Excel 2002 SP3 (windows): cannot reproduce I also was not able to reproduce your problem using a single cell w/your date data. Perhaps it's a locale problem? I am in the US and use US locale's in OOo etc. Clive is in the UK so perhaps this is a related regional bug. Perhaps someone from your (and Clive's region) could check? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
