Released: Dec 9, 2024

v7.5.2 中的更新

修補程式

• Fixed issue where pivot tables with blanks could cause the pivot table to become corrupt.
• Fixed error handling in the TEXTJOIN, TEXTSPLIT and CONCAT functions.
• Fixed issue where an exception was thrown when trying to delete the last column in a worksheet.
• Fixed issue where ExcelColor.LookupColor() returned an unexpected color code for empty colors. LookupColor() now returns an empty string for empty colors.
• Fixed issue where DimensionByValue would throw an System.ArgumentException: 'Column out of range' in some cases.
• Fixed issue when having a column style on a column that spans multiple columns, where only the first column is considered when reading a package.
• XLOOKUP now returns empty string instead of #N/A when the third argument is an empty string.
• Fixed issue where ToDataTable did not return rich text cells correctly.
• Fixed issue where ExcelWorksheets.MoveToStart did not always work correctly if IsWorksheets1Based was set.
• Fixed issue where reading boolean properties of data validations saved in LibreOffice was not correctly read.
• Fixed issue where adding a pivot table page field could crash in some cases.
• Fixed issue where linked images crashed on read if the link attribute was empty.
• Fixed "Worksheet position out of range" exception when calculating a formula having IsWorksheets1Based set.