Feb 10, 2010 at 7:35 AM

here is the code:

$formula = "=SUMIF(K5:BF5,F5,K39:BF39)";


in my excel file i have the following:

Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\repsys\Classes\PHPExcel\Calculation\Functions.php on line 1235

Notice: Array to string conversion in C:\Inetpub\wwwroot\repsys\Classes\PHPExcel\Calculation\Functions.php on line 1236


Feb 10, 2010 at 12:34 PM
This discussion has been copied to a work item. Click here to go to the work item and continue the discussion.
Feb 10, 2010 at 12:39 PM

In the meanwhile, Iif you want to fix the code yourself:

Lines 1230,1231 in file Classes/PHPExcel/Calculation/Functions.php currently read:

$aArgs = self::flattenArray($aArgs);
$sumArgs = self::flattenArray($sumArgs);

Add an extra line so that it reads

$aArgs = self::flattenArray($aArgs);
$condition = self::flattenSingleValue($condition);
$sumArgs = self::flattenArray($sumArgs);