#7 fpspreadsheet: exception loading excel file saved with OO

closed-fixed
nobody
None
5
2009-11-13
2009-11-12
Luiz Camara
No

The attached file (saved with OO3.1 in Excel 97/2000/XP format) crashes when loading with the error below.
To test i compiled the excel8read project and executed it with the file in the same directory.

Using fpc240rc1, windowsXP, fpspreadsheet from today svn

D:\repositories\lazarus-ccr\components\fpspreadsheet\examples\excel8demo>excel8read.exe
Opening input file D:\repositories\lazarus-ccr\components\fpspreadsheet\examples\excel8demo\test.xls
An unhandled exception occurred at $00411634 :
EReadError : Stream read error
$00411634
$004299A6 TSSPREADBIFF8READER__READFROMSTREAM, line 1265 of xlsbiff8.pas
$0042990F TSSPREADBIFF8READER__READFROMFILE, line 1242 of xlsbiff8.pas
$0042794D TSWORKBOOK__READFROMFILE, line 652 of fpspreadsheet.pas
$00401798 main, line 34 of excel8read.lpr

Discussion

  • Luiz Camara
    Luiz Camara
    2009-11-12

    Test file

     
    Attachments
  • Jose Mejuto
    Jose Mejuto
    2009-11-12

    Compile the fpspreadsheet package with "-dUSE_NEW_OLE"

    Compiler Options -> Other -> Custom Options -> -dUSE_NEW_OLE

     
  • Luiz Camara
    Luiz Camara
    2009-11-13

    It works with -dUSE_NEW_OLE

     
  • Luiz Camara
    Luiz Camara
    2009-11-13

    • status: open --> closed-fixed