Fatal error XlsxWriter.php on line 201

[sam369963]

Hi I am using PHP version 7.4.27 and i have tried to-get it working phpspreadsheet to
phpoffice/phpspreadsheet": "^1.22",

When i use the your settings version 7.0 and 1.5 with this command
composer require lyquidity/php-pivottables-4-excel-lite:dev-master --prefer-dist

Fatal error: Declaration of lyquidity\xbrl_validate\PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($pFilename): void must be compatible with PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($filename, int $flags = 0): void in C:\xampp\htdocs\Pivot\vendor\lyquidity\php-pivottables-4-excel-lite\phpspreadsheet\XlsxWriter.php on line 201

Then i tried to use,
1. composer update --verbose (with the setting 7.4 and 1.22)
2. composer require lyquidity/php-pivottables-4-excel-lite:dev-master --prefer-dist
I still get the same error.

Fatal error: Declaration of lyquidity\xbrl_validate\PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($pFilename): void must be compatible with PhpOffice\PhpSpreadsheet\Writer\Xlsx::save($filename, int $flags = 0): void in C:\xampp\htdocs\Pivot\vendor\lyquidity\php-pivottables-4-excel-lite\phpspreadsheet\XlsxWriter.php on line 201

What am i doing wrong

[bseddon]

My guess is that you are using a later version of phpSpreadsheet than me and in the newer the signature of the save function has changed to have a second optional int parameter called $flags. You will need to update the file indicated in the message to add the new parameter.

[sam369963]

Hi, okay.
Sorry for the stupid question.
With what should I update the file indicated in the message to new parameter.
Thanks.

[bseddon]

Copy the signature of the Save() function from the first mentioned file to the save() function of the second mentioned file.

Please note that the reason you are seeing the message is that code is written for an earlier version of phpSpreadsheet. Because I have no need to update to a newer version, the code has not been updated. As a result, the error you see may only be the tip of the iceberg.

I think there are posts in the Issues that indicate others have not been able to use the code in this repository with newer versions of phpSpreadsheet.

[sam369963]

ooo OKay, thanks for the information

[laxx]

I downgraded my phpSpreadsheet version down to 1.15 because I saw your above comment regarding the function signature and all. After the downgrade, I tried to reinstall your package but i'm still getting the same error. Do I need to manually edit the files to make sure that the function signature matches on both sides?

Will really appreciate your feedback