1.26.0 - 2022-12-21
Added
- Extended flag options for the Reader
load()and Writersave()methods - Apply Row/Column limits (1048576 and XFD) in ReferenceHelper PR #3213
- Allow the creation of In-Memory Drawings from a string of binary image data, or from a stream. PR #3157
- Xlsx Reader support for Tables PR #2829
- Permit Date/Time Entered on Spreadsheet to be calculated as Float Issue #1416 PR #3121
Changed
- Nothing
Deprecated
- Direct update of Calculation::suppressFormulaErrors is replaced with setter.
- Font public static variable defaultColumnWidths replaced with constant DEFAULT_COLUMN_WIDTHS.
- ExcelError public static variable errorCodes replaced with constant ERROR_CODES.
- NumberFormat constant FORMAT_DATE_YYYYMMDD2 replaced with existing identical FORMAT_DATE_YYYYMMDD.
Removed
- Nothing
Fixed
- Fixed handling for
_xlwsprefixed functions from Office365 Issue #3245 PR #3247 - Conditionals formatting rules applied to rows/columns are removed Issue #3184 PR #3213
- Treat strings containing currency or accounting values as floats in Calculation Engine operations Issue #3165 PR #3189
- Treat strings containing percentage values as floats in Calculation Engine operations Issue #3155 PR #3156 and PR #3164
- Xlsx Reader Accept Palette of Fewer than 64 Colors Issue #3093 PR #3096
- Use Locale-Independent Float Conversion for Xlsx Writer Custom Property Issue #3095 PR #3099
- Allow setting AutoFilter range on a single cell or row Issue #3102 PR #3111
- Xlsx Reader External Data Validations Flag Missing Issue #2677 PR #3078
- Reduces extra memory usage on
__destruct()calls PR #3092 - Additional properties for Trendlines Issue #3011 PR #3028
- Calculation suppressFormulaErrors fix Issue #1531 PR #3092
- Permit Date/Time Entered on Spreadsheet to be Calculated as Float Issue #1416 PR #3121
- Incorrect Handling of Data Validation Formula Containing Ampersand Issue #3145 PR #3146
- Xlsx Namespace Handling of Drawings, RowAndColumnAttributes, MergeCells Issue #3138 PR #3136
- Generation3 Copy With Image in Footer Issue #3126 PR #3140
- MATCH Function Problems with Int/Float Compare and Wildcards Issue #3141 PR #3142
- Fix ODS Read Filter on number-columns-repeated cell Issue #3148 PR #3149
- Problems Formatting Very Small and Very Large Numbers Issue #3128 PR #3152
- XlsxWrite preserve line styles for y-axis, not just x-axis PR #3163
- Xlsx Namespace Handling of Drawings, RowAndColumnAttributes, MergeCells Issue #3138 PR #3137
- More Detail for Cyclic Error Messages Issue #3169 PR #3170
- Improved Documentation for Deprecations - many PRs Issue #3162