Released: Oct 28, 2024

v7.4.2 での更新項目

機能

• Added support for the array attribute on table column formulas:
  • Added new property 'ExcelTableColumn.IsCalculatedFormulaArray'.
  • EPPlus automatically updates the IsCalculatedFormulaArray if a table formula is identified as an array formula in the calculation.
• You can now add mappings for error values as a string in the ToDataTableOptions.

不具合の修正

• Rich text strings in the shared strings XML did not support both text and RichText elements in the same item.
• The dynamic array formula flag was not set for single cell results containing range operations.
• Fixed inaccurate relative addresses in cloned formulas in rare cases.
• Deleting and adding a table with multiple worksheets no longer gives the added table an invalid ID.
• Ensured ExcelPictures are sized correctly when copying worksheets.
• Fixed issue where adding rows to a Table that contained error values would throw error or generate a corrupt workbook, when the table was the source range of a pivot table.
• Fixed ExcelErrorValues GetHashCode and Equals methods to return appropriate Type value.
• Fixed incorrect datatype flags for ExcelPivotTableCacheField.
• One-cell anchored, and absolute positioned drawings failed to copy when copying ranges.
• Pivot tables with a page field, item filter or a slicer added new items as visible when refreshing the pivot table. EPPlus will now keep the filter when refreshing the pivot table, hiding values not matched by the filter.
• Fixed issues regarding the preservation of geo, stock and currency data types.