Recent

Author Topic: "" is an invalid integer when Load File  (Read 3069 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: 6676
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
MT+86 & Turbo Pascal v1 on CCP/M-86, multitasking with LAN & graphics in 128Kb.
Pet hate: people who boast about the size and sophistication of their computer.
GitHub repositories: https://github.com/MarkMLl?tab=repositories

wp

  • Hero Member
  • *****
  • Posts: 11855
Re: "" is an invalid integer when Load File
« Reply #2 on: January 28, 2020, 01:13:38 am »
Fixed in fpspreadsheet trunk, r7321.

egsuh

  • Hero Member
  • *****
  • Posts: 1273
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: 11855
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:

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