Description: ------------ Using php.ini's mbstring.func_overload = 7 breaks Spreadsheet_Excel_Writer

The following script, along with mbstring.func_overload = 7 in php.ini, will produce an invalid XLS file: <?php // Include PEAR::Spreadsheet_Excel_Writer require_once "Spreadsheet/Excel/Writer.php"; // Create an instance $xls =& new Spreadsheet_Excel_Writer(); // Send HTTP headers to tell the browser what's coming $xls->send("test.xls"); // Add a worksheet to the file, returning an object to add data to $sheet =& $xls->addWorksheet('Binary Count'); // Write some numbers for ( $i=0;$i<11;$i++ ) { // Use PHP's decbin() function to convert integer to binary $sheet->write($i,0,decbin($i)); } // Finish the spreadsheet, dumping it to the browser $xls->close(); ?>

A _workaround_ for this is: // save current encoding somewhere safe $original_encoding = mb_internal_encoding(); // hack mb_internal_encoding('ISO-8859-1'); // do spreadsheet stuff here // set the encoding back again mb_internal_encoding($original_encoding); But this defeats the point, because it prevents non-iso1 data being saved.

Hi! Any news on this? Thanks :)

I saw that this is fixed for the Perl equivalent, works with perl 5.8+