Released: Dec 5, 2023

v7.0.3 での更新項目

機能

• Added support for Microsoft .NET 8.
• Added Alignment and Protection properties to ExcelDxfStyle - Affects Table and Pivot Table styling.
• Improved handling of negation of ranges in formula calculation.
• Added AlwaysAllowNull property to ToDataTableOptions parameter of the ExcelRangeBase.ToDataTable function.

不具合の修正

• ExcelValueFilterColumn.Filters. Blank property now hides rows even if it contains no other filters.
• Resolved issue where ExcelValueFilterCollection.Add("") or adding null on ExcelFilterValueItem generated corrupt worksheet. The Blank property is now set to true instead.
• Hyperlinks were not correctly encoded if Unicode characters was used.
• External references in the lookup range did not work in the VLOOKUP & HLOOKUP functions.
• Copying worksheets with pivot tables caused a corrupt workbook in some cases.
• Insert/Deleting in ranges sometimes affected addresses referencing other worksheets.
• The ExcelRangeBase.Text property sometimes returned a formatted value with both - and () for negative values on some cultures.