Recent

Author Topic: "" is an invalid integer when Load File  (Read 1237 times)

melwinek

  • Jr. Member
  • **
  • Posts: 60
"" is an invalid integer when Load File
« 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
« Last Edit: January 28, 2020, 11:04:41 am by melwinek »

MarkMLl

  • Hero Member
  • *****
  • Posts: 1347
Re: "" is an invalid integer when Load File
« Reply #1 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
Turbo Pascal v1 on CCP/M-86, multitasking with LAN and graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.

wp

  • Hero Member
  • *****
  • Posts: 7631
Re: "" is an invalid integer when Load File
« Reply #2 on: January 28, 2020, 01:13:38 am »
Fixed in fpspreadsheet trunk, r7321.
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...

egsuh

  • Sr. Member
  • ****
  • Posts: 467
Re: "" is an invalid integer when Load File
« Reply #3 on: January 28, 2020, 03:30:49 am »
Is there any similar unit/package for documents, eg. MS-Word or OpenOffice documents?

wp

  • Hero Member
  • *****
  • Posts: 7631
Re: "" is an invalid integer when Load File
« Reply #4 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:
Mainly Lazarus trunk / fpc 3.2.0 / all 32-bit on Win-10, but many more...

melwinek

  • Jr. Member
  • **
  • Posts: 60
Re: "" is an invalid integer when Load File
« Reply #5 on: January 29, 2020, 10:07:37 am »
Thank you for fixing this problem quickly. Now works very well.

 

TinyPortal © 2005-2018