Home » File Formats » Spreadsheet_Excel_Writer » Bug #2146

[2004-08-17 12:32 UTC] pwa dot net at free dot fr

Description:
------------
setversion(8) used with printArea crashes Excel
Use excel spreadsheet 0.8,
OLE 5.0

Reproduce code:
---------------
require_once 'Spreadsheet/Excel/Writer.php';
// Creating a workbook
$workbook = new Spreadsheet_Excel_Writer();
$workbook->SetVersion(8);

// sending HTTP headers
$workbook->send('test.xls');

// Creating a worksheet
$worksheet1 =& $workbook->addWorksheet('Premier feuillet');

// The actual data
$worksheet1->write(3, 2, 'Ce fichier à été entièrement généré avec PHP');

// BUG WITH THIS LINE
$worksheet1->printArea(1,1,5,5);

// Let's send the file
$workbook->close();

Actual result:
--------------
Excel crashes