packagist phpoffice/phpspreadsheet 5.12.0

one hour ago

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 #5022 PR #5067
  • Fix pivot table with two or more data fields removed by Excel. Issue #5106 PR #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 #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

Don't miss a new phpspreadsheet release

NewReleases is sending notifications on new releases.