PhpSpreadsheet v1.14.0 Release Notes
Release Date: 2020-06-29 // almost 4 years ago-
➕ Added
- ➕ Add support for IFS() logical function #1442
- ➕ Add Cell Address Helper to provide conversions between the R1C1 and A1 address formats #1558
- ➕ Add ability to edit Html/Pdf before saving #1499
- ➕ Add ability to set codepage explicitly for BIFF5 #1018
- ➕ Added support for the WEBSERVICE function #1409
🛠 Fixed
- Resolve evaluation of utf-8 named ranges in calculation engine #1522
- 🛠 Fix HLOOKUP on single row #1512
- 🛠 Fix MATCH when comparing different numeric types #1521
- 🛠 Fix exact MATCH on ranges with empty cells #1520
- 🛠 Fix for Issue #1516 (Cloning worksheet makes corrupted Xlsx) #1530
- 🛠 Fix For Issue #1509 (Can not set empty enclosure for CSV) #1518
- 🛠 Fix for Issue #1505 (TypeError : Argument 4 passed to PhpOffice\PhpSpreadsheet\Writer\Xlsx\Worksheet::writeAttributeIf() must be of the type string) #1525
- 🛠 Fix for Issue #1495 (Sheet index being changed when multiple sheets are used in formula) [#1500]((https://github.com/PHPOffice/PhpSpreadsheet/pull/1500))
- 🛠 Fix for Issue #1533 (A reference to a cell containing a string starting with "#" leads to errors in the generated xlsx.) #1534
- Xls Writer - Correct Timestamp Bug #1493
- Don't ouput row and columns without any cells in HTML writer #1235