Formula Does Not calculate automatically

May 15, 2010 at 11:45 PM

I've been using the PHPExcel Class for some development today and everything was running fine (fantastic open-source work) until I ran into this problem.  I tried to set the following formula:

=G2*SUMPRODUCT(D5:F5/D2:F2)/3

And the excel file shows a calculation error (#VALUE!), until I double-click into it and hit enter, then everything is fine.  Is there something off with my syntax or is there  property I should be setting?

 

Coordinator
May 15, 2010 at 11:57 PM
Edited May 15, 2010 at 11:58 PM

Quoting from the FAQ

Formulas don’t seem to be calculated in Excel2003 using compatibility pack?
This is normal behaviour of the compatibility pack, Excel2007 displays this correctly. Use PHPExcelWriterExcel5 if you really need calculated values, or force recalculation in Excel2003.

Is this the problem?

Aug 14, 2010 at 12:11 AM

For future reference - in Excel2003, Ctrl-Alt-F9 will force a complete recalculation.