Tags: pltrm/PhpSpreadsheet
Tags
1.13.0 ### Added - Support writing to streams in all writers [PHPOffice#1292](PHPOffice#1292) - Support CSV files with data wrapping a lot of lines [PHPOffice#1468](PHPOffice#1468) - Support protection of worksheet by a specific hash algorithm [PHPOffice#1485](PHPOffice#1485) ### Fixed - Fix Chart samples by updating chart parameter from 0 to DataSeries::EMPTY_AS_GAP [PHPOffice#1448](PHPOffice#1448) - Fix return type in docblock for the Cells::get() [PHPOffice#1398](PHPOffice#1398) - Fix RATE, PRICE, XIRR, and XNPV Functions [PHPOffice#1456](PHPOffice#1456) - Save Excel 2010+ functions properly in XLSX [PHPOffice#1461](PHPOffice#1461) - Several improvements in HTML writer [PHPOffice#1464](PHPOffice#1464) - Fix incorrect behaviour when saving XLSX file with drawings [PHPOffice#1462](PHPOffice#1462), - Fix Crash while trying setting a cell the value "123456\n" [PHPOffice#1476](PHPOffice#1481) - Improved DATEDIF() function and reduced errors for Y and YM units [PHPOffice#1466](PHPOffice#1466) - Stricter typing for mergeCells [PHPOffice#1494](PHPOffice#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 [PHPOffice#1445](PHPOffice#1445) - Limit composer package to `src/` [PHPOffice#1424](PHPOffice#1424)
1.12.0 ### Added - Improved the ARABIC function to also handle short-hand roman numerals - Added support for the FLOOR.MATH and FLOOR.PRECISE functions [PHPOffice#1351](PHPOffice#1351) ### Fixed - Fix ROUNDUP and ROUNDDOWN for floating-point rounding error [PHPOffice#1404](PHPOffice#1404) - Fix ROUNDUP and ROUNDDOWN for negative number [PHPOffice#1417](PHPOffice#1417) - Fix loading styles from vmlDrawings when containing whitespace [PHPOffice#1347](PHPOffice#1347) - Fix incorrect behavior when removing last row [PHPOffice#1365](PHPOffice#1365) - MATCH with a static array should return the position of the found value based on the values submitted [PHPOffice#1332](PHPOffice#1332) - Fix Xlsx Reader's handling of undefined fill color [PHPOffice#1353](PHPOffice#1353)
1.11.0 ### Added - Added support for the BASE function - Added support for the ARABIC function - Conditionals - Extend Support for (NOT)CONTAINSBLANKS [PHPOffice#1278](PHPOffice#1278) ### Fixed - Handle Error in Formula Processing Better for Xls [PHPOffice#1267](PHPOffice#1267) - Handle ConditionalStyle NumberFormat When Reading Xlsx File [PHPOffice#1296](PHPOffice#1296) - Fix Xlsx Writer's handling of decimal commas [PHPOffice#1282](PHPOffice#1282) - Fix for issue by removing test code mistakenly left in [PHPOffice#1328](PHPOffice#1328) - Fix for Xls writer wrong selected cells and active sheet [PHPOffice#1256](PHPOffice#1256) - Fix active cell when freeze pane is used [PHPOffice#1323](PHPOffice#1323) - Fix XLSX file loading with autofilter containing '$' [PHPOffice#1326](PHPOffice#1326) - PHPDoc - Use `@return $this` for fluent methods [PHPOffice#1362](PHPOffice#1362)
1.10.1 ### Changed - PHP 7.4 compatibility ### Fixed - FLOOR() function accept negative number and negative significance [PHPOffice#1245](PHPOffice#1245) - Correct column style even when using rowspan [PHPOffice#1249](PHPOffice#1249) - Do not confuse defined names and cell refs [PHPOffice#1263](PHPOffice#1263) - XLSX reader/writer keep decimal for floats with a zero decimal part [PHPOffice#1262](PHPOffice#1262) - ODS writer prevent invalid numeric value if locale decimal separator is comma [PHPOffice#1268](PHPOffice#1268) - Xlsx writer actually writes plotVisOnly and dispBlanksAs from chart properties [PHPOffice#1266](PHPOffice#1266)
1.10.0 ### Changed - Change license from LGPL 2.1 to MIT [PHPOffice#140](PHPOffice#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 [PHPOffice#1212](PHPOffice#1212) ### Fixed - IF implementation properly handles the value `#N/A` [PHPOffice#1165](PHPOffice#1165) - Formula Parser: Wrong line count for stuff like "MyOtherSheet!A:D" [PHPOffice#1215](PHPOffice#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 [PHPOffice#874](PHPOffice#874) - Fix branch pruning handling of non boolean conditions [PHPOffice#1167](PHPOffice#1167) - Fix ODS Reader when no DC namespace are defined [PHPOffice#1182](PHPOffice#1182) - Fixed Functions->ifCondition for allowing <> and empty condition [PHPOffice#1206](PHPOffice#1206) - Validate XIRR inputs and return correct error values [PHPOffice#1120](PHPOffice#1120) - Allow to read xlsx files with exotic workbook names like "workbook2.xml" [PHPOffice#1183](PHPOffice#1183)
1.9.0 ### Added - When <br> appears in a table cell, set the cell to wrap [PHPOffice#1071](PHPOffice#1071) and [PHPOffice#1070](PHPOffice#1070) - Add MAXIFS, MINIFS, COUNTIFS and Remove MINIF, MAXIF [PHPOffice#1056](PHPOffice#1056) - HLookup needs an ordered list even if range_lookup is set to false [PHPOffice#1055](PHPOffice#1055) and [PHPOffice#1076](PHPOffice#1076) - Improve performance of IF function calls via ranch pruning to avoid resolution of every branches [PHPOffice#844](PHPOffice#844) - MATCH function supports `*?~` Excel functionality, when match_type=0 [PHPOffice#1116](PHPOffice#1116) - Allow HTML Reader to accept HTML as a string [PHPOffice#1136](PHPOffice#1136) ### Fixed - Fix to AVERAGEIF() function when called with a third argument - Eliminate duplicate fill none style entries [PHPOffice#1066](PHPOffice#1066) - Fix number format masks containing literal (non-decimal point) dots [PHPOffice#1079](PHPOffice#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 [PHPOffice#1009](PHPOffice#1009) - Stricter-typed comparison testing in COUNTIF() and COUNTIFS() evaluation [PHPOffice#1046](PHPOffice#1046) - COUPNUM should not return zero when settlement is in the last period [PHPOffice#1020](PHPOffice#1020) and [PHPOffice#1021](PHPOffice#1021) - Fix handling of named ranges referencing sheets with spaces or "!" in their title - Cover `getSheetByName()` with tests for name with quote and spaces [PHPOffice#739](PHPOffice#739) - Best effort to support invalid colspan values in HTML reader - [PHPOffice#878](PHPOffice#878) - Fixes incorrect rows deletion [PHPOffice#868](PHPOffice#868) - MATCH function fix (value search by type, stop search when match_type=-1 and unordered element encountered) [PHPOffice#1116](PHPOffice#1116) - Fix `getCalculatedValue()` error with more than two INDIRECT [PHPOffice#1115](PHPOffice#1115) - Writer\Html did not hide columns [PHPOffice#985](PHPOffice#985)
1.7.0 ### Added - 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 [PHPOffice#700](PHPOffice#700) - Fix VLOOKUP - Fix return type hint