[BUG] TypeError: round(): Argument #1 ($num) must be of type int|float, string given

[hebinet]

1️⃣ Is the bug applicable and reproducable to the latest version of the package and hasn't it been reported before? (Currently 3.1.x)
Yes

2️⃣ What version of the package, Laravel and PHP do you use? Please provide the FULL version number.
Package: 3.1.30
Laravel: 8.41.0
PHP: 8.0.6

3️⃣ Describe your issue. Please be short, but concise.
There is a problem with formula calulations if a division by 0 occures.
This was fixed in phpoffice/phpspreadsheet v1.17.x (see Issue in Package: PHPOffice/PhpSpreadsheet#1789 ) but in the composer json the Version was pinned to 1.16.x

4️⃣ How can the issue be reproduced? Please provide easy-to-reproduce steps (repository, simple code example, failing unit test).
See PHPOffice/PhpSpreadsheet#1789

5️⃣ What should be the expected behaviour?
See PHPOffice/PhpSpreadsheet#1789

No exception gets thrown and the excel can be generated as normal

6️⃣ Have you filled in the entire issue template? If not, your issue will be closed. Thanks for using the package! 🙌
Yes ;)

[patrickbrouwers]

I'm still waiting for a 1.17.2 release of PhpSpreadsheet. 1.17.1 has a bug which makes it unusable for Laravel Excel. Not much we can do until then I'm afraid.

[patrickbrouwers]

PhpSpreadsheet released 1.18 so it should be fixed now