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.

I can reproduce this with the test script. Second line does not contain an invalid char, but only the number for me.