Excel2007 setPreCalculateFormulas formular are lowercase

Jan 10, 2013 at 7:42 AM

Hi,

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();
$objPHPExcel->setActiveSheetIndex(0);

$objPHPExcel->getActiveSheet()->SetCellValue('J1',"=Wert(H1)");

$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

Jan 26, 2013 at 8:49 AM

I think this is not the right place to discus about this. As that is not directly related and has nothing to do with the management/maintenance of www.codeplex.com.

codeplex.com is an Open Source Project hosting website. You might be referring to one of the project which is hosted here.