[Lazarus] fpSpreadsheet date formats

Hans-Peter Diettrich DrDiettrich1 at aol.com
Thu Aug 4 19:32:59 CEST 2011


Mark E. Skeels schrieb:

> 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.

This may be very spreadsheet dependent. IMO you should try to 
copy&paste, using the clipboard, so that the spreadsheet can copy the 
(binary) value, regardless of the display format of the cell(s).

DoDi





More information about the Lazarus mailing list