Bug #2010

SetVersion (8) BIFF8 crashes Excel X

Details

Submitted	2004-07-28 23:53 UTC
From	emilio at dorial dot com
Assigned	cschmitz
Status	Closed
Package	Spreadsheet_Excel_Writer
PHP Version	4.3.2
OS	Mac OS X
Roadmaps	(Not assigned)

Comments

[2004-07-28 23:53 UTC] emilio at dorial dot com

Description:
------------
MS Excel X SR1 (For Mac OS X) crashes when trying to
open a file generated with setVersion(8). Both with long
and short text fields.

[2004-07-29 02:59 UTC] emilio at dorial dot com

This also affects Windows versions of Excel.
Excel crashes when the file is in BIFF8 format and
$worksheet->repeatRows(0) is present.
Removing the method repeatRows from the application
works as expected.

[2004-09-09 21:50 UTC] lukasl at rogers dot com

I can confirm that $worksheet->repeatRows(0) crashes Excel 2003 SP1 on Windows XP.

[2006-02-14 11:26 UTC] heck at ondics dot de

I changed in BIFFwriter.php the variable BIFFversion from 0x0500 to 0x0600 and all is perfect. No deleting from functions!!!

[2006-05-29 09:15 UTC] ronaldcanete at gmail dot com

setVersion(8) together with $sheet->setInputEncoding('UTF-8') crashes excel 2003 when writing >175 rows, 19 cols with some korean characters in each row.

[2006-06-14 21:12 UTC] schotte at mayflower dot de

setVersion(8) also crashed here with setInputEncoding('iso-8859-5'); after about 100 rows - seems that only iso-8859-1 or no setInputEncoding() is working.

[2006-10-11 07:45 UTC] micbox at freenet dot am

I have experienced the same crash problem while trying to generate Excel files with setVersion(8) and repeating a header row.

[2006-10-18 10:41 UTC] pear at oliwel dot de

Can confirm this too - PHP 4.4 with v0.9.1.
Document is Version 8 with UTF8 encoding. 32 Cols each row, crashes after 38 Rows.

Oliver

[2006-11-18 00:32 UTC] juha at kinesissurvey dot com

PHP Version 4.3.10 on SuSe Linux 9 with Excel Writer 0.9.1 crashes Excel 2003 on Windows XP. I have setVersion(8) and set encoding to UTF-8.

[2006-12-20 17:39 UTC] cyberon at poczta dot onet dot pl

PHP 5 apache 2, excel crashes after setVersion(8) in php script :(

[2007-01-09 15:23 UTC] marcofw at web dot de

Hi, got problems with 0.9.1, setVersion(8) and setInputEncoding('UTF-8'). The data is stored in utf8 in MySQL after an reproducable count of rows it leads to an error and the following data is corrupt. Any news on this issue? Regards, Marco