Inconsistent handling of empty parameters in formulas between PhpSpreadsheet and Excel

[jonas-grobe]

This is a bug report.

What is the expected behavior?

Excel seems to treat empty parameters as 0, =MIN(3,2,) evaluates to 0.

What is the current behavior?

=MIN(3,2,) evaluates to 2 in PHPSpreadsheet.

What are the steps to reproduce?

<?php

require __DIR__ . '/vendor/autoload.php';

$spreadsheet = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$formula = '=MIN(3,2,)';
$sheet->setCellValue('A1', $formula);
$cellValue = $sheet->getCell('A1')->getCalculatedValue();
echo "Result of MIN(3,2,): $cellValue"; // PHPSpreadsheet: 2, Excel: 0

What features do you think are causing the issue

• Formula Calculations

Which versions of PhpSpreadsheet and PHP are affected?

Tested on PHPSpreadsheet 1.29.0 with PHP 8.0.12