MINOR BREAKING CHANGE

• Writing of cell comments to Html will now sanitize all Html tags within the comment, so the tags will be rendered as plaintext and have no other effects when rendered. Styling can be achieved by using the Font property of of the TextRuns which make up the comment, as is already the cases for Xlsx. PR #3957

Added

• Default Style Alignment Property (workaround for bug in non-Excel spreadsheet apps) Issue #3918 PR #3924
• Additional Support for Date/Time Styles PR #3939

Changed

• Nothing

Deprecated

• Reader/Xml trySimpleXMLLoadString should not have had public visibility, and will be removed.

Removed

• Nothing

Fixed

• IF Empty Arguments. Issue #3875 Issue #2146 PR #3879
• Changes to floating point in Php8.4. Issue #3896 PR #3897
• Handling User-supplied Decimal and Thousands Separators. Issue #3900 PR #3903
• Improve Performance of CSV Writer. Issue #3904 PR #3906
• Fix issue with prepending zero in percentage Issue #3920 PR #3921
• Incorrect SUMPRODUCT Calculation Issue #3909 PR #3916
• Formula Misidentifying Text as Cell After Insertion/Deletion Issue #3907 PR #3915
• Unexpected Absolute Address in Xlsx Rels Issue #3730 PR #3923
• Unallocated Cells Affected by Column/Row Insert/Delete Issue #3933 PR #3940
• Invalid Builtin Defined Name in Xls Reader Issue #3935 PR #3942
• Hidden Rows and Columns Tcpdf/Mpdf PR #3945
• RTL Text Alignment in Xlsx Comments Issue #4004 PR #4006
• Protect Sheet But Allow Sort Issue #3951 PR #3956
• Default Value for Conditional::$text PR #3946
• Table Filter Buttons Issue #3988 PR #3992
• Improvements to Xml Reader Issue #3999 Issue #4000 Issue #4001 Issue #4002 PR #4003 PR #4007
• Html Reader non-UTF8 Issue #3995 Issue #866 Issue #1681 PR #4019