1.9.0
版本发布时间: 2019-08-18 06:26:03
PHPOffice/PhpSpreadsheet最新发布版本:2.2.2(2024-08-08 10:45:26)
Changed
- Drop support for PHP 5.6 and 7.0, according to our policy
Added
- When <br> appears in a table cell, set the cell to wrap #1071 and #1070
- Add MAXIFS, MINIFS, COUNTIFS and Remove MINIF, MAXIF #1056
- HLookup needs an ordered list even if range_lookup is set to false #1055 and #1076
- Improve performance of IF function calls via ranch pruning to avoid resolution of every branches #844
- MATCH function supports
*?~
Excel functionality, when match_type=0 #1116 - Allow HTML Reader to accept HTML as a string #1136
Fixed
- Fix to AVERAGEIF() function when called with a third argument
- Eliminate duplicate fill none style entries #1066
- Fix number format masks containing literal (non-decimal point) dots #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
- Stricter-typed comparison testing in COUNTIF() and COUNTIFS() evaluation #1046
- COUPNUM should not return zero when settlement is in the last period #1020 and #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 - Best effort to support invalid colspan values in HTML reader - #878
- Fixes incorrect rows deletion #868
- MATCH function fix (value search by type, stop search when match_type=-1 and unordered element encountered) #1116
- Fix
getCalculatedValue()
error with more than two INDIRECT #1115 - Writer\Html did not hide columns #985