Excel2007 setPreCalculateFormulas formular are lowercase

Topics: Developer Forum
Jan 10, 2013 at 8:47 AM
Edited Jan 10, 2013 at 8: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

Jan 13, 2013 at 12:08 PM

Is Wert() a valid Excel function? Unless you're using one of the locale settings for the calculation engine, all formulae must be "English" formatted: English language function names, commas as function argument separators, etc

Jan 17, 2013 at 11:52 AM

Thank you,

that fixed my problem