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)
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)
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.
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)
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.
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/netresearch/timetracker/network/alerts).
Bumps phpoffice/phpspreadsheet from 1.10.1 to 1.16.0.
Release notes
Sourced from phpoffice/phpspreadsheet's releases.
... (truncated)
Changelog
Sourced from phpoffice/phpspreadsheet's changelog.
... (truncated)
Commits
76d4323
Changelog for 1.16.0 release002044c
Update Units of Measure supported by the CONVERT() function (#1768)a6240b0
Update changeloge768cb0
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 log51cb212
Fix for bug #1592 (UPDATED) (#1623)3025824
Merge pull request #16988833c23
DocBlock Change in Styles/Conditional (#1697)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/netresearch/timetracker/network/alerts).