Released: Mar 8, 2020

5.x での更新項目

機能

• Support all Excel 2019 chart types with the new, modern styling.
• Insert/Delete ranges in worksheets and rows/cols in tables.
• Extended support for Pivot tables - Filters, calculated columns, support for shared caches, auto sort and "Show Value As" on data fields.
• Pivot table- and table- slicers.
• Custom table-, pivot table- and slicer styles.
• Pivot table styling via pivot areas.
• Improvements of the formula calculation engine and 147 new supported functions.
• Threaded comments with support for mentions.
• Support for importing dynamic/ExpandoObject to worksheets and a new set of attributes extending the capabilities of the LoadFromCollection method..
• Support for exporting data from worksheets to files and DataTable.
• Async methods for I/O operations.
• Themes, Filters, Ignore errors.
• Support for form controls and grouping of drawings.
• External links.
• Enhanced sorting - Sort state, left-to-right and custom list sorting and auto sort on pivot tables.
• New Fill functionality and improved Copy method on Ranges.
• Split worksheet into panes.
• Easier access to Rows and Columns - Worksheet.Rows, Worksheet.Columns, Range.EntireRow and Range.EntireColumn.
• Minor new features and fixed issues.