XLS 2003 VSLOOKUP parsing error

[bbinotto-redline]

Tested with Version 3.9.0

The Following Code produces the error:
"PhpOffice\PhpSpreadsheet\Writer\Xls\Parser::convertFunction(): Argument #2 ($num_args) must be of type int, string given"

Code:

        $reader = IOFactory::createReader(IOFactory::READER_XLS);
        $reader->setReadDataOnly(true);
        $excel = $reader->load(dirname(__FILE__).'/VSLOOKUP_example_2003.xls');
        $writer = IOFactory::createWriter($excel, IOFactory::WRITER_XLS);
        $writer->save(dirname(__FILE__).'/VSLOOKUP_output_2003.xls');

File (German XLS File with German Function Name 'SVERWEIS' for 'VSLOOKUP':
VSLOOKUP_example_2003.xls

[oleibman]

Thank you for the sample file. There have been recent changes to Writer/Xls/Parser, but I have confirmed that this problem existed before those changes. What appears to be happening is that Parser is treating FALSE (or TRUE) as a function rather than a constant, which is nominally a harmless difference. However, since it wasn't a function, when it tries to parse the arguments, the field in which it expects the argument count is null-string rather than 0. Expect a fix within a day or two.