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

Bug #18078 printArea + setVersion(8) + setInputEncoding('utf-8') = error
Submitted: 2010-11-19 17:52 UTC
From: olga25 Assigned:
Status: Feedback Package: Spreadsheet_Excel_Writer (version 0.9.2)
PHP Version: 5.2.9 OS: Linux
Roadmaps: (Not assigned)    
Subscription  


 [2010-11-19 17:52 UTC] olga25 (Olga Zhuravleva)
Description: ------------ I have generated the excel spreadsheet using Spreadsheet_Excel_writer. Every thing is working fine in Openoffice, but in MS Office when I try to open the generated spreadsheet it gives error message "File error: can't read date" Php file saved in utf8. Test script: --------------- <? //setVersion(8)+setInputEncoding('utf-8')+printArea=error im MS Office include "Spreadsheet/Excel/Writer.php"; $xls = new Spreadsheet_Excel_Writer(); $xls->setVersion(8); $format =& $xls->addFormat(array('Size'=>11,'Bold'=>1,'FontFamily'=>'Times New Roman','TextWrap'=>1)); $worksheet =& $xls->addWorksheet('my'); $worksheet->setInputEncoding('utf-8'); $worksheet->write(0, 2, 'Namber ',$format); $worksheet->printArea(0,0,10,5); $xls->send('ter.xls'); $xls->close(); ?> Expected result: ---------------- Open MS Office excel file Actual result: -------------- error: can't read date

Comments

 [2017-03-25 05:09 UTC] sanmai (Alexey Kopytko)
-Status: Open +Status: Feedback
Please try with the latest development version: http://pear.php.net/package/Spreadsheet_Excel_Writer If using composer it is a simple as this: composer require pear/spreadsheet_excel_writer