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

Bug #14738 Euro symbol not working in formats
Submitted: 2008-10-03 15:57 UTC
From: tuggie Assigned:
Status: Verified Package: Spreadsheet_Excel_Writer (version 0.9.2)
PHP Version: 5.2.6 OS: Windows XP
Roadmaps: (Not assigned)    
Subscription  


 [2008-10-03 15:57 UTC] tuggie (Paul Tugwell)
Description: ------------ I cannot get the Euro symbol to print in formatted numbers in spreadsheets using BIFF8, although it works fine with BIFF5. However, I have to use BIFF8 as I need to use long labels that are truncated in BIFF5. Any suggestions? Any ideas for workarounds? Test script: --------------- <?php require_once('Spreadsheet/Excel/Writer.php'); $workbook = new Spreadsheet_Excel_Writer(); $workbook->setVersion(8); $worksheet =& $workbook->addWorksheet(); $worksheet->setInputEncoding('Windows-1252' ); $worksheet->write(1,0,'ยค'); $strEuroFormat = '#,##0.00'; $objEuroFormat = &$workbook->addFormat(); $objEuroFormat->setNumFormat($strEuroFormat); $objEuroFormat->setAlign('right'); $worksheet->writeNumber(2,0,250, $objEuroFormat); $workbook->send('test.xls'); $workbook->close(); ?> Expected result: ---------------- Cell (1,0) contains a Euro symbol and cell (2,0) contains 250.00 precedded by a Euro symbol. Actual result: -------------- Cell (1,0) contains a Euro symbol but cell (2,0) contains 250.00 precedded by a ? in a square.

Comments

 [2009-11-29 05:56 UTC] cschmitz (Carsten Schmitz)
-Status: Open +Status: Verified -Package Version: 0.9.1 +Package Version: 0.9.2
I can reproduce this with the test script. Second line does not contain an invalid char, but only the number for me.