Warning: trim() expects parameter 1 to be string, array given

[alaindev]

when cell with indirect formula "=SUM(D1:INDIRECT(ADDRESS(ROW();COLUMN()-4)))"

Warning: trim() expects parameter 1 to be string, array given in C:\Program Files (x86)\EasyPHP-Devserver-17\eds-www\aplitec\includes\modules\phpoffice\phpspreadsheet\src\PhpSpreadsheet\Calculation\Calculation.php on

Patch : Calculation.php line 4536 & 4546
if ((trim($operand1Data['value']) != '') && (is_numeric($operand1Data['value']))) {

should be
if (!is_array($operand1Data['value']) && (trim($operand1Data['value']) != '') && (is_numeric($operand1Data['value']))) {

relativecell.xlsx

Regards
Alain

[alaindev]

Sorry
I forgot PHP Code & version : PHPSpreadsheet 1.23

Appears at save

getSheetNames(); $liassewriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($showPHPExcel, "Xlsx"); $file = 'c:\tmp\file1.xlsx'; $liassewriter->save($file); ?>

[oleibman]

PR #2774 makes minor changes to the same area of code. I will try to address this in that change. In the meantime, can you open this as a new issue rather than a discussion topic.

[alaindev]

Thanks created the issue 2780 Alain Le 25/04/2022 à 16:50, oleibman a écrit : PR #2774 makes minor changes to the same area of code. I will try to address this in that change. In the meantime, can you open this as a new issue rather than a discussion topic. — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you authored the thread.Message ID: ***@***.***> [ { ***@***.***": "http://schema.org", ***@***.***": "EmailMessage", "potentialAction": { ***@***.***": "ViewAction", "target": "#2778 (comment)", "url": "#2778 (comment)", "name": "View Discussion" }, "description": "View this Discussion on GitHub", "publisher": { ***@***.***": "Organization", "name": "GitHub", "url": "https://github.com" } } ]

[oleibman]

Fixed by PR #2774.