2024-07-24 - 2.2.0
Added
- Xlsx Reader Optionally Ignore Rows With No Cells. Issue #3982 PR #4035
- Means to change style without affecting current cell/sheet. PR #4073
- Option for CSV output file to have varying numbers of columns for each row. Issue #1415 PR #4076
Changed
- On read, Xlsx Reader had been breaking up union ranges into separate individual ranges. It will now try to preserve range as it was read in. PR #4042
- Xlsx/Xls spreadsheet calculation and formatting of dates will use base date of spreadsheet even when spreadsheets with different base dates are simultaneously open. Issue #1036 Issue #1635 PR #4071
Deprecated
- Writer\Xls\Style\ColorMap is no longer needed.
Moved
- Nothing
Fixed
- Incorrect Reader CSV with BOM. Issue #4028 PR #4029
- POWER Null/Bool Args. PR #4031
- Do Not Output Alignment and Protection for Conditional Format. Issue #4025 PR #4027
- Conditional Color Scale Improvements. Issue #4049 PR #4050
- Mpdf and Tcpdf Borders on Merged Cells. Issue #3557 PR #4047
- Xls Conditional Format Improvements. PR #4030 PR #4033
- Conditional Range Unions and Intersections Issue #4039 PR #4042
- Ods comments with newlines. Issue #4081 PR #4086
- Propagate errors in Text functions. Issue #2581 PR #4080
- Csv Reader allow use of html mimetype. Issue #4036 PR #4040
- Problem rendering line chart with missing plot label. PR #4074
- More RTL in Xlsx/Html Comments Issue #4004 PR #4065
- Empty String in sharedStrings. Issue #4063 PR #4064
- Xlsx Writer RichText and TYPE_STRING. Issue #476 PR #4094
- Ods boolean data. Issue #460 PR #4093
- Html Writer Minor Fixes. PR #4089
- Changes to INDEX function. Issue #64 PR #4088
- Ods Reader and Whitespace Text Nodes. Issue #804 PR #4087
- Ods Xml Reader and Whitespace Text Nodes. Issue #804 PR #4087
- Treat invalid formulas as strings. Issue #1310 PR #4073