IF Problem, bug?

Topics: User Forum
Oct 29, 2010 at 4:43 PM
Edited Oct 30, 2010 at 9:06 AM

in an xlsx and an xls file i have the following:

In cell C38 on sheet IBFR have this formula:
=IF(COUNT(Score!A3:A52)=0,"",Score!AC53) (in excel it displays 72 in this column)

Score!A3:A52 is numbered 1 to 15 (the numbers alternate rows, so A3=1,A4='',A5=2...), with the extra cells to A52 empty.

Score!AC53 is =IF(COUNT(AC3:AC52),SUM(AC3:AC52),"") (in excel it displays 72 in this column)

When I do a getCalculatedValue on the cell at C38 on the IBFR sheet I get 0

It's wrong. In Excel, it shows 72. Is a bug?

Nov 1, 2010 at 10:53 PM

It could be a bug. The calculation engine in PHPExcel isn't perfect. However, can you please try with the latest SVN code which includes some fixes for problems when a formula references cells in another worksheet. Latest SVN code can be accessed from the "Source Code" tab here on phpexcel.net