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