Forum > FPSpreadsheet
Excel 2010 cannot read large(ish, 8MB) files created by fpspreadsheet
BigChimp:
With Lazarus 1.0.10 (and FPC 2.6.2 x86 on Windows), with fpspreadsheet at the latest SVN version (revision 2731 date 13 February), and the program you uploaded, I get a spreadsheet that LibreOffice 4.0.4 and Excel XP (2002) can read...
Edit: See Removed attached zip... due to post below.
wp:
But you will have an unreadable xls when you increase the number of columns. In my case, the ParamStr(0) is 43 characters long and Excel 2007 cannot read the file if it has more than 14 columns.
grandehombre:
I am downloading the latest version from SF svn and will report back what I discover.
grandehombre:
Bad news, I am afraid.
I downloaded the latest from SF svn (lazarus-ccr-svn-2756.zip) and re-run the test program.
It generated a 7MB file which could not be read by either LibreOffice or Excel.
:-(
BigChimp:
Strange. We're using the same Lazarus/compiler on the same OS. Only difference would be fpspreadsheet I suppose.
I'll send you the fpspreadsheet files I used by pm so you can compare if you want to...
Hmmm there doesn't seem to be a way to send attachments.
Uploaded everything to
http://ubuntuone.com/6l5vgablzHAZMkuPXOqTZS
as I don't want to spam the forum with too many attachments...
Navigation
[0] Message Index
[#] Next page
[*] Previous page