« Changelog History


PhpSpreadsheet v1.16.0 Release Notes

Release Date: 2020-12-31 // over 3 years ago

  • ➕ Added

    • CSV Reader - Best Guess for Encoding, and Handle Null-string Escape #1647

    🔄 Changed

    • ⚡️ Updated the CONVERT() function to support all current MS Excel categories and Units of Measure.

    🗄 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

    • Nothing.

    🛠 Fixed

    • 🛠 Fixed issue with absolute path in worksheets' Target. PR #1769
    • 🛠 Fix for Xls Reader when SST has a bad length #1592
    • Resolve Xlsx loader issue whe hyperlinks don't have a destination
    • 🖨 Resolve issues when printer settings resources IDs clash with drawing IDs
    • Resolve issue with SLK long filenames #1612
    • ROUNDUP and ROUNDDOWN return incorrect results for values of 0 #1627
    • 💅 Apply Column and Row Styles to Existing Cells #1712 PR #1721
    • Resolve issues with defined names where worksheet doesn't exist (#1686)[https://github.com/PHPOffice/PhpSpreadsheet/issues/1686] and #1723 - PR #1742
    • 🛠 Fix for issue #1735 Incorrect activeSheetIndex after RemoveSheetByIndex - PR #1743
    • Ensure that the list of shared formulae is maintained when an xlsx file is chunked with readFilterIssue #169.
    • 🛠 Fix for notice during accessing "cached magnification factor" offset #1354
    • 🛠 Fix compatibility with ext-gd on php 8

    🔒 Security Fix (CVE-2020-7776)

    • Prevent XSS through cell comments in the HTML Writer.