leantony / laravel-grid

A grid view for laravel, inspired by the yii2 grid widget
https://leantony.github.io/laravel-grid/
MIT License
91 stars 39 forks source link

Bump phpoffice/phpspreadsheet from 1.2.1 to 1.10.0 #117

Open dependabot[bot] opened 4 years ago

dependabot[bot] commented 4 years ago

Bumps phpoffice/phpspreadsheet from 1.2.1 to 1.10.0.

Release notes *Sourced from [phpoffice/phpspreadsheet's releases](https://github.com/PHPOffice/PhpSpreadsheet/releases).* > ## 1.10.0 > ### Changed > > - Change license from LGPL 2.1 to MIT [#140](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/140) > > ### Added > > - Implementation of IFNA() logical function > - Support "showZeros" worksheet option to change how Excel shows and handles "null" values returned from a calculation > - Allow HTML Reader to accept HTML as a string into an existing spreadsheet [#1212](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1212) > > ### Fixed > > - IF implementation properly handles the value `#N/A` [#1165](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1165) > - Formula Parser: Wrong line count for stuff like "MyOtherSheet!A:D" [#1215](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1215) > - Call garbage collector after removing a column to prevent stale cached values > - Trying to remove a column that doesn't exist deletes the latest column > - Keep big integer as integer instead of lossely casting to float [#874](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/874) > - Fix branch pruning handling of non boolean conditions [#1167](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1167) > - Fix ODS Reader when no DC namespace are defined [#1182](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1182) > - Fixed Functions->ifCondition for allowing <> and empty condition [#1206](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1206) > - Validate XIRR inputs and return correct error values [#1120](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1120) > - Allow to read xlsx files with exotic workbook names like "workbook2.xml" [#1183](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1183) > > ## 1.9.0 > ### Changed > > - Drop support for PHP 5.6 and 7.0, according to [our policy](https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support) > > ### Added > > - When <br> appears in a table cell, set the cell to wrap [#1071](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1071) and [#1070](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1070) > - Add MAXIFS, MINIFS, COUNTIFS and Remove MINIF, MAXIF [#1056](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1056) > - HLookup needs an ordered list even if range_lookup is set to false [#1055](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1055) and [#1076](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1076) > - Improve performance of IF function calls via ranch pruning to avoid resolution of every branches [#844](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/844) > - MATCH function supports `*?~` Excel functionality, when match_type=0 [#1116](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1116) > - Allow HTML Reader to accept HTML as a string [#1136](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1136) > > ### Fixed > > - Fix to AVERAGEIF() function when called with a third argument > - Eliminate duplicate fill none style entries [#1066](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1066) > - Fix number format masks containing literal (non-decimal point) dots [#1079](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1079) > - Fix number format masks containing named colours that were being misinterpreted as date formats; and add support for masks that fully replace the value with a full text string [#1009](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1009) > - Stricter-typed comparison testing in COUNTIF() and COUNTIFS() evaluation [#1046](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1046) > - COUPNUM should not return zero when settlement is in the last period [#1020](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1020) and [#1021](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1021) > - Fix handling of named ranges referencing sheets with spaces or "!" in their title > - Cover `getSheetByName()` with tests for name with quote and spaces [#739](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/739) > - Best effort to support invalid colspan values in HTML reader - [#878](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/878) > - Fixes incorrect rows deletion [#868](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/868) > ... (truncated)
Changelog *Sourced from [phpoffice/phpspreadsheet's changelog](https://github.com/PHPOffice/PhpSpreadsheet/blob/master/CHANGELOG.md).* > ## [1.10.0] - 2019-11-18 > > ### Changed > > - Change license from LGPL 2.1 to MIT [#140](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/140) > > ### Added > > - Implementation of IFNA() logical function > - Support "showZeros" worksheet option to change how Excel shows and handles "null" values returned from a calculation > - Allow HTML Reader to accept HTML as a string into an existing spreadsheet [#1212](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1212) > > ### Fixed > > - IF implementation properly handles the value `#N/A` [#1165](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1165) > - Formula Parser: Wrong line count for stuff like "MyOtherSheet!A:D" [#1215](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1215) > - Call garbage collector after removing a column to prevent stale cached values > - Trying to remove a column that doesn't exist deletes the latest column > - Keep big integer as integer instead of lossely casting to float [#874](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/874) > - Fix branch pruning handling of non boolean conditions [#1167](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1167) > - Fix ODS Reader when no DC namespace are defined [#1182](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1182) > - Fixed Functions->ifCondition for allowing <> and empty condition [#1206](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1206) > - Validate XIRR inputs and return correct error values [#1120](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1120) > - Allow to read xlsx files with exotic workbook names like "workbook2.xml" [#1183](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1183) > > ## [1.9.0] - 2019-08-17 > > ### Changed > > - Drop support for PHP 5.6 and 7.0, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support > > ### Added > > - When <br> appears in a table cell, set the cell to wrap [#1071](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1071) and [#1070](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1070) > - Add MAXIFS, MINIFS, COUNTIFS and Remove MINIF, MAXIF [#1056](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1056) > - HLookup needs an ordered list even if range_lookup is set to false [#1055](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1055) and [#1076](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1076) > - Improve performance of IF function calls via ranch pruning to avoid resolution of every branches [#844](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/844) > - MATCH function supports `*?~` Excel functionality, when match_type=0 [#1116](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1116) > - Allow HTML Reader to accept HTML as a string [#1136](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1136) > > ### Fixed > > - Fix to AVERAGEIF() function when called with a third argument > - Eliminate duplicate fill none style entries [#1066](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1066) > - Fix number format masks containing literal (non-decimal point) dots [#1079](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1079) > - Fix number format masks containing named colours that were being misinterpreted as date formats; and add support for masks that fully replace the value with a full text string [#1009](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1009) > - Stricter-typed comparison testing in COUNTIF() and COUNTIFS() evaluation [#1046](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1046) > - COUPNUM should not return zero when settlement is in the last period [#1020](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/1020) and [#1021](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/pull/1021) > - Fix handling of named ranges referencing sheets with spaces or "!" in their title > - Cover `getSheetByName()` with tests for name with quote and spaces [#739](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/739) > ... (truncated)
Commits - [`f734783`](https://github.com/PHPOffice/PhpSpreadsheet/commit/f734783d826bd84c3d54fcf7b71c37ab9bac4b04) 1.10.0 - [`6a2e0ce`](https://github.com/PHPOffice/PhpSpreadsheet/commit/6a2e0cef4390c62e9847eaa09b1a2b48297d5651) Read xlsx files with exotic workbook names like "workbook2.xml" - [`e5409f0`](https://github.com/PHPOffice/PhpSpreadsheet/commit/e5409f0fed230b8cfe8aeb8a587c29322bd06e46) fix access error - [`7f5e0f0`](https://github.com/PHPOffice/PhpSpreadsheet/commit/7f5e0f0a3756e32af5872a0d5396ef17be2f1766) Add test for PhpOffice\PhpSpreadsheet\Worksheet\ColumnDimension - [`5435fe8`](https://github.com/PHPOffice/PhpSpreadsheet/commit/5435fe8025a595dbfc220169e087348950c86b91) Move Changelog entry - [`256e5ad`](https://github.com/PHPOffice/PhpSpreadsheet/commit/256e5ad0e7074befd9bcaa37c4c858eae6b4dd91) Code style - [`22bf54c`](https://github.com/PHPOffice/PhpSpreadsheet/commit/22bf54ca11579af0edd6f0b613052044cf5258f5) Allow Html Reader to write into existing spreadsheet - [`788f79c`](https://github.com/PHPOffice/PhpSpreadsheet/commit/788f79c1bbc57c7408f98969b27cd3778c687caa) Validate XIRR inputs and return correct error values - [`3fc2fa4`](https://github.com/PHPOffice/PhpSpreadsheet/commit/3fc2fa47de62dd2e2b8e6f2d23a4d3e3c9db316f) Check for existing xf index in mapping array before accessing it - [`b636c56`](https://github.com/PHPOffice/PhpSpreadsheet/commit/b636c56d7f6b9efd50a17eddc144a78b4ddc7362) Code style - Additional commits viewable in [compare view](https://github.com/PHPOffice/PhpSpreadsheet/compare/1.2.1...1.10.0)


Dependabot compatibility score

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 ignore this [patch|minor|major] version` will close this PR and stop Dependabot creating any more for this minor/major 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/leantony/laravel-grid/network/alerts).