IF conditions in Cell Value

[pashochok]

Hi, I have some issues with setting conditions to Cell
I have two types of formulas (SUM and IF)
in maatwebsite/excel versions 3.1.21-3.1.25 (php 7.4, Laravel 5.6) i coud set condition formulas to the cell such as
$event->sheet->getCell('A5' )->setValue('=SUM(A1:A4)');
$event->sheet->getCell('B1' )->setValue('=IF(A2 = 0;0;1)');
works well,

but after updating php to version 8.0.2 and laravel to 9+ and maatwebsite/excel to 3.1.36-3.1.40(tried every release)

this line -> "$event->sheet->getCell('B1' )->setValue('=IF(A2 = 0;0;1)');" causes error "B1 -> Formula Error: An unexpected error occurred"
Can you help me with this issue?

[MarkBaker]

I don't know how

$event->sheet->getCell('B1' )->setValue('=IF(A2 = 0;0;1)');

would have worked before, if there is anything in Laravel-Excel that converts a formula to the rules required in PhpSpreadsheet, but from the PhpSpreadsheet documentation:

Inside the Excel file, formulas are always stored as they would appear in an English version of Microsoft Office Excel, and PhpSpreadsheet handles all formulae internally in this format. This means that the following rules hold:

• Decimal separator is . (period)
• Function argument separator is , (comma)
• Matrix row separator is ; (semicolon)
• English function names must be used

If you want to use locale-specific formulae, then this is supported through a PhpSpreadsheet setting