« Changelog History


PhpSpreadsheet v1.9.0 Release Notes

Release Date: 2019-08-17 // almost 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