Lazarus

Programming => Packages and Libraries => FPSpreadsheet => Topic started by: melwinek on January 27, 2020, 08:10:15 pm

Title: "" is an invalid integer when Load File
Post by: melwinek on January 27, 2020, 08:10:15 pm
When loading a file from an attachment using:
sWorksheetGrid1.LoadFromSpreadsheetFile(OpenDialog1.FileName,sfOOXML)

There is an error:
"" is an invalid integer
Title: Re: "" is an invalid integer when Load File
Post by: MarkMLl on January 27, 2020, 10:18:00 pm
According to Libre Office, every column in that spreadsheet is set to numeric even when it's full of text. I'm not sure how FPS is supposed to react to that, but I'd suggest that looking carefully at the source file would probably be a good first step.

Also note that that file contains somebody's name, and posting it rather than trying to duplicate the error with a test file might not be such a wise move.

MarkMLl
Title: Re: "" is an invalid integer when Load File
Post by: wp on January 28, 2020, 01:13:38 am
Fixed in fpspreadsheet trunk, r7321.
Title: Re: "" is an invalid integer when Load File
Post by: egsuh on January 28, 2020, 03:30:49 am
Is there any similar unit/package for documents, eg. MS-Word or OpenOffice documents?
Title: Re: "" is an invalid integer when Load File
Post by: wp on January 28, 2020, 03:09:43 pm
Is there any similar unit/package for documents, eg. MS-Word or OpenOffice documents?
Maybe incomplete, but here are some links:
Title: Re: "" is an invalid integer when Load File
Post by: melwinek on January 29, 2020, 10:07:37 am
Thank you for fixing this problem quickly. Now works very well.
TinyPortal © 2005-2018