Am Donnerstag, den 04.08.2011, 10:50 -0500 schrieb Mark E. Skeels: > All... > > I am using fpSpreadsheet and trying to read spreadsheet cells containing > dates from one worksheet and write them to another. > > The written cells' formats are being changed to the integer > representation of the dates. > > I either need to reformat them before writing or get the new worksheet > cells' format set to properly display the dates. > > I get the same results whether using Open Office Calc or Excel. > > Does anyone know what is going on here and can steer me in the right > direction?
That's the way spreadsheet programs work. A date is an integer behind the scenes, what makes it look like a date string is the formatting. If your target cells have to be read using openoffice or excel you will have to change the format for visualization to date display. If you have problems inside fpSpreadsheet you might have to do something similar (never used it) or convert the date serials from other programs to date types (TDateTime). -- Marc Santhoff <m.santh...@web.de> -- _______________________________________________ Lazarus mailing list Lazarus@lists.lazarus.freepascal.org http://lists.lazarus.freepascal.org/mailman/listinfo/lazarus