You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
This commit was created on GitHub.com and signed with GitHub’s verified signature.
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/A or #DIV/0!; every error constant was written as #NULL!. Issue #5022PR #5067
Fix pivot table with two or more data fields removed by Excel. Issue #5106PR #5107
XLOOKUP() without an if_not_found argument returns a real #N/A error when nothing matches, instead of the string #N/A!, so ISNA(), ISERROR() and IFNA() handle it. Issue #5085PR #5095
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 #5092PR #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 #792PR #5077
SEARCH() treats ? and * in the text to find as wildcards, and ~ as escaping them, as Excel does; they were matched literally. Issue #5075PR #5076