Disable formula Parse

Topics: User Forum
Oct 30, 2008 at 10:18 AM
Edited Oct 30, 2008 at 10:26 AM
Hi, (sorry for my english)
is possible to disable the formula parse/precalculation?
(with: PHPExcel_Writer_Excel5)

- Feature:  (MB) Work item 3080 - Optionally disable formula precalculation
I have read this, but i cant find an example of this. What is the function?

Thank you.
Andy


Developer
Oct 30, 2008 at 10:35 AM
Edited Oct 30, 2008 at 11:05 AM
Here is the method:

$excel = new PHPExcel();
...

$writer = new PHPExcel_Writer_Excel2007($excel);
$writer->setPreCalculateFormulas(false);
$writer->save('test.xlsx');

Note that this is only for the Excel2007 writer. For the Excel5 writer
there is no precalculation. (Not yet implemented)