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