PhpSpreadsheet v1.19.0 Release Notes
Release Date: 2021-10-31 // over 2 years ago-
➕ Added
- 💅 Ability to set style on named range, and validate input to setSelectedCells Issue #2279 PR #2280
- 🖨 Process comments in Sylk file Issue #2276 PR #2277
- ➕ Addition of Custom Properties to Ods Writer, and 32-bit-safe timestamps for Document Properties PR #2113
- ➕ Added callback to CSV reader to set user-specified defaults for various properties (especially for escape which has a poor PHP-inherited default of backslash which does not correspond with Excel) PR #2103
- 👍 Phase 1 of better namespace handling for Xlsx, resolving many open issues PR #2173 PR #2204 PR #2303
- ➕ Add ability to extract images if source is a URL Issue #1997 PR #2072
- 👌 Support for passing flags in the Reader
load()and Writersave()methods, and through the IOFactory, to set behaviours PR #2136- See documentation for details
- More flexibility in the StringValueBinder to determine what datatypes should be treated as strings PR #2138
- Helper class for conversion between css size Units of measure (
px,pt,pc,in,cm,mm) PR #2152 - 👍 Allow Row height and Column Width to be set using different units of measure (
px,pt,pc,in,cm,mm), rather than only in points or MS Excel column width units PR #2152 - Ability to stream to an Amazon S3 bucket Issue #2249
- Provided a Size Helper class to validate size values (pt, px, em) PR #1694
🔄 Changed
- Nothing.
🗄 Deprecated
- PHP 8.1 will deprecate auto_detect_line_endings. As a result of this change, Csv Reader using some release after PHP8.1 will no longer be able to handle a Csv with Mac line endings.
✂ Removed
- Nothing.
🛠 Fixed
- Unexpected format in Xlsx Timestamp Issue #2331 PR #2332
- Corrections for HLOOKUP Issue #2123 PR #2330
- Corrections for Xlsx Read Comments Issue #2316 PR #2329
- Lowercase Calibri font names Issue #2273 PR #2325
- isFormula Referencing Sheet with Space in Title Issue #2304 PR #2306
- Xls Reader Fatal Error due to Undefined Offset Issue #1114 PR #2308
- Permit Csv Reader delimiter to be set to null Issue #2287 PR #2288
- Csv Reader did not handle booleans correctly PR #2232
- Problems when deleting sheet with local defined name Issue #2266 PR #2284
- Worksheet passwords were not always handled correctly Issue #1897 PR #2197
- Gnumeric Reader will now distinguish between Created and Modified timestamp PR #2133
- Xls Reader will now handle MACCENTRALEUROPE with or without hyphen Issue #549 PR #2213
- 👉 Tweaks to input file validation Issue #1718 PR #2217
- Html Reader did not handle comments correctly Issue #2234 PR #2235
- Apache OpenOffice Uses Unexpected Case for General format Issue #2239 PR #2242
- Problems with fraction formatting Issue #2253 PR #2254
- 💅 Xlsx Reader had problems reading file with no styles.xml or empty styles.xml Issue #2246 PR #2247
- Xlsx Reader did not read Data Validation flags correctly Issue #2224 PR #2225
- 👍 Better handling of empty arguments in Calculation engine PR #2143
- 🛠 Many fixes for Autofilter Issue #2216 PR #2141 PR #2162 PR #2218
- 🏁 Locale generator will now use Unix line endings even on Windows Issue #2172 PR #2174
- 👌 Support differences in implementation of Text functions between Excel/Ods/Gnumeric PR #2151
- 🛠 Fixes to places where PHP8.1 enforces new or previously unenforced restrictions PR #2137 PR #2191 PR #2231
- 👯 Clone for HashTable was incorrect PR #2130
- 🔒 Xlsx Reader was not evaluating Document Security Lock correctly PR #2128
- Error in COUPNCD handling end of month Issue #2116 PR #2119
- 📜 Xls Writer Parser did not handle concatenation operator correctly PR #2080
- Xlsx Writer did not handle boolean false correctly Issue #2082 PR #2087
- SUM needs to treat invalid strings differently depending on whether they come from a cell or are used as literals Issue #2042 PR #2045
- Html reader could have set illegal coordinates when dealing with embedded tables Issue #2029 PR #2032
- 📚 Documentation for printing gridlines was wrong PR #2188
- 🏗 Return Value Error - DatabaseAbstruct::buildQuery() return null but must be string Issue #2158 PR #2160
- Xlsx reader not recognize data validations that references another sheet Issue #1432 Issue #2149 PR #2150 PR #2265
- Don't calculate cell width for autosize columns if a cell contains a null or empty string value Issue #2165 PR #2167
- 👍 Allow negative interest rate values in a number of the Financial functions (
PPMT(),PMT(),FV(),PV(),NPER(), etc) Issue #2163 PR #2164 - Xls Reader changing grey background to black in Excel template Issue #2147 PR #2156
- 💅 Column width and Row height styles in the Html Reader when the value includes a unit of measure Issue #2145.
- Data Validation flags not set correctly when reading XLSX files Issue #2224 PR #2225
- 💅 Reading XLSX files without styles.xml throws an exception Issue #2246
- 👌 Improved performance of
Style::applyFromArray()when applied to several cells PR #1785. - 👌 Improve XLSX parsing speed if no readFilter is applied (again) - #772