Roadmap

Future roadmap

Version 6.2

• New implementation of data validations.
  • Data validations will now be kept in-memory until the workbook is saved (Worksheet xml will not be updated in runtime).
  • Improved performance.
  • Better support for formulas referring to other worksheets.

Version 7.0-

• Improvements to the formula parser.
  • Optimized tokenizer
  • Improved handling/performance of shared formulas.
  • Support for array formulas and dynamic array formulas.
• Pivot table enhancements.

Short / mid term

• Improved formula calc engine (performance, more functions/functionality).
• Improved support for array formulas
• Improve test coverage
• Improve documentation & samples

Long term

• Redesign of the library into a modular architecture

History

Version 6.1

• Support for newer VBA signatures - Agile and V3
• Added ExcelRangeBase.ToCollection to map ranges and tables to a collection of T.
• New methods for grouping Rows and Columns.

Version 6.0

• Html/css & Json export.
• Remove dependency to System.Drawing.Common for Non GDI environments.

Version 5.8

• Support for splitting panes in a worksheet.
• Better support for Row and Column properties (easier access via range, enumeration).
• Improved Range Copy support

Version 5.7

• Support for 'Show data as' on pivot tables data fields.
• Support for External references in the formula parser.
• Enhanced sorting.

Version 5.6

• Custom styles for Tables and Pivot Table and slicers
• Styling for tables.
• Pivot table styling via Pivot Areas

Version 5.5

• Add support for Form controls like, buttons and checkboxes
• Export range to DataTable.

Version 5.4

• Pivot Table Enhancements - Filters, Calculated Columns and Shared Caches
• Slicers

Version 5.3

• Threaded comments
• Improve test coverage

Version 5.2

• Add support for Extended chart types, like treemap, sunburst, histogram and more
• Improve documentation & samples
• Improve test coverage