Added
- Formal support for Php8.6.
- Psalm taint analysis annotations: the files read and written are file sinks, and cell values are untrusted input. PR #5070
Fixed
- Ods Writer writes the value of an error cell, such as
#N/Aor#DIV/0!; every error constant was written as#NULL!. Issue #5022 PR #5067 - Fix pivot table with two or more data fields removed by Excel. Issue #5106 PR #5107
XLOOKUP()without anif_not_foundargument returns a real#N/Aerror when nothing matches, instead of the string#N/A!, soISNA(),ISERROR()andIFNA()handle it. Issue #5085 PR #5095- Defined Name can be set to TRUE or FALSE. Issue #5087 PR #5100
- Csv Writer: a text cell is written as it is, and only a value that is entirely a number is limited to 15 digits, so text that begins with a long number is no longer cut down to that number. Issue #5092 PR #5094
- Removing a sheet drops the defined names local to it, and turns the named ranges which refer to it into
#REF!, as Excel does. Issue #792 PR #5077 SEARCH()treats?and*in the text to find as wildcards, and~as escaping them, as Excel does; they were matched literally. Issue #5075 PR #5076