Home » File Formats » Spreadsheet_Excel_Writer » Bug #6099

[2005-11-28 22:39 UTC] tim at davidandgoliathtees dot com

Description:
------------
This is with Spreadsheet_Excel_Writer 0.8, which is the highest stable version in Gentoo.

When I generate a multi-sheet workbook with Spreadsheet_Excel_Writer and open it in either OpenOffice Calc or Excel 2000, any entry into a cell is duplicated in the same cell of every other sheet in the workbook. However, this behavior does not exist during the original creation of the document in PHP.

Also, when I do a Save As in OpenOffice Calc, it thinks the document is an Excel 5.0 spreadsheet, but I can live with that for now.

Let me know what info you need from me, as I'm not sure if the problem is just me being thick and missing something, or a bug in the module.

Test script:
---------------
/*
* Nothing special about how I create the file, except
* that the file name and sheet names are dynamically
* generated.
*/

$workbook = new Spreadsheet_Excel_Writer(sprintf("/home/tredman/docs/edi/originals/%s %s.xls", strtolower($header["customer_name"]), strtolower($header["po_number"])));
$mastersheet =& $workbook->addWorksheet("Master");
$dcsheet =& $workbook->addWorksheet($header["dc_code"]);
$workbook->close();

[2005-11-28 22:43 UTC] tim at davidandgoliathtees dot com

Addendum: I've noticed that resaving it as a 97/2000 Excel sheet doesn't have an effect. However, when I add a sheet to the workbook manually, the behavior goes away on all sheets, and everything works like it's supposed to.