"" is an invalid integer when Load File
lazarus / 49-FPSpreadsheet

----------------------------------------------------------------------
melwinek · 2020-01-27 19:10

When loading a file from an attachment using:
sWorksheetGrid1.LoadFromSpreadsheetFile(OpenDialog1.FileName,sfOOXML)

There is an error:
"" is an invalid integer

----------------------------------------------------------------------
MarkMLl · 2020-01-27 21:18

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

----------------------------------------------------------------------
wp · 2020-01-28 00:13

Fixed in fpspreadsheet trunk, r7321.

----------------------------------------------------------------------
egsuh · 2020-01-28 02:30

Is there any similar unit/package for documents, eg. MS-Word or
OpenOffice documents?

----------------------------------------------------------------------
wp · 2020-01-28 14:09

Quote from: egsuh on January 28, 2020, 03:30:49 amIs there any similar
unit/package for documents, eg. MS-Word or OpenOffice documents?
Maybe incomplete, but here are some links:
fpvectorial: general vector graphics library, with docx and odf
support, ATM, however, only for writing. It comes with Lazarus and is
in folder components/fpvectorial of the Lazarus installation
(https://wiki.freepascal.org/fpvectorial,
https://wiki.freepascal.org/fpvectorial_-
_Text_Document_Support).fpODF: Stand-alone Opendocument text writer:
https://github.com/dgaspary/fpOdfOffice Automation: If you are on
Windows...: https://wiki.lazarus.freepascal.org/WordAutomation/de
(German site only).

----------------------------------------------------------------------
melwinek · 2020-01-29 09:07

Thank you for fixing this problem quickly. Now works very well.