Hello NoOp,Thanks for the reply. I searched the archives but didn't find any information to fix it. I have no clue how to troubleshoot this problem. Can anybody suggest wow I would further investigate this problem? How would I know if it is a local problem?
The same is happening on my colleague's computer who is using Ubuntu 7.04.I'm attaching the document with personal data removed. Can somebody try replicate the problem please?
Any help would be appreciated, NoOp wrote:
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]
-- With Warm Regards, Sudheer. S http://www.binaryvibes.co.in
date-format-problem.ods
Description: application/vnd.oasis.opendocument.spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
