mirror of
https://github.com/PHPOffice/PhpSpreadsheet.git
synced 2026-11-09 19:36:15 +00:00
HawkForge
a7dbf35f62
When an IF sits in the condition of another IF, BranchPruner only looked at the immediately enclosing IF to decide which branch the condition tokens depend on. If that enclosing IF was itself still in its condition, nothing was recorded, so the link to an outer IF whose branch is being pruned was lost. Those tokens were then evaluated and left on the stack while the rest of the branch was pruned, and the calculation ended with "internal error". Walk up the stack of enclosing IFs to the closest one whose then or else branch contains the nested IF instead. Fixes #3790 Fixes #3755
83 lines
2.4 KiB
PHP
83 lines
2.4 KiB
PHP
<?php
|
|
|
|
declare(strict_types=1);
|
|
|
|
/** @return mixed[] */
|
|
function calculationTestDataGenerator(): array
|
|
{
|
|
$dataArray1 = [
|
|
['please +', 'please *', 'increment'],
|
|
[1, 1, 1], // sum is 3
|
|
[3, 3, 3], // product is 27
|
|
];
|
|
$set0 = [3, $dataArray1, '=IF(A1="please +", SUM(A2:C2), 2)', 'E5'];
|
|
|
|
$set1 = [3, $dataArray1, '=IF(TRUE(), SUM(A2:C2), 2)', 'E5'];
|
|
|
|
$formula1 = '=IF(A1="please +",SUM(A2:C2),7 + IF(B1="please *", 4, 2))';
|
|
$set2 = [3, $dataArray1, $formula1, 'E5'];
|
|
|
|
$dataArray1[0][0] = 'not please + something else';
|
|
$set3 = [11, $dataArray1, $formula1, 'E5'];
|
|
|
|
$dataArray2 = [
|
|
['flag1', 'flag2', 'flag3', 'flag1'],
|
|
[1, 2, 3, 4],
|
|
[5, 6, 7, 8],
|
|
];
|
|
$set4 = [3, $dataArray2, '=IF($A$1=$B$1,A2,IF($A$1=$C$1,B2,IF($A$1=$D$1,C2,C3)))', 'E5'];
|
|
|
|
$dataArray2[0][0] = 'flag3';
|
|
$set5 = [2, $dataArray2, '=IF(A1=B1,A2,IF(A1=C1,B2,IF(A1=D1,C2,C3)))', 'E5'];
|
|
|
|
$dataArray3 = [
|
|
[1, 2, 3],
|
|
[4, 5, 6],
|
|
[7, 8, 9],
|
|
];
|
|
$set6 = [0, $dataArray3, '=IF(A1+B1>3,C1,0)', 'E5'];
|
|
|
|
$dataArray4 = [
|
|
['noflag', 0, 0],
|
|
[127000, 0, 0],
|
|
[10000, 0.03, 0],
|
|
[20000, 0.06, 0],
|
|
[40000, 0.09, 0],
|
|
[70000, 0.12, 0],
|
|
[90000, 0.03, 0],
|
|
];
|
|
$formula2 = '=IF(A1="flag",IF(A2<10, 0) + IF(A3<10000, 0))';
|
|
$set7 = [false, $dataArray4, $formula2, 'E5'];
|
|
|
|
$dataArray5 = [
|
|
[1, 2],
|
|
[3, 4],
|
|
['=A1+A2', '=SUM(B1:B2)'],
|
|
['take A', 0],
|
|
];
|
|
$formula3 = '=IF(A4="take A", A3, B3)';
|
|
$set8 = [4, $dataArray5, $formula3, 'E5', ['A3'], ['B3']];
|
|
|
|
$dataArray6 = [
|
|
['=IF(22,"a","b")'],
|
|
];
|
|
$set9 = ['a', $dataArray6, '=A1', 'A2'];
|
|
|
|
// Issues 3755 and 3790 - IF nested in the condition of an IF within a pruned branch
|
|
$set10 = [3, [], '=IF(FALSE, IF(IF(TRUE,6,2),1,2), 3)', 'E5'];
|
|
$formula4 = '=IF(FALSE, IF( LEFT( "0", 3 ) = "16-", 1, IF( OR( 1 = IF( "Le L" = "Le L", 6.89, 2 ), AND( 0.735 = 1, "0" <> "" ) ), "", 1 ) ), 3)';
|
|
$set11 = [3, [], $formula4, 'E5'];
|
|
$dataArray7 = [
|
|
[2],
|
|
];
|
|
$formula5 = '=IF(A1=1,IF(AND(IF(1>0,1,IF(0=0,(0*0),0))>0,IF(0>0,0,IF(0=0,(0*0),0))<1),1,ROUND(IF(0>0,0,IF(1=0,(1*1),1)),0)),0)';
|
|
$set12 = [0, $dataArray7, $formula5, 'E5'];
|
|
|
|
return [
|
|
$set0, $set1, $set2, $set3, $set4, $set5, $set6, $set7, $set8, $set9,
|
|
$set10, $set11, $set12,
|
|
];
|
|
}
|
|
|
|
return calculationTestDataGenerator();
|