PhpSpreadsheet: Uncaught PHP Exception Error: "Call to a member function getHashCode() on null"

[kernie]

Describe the bug
I added a xlsx file as invoice template. Creating the invoice I get an error message in the log files.

Searching a bit I found this PHPOffice/PhpSpreadsheet#1873 .

A fix was added for Version 1.17.1 of PhPSpreadsheet recently.

Logfile

[2021-04-16 12:04:35] request.CRITICAL: Uncaught PHP Exception Error: "Call to a member function getHashCode() on null" at /var/www/kimai2/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/ReferenceHelper.php line 611 {"exception":"[object] (Error(code: 0): Call to a member function getHashCode() on null at /var/www/kimai2/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/ReferenceHelper.php:611)"} []
[2021-04-16 12:04:35] php.CRITICAL: Uncaught Error: Call to a member function getHashCode() on null {"exception":"[object] (Error(code: 0): Call to a member function getHashCode() on null at /var/www/kimai2/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/ReferenceHelper.php:611)"} []

Additional context

• Kimai version: 1.13
• PHP version: 7.3.24
• Browser: Firefox 87

[kevinpapst]

I assume you are using a different PHP version for the command line (to clear the cache) and web.
I'd say command line 7.4 and webserver/browser 7.3.

[kernie]

So, I checked, the only php version installed on the server is PHP 7.3.24. I corrected it above.

[kevinpapst]

Hm, I never experienced that bug, but I also never use excel invoices ....

Try the excel templates from here: https://github.com/Keleo/kimai2-invoice-templates
Do they work? Maybe it is a problem of your template.

[kernie]

The templates you suggested seem to work. Probably, it's my template, I have to investigate further.

[kevinpapst]

I am closing here, as it is not a direct Kimai bug.
If you can share more infos, please share them with the community.

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs. If you use Kimai on a daily basis, please consider donating to support further development of Kimai.