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

Bug #9062 Euro does not appear correctly in formula styles
Submitted: 2006-10-16 08:03 UTC Modified: 2009-08-05 13:41 UTC
From: simon at elroble dot co dot uk Assigned: progi1984
Status: Verified Package: Spreadsheet_Excel_Writer (version 0.9.1)
PHP Version: 4.4.3 OS: Apache Webserver | Windows XL
Roadmaps: (Not assigned)    
Subscription  
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes. If this is not your bug, you can add a comment by following this link. If this is your bug, but you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: simon at elroble dot co dot uk
New email:
PHP Version: Package Version: OS:

 

 [2006-10-16 08:03 UTC] simon at elroble dot co dot uk (Simon Tiplady)
Description: ------------ I can add the euro symbol to a worksheet as text field with no problem but when i use the euro symbol as part of a number format in a style the euro is encoded incorrectly. From past experience the Euro symobl may not appear correctly in this bug report, setNumFormat("#,##0.00 ¤"); The character between the 0.00 and the close quote should be a euro symbol Test script: --------------- <? include("Spreadsheet/Excel/Writer.php"); $workbook = new Spreadsheet_Excel_Writer(); $workbook->setVersion(8); $worksheet =& $workbook->addWorksheet(); $worksheet->setInputEncoding('UTF-8'); $CurrencyStyle =& $workbook->addFormat(); $CurrencyStyle->setNumFormat("#,##0.00 ¤"); /** this one works ok when added as text */ $worksheet->write(0,0,"2.15 ¤"); /** because the euro is added as a format, it now fails */ $worksheet->write(1,1,"2.15",$CurrencyStyle); $workbook->send('Euro.xls'); $workbook->close(); ?> Expected result: ---------------- Euro should display correctly in the sheet regardless if it is a format or a text.

Comments

 [2008-11-03 07:05 UTC] body (Yerbol Nyssanbekov)
Hi, I have the same problem... Does anybody know solution for this? Please help...
 [2009-08-05 13:41 UTC] progi1984 (Franck Lefevre)
-Status: Open +Status: Verified -Assigned To: +Assigned To: progi1984