PhpSpreadsheet v1.22.0 Release Notes
Release Date: 2022-02-18 // about 2 years ago-
โ Added
๐ Namespacing phase 2 - styles. PR #2471
๐ Improved support for passing of array arguments to Excel function implementations to return array results (where appropriate). Issue #2551
This is the first stage in an ongoing process of adding array support to all appropriate function implementations,
- ๐ Support for the Excel365 Math/Trig SEQUENCE() function PR #2536
- ๐ Support for the Excel365 Math/Trig RANDARRAY() function PR #2540
Note that the Spill Operator is not yet supported in the Calculation Engine; but this can still be useful for defining array constants.
๐ Improved support for Conditional Formatting Rules PR #2491
- Provide support for a wider range of Conditional Formatting Rules for Xlsx Reader/Writer:
- Cells Containing (cellIs)
- Specific Text (containing, notContaining, beginsWith, endsWith)
- Dates Occurring (all supported timePeriods)
- Blanks/NoBlanks
- Errors/NoErrors
- Duplicates/Unique
- Expression
- Provision of CF Wizards (for all the above listed rule types) to help create/modify CF Rules without having to manage all the combinations of types/operators, and the complexities of formula expressions, or the text/timePeriod attributes.
See documentation for details
- Full support of the above CF Rules for the Xlsx Reader and Writer; even when the file being loaded has CF rules listed in the
<extLst><ext><ConditionalFormattings>
element for the worksheet rather than the<ConditionalFormatting>
element. - Provision of a CellMatcher to identify if rules are matched for a cell, and which matching style will be applied.
- Improved documentation and examples, covering all supported CF rule types.
- Add support for one digit decimals (FORMAT_NUMBER_0, FORMAT_PERCENTAGE_0). PR #2525
- Initial work enabling Excel function implementations for handling arrays as arguments when used in "array formulae" #2562
- Enable most of the Date/Time functions to accept array arguments #2573
- Array ready functions - Text, Math/Trig, Statistical, Engineering and Logical #2580
๐ Changed
- โ Additional Russian translations for Excel Functions (courtesy of aleks-samurai).
- ๐ Improved code coverage for NumberFormat. PR #2556
- Extract some methods from the Calculation Engine into dedicated classes #2537
- Eliminate calls to
flattenSingleValue()
that are no longer required when we're checking for array values as arguments #2590
๐ Deprecated
- Nothing
โ Removed
- Nothing
๐ Fixed
- ๐ Fixed
ReferenceHelper@insertNewBefore
behavior when removing column before last column with null value PR #2541 - ๐ Fix bug with
DOLLARDE()
andDOLLARFR()
functions when the dollar value is negative Issue #2578 PR #2579 - ๐ Fix partial function name matching when translating formulae from Russian to English Issue #2533 PR #2534
- Various bugs related to Conditional Formatting Rules, and errors in the Xlsx Writer for Conditional Formatting PR #2491
- ๐ Xlsx Reader merge range fixes. Issue #2501 PR #2504
- ๐ Handle explicit "date" type for Cell in Xlsx Reader. Issue #2373 PR #2485
- ๐ Recalibrate Row/Column Dimensions after removeRow/Column. Issue #2442 PR #2486
- Refinement for XIRR. Issue #2469 PR #2487
- Xlsx Reader handle cell with non-null explicit type but null value. Issue #2488 PR #2489
- Xlsx Reader fix height and width for oneCellAnchorDrawings. PR #2492
- Fix rounding error in NumberFormat::NUMBER_PERCENTAGE, NumberFormat::NUMBER_PERCENTAGE_00. PR #2555
- Don't treat thumbnail file as xml. Issue #2516 PR #2517
- โ Eliminating Xlsx Reader warning when no sz tag for RichText. Issue #2542 PR #2550
- ๐ Fix Xlsx/Xls Writer handling of inline strings. Issue #353 PR #2569
- Richtext colors were not being read correctly after namespace change #2458
- ๐ Fix discrepancy between the way markdown tables are rendered in ReadTheDocs and in PHPStorm #2520
- โก๏ธ Update Russian Functions Text File #2557
- ๐ Fix documentation, instantiation example #2564