packagist phpoffice/phpspreadsheet 1.9.0

latest releases: dev-release210, 2.1.1, dev-release222...
5 years ago

Changed

  • Drop support for PHP 5.6 and 7.0, according to our policy

Added

  • When <br> appears in a table cell, set the cell to wrap #1071 and #1070
  • Add MAXIFS, MINIFS, COUNTIFS and Remove MINIF, MAXIF #1056
  • HLookup needs an ordered list even if range_lookup is set to false #1055 and #1076
  • Improve performance of IF function calls via ranch pruning to avoid resolution of every branches #844
  • MATCH function supports *?~ Excel functionality, when match_type=0 #1116
  • Allow HTML Reader to accept HTML as a string #1136

Fixed

  • Fix to AVERAGEIF() function when called with a third argument
  • Eliminate duplicate fill none style entries #1066
  • Fix number format masks containing literal (non-decimal point) dots #1079
  • Fix number format masks containing named colours that were being misinterpreted as date formats; and add support for masks that fully replace the value with a full text string #1009
  • Stricter-typed comparison testing in COUNTIF() and COUNTIFS() evaluation #1046
  • COUPNUM should not return zero when settlement is in the last period #1020 and #1021
  • Fix handling of named ranges referencing sheets with spaces or "!" in their title
  • Cover getSheetByName() with tests for name with quote and spaces #739
  • Best effort to support invalid colspan values in HTML reader - #878
  • Fixes incorrect rows deletion #868
  • MATCH function fix (value search by type, stop search when match_type=-1 and unordered element encountered) #1116
  • Fix getCalculatedValue() error with more than two INDIRECT #1115
  • Writer\Html did not hide columns #985

Don't miss a new phpspreadsheet release

NewReleases is sending notifications on new releases.