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.PHPExcel.md).*
> # 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.
>
> ## [1.8.1] - 2015-04-30
>
> ### Bugfixes
>
> - Fix for Writing an Open Document cell with non-numeric formula - [@goncons](https://github.com/goncons) [#397](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/397)
> - Avoid potential divide by zero in basedrawing - [@sarciszewski](https://github.com/sarciszewski) [#329](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/329)
> - XML External Entity (XXE) Processing, different behaviour between simplexml_load_string() and simplexml_load_file(). - [@ymaerschalck](https://github.com/ymaerschalck) [#405](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/405)
> - Fix to ensure that current cell is maintained when executing formula calculations - [@MarkBaker](https://github.com/MarkBaker)
> - Keep/set the value on Reader _loadSheetsOnly as NULL, courtesy of Restless-ET - [@MarkBaker](https://github.com/MarkBaker) [#350](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/350)
> - Loading an Excel 2007 spreadsheet throws an "Autofilter must be set on a range of cells" exception - [@MarkBaker](https://github.com/MarkBaker) [CodePlex [#18105](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/18105)](https://phpexcel.codeplex.com/workitem/18105)
> - Fix to autoloader registration for backward compatibility with PHP 5.2.0 not accepting the prepend flag - [@MarkBaker](https://github.com/MarkBaker) [#388](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/388)
> - DOM loadHTMLFile() failing with options flags when using PHP < 5.4.0 - [@MarkBaker](https://github.com/MarkBaker) [#384](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/384)
> - Fix for percentage operator in formulae for BIFF Writer - [@MarkBaker](https://github.com/MarkBaker)
> - Fix to getStyle() call for cell object - [@MarkBaker](https://github.com/MarkBaker)
> - Discard Autofilters in Excel2007 Reader when filter range isn't a valid range - [@MarkBaker](https://github.com/MarkBaker)
> - Fix invalid NA return in VLOOKUP - [@frozenstupidity](https://github.com/frozenstupidity) [#423](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/423)
> - "No Impact" conditional formatting fix for NumberFormat - [@wiseloren](https://github.com/wiseloren) [CodePlex [#21454](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/21454)](https://phpexcel.codeplex.com/workitem/21454)
> - Bug in Excel2003XML reader, parsing merged cells - [@bobwitlox](https://github.com/bobwitlox) [#467](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/467)
> - Fix for CEIL() and FLOOR() when number argument is zero - [@MarkBaker](https://github.com/MarkBaker) [#302](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/302)
>
> ### General
>
> - Remove cells cleanly when calling RemoveRow() or RemoveColumn() - [@MarkBaker](https://github.com/MarkBaker)
> - Small performance improvement for autosize columns - [@MarkBaker](https://github.com/MarkBaker)
> - Change the getter/setter for zeroHeight to camel case - [@frost-nzcr4](https://github.com/frost-nzcr4) [#379](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/379)
> - DefaultValueBinder is too much aggressive when converting string to numeric - [@MarkBaker](https://github.com/MarkBaker) [#394](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/394)
> - Default precalculate formulas to false for writers - [@MarkBaker](https://github.com/MarkBaker)
> - Set default Cyclic Reference behaviour to 1 to eliminate exception when using a single cyclic iteration in formulae - [@MarkBaker](https://github.com/MarkBaker)
>
> ### Features
>
> - Some Excel writer libraries erroneously use Codepage 21010 for UTF-16LE - [@MarkBaker](https://github.com/MarkBaker) [#396](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/396)
> - Methods to manage most of the existing options for Chart Axis, Major Grid-lines and Minor Grid-lines - [@WiktrzGE](https://github.com/WiktrzGE) [#404](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/404)
> - ODS read/write comments in the cell - [@frost-nzcr4](https://github.com/frost-nzcr4) [#403](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/403)
> - Additional Mac CJK codepage definitions - [@CQD](https://github.com/CQD) [#389](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/389)
> - Update Worksheet.php getStyleByColumnAndRow() to allow a range of cells rather than just a single cell - [@bolovincev](https://github.com/bolovincev) [#269](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/269)
> - New methods added for testing cell status within merge groups - [@MarkBaker](https://github.com/MarkBaker)
> - Handling merge cells in HTML Reader - @cifren/MBaker [#205](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/205)
> - Helper to convert basic HTML markup to a Rich Text object - [@MarkBaker](https://github.com/MarkBaker)
> - Improved Iterators - [@MarkBaker](https://github.com/MarkBaker)
> - New Column Iterator
> - Support for row and column ranges
> - Improved handling for next/prev
>
> ... (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.6.0...1.10.0)
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/adr1enbe4udou1n/laravel-boilerplate/network/alerts).
dependabot[bot]
commented
3 years ago
Bumps phpoffice/phpspreadsheet from 1.6.0 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.PHPExcel.md).* > # 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. > > ## [1.8.1] - 2015-04-30 > > ### Bugfixes > > - Fix for Writing an Open Document cell with non-numeric formula - [@goncons](https://github.com/goncons) [#397](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/397) > - Avoid potential divide by zero in basedrawing - [@sarciszewski](https://github.com/sarciszewski) [#329](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/329) > - XML External Entity (XXE) Processing, different behaviour between simplexml_load_string() and simplexml_load_file(). - [@ymaerschalck](https://github.com/ymaerschalck) [#405](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/405) > - Fix to ensure that current cell is maintained when executing formula calculations - [@MarkBaker](https://github.com/MarkBaker) > - Keep/set the value on Reader _loadSheetsOnly as NULL, courtesy of Restless-ET - [@MarkBaker](https://github.com/MarkBaker) [#350](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/350) > - Loading an Excel 2007 spreadsheet throws an "Autofilter must be set on a range of cells" exception - [@MarkBaker](https://github.com/MarkBaker) [CodePlex [#18105](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/18105)](https://phpexcel.codeplex.com/workitem/18105) > - Fix to autoloader registration for backward compatibility with PHP 5.2.0 not accepting the prepend flag - [@MarkBaker](https://github.com/MarkBaker) [#388](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/388) > - DOM loadHTMLFile() failing with options flags when using PHP < 5.4.0 - [@MarkBaker](https://github.com/MarkBaker) [#384](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/384) > - Fix for percentage operator in formulae for BIFF Writer - [@MarkBaker](https://github.com/MarkBaker) > - Fix to getStyle() call for cell object - [@MarkBaker](https://github.com/MarkBaker) > - Discard Autofilters in Excel2007 Reader when filter range isn't a valid range - [@MarkBaker](https://github.com/MarkBaker) > - Fix invalid NA return in VLOOKUP - [@frozenstupidity](https://github.com/frozenstupidity) [#423](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/423) > - "No Impact" conditional formatting fix for NumberFormat - [@wiseloren](https://github.com/wiseloren) [CodePlex [#21454](https://github-redirect.dependabot.com/PHPOffice/PhpSpreadsheet/issues/21454)](https://phpexcel.codeplex.com/workitem/21454) > - Bug in Excel2003XML reader, parsing merged cells - [@bobwitlox](https://github.com/bobwitlox) [#467](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/467) > - Fix for CEIL() and FLOOR() when number argument is zero - [@MarkBaker](https://github.com/MarkBaker) [#302](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/302) > > ### General > > - Remove cells cleanly when calling RemoveRow() or RemoveColumn() - [@MarkBaker](https://github.com/MarkBaker) > - Small performance improvement for autosize columns - [@MarkBaker](https://github.com/MarkBaker) > - Change the getter/setter for zeroHeight to camel case - [@frost-nzcr4](https://github.com/frost-nzcr4) [#379](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/379) > - DefaultValueBinder is too much aggressive when converting string to numeric - [@MarkBaker](https://github.com/MarkBaker) [#394](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/394) > - Default precalculate formulas to false for writers - [@MarkBaker](https://github.com/MarkBaker) > - Set default Cyclic Reference behaviour to 1 to eliminate exception when using a single cyclic iteration in formulae - [@MarkBaker](https://github.com/MarkBaker) > > ### Features > > - Some Excel writer libraries erroneously use Codepage 21010 for UTF-16LE - [@MarkBaker](https://github.com/MarkBaker) [#396](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/396) > - Methods to manage most of the existing options for Chart Axis, Major Grid-lines and Minor Grid-lines - [@WiktrzGE](https://github.com/WiktrzGE) [#404](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/404) > - ODS read/write comments in the cell - [@frost-nzcr4](https://github.com/frost-nzcr4) [#403](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/403) > - Additional Mac CJK codepage definitions - [@CQD](https://github.com/CQD) [#389](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/389) > - Update Worksheet.php getStyleByColumnAndRow() to allow a range of cells rather than just a single cell - [@bolovincev](https://github.com/bolovincev) [#269](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/269) > - New methods added for testing cell status within merge groups - [@MarkBaker](https://github.com/MarkBaker) > - Handling merge cells in HTML Reader - @cifren/MBaker [#205](https://github-redirect.dependabot.com/PHPOffice/PHPExcel/issues/205) > - Helper to convert basic HTML markup to a Rich Text object - [@MarkBaker](https://github.com/MarkBaker) > - Improved Iterators - [@MarkBaker](https://github.com/MarkBaker) > - New Column Iterator > - Support for row and column ranges > - Improved handling for next/prev > > ... (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.6.0...1.10.0)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/adr1enbe4udou1n/laravel-boilerplate/network/alerts).