Empty Arg for Function Embedded in False Side of IF

[oleibman]

This is:

- [x] a bug report
- [ ] a feature request
- [x] **not** a usage question (ask them on https://stackoverflow.com/questions/tagged/phpspreadsheet or https://gitter.im/PHPOffice/PhpSpreadsheet)

What is the expected behavior?

See below

What is the current behavior?

See below

What are the steps to reproduce?

An empty argument passed to a function on the False side of an IF function will cause an "Internal Error" when evaluated. I initially thought this might be due to PR #3868, but this also happened before the PR. In addition, that PR affected only 4 functions, and this problem will arise when an argument is omitted from any function.

Disabling branch pruning eliminates the problem.

$sheet->setCellValue('B1', 2);
$sheet->setCellValue('A1','=if(1=B1,min(3,2,,4),99)');

A1 will be correctly calculated as 99 without pruning, but will receive an internal error with pruning.

There is no problem if no argument is omitted.

$sheet->setCellValue('B1', 2);
$sheet->setCellValue('A1','=if(1=B1,min(3,2,1,4),99)');

A1 will be correctly calculated as 99 with or without pruning.

There is no problem if an argument is omitted on the TRUE side.

$sheet->setCellValue('B1', 1);
$sheet->setCellValue('A1','=if(1=B1,min(3,2,,4),99)');

A1 will be correctly calculated as 0 with or without pruning.

What features do you think are causing the issue

• Reader
• Writer
• Styles
• Data Validations
• Formula Calculations
• Charts
• AutoFilter
• Form Elements

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

All

Which versions of PhpSpreadsheet and PHP are affected?

All

[oleibman]

I think I have found the problem and a possible fix. Expect something within the next few days.