fpspreadsheet unreadable file

[tjstew]

I have a problem which only seems to happen on a 64 bit machine (although I only have the 32 bit lazarus installed)

When I create a file from fpspreadsheet (using sfExcel8 or sfExcel5), it works well up to a cretain size (about 5000 cells it seems).  But t hereafter, when opening in Excel I get a report of "unreadable content" and it won't open.  I can spit the output into twp separate files, which works OK.  Any suggestions where I can look for the problem?

[BigChimp]

Sorry,  no idea about that, but...
IIRC there were some recent fixes to support very large spreadsheets in fpspreadsheet... but the number was way more than 5000 and I'm not sure for what spreadsheet format these were implemented.

Apart from that, there were some fixes in FPC trunk (2.7.1) itself to fix problems that manifested themselves in fpspreadsheet. IIRC these were backported to fixes 2.6 but are (by definition because that release is unchanged) not available in FPC stable (2.6)

Apart from that going to do my standard suggestions:
- please specify your operating system, lazarus and fpc version (if not the one supplied with Lazarus).
- what is your fpspreadsheet version/date?
- given the fact that some FPC fixes solved fpspreadsheet errors, you might want to attach a small sample project that demonstrates the error, and I'd be happy to test it with x86 or x64 FPC trunk on Win x64

I hope a spreadsheet guru may have ideas about where specifically to look.

[wp]

I think this is exactly the same issue that I had reported in http://www.lazarus.freepascal.org/index.php/topic,16716.0.html. It has been fixed in the current svn version of fpspreadsheet.

[tjstew]

Thanks for the responses.  In reply to BigChimp:

please specify your operating system, lazarus and fpc version (if not the one supplied with Lazarus). Windows 7, Lazarus 0.9.30.4

- what is your fpspreadsheet version/date? V 1.0 dated Novemebr 11, but donwloaded in the last few weeks as the latest version

- given the fact that some FPC fixes solved fpspreadsheet errors, you might want to attach a small sample project that demonstrates the error, and I'd be happy to test it with x86 or x64 FPC trunk on Win x64 ... SORRY, at this stage I can't unscramble the oart of the code easily

In reaction to one of the responses ... I copied the offending file to an older XP system, and it did pen.

Maybe I'll just have to work round, but thanks for responses

[BigChimp]

fpspreadsheet version/date? V 1.0 dated Novemebr 11, but donwloaded in the last few weeks as the latest version

Mmm... if you didn't download from SVN (see http://wiki.lazarus.freepascal.org/FPSpreadsheet#Download) but from sourceforge I suspect you may have quite an old version where the fix mentioned by wp definitely is not in.

[tjstew]

Hi again ... I found the latest fpspreadsheet ... But now it wants a package called LazUtils which I can't find.  Any directions?

[BigChimp]

Upgrading to current Lazarus stable (1.0.2) would be easiest, I'd think.

Otherwise check the release notes for the various Lazarus releases [1] and find out which unit functionality was moved to LazUtils
The Lazutils stuff happened around 0.9.30, before 1.0 anyway, IIRC.

[1] e.g.
http://wiki.lazarus.freepascal.org/Lazarus_1.0_release_notes

[tjstew]

OK, guys ... Thanks.  Upgrading my Lazarus has done the trick.  Thanks for your patience