« Changelog History


PhpSpreadsheet v1.18.0 Release Notes

Release Date: 2021-05-31 // almost 3 years ago

  • ➕ Added

    • ✨ Enhancements to CSV Reader, allowing options to be set when using IOFactory::load() with a callback to set delimiter, enclosure, charset etc. PR #2103 - See documentation for details.
    • Implemented basic AutoFiltering for Ods Reader and Writer PR #2053
    • Implemented basic AutoFiltering for Gnumeric Reader PR #2055
    • 👌 Improved support for Row and Column ranges in formulae Issue #1755 PR #2028
    • 🌐 Implemented URLENCODE() Web Function
    • ✅ Implemented the CHITEST(), CHISQ.DIST() and CHISQ.INV() and equivalent Statistical functions, for both left- and right-tailed distributions.
    • 👌 Support for ActiveSheet and SelectedCells in the ODS Reader and Writer. PR #1908
    • 👌 Support for notContainsText Conditional Style in xlsx Issue #984

    🔄 Changed

    • 👉 Use of nb rather than no as the locale code for Norsk Bokmål.

    🗄 Deprecated

    • 👀 All Excel Function implementations in Calculation\Database, Calculation\DateTime, Calculation\Engineering, Calculation\Financial, Calculation\Logical, Calculation\LookupRef, Calculation\MathTrig, Calculation\Statistical, Calculation\TextData and Calculation\Web have been moved to dedicated classes for individual functions or groups of related functions. See the docblocks against all the deprecated methods for details of the new methods to call instead. At some point, these old classes will be deleted.

    ✂ Removed

    • 👉 Use of nb rather than no as the locale language code for Norsk Bokmål.

    🛠 Fixed

    • 🛠 Fixed error in COUPNCD() calculation for end of month Issue #2116 - PR #2119
    • 0️⃣ Resolve default values when a null argument is passed for HLOOKUP(), VLOOKUP() and ADDRESS() functions Issue #2120 - PR #2121
    • 🛠 Fixed incorrect R1C1 to A1 subtraction formula conversion (R[-2]C-R[2]C) Issue #2076 PR #2086
    • Correctly handle absolute A1 references when converting to R1C1 format PR #2060
    • 💅 Correct default fill style for conditional without a pattern defined Issue #2035 PR #2050
    • 🛠 Fixed issue where array key check for existince before accessing arrays in Xlsx.php. PR #1970
    • 🛠 Fixed issue with quoted strings in number format mask rendered with toFormattedString() Issue 1972# PR #1978
    • 🛠 Fixed issue with percentage formats in number format mask rendered with toFormattedString() Issue 1929# PR #1928
    • 🛠 Fixed issue with _ spacing character in number format mask corrupting output from toFormattedString() Issue 1924# PR #1927
    • 🛠 Fix for Issue #1887 - Lose Track of Selected Cells After Save
    • 🛠 Fixed issue with Xlsx@listWorksheetInfo not returning any data
    • 🛠 Fixed invalid arguments triggering mb_substr() error in LEFT(), MID() and RIGHT() text functions. Issue #640
    • 🛠 Fix for Issue #1916 - Invalid signature check for XML files
    • 🛠 Fix change in Font::setSize() behavior for PHP8. PR #2100