Deprecated NULL in 1st arg implode

[T35]

\PhpOffice\PhpSpreadsheet\Calculation\TextData\Concatenate::TEXTJOIN
...
88 $returnValue = ($returnValue !== '') ? $returnValue : implode($delimiter, $aArgs);
...
(!) $delimiter = NULL if the function in the table looks like this: =TEXTJOIN(;;$B13:$E13)
PHP 8.1.11
LibreOffice

[MarkBaker]

I do love the consistency of Microsoft documentation. The official documented signature for TEXTJOIN() is:

TEXTJOIN(delimiter, ignore_empty, text1, [text2], …)

argument	description
delimiter (required)	A text string, either empty, or one or more characters enclosed by double quotes, or a reference to a valid text string. If a number is supplied, it will be treated as text.
ignore_empty (required)	If TRUE, ignores empty cells.
text1 (required)	Text item to be joined. A text string, or array of strings, such as a range of cells.
[text2, ...] (optional)	Additional text items to be joined. There can be a maximum of 252 text arguments for the text items, including text1. Each can be a text string, or array of strings, such as a range of cells.

So delimiter and ignore_empty should be mandatory according to that.

But Excel itself does allow

=TEXTJOIN(;;$B13:$E13)

like LibreOffice

---

required
/rɪˈkwʌɪəd/
adjective

officially compulsory, or otherwise considered essential; indispensable.

[MarkBaker]

PR #3197