-
Notifications
You must be signed in to change notification settings - Fork 275
Roadmap
Mats Alm edited this page Apr 15, 2024
·
39 revisions
- Pivot table enhancements.
- Refresh pivot caches.
- Calculate Pivot Tables.
- Support for the
GetPivotData
function. EPPlus 7.2 - Support for newer pivot table properties stored in the extLst element.
- Support for Conditional Formatting - Data bars and Icon Sets - in the HTML Export.
- Load and Save fixed-width text files.
- Transpose functionality in Load-, Save- and Copy functions
See the EPPlus 7.2 Project
- Redesign of the library into a modular architecture
- Improve test coverage
- Improve documentation & samples
- Performance improvements and new features.
See the EPPlus Epics project.
- ExcelRange.LoadFromCollection improvments.
- Support for Conditional Formatting in the HTML Export (except Data bars and Icon Sets).
- Improvements of the formula calculation engine.
- Optimized tokenizer
- Improved handling/performance of shared formulas.
- Support for array formulas and dynamic array formulas.
- Support for more functions.
- Conditional formatting
- Improved performance.
- Support for newer formats such as databars with gradient fill.
- 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.
- 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.
- Html/css & Json export.
- Remove dependency to System.Drawing.Common for Non GDI environments.
- Support for splitting panes in a worksheet.
- Better support for Row and Column properties (easier access via range, enumeration).
- Improved Range Copy support
- Support for 'Show data as' on pivot tables data fields.
- Support for External references in the formula parser.
- Enhanced sorting.
- Custom styles for Tables and Pivot Table and slicers
- Styling for tables.
- Pivot table styling via Pivot Areas
- Add support for Form controls like, buttons and checkboxes
- Export range to DataTable.
- Pivot Table Enhancements - Filters, Calculated Columns and Shared Caches
- Slicers
- Threaded comments
- Improve test coverage
- Add support for Extended chart types, like treemap, sunburst, histogram and more
- Improve documentation & samples
- Improve test coverage
EPPlus Software AB - https://epplussoftware.com
- Getting Started
- The Sample Project
- EPPlus and Docker
- EPPlus and Blazor
- EPPlus and Linux
- Security
- Configuration
- Releases/versioning
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles