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

Bug #21 Formula BUG
Submitted: 2003-09-18 14:04 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)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 11 - 1 = ?

 
 [2003-09-18 14: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/vnd.ms-excel"); 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.

Comments

 [2003-09-26 15: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 http://snaps.php.net/. In case this was a documentation problem, the fix will show up soon at http://www.php.net/manual/. In case this was a PHP.net website problem, the change will show up on the PHP.net site and on the mirror sites in short time. Thank you for the report, and for helping us make PHP better.