On 05/24/2009 10:13 AM, H.S.Rai wrote: > http://www.goldentemplephotos.com/datesheet_new.xls has row no 362, 363 when > opened using OpenOffice 3.0.1 (on Ubuntu 9.04) build 9379 shown as: > > 29/5/2009 EVENING 6TH CE-304 Geotechnical Engg. CIVL A0619 06/01/2009 > EVENING 6TH CE-306 Irrigation Engineering-I CIVL A0620 > > While Google Doc as well MSExcell shows 01/06/2009 for row no. 363 (which is > correct), that mean 1st of June is shown as 6th of Jan. Such error is there > for many rows in same spreadsheet. > > Where is problem? With excel spreadsheet or with OpenOffice? >
Look at the 'A' cell values: 360: 30/6/2009 361: '27/5/2009 362: '29/5/2009 363: 01/06/2009 In Excel: 360: Format is 'Date' '*3/14/1001' 361: Format is 'Custom' 'd-mmm' 362: Format is 'Custom' 'd-mmm' 363: Format is 'Date' '*3/14/1001' The problem is in Excel. Fix your inconsistent cell formats in Excel. OOo is interpreting the data correctly... GIGO. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
