Jan 10, 2013 at 7:47 AM
Edited Jan 10, 2013 at 7:51 AM
I write some Code to transform a CSV file to a Excel.
I don't want to that the Formulas are Calculated in the outputfile, so I user the setPreCalculateFormulas Flag
When I save the document all Formulars in the Document are lowercase an show me an error because the must write Uppercase.
Some Example Code
$objPHPExcel = new PHPExcel();
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$objWriter->setPreCalculateFormulas(FALSE); $objWriter->save(str_replace('.php', '.xlsx', __FILE__));
I can't finde the reason why the Formulars are written lowercase. I Zip the xlsx and can see that the Formula is uppercase in xl\worksheets\sheet1.xml
I use the PHPExcel Version 1.7.8 and PHP 5.3.2 on ubuntu 4.17