Recent

Author Topic: fpspreadsheet 1.10 & 1.11  (Read 2772 times)

docno

  • New Member
  • *
  • Posts: 16
fpspreadsheet 1.10 & 1.11
« on: July 17, 2018, 02:25:06 pm »
Hello,

On windows 10 1803 x64, i upgrade lazarus to 1.8.4
FPspreadsheet 1.8.4 dont compile.
I install fpspreadsheet 1.10

I recompile my app that work well with lazarus 1.8.2 and fpspreadsheet 1.8.4 and i have a message :
error reading sworkbooksource1
is not a valid spreadsheet file.
Press ok to ignore.

I have this message with all xls file i submit that worked before.

For test, put on a form :sworkbooksource, sworkbooktab and sworksheetgrid.
set : sworkbooksource filename with a xls file.
All is good on design time : the file is loaded on grid.
But if compile : error.

tested with beta version 1.11 : same error.
any help ????

wp

  • Hero Member
  • *****
  • Posts: 11858
Re: fpspreadsheet 1.10 & 1.11
« Reply #1 on: July 17, 2018, 02:37:08 pm »
Did you add the reader unit for the file format to "uses"? For xls this is usually xlsBiff8 (for the format of Excel 97) or xlsBiff5 or xlsBiff2 for older formats. Or use "fpsAllFormats" to include all file formats supported.

This unit had been removed from "uses" some time ago to avoid linking all reader/writer classes into the binary.

FPspreadsheet 1.8.4 dont compile.
You should mention the exact error mesage, otherwise this notice is of little help.

docno

  • New Member
  • *
  • Posts: 16
Re: fpspreadsheet 1.10 & 1.11
« Reply #2 on: July 17, 2018, 03:37:58 pm »
@WP, thanx for the speed reply : this help very much.

I dont know, that i have to add the unit in uses : xlsbiff8 work for me.

with lazarus 1.8.4 : component fpspeedsheet 1.8.4 cant be installed.
i dont have the error message because i remove this version and install newer version.

Component fpspeadsheet 1.10 : install well.
and version beta 1.11 too.

thanx for help.
I can recompile my applications and read my xls files.

 

TinyPortal © 2005-2018