Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.9.3

Bug #21 Formula BUG
Submitted: 2003-09-18 09:04 UTC Modified: 2003-09-26 10:21 UTC
From: arhip at goldentele dot com Assigned: xnoguer
Status: Closed Package: Spreadsheet_Excel_Writer
PHP Version: 4.3.2 OS: Linux
Roadmaps: (Not assigned)    

 [2003-09-18 09:04 UTC] arhip at goldentele dot com
Description: ------------ I'm using the last ersions of Spreadsheet Write Excell and OLE. I found a problem with russian (windows-1251 codepage) characters in formula: using a sheet reference. But russian chars works well just as sheet name. With english chars all ok. Reproduce code: --------------- $wb = new Spreadsheet_Excel_Writer("-"); $sheet = array(); $sheet[1] =& $wb->addWorksheet('îäèí'); $sheet[2] =& $wb->addWorksheet('Òåëåôîíèÿ'); $sheet[1]->write(1, 2, ''); $sheet[1]->write(1, 3, ''); $sheet[1]->write(1, 1, 5000); $sheet[1]->mergeCells(1,1, 1,3); $sheet[1]->write(2, 3, 1000); $sheet[1]->writeFormula(3, 3, "=SUM(B2,D3)"); $sheet[2]->writeFormula(3, 3, "=SUM(îäèí!B2,D3)"); header("Content-type: application/"); header("Content-Disposition: attachment; filename=test.xls" ); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0,pre-check=0"); header("Pragma: public"); $wb->close(); Expected result: ---------------- In second sheet (named Òåëåôîíèÿ) in cell 3, 3 must be a formula with reference to onother sheet (sheet number one named îäèí). Actual result: -------------- I don't know what happens. IE shows to me an standart page: "The page cannot be displayed". In acces and error log of my web-server (Apache) i cant find records for this request. If i'm using an english chars in sheet name and in formula - all works correctly.


 [2003-09-26 10:21 UTC] xnoguer at php dot net
This bug has been fixed in CVS. In case this was a PHP problem, snapshots of the sources are packaged every three hours; this change will be in the next snapshot. You can grab the snapshot at In case this was a documentation problem, the fix will show up soon at In case this was a website problem, the change will show up on the site and on the mirror sites in short time. Thank you for the report, and for helping us make PHP better.