[Lazarus] fpSpreadsheet date formats

[Marc Santhoff]

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.Santhoff at web.de>