Tags: 6ugly/PhpSpreadsheet
Tags
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
1.6.0 ### Added - Refactored Matrix Functions to use external Matrix library - Possibility to specify custom colors of values for pie and donut charts - [PHPOffice#768](PHPOffice#768) ### Fixed - Improve XLSX parsing speed if no readFilter is applied - [PHPOffice#772](PHPOffice#772) - Fix column names if read filter calls in XLSX reader skip columns - [PHPOffice#777](PHPOffice#777) - Fix LOOKUP function which was breaking on edge cases - [PHPOffice#796](PHPOffice#796) - Fix VLOOKUP with exact matches - [PHPOffice#809](PHPOffice#809) - Support COUNTIFS multiple arguments - [PHPOffice#830](PHPOffice#830) - Change `libxml_disable_entity_loader()` as shortly as possible - [PHPOffice#819](PHPOffice#819) - Improved memory usage and performance when loading large spreadsheets - [PHPOffice#822](PHPOffice#822) - Improved performance when loading large spreadsheets - [PHPOffice#825](PHPOffice#825) - Improved performance when loading large spreadsheets - [PHPOffice#824](PHPOffice#824) - Fix color from CSS when reading from HTML - [PHPOffice#831](PHPOffice#831) - Fix infinite loop when reading invalid ODS files - [PHPOffice#832](PHPOffice#832) - Fix time format for duration is incorrect - [PHPOffice#666](PHPOffice#666) - Fix iconv unsupported `//IGNORE//TRANSLIT` on IBM i - [PHPOffice#791](PHPOffice#791) ### Changed - `master` is the new default branch, `develop` does not exist anymore
PreviousNext