Sourced from phpoffice/phpspreadsheet's releases.

1.16.0

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

• Nothing.

Removed

• Nothing.

Fixed

• 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](PHPOffice/PhpSpreadsheet#1721)
• Resolve issues with defined names where worksheet doesn't exist (#1686)[https://redirect.github.com/PHPOffice/PhpSpreadsheet/issues/1686] and #1723 - [PR #1742](PHPOffice/PhpSpreadsheet#1742)
• Fix for issue #1735 Incorrect activeSheetIndex after RemoveSheetByIndex - [PR #1743](PHPOffice/PhpSpreadsheet#1743)
• Ensure that the list of shared formulae is maintained when an xlsx file is chunked with readFilter[Issue #169](PHPOffice/PhpSpreadsheet#1669).
• 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.

1.15.0

Added

• Implemented Page Order for Xlsx and Xls Readers, and provided Page Settings (Orientation, Scale, Horizontal/Vertical Centering, Page Order, Margins) support for Ods, Gnumeric and Xls Readers #1559
• Implementation of the Excel LOGNORM.DIST(), NORM.S.DIST(), GAMMA() and GAUSS() functions. #1588
• Named formula implementation, and improved handling of Defined Names generally #1535
  • Defined Names are now case-insensitive
  • Distinction between named ranges and named formulae
  • Correct handling of union and intersection operators in named ranges
  • Correct evaluation of named range operators in calculations
  • fix resolution of relative named range values in the calculation engine; previously all named range values had been treated as absolute.
  • Calculation support for named formulae
  • Support for nested ranges and formulae (named ranges and formulae that reference other named ranges/formulae) in calculations
  • Introduction of a helper to convert address formats between R1C1 and A1 (and the reverse)

... (truncated)

Sourced from phpoffice/phpspreadsheet's changelog.

Changelog for PHPExcel

This is the historic changelog of the project when it was still called PHPExcel. It exists only for historical purposes and versions mentioned here should not be confused with PhpSpreadsheet versions.

• 76d4323 Changelog for 1.16.0 release
• 002044c Update Units of Measure supported by the CONVERT() function (#1768)
• a6240b0 Update changelog
• e768cb0 CSV - Guess Encoding, Handle Null-string Escape (#1717)
• 607d347 Fix compatibility with ext-gd on php 8 (#1762)
• 8007872 Add nightly PHP 8.1 dev to github actions (#1763)
• e10c01d Update change log
• 51cb212 Fix for bug #1592 (UPDATED) (#1623)
• 3025824 Merge pull request #1698
• 8833c23 DocBlock Change in Styles/Conditional (#1697)
• Additional commits viewable in compare view

You can trigger Dependabot actions by commenting on this PR:

• @dependabot rebase will rebase this PR
• @dependabot recreate will recreate this PR, overwriting any edits that have been made to it
• @dependabot merge will merge this PR after your CI passes on it
• @dependabot squash and merge will squash and merge this PR after your CI passes on it
• @dependabot cancel merge will cancel a previously requested merge and block automerging
• @dependabot reopen will reopen this PR if it is closed
• @dependabot close will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually
• @dependabot ignore this major version will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this minor version will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself)
• @dependabot ignore this dependency will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself) You can disable automated security fix PRs for this repo from the Security Alerts page.