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

Bug #2876 German Umlauts destroy sheet references
Submitted: 2004-12-02 17:00 UTC
From: bieniek at dotzilla dot de Assigned: xnoguer
Status: Closed Package: Spreadsheet_Excel_Writer
PHP Version: 4.3.9 OS: Win32/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 : 32 - 21 = ?

 
 [2004-12-02 17:00 UTC] bieniek at dotzilla dot de
Description: ------------ If You use german umlauts in sheetnames like Düsseldorf (ÖÄÜöäüß) the sheet reference is broken... with strange behaviour... although spaces are not working Reproduce code: --------------- $ypos=1; $worksheetname="Düsseldorf"; $worksheet->write($ypos,0,$worksheetname); $formula="='".$worksheetname."'!A1"; # not working $worksheet->writeFormula($ypos,1,$formula); $worksheetname="Essen 1"; $formula="='".$worksheetname."'!A1"; #not working $worksheet->writeFormula($ypos,2,$formula); $worksheetname="Essen"; $formula="='".$worksheetname."'!A1"; #working $worksheet->writeFormula($ypos,3,$formula); Expected result: ---------------- Field 1 0 Value= Düsseldorf Field 1 1 Value of ='Düsseldorf'!A1 Field 1 2 Value of ='Essen 1'!A1 Field 1 3 Value of ='Essen'!A1 Actual result: -------------- Field 1 0 Value= Düsseldorf Field 1 1 Value of some field in the current sheet Field 1 2 Value of straight error Field 1 3 Value of ='Essen'!A1

Comments

 [2005-11-08 00:24 UTC] xnoguer at php dot net
This bug has been fixed in CVS. If this was a documentation problem, the fix will appear on pear.php.net by the end of next Sunday (CET). If this was a problem with the pear.php.net website, the change should be live shortly. Otherwise, the fix will appear in the package's next release. Thank you for the report and for helping us make PEAR better. seems to be working for me now, but if you could test the cvs version I would really apreciate it. The fix requires php >= 4.1.0 in unix or php >= 4.2.3 on win.