Bump phpoffice/phpspreadsheet from 1.2.1 to 1.16.0

[dependabot[bot]]

Bumps phpoffice/phpspreadsheet from 1.2.1 to 1.16.0.

Release notes

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://github-redirect.dependabot.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)

Changelog

Sourced from phpoffice/phpspreadsheet's changelog.

1.16.0 - 2020-12-31

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

• Fixed issue with absolute path in worksheets' Target. [PR #1769](PHPOffice/PhpSpreadsheet#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](PHPOffice/PhpSpreadsheet#1721)
• Resolve issues with defined names where worksheet doesn't exist (#1686)[https://github-redirect.dependabot.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 - 2020-10-11

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

... (truncated)

Commits

• 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

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

---

Dependabot commands and options

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) - `@dependabot use these labels` will set the current labels as the default for future PRs for this repo and language - `@dependabot use these reviewers` will set the current reviewers as the default for future PRs for this repo and language - `@dependabot use these assignees` will set the current assignees as the default for future PRs for this repo and language - `@dependabot use this milestone` will set the current milestone as the default for future PRs for this repo and language You can disable automated security fix PRs for this repo from the [Security Alerts page](https://github.com/Amsterdam/fixxx-schuldhulp/network/alerts).

[dependabot[bot]]

OK, I won't notify you again about this release, but will get in touch when a new version is available. If you'd rather skip all updates until the next major or minor version, let me know by commenting @dependabot ignore this major version or @dependabot ignore this minor version.

If you change your mind, just re-open this PR and I'll resolve any conflicts on it.