PHPOffice/PhpSpreadsheet 1.19.0

on GitHub

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 Writer save()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 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