Formula not calculated in PDF

Topics: Developer Forum, User Forum
Aug 24, 2009 at 2:50 PM
Edited Aug 24, 2009 at 2:52 PM

 

I was trying out a sample Excel invoice template with formula like:
=TODAY()
=IF(SUM(A20)>0,SUM((A20*E20)-F20),"")
When generating PDF, they come up as 
[$-40047]mmmm d yyyy, and 0
I am just using the following script:
$objPHPExcel = PHPExcel_IOFactory::load($filename);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');
$objWriter->setSheetIndex(0); 
$objWriter->save(str_replace('.php', '.pdf', __FILE__));
Does it supposed to work?
Thanks!

I was trying out a sample Excel invoice template with formula like:

=TODAY()

=IF(SUM(A20)>0,SUM((A20*E20)-F20),"")

When generating PDF, they come up as 

[$-40047]mmmm d yyyy, and 0

 

I am just using the following script:

$objPHPExcel = PHPExcel_IOFactory::load($filename);

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'PDF');

$objWriter->setSheetIndex(0); 

$objWriter->save(str_replace('.php', '.pdf', __FILE__));

 

Does it supposed to work?

Thanks!

 

 

 

Developer
Aug 25, 2009 at 3:24 PM

Work item created:

http://phpexcel.codeplex.com/WorkItem/View.aspx?WorkItemId=10524