Changelog for php8-PhpSpreadsheet-1.23.0-ill15400.3.1.noarch.rpm :

* Fri Nov 19 2021 Tuukka Pasanen - 1.19.0 - 2021-10-31
* Added - Ability to set style on named range, and validate input to setSelectedCells [Issue #2279] [PR #2280] - Process comments in Sylk file [Issue #2276] - 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] - 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] - 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] - 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]
* Thu Jul 15 2021 Tuukka Pasanen - 1.18.0 - 2021-05-31
* Added - Enhancements to CSV Reader, allowing options to be set when using `IOFactory::load()` with a callback to set delimiter, enclosure, charset etc. [PR #2103](https://github.com/PHPOffice/PhpSpreadsheet/pull/2103) - See [documentation](https://github.com/PHPOffice/PhpSpreadsheet/blob/master/docs/topics/reading-and-writing-to-file.md#csv-comma-separated-values) for details. - Implemented basic AutoFiltering for Ods Reader and Writer [PR #2053](https://github.com/PHPOffice/PhpSpreadsheet/pull/2053) - Implemented basic AutoFiltering for Gnumeric Reader [PR #2055](https://github.com/PHPOffice/PhpSpreadsheet/pull/2055) - Improved support for Row and Column ranges in formulae [Issue #1755](https://github.com/PHPOffice/PhpSpreadsheet/issues/1755) [PR #2028](https://github.com/PHPOffice/PhpSpreadsheet/pull/2028) - Implemented URLENCODE() Web Function - Implemented the CHITEST(), CHISQ.DIST() and CHISQ.INV() and equivalent Statistical functions, for both left- and right-tailed distributions. - Support for ActiveSheet and SelectedCells in the ODS Reader and Writer. [PR #1908](https://github.com/PHPOffice/PhpSpreadsheet/pull/1908) - Support for notContainsText Conditional Style in xlsx [Issue #984](https://github.com/PHPOffice/PhpSpreadsheet/issues/984)
* Changed - Use of `nb` rather than `no` as the locale code for Norsk Bokmål.
* Deprecated - All Excel Function implementations in `Calculation\\Database`, `Calculation\\DateTime`, `Calculation\\Engineering`, `Calculation\\Financial`, `Calculation\\Logical`, `Calculation\\LookupRef`, `Calculation\\MathTrig`, `Calculation\\Statistical`, `Calculation\\TextData` and `Calculation\\Web` have been moved to dedicated classes for individual functions or groups of related functions. See the docblocks against all the deprecated methods for details of the new methods to call instead. At some point, these old classes will be deleted.
* Removed - Use of `nb` rather than `no` as the locale language code for Norsk Bokmål.
* Fixed - Fixed error in COUPNCD() calculation for end of month [Issue #2116](https://github.com/PHPOffice/PhpSpreadsheet/issues/2116) - [PR #2119](https://github.com/PHPOffice/PhpSpreadsheet/pull/2119) - Resolve default values when a null argument is passed for HLOOKUP(), VLOOKUP() and ADDRESS() functions [Issue #2120](https://github.com/PHPOffice/PhpSpreadsheet/issues/2120) - [PR #2121](https://github.com/PHPOffice/PhpSpreadsheet/pull/2121) - Fixed incorrect R1C1 to A1 subtraction formula conversion (`R[-2]C-R[2]C`) [Issue #2076](https://github.com/PHPOffice/PhpSpreadsheet/pull/2076) [PR #2086](https://github.com/PHPOffice/PhpSpreadsheet/pull/2086) - Correctly handle absolute A1 references when converting to R1C1 format [PR #2060](https://github.com/PHPOffice/PhpSpreadsheet/pull/2060) - Correct default fill style for conditional without a pattern defined [Issue #2035](https://github.com/PHPOffice/PhpSpreadsheet/issues/2035) [PR #2050](https://github.com/PHPOffice/PhpSpreadsheet/pull/2050) - Fixed issue where array key check for existince before accessing arrays in Xlsx.php. [PR #1970](https://github.com/PHPOffice/PhpSpreadsheet/pull/1970) - Fixed issue with quoted strings in number format mask rendered with toFormattedString() [Issue 1972#](https://github.com/PHPOffice/PhpSpreadsheet/issues/1972) [PR #1978](https://github.com/PHPOffice/PhpSpreadsheet/pull/1978) - Fixed issue with percentage formats in number format mask rendered with toFormattedString() [Issue 1929#](https://github.com/PHPOffice/PhpSpreadsheet/issues/1929) [PR #1928](https://github.com/PHPOffice/PhpSpreadsheet/pull/1928) - Fixed issue with _ spacing character in number format mask corrupting output from toFormattedString() [Issue 1924#](https://github.com/PHPOffice/PhpSpreadsheet/issues/1924) [PR #1927](https://github.com/PHPOffice/PhpSpreadsheet/pull/1927) - Fix for [Issue #1887](https://github.com/PHPOffice/PhpSpreadsheet/issues/1887] - Lose Track of Selected Cells After Save - Fixed issue with XlsxAATTlistWorksheetInfo not returning any data - Fixed invalid arguments triggering mb_substr() error in LEFT(), MID() and RIGHT() text functions. [Issue #640](https://github.com/PHPOffice/PhpSpreadsheet/issues/640) - Fix for [Issue #1916](https://github.com/PHPOffice/PhpSpreadsheet/issues/1916) - Invalid signature check for XML files - Fix change in `Font::setSize()` behavior for PHP8. [PR #2100](https://github.com/PHPOffice/PhpSpreadsheet/pull/2100)- 1.17.1 - 2021-03-01
* Added - Implementation of the Excel `AVERAGEIFS()` functions as part of a restructuring of Database functions and Conditional Statistical functions. - Support for date values and percentages in query parameters for Database functions, and the IF expressions in functions like COUNTIF() and AVERAGEIF(). [#1875](https://github.com/PHPOffice/PhpSpreadsheet/pull/1875) - Support for booleans, and for wildcard text search in query parameters for Database functions, and the IF expressions in functions like COUNTIF() and AVERAGEIF(). [#1876](https://github.com/PHPOffice/PhpSpreadsheet/pull/1876) - Implemented DataBar for conditional formatting in Xlsx, providing read/write and creation of (type, value, direction, fills, border, axis position, color settings) as DataBar options in Excel. [#1754](https://github.com/PHPOffice/PhpSpreadsheet/pull/1754) - Alignment for ODS Writer [#1796](https://github.com/PHPOffice/PhpSpreadsheet/issues/1796) - Basic implementation of the PERMUTATIONA() Statistical Function
* Changed - Formula functions that previously called PHP functions directly are now processed through the Excel Functions classes; resolving issues with PHP8 stricter typing. [#1789](https://github.com/PHPOffice/PhpSpreadsheet/issues/1789) The following MathTrig functions are affected: `ABS()`, `ACOS()`, `ACOSH()`, `ASIN()`, `ASINH()`, `ATAN()`, `ATANH()`, `COS()`, `COSH()`, `DEGREES()` (rad2deg), `EXP()`, `LN()` (log), `LOG10()`, `RADIANS()` (deg2rad), `SIN()`, `SINH()`, `SQRT()`, `TAN()`, `TANH()`. One TextData function is also affected: `REPT()` (str_repeat). - `formatAsDate` correctly matches language metadata, reverting c55272e - Formulae that previously crashed on sub function call returning excel error value now return said value. The following functions are affected `CUMPRINC()`, `CUMIPMT()`, `AMORLINC()`, `AMORDEGRC()`. - Adapt some function error return value to match excel\'s error. The following functions are affected `PPMT()`, `IPMT()`.
* Deprecated - Calling many of the Excel formula functions directly rather than through the Calculation Engine. The logic for these Functions is now being moved out of the categorised `Database`, `DateTime`, `Engineering`, `Financial`, `Logical`, `LookupRef`, `MathTrig`, `Statistical`, `TextData` and `Web` classes into small, dedicated classes for individual functions or related groups of functions. This makes the logic in these classes easier to maintain; and will reduce the memory footprint required to execute formulae when calling these functions.
* Removed - Nothing.
* Fixed - Avoid Duplicate Titles When Reading Multiple HTML Files. [Issue #1823](https://github.com/PHPOffice/PhpSpreadsheet/issues/1823) [PR #1829](https://github.com/PHPOffice/PhpSpreadsheet/pull/1829) - Fixed issue with Worksheet\'s `getCell()` method when trying to get a cell by defined name. [#1858](https://github.com/PHPOffice/PhpSpreadsheet/issues/1858) - Fix possible endless loop in NumberFormat Masks [#1792](https://github.com/PHPOffice/PhpSpreadsheet/issues/1792) - Fix problem resulting from literal dot inside quotes in number format masks. [PR #1830](https://github.com/PHPOffice/PhpSpreadsheet/pull/1830) - Resolve Google Sheets Xlsx charts issue. Google Sheets uses oneCellAnchor positioning and does not include
*Cache values in the exported Xlsx. [PR #1761](https://github.com/PHPOffice/PhpSpreadsheet/pull/1761) - Fix for Xlsx Chart axis titles mapping to correct X or Y axis label when only one is present. [PR #1760](https://github.com/PHPOffice/PhpSpreadsheet/pull/1760) - Fix For Null Exception on ODS Read of Page Settings. [#1772](https://github.com/PHPOffice/PhpSpreadsheet/issues/1772) - Fix Xlsx reader overriding manually set number format with builtin number format. [PR #1805](https://github.com/PHPOffice/PhpSpreadsheet/pull/1805) - Fix Xlsx reader cell alignment. [PR #1710](https://github.com/PHPOffice/PhpSpreadsheet/pull/1710) - Fix for not yet implemented data-types in Open Document writer [Issue #1674](https://github.com/PHPOffice/PhpSpreadsheet/issues/1674) - Fix XLSX reader when having a corrupt numeric cell data type [PR #1664](https://github.com/phpoffice/phpspreadsheet/pull/1664) - Fix on `CUMPRINC()`, `CUMIPMT()`, `AMORLINC()`, `AMORDEGRC()` usage. When those functions called one of `YEARFRAC()`, `PPMT()`, `IPMT()` and they would get back an error value (represented as a string), trying to use numeral operands (`+`, `/`, `-`, `
*`) on said return value and a number (`float or `int`) would fail.- 1.16.0 - 2020-12-31
* Added - CSV Reader - Best Guess for Encoding, and Handle Null-string Escape [#1647](https://github.com/PHPOffice/PhpSpreadsheet/issues/1647)
* Changed - Updated the CONVERT() function to support all current MS Excel categories and Units of Measure.
* Deprecated - All Excel Function implementations in `Calculation\\Database`, `Calculation\\DateTime`, `Calculation\\Engineering`, `Calculation\\Financial`, `Calculation\\Logical`, `Calculation\\LookupRef`, `Calculation\\MathTrig`, `Calculation\\Statistical`, `Calculation\\TextData` and `Calculation\\Web` have been moved to dedicated classes for individual functions or groups of related functions. See the docblocks against all the deprecated methods for details of the new methods to call instead. At some point, these old classes will be deleted.
* Removed- Nothing.
* Fixed - Fixed issue with absolute path in worksheets\' Target. [PR #1769](https://github.com/PHPOffice/PhpSpreadsheet/pull/1769) - Fix for Xls Reader when SST has a bad length [#1592](https://github.com/PHPOffice/PhpSpreadsheet/issues/1592) - Resolve Xlsx loader issue whe hyperlinks don\'t have a destination - Resolve issues when printer settings resources IDs clash with drawing IDs - Resolve issue with SLK long filenames [#1612](https://github.com/PHPOffice/PhpSpreadsheet/issues/1612) - ROUNDUP and ROUNDDOWN return incorrect results for values of 0 [#1627](https://github.com/phpoffice/phpspreadsheet/pull/1627) - Apply Column and Row Styles to Existing Cells [#1712](https://github.com/PHPOffice/PhpSpreadsheet/issues/1712) [PR #1721](https://github.com/PHPOffice/PhpSpreadsheet/pull/1721) - Resolve issues with defined names where worksheet doesn\'t exist (#1686)[https://github.com/PHPOffice/PhpSpreadsheet/issues/1686] and [#1723](https://github.com/PHPOffice/PhpSpreadsheet/issues/1723) - [PR #1742](https://github.com/PHPOffice/PhpSpreadsheet/pull/1742) - Fix for issue [#1735](https://github.com/PHPOffice/PhpSpreadsheet/issues/1735) Incorrect activeSheetIndex after RemoveSheetByIndex - [PR #1743](https://github.com/PHPOffice/PhpSpreadsheet/pull/1743) - Ensure that the list of shared formulae is maintained when an xlsx file is chunked with readFilter[Issue #169](https://github.com/PHPOffice/PhpSpreadsheet/issues/1669). - Fix for notice during accessing \"cached magnification factor\" offset [#1354](https://github.com/PHPOffice/PhpSpreadsheet/pull/1354) - Fix compatibility with ext-gd on php 8
* Security Fix (CVE-2020-7776) - Prevent XSS through cell comments in the HTML Writer.- 1.15.0 - 2020-10-11
* Added - Implemented Page Order for Xlsx and Xls Readers, and provided Page Settings (Orientation, Scale, Horizontal/Vertical Centering, Page Order, Margins) support for Ods, Gnumeric and Xls Readers [#1559](https://github.com/PHPOffice/PhpSpreadsheet/pull/1559) - Implementation of the Excel `LOGNORM.DIST()`, `NORM.S.DIST()`, `GAMMA()` and `GAUSS()` functions. [#1588](https://github.com/PHPOffice/PhpSpreadsheet/pull/1588) - Named formula implementation, and improved handling of Defined Names generally [#1535](https://github.com/PHPOffice/PhpSpreadsheet/pull/1535) - Defined Names are now case-insensitive - Distinction between named ranges and named formulae - Correct handling of union and intersection operators in named ranges - Correct evaluation of named range operators in calculations - fix resolution of relative named range values in the calculation engine; previously all named range values had been treated as absolute. - Calculation support for named formulae - Support for nested ranges and formulae (named ranges and formulae that reference other named ranges/formulae) in calculations - Introduction of a helper to convert address formats between R1C1 and A1 (and the reverse) - Proper support for both named ranges and named formulae in all appropriate Readers -
*
*Xlsx
*
* (Previously only simple named ranges were supported) -
*
*Xls
*
* (Previously only simple named ranges were supported) -
*
*Gnumeric
*
* (Previously neither named ranges nor formulae were supported) -
*
*Ods
*
* (Previously neither named ranges nor formulae were supported) -
*
*Xml
*
* (Previously neither named ranges nor formulae were supported) - Proper support for named ranges and named formulae in all appropriate Writers -
*
*Xlsx
*
* (Previously only simple named ranges were supported) -
*
*Xls
*
* (Previously neither named ranges nor formulae were supported) - Still not supported, but some parser issues resolved that previously failed to differentiate between a defined name and a function name -
*
*Ods
*
* (Previously neither named ranges nor formulae were supported) - Support for PHP 8.0
* Changed - Improve Coverage for ODS Reader [#1545](https://github.com/phpoffice/phpspreadsheet/pull/1545) - Named formula implementation, and improved handling of Defined Names generally [#1535](https://github.com/PHPOffice/PhpSpreadsheet/pull/1535) - fix resolution of relative named range values in the calculation engine; previously all named range values had been treated as absolute. - Drop $this->spreadSheet null check from Xlsx Writer [#1646](https://github.com/phpoffice/phpspreadsheet/pull/1646) - Improving Coverage for Excel2003 XML Reader [#1557](https://github.com/phpoffice/phpspreadsheet/pull/1557)
* Deprecated -
*
*IMPORTANT NOTE:
*
* This Introduces a
*
*BC break
*
* in the handling of named ranges. Previously, a named range cell reference of `B2` would be treated identically to a named range cell reference of `$B2` or `B$2` or `$B$2` because the calculation engine treated then all as absolute references. These changes \"fix\" that, so the calculation engine now handles relative references in named ranges correctly. This change that resolves previously incorrect behaviour in the calculation may affect users who have dynamically defined named ranges using relative references when they should have used absolute references. [#]## Removed- Nothing. [#]## Fixed- PrintArea causes exception [#1544](https://github.com/phpoffice/phpspreadsheet/pull/1544)- Calculation/DateTime Failure With PHP8 [#1661](https://github.com/phpoffice/phpspreadsheet/pull/1661)- Reader/Gnumeric Failure with PHP8 [#1662](https://github.com/phpoffice/phpspreadsheet/pull/1662)- ReverseSort bug, exposed but not caused by PHP8 [#1660](https://github.com/phpoffice/phpspreadsheet/pull/1660)- Bug setting Superscript/Subscript to false [#1567](https://github.com/phpoffice/phpspreadsheet/pull/1567)
* Thu Oct 08 2020 Tuukka Pasanen - Update to release 1.14.1 - 2020-07-19
* Added - nothing
* Fixed - WEBSERVICE is HTTP client agnostic and must be configured via Settings::setHttpClient() #1562 - Borders were not complete on rowspanned columns using HTML reader #1473
* Changed - nothing- [1.14.0] - 2020-06-29
* 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 - 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- [1.13.0] - 2020-05-31
* Added - Support writing to streams in all writers #1292 - Support CSV files with data wrapping a lot of lines #1468 - Support protection of worksheet by a specific hash algorithm #1485
* Fixed - Fix Chart samples by updating chart parameter from 0 to DataSeries::EMPTY_AS_GAP #1448 - Fix return type in docblock for the Cells::get() #1398 - Fix RATE, PRICE, XIRR, and XNPV Functions #1456 - Save Excel 2010+ functions properly in XLSX #1461 - Several improvements in HTML writer #1464 - Fix incorrect behaviour when saving XLSX file with drawings #1462, - Fix Crash while trying setting a cell the value \"123456\
\" #1476 - Improved DATEDIF() function and reduced errors for Y and YM units #1466 - Stricter typing for mergeCells #1494
* Changed - Drop support for PHP 7.1, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support - Drop partial migration tool in favor of complete migration via RectorPHP #1445 - Limit composer package to src/ #1424- [1.12.0] - 2020-04-27
* Added - Improved the ARABIC function to also handle short-hand roman numerals - Added support for the FLOOR.MATH and FLOOR.PRECISE functions #1351
* Fixed - Fix ROUNDUP and ROUNDDOWN for floating-point rounding error #1404 - Fix ROUNDUP and ROUNDDOWN for negative number #1417 - Fix loading styles from vmlDrawings when containing whitespace #1347 - Fix incorrect behavior when removing last row #1365 - MATCH with a static array should return the position of the found value based on the values submitted #1332 - Fix Xlsx Reader\'s handling of undefined fill color #1353- [1.11.0] - 2020-03-02
* Added - Added support for the BASE function - Added support for the ARABIC function - Conditionals - Extend Support for (NOT)CONTAINSBLANKS #1278
* Fixed - Handle Error in Formula Processing Better for Xls #1267 - Handle ConditionalStyle NumberFormat When Reading Xlsx File #1296 - Fix Xlsx Writer\'s handling of decimal commas #1282 - Fix for issue by removing test code mistakenly left in #1328 - Fix for Xls writer wrong selected cells and active sheet #1256 - Fix active cell when freeze pane is used #1323 - Fix XLSX file loading with autofilter containing \'$\' #1326 - PHPDoc - Use AATTreturn $this for fluent methods #1362- [1.10.1] - 2019-12-02
* Changed - PHP 7.4 compatibility
* Fixed - FLOOR() function accept negative number and negative significance #1245 - Correct column style even when using rowspan #1249 - Do not confuse defined names and cell refs #1263 - XLSX reader/writer keep decimal for floats with a zero decimal part #1262 - ODS writer prevent invalid numeric value if locale decimal separator is comma #1268 - Xlsx writer actually writes plotVisOnly and dispBlanksAs from chart properties #1266
* Fri Nov 22 2019 Tuukka Pasanen - Update to release 1.10.0 - 2019-11-18
* Changed - Change license from LGPL 2.1 to MIT #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
* Fixed - IF implementation properly handles the value #N/A #1165 - Formula Parser: Wrong line count for stuff like \"MyOtherSheet!A:D\" #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 - Fix branch pruning handling of non boolean conditions #1167 - Fix ODS Reader when no DC namespace are defined #1182 - Fixed Functions->ifCondition for allowing <> and empty condition #1206 - Validate XIRR inputs and return correct error values #1120 - Allow to read xlsx files with exotic workbook names like \"workbook2.xml\" #1183 - [1.9.0] - 2019-08-17
* Changed - Drop support for PHP 5.6 and 7.0, according to https://phpspreadsheet.readthedocs.io/en/latest/#php-version-support
* Added - When
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- [1.8.2] - 2019-07-08
* Fixed - Uncaught error when opening ods file and properties aren\'t defined #1047 - Xlsx Reader Cell datavalidations bug #1052 - [1.8.1] - 2019-07-02
* Fixed - Allow nullable theme for Xlsx Style Reader class #1043 - [1.8.0] - 2019-07-01
* Security Fix (CVE-2019-12331) - Detect double-encoded xml in the Security scanner, and reject as suspicious.
* This change also broadens the scope of the libxml_disable_entity_loader setting when reading XML-based formats, so that it is enabled while the xml is being parsed and not simply while it is loaded. On some versions of PHP, this can cause problems because it is not thread-safe, and can affect other PHP scripts running on the same server. This flag is set to true when instantiating a loader, and back to its original setting when the Reader is no longer in scope, or manually unset. - provide a check to identify whether libxml_disable_entity_loader is thread-safe or not. - XmlScanner::threadSafeLibxmlDisableEntityLoaderAvailability()
* Provide an option to disable the libxml_disable_entity_loader call through settings. This is not recommended as it reduces the security of the XML-based readers, and should only be used if you understand the consequences and have no other choice.
* Added - Added support for the SWITCH function #963 and #983 - Add accounting number format style #974
* Fixed - Whitelist tsv extension when opening CSV files #429 - Fix a SUMIF warning with some versions of PHP when having different length of arrays provided as input #873 - Fix incorrectly handled backslash-escaped space characters in number format- [1.7.0] - 2019-05-26
* Added - Support for inline styles in Html reader (borders, alignment, width, height) - QuotedText cells no longer treated as formulae if the content begins with a = - Clean handling for DDE in formulae
* Fixed - Fix handling for escaped enclosures and new lines in CSV Separator Inference - Fix MATCH an error was appearing when comparing strings against 0 (always true) - Fix wrong calculation of highest column with specified row #700 - Fix VLOOKUP - Fix return type hint- [1.6.0] - 2019-01-02
* Added - Refactored Matrix Functions to use external Matrix library - Possibility to specify custom colors of values for pie and donut charts #768
* Fixed - Improve XLSX parsing speed if no readFilter is applied #772 - Fix column names if read filter calls in XLSX reader skip columns #777 - XLSX reader can now ignore blank cells, using the setReadEmptyCells(false) method. #810 - Fix LOOKUP function which was breaking on edge cases #796 - Fix VLOOKUP with exact matches #809 - Support COUNTIFS multiple arguments #830 - Change libxml_disable_entity_loader() as shortly as possible #819 - Improved memory usage and performance when loading large spreadsheets #822 - Improved performance when loading large spreadsheets #825 - Improved performance when loading large spreadsheets #824 - Fix color from CSS when reading from HTML #831 - Fix infinite loop when reading invalid ODS files #832 - Fix time format for duration is incorrect #666 - Fix iconv unsupported //IGNORE//TRANSLIT on IBM i #791
* Changed - master is the new default branch, develop does not exist anymore
* Tue Dec 04 2018 Tuukka Pasanen - Release 1.5.2
* Security - Improvements to the design of the XML Security Scanner - #771 - Fix and improve XXE security scanning for XML-based and HTML Readers - #771
* Added - Support page margin in mPDF - #750
* Fixed - Support numeric condition in SUMIF, SUMIFS, AVERAGEIF, COUNTIF, MAXIF and MINIF - #683 - SUMIFS containing multiple conditions - #704 - Csv reader avoid notice when the file is empty - #743 - Fix print area parser for XLSX reader - #734 - Support overriding DefaultValueBinder::dataTypeForValue() without overriding DefaultValueBinder::bindValue() - #735 - Mpdf export can exceed pcre.backtrack_limit - #637 - Fix index overflow on data values array - #748
* Thu Nov 15 2018 Tuukka Pasanen 1.5.0- Release 1.5.0
* Added - PHP 7.3 support - Add the DAYS() function - #594
* Fixed - Sheet title can contain exclamation mark - #325 - Xls file cause the exception during open by Xls reader - #402 - Skip non numeric value in SUMIF - #618 - OFFSET should allow omitted height and width - #561 - Correctly determine delimiter when CSV contains line breaks inside enclosures - #716 - Remove locale from formatting string - #644 - Allow iterators to go out of bounds with prev - #587 - Fix warning when reading xlsx without styles - #631 - Fix broken sample links on windows due to $baseDir having backslash - #653
* Thu Sep 13 2018 Tuukka Pasanen - Initial version 1.4.0