LNA wrote:
While reading the following formula, I get a "3D Range references are not yet supported" exception
SUMIF(Detail!$K:$K,"CP",Detail!$C:$C)
The same error occurs when setting bounds to the cell range :
SUMIF(Detail!$K1:$K1000,"CP",Detail!$C1:$C1000)
I thought that a 3D range reference was a formula calling multiple sheets (like SUM(Sheet1:Sheet2!$K1...) )
Did I misunderstood something or is this formula just not readable by PHPExcel for now?
This issue is partially resolved in the latest SVN code. Using the formula:
SUMIF(Detail!$K1:$K1000,"CP",Detail!$C1:$C1000)
specifying a cell range will return the correct result
You can access the latest SVN code via the "Source Code" tab here on PHPExcel.net, and the only file needed to resolve this is Classes/PHPExcel/Calculation.php
Row and column ranges such as
SUMIF(Detail!$K:$K,"CP",Detail!$C:$C)
or
SUMIF(Detail!$2:$2,"CP",Detail!$2:$2)
still cause some problems
