Releases: EPPlusSoftware/EPPlus
8.0.3
Features
- Support for OLE objects (Linked or Embedded files).
- Support for digital signing workbooks and signature lines.
- In-cell pictures / support for the IMAGE function.
- Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
Minor features
- Autofit columns optimization.
- Range Copy now supports fill.
- Reduced memory consumption when calculating formulas.
- Added ExcelRange.IsEmpty method.
- Shape adjustments points support.
- ExcelRangeBase.BorderAround now override borders for adjacent cells.
- InsertRange now returns the new inserted range.
- In-cell checkboxes now render in the HTML export.
- Improved API for Tables to access data via column names.
- Added IsEmpty() method on ExcelRange. Can test for value, comments, threaded comments and formulas.
- Override borders in Adjacent cells in BorderAround method.
EPPlus 8.0.3
- Minor bug fixes-See https://epplussoftware.com/en/Developers/MinorFeaturesAndIssues
8.0.2
Features
- Support for OLE objects (Linked or Embedded files).
- Support for digital signing workbooks and signature lines.
- In-cell pictures / support for the IMAGE function.
- Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
Minor features
- Autofit columns optimization.
- Range Copy now supports fill.
- Reduced memory consumption when calculating formulas.
- Added ExcelRange.IsEmpty method.
- Shape adjustments points support.
- ExcelRangeBase.BorderAround now override borders for adjacent cells.
- InsertRange now returns the new inserted range.
- In-cell checkboxes now render in the HTML export.
- Improved API for Tables to access data via column names.
- Added IsEmpty() method on ExcelRange. Can test for value, comments, threaded comments and formulas.
- Override borders in Adjacent cells in BorderAround method.
EPPlus 8.0.2
- Minor bug fixes-See https://epplussoftware.com/en/Developers/MinorFeaturesAndIssues
7.7.1
Major update to the calculation engine to support array formulas. See EPPlus7 features
Improved performance and better support for cross-worksheet references in conditional formatting.
7.7.1 Minor bug fixes
Release is available on Nuget.org per 20250415 : https://www.nuget.org/packages/EPPlus/
8.0.1
Features
- Support for OLE objects (Linked or Embedded files).
- Support for digital signing workbooks and signature lines.
- In-cell pictures / support for the IMAGE function.
- Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
Minor features
- Autofit columns optimization.
- Range Copy now supports fill.
- Reduced memory consumption when calculating formulas.
- Added ExcelRange.IsEmpty method.
- Shape adjustments points support.
- ExcelRangeBase.BorderAround now override borders for adjacent cells.
- InsertRange now returns the new inserted range.
- In-cell checkboxes now render in the HTML export.
- Improved API for Tables to access data via column names.
- Added IsEmpty() method on ExcelRange. Can test for value, comments, threaded comments and formulas.
- Override borders in Adjacent cells in BorderAround method.
Fixes since 8.0.0-beta
- Several fixes in the formula calculation,
- Better expression caching
- Fixed column filter in GETPIVOTDATA.
- Fixed PERCENTRANKS functions.
- Fixed array handling in the IF function.
- Fixed some issues in the IMAGE function.
- Fixed an issue in the COUNTIF function when comparing numbers
- Ole objects
- Added new properties ProgId, ExternalLink and Image to the ExcelOleObject
- Removed Removed ExcelOleObjectParameters.Extension and use extension from the file name.
- Fixed issue with duplicate images.
- Added DeleteAll method with predicate to ExcelWorkbook, ExcelRange, ExcelRangeRow and ExcelRangeColumn
- Adding EMZ image files did not work in streams.
- Removed several methods and properties marked as obsolete.
- Changed several properties and methods from decimal to double. See breaking changes.
- Fixed some issues with rich data and in-cell images.
- GenericImageReader sometimes returned an invalid DPI.
- Fixed support for .tif files.
- Fixed images corrupting files in rare cases.
- Ensured ungrouping the last drawing in a group deletes the group shape.
- Ensured valid xml for leader lines in charts.
- Ensured SetImage method did not swap width and height when switching between .svg and .png.
- Inserting and deleting cells now updates chart references. Ensuring charts continue pointing to the moved cells.
- Fixed numerous issues with array formulas and CalculatedColumnFormulas in tables related to inserting and deleting.
License keys
EPPlus 8 introduces license keys for commercial licenses and a new interface for providing license information. See this page for Commercial Use and this page for Noncommercial/Personal Use
8.0.0-rc
Features
- Support for OLE objects (Linked or Embedded files).
- Support for digital signing workbooks and signature lines.
- In-cell pictures / support for the IMAGE function.
- Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
Minor features
- Autofit columns optimization.
- Range Copy now supports fill.
- EPPlus now rounds decimal numbers more true to Excels precision.
- Added ExcelRange.IsEmpty method.
- Shape adjustments points support.
- ExcelRangeBase.BorderAround now override borders for adjacent cells.
- InsertRange now returnes the new inserted range.
- In-cell checkboxes now renders in the HTML export.
- Improved API for Tables to access data via column names.
- Added a new rounding that is more true to Excels precision. You can switch between .Net and Excel precision with ParsingContext.
- Added IsEmpty() method on ExcelRange. Can test for value, comments, threaded comments and formulas.
- Override borders in Adjacent cells in BorderAround method.
Fixes since 8.0.0-beta
- Several fixes in the formula calculation,
- Better expression caching
- Fixed column filter in GETPIVOTDATA.
- Fixed PERCENTRANKS functions.
- Fixed array handling in the IF function.
- Fixed some issues in the IMAGE function.
- Fixed an issue in the COUNTIF function when comparing numbers
- Ole objects
- Added new properties ProgId, ExternalLink and Image to the ExcelOleObject
- Removed Removed ExcelOleObjectParameters.Extension and use extension from the file name.
- Fixed issue with duplicate images.
- Added DeleteAll method with predicate to ExcelWorkbook, ExcelRange, ExcelRangeRow and ExcelRangeColumn
- Adding EMZ image files did not work in streams.
- Removed several methods and properties marked as obsolete.
- Changed several properties and methods from decimal to double. See breaking changes.
- Fixed some issues with rich data and in-cell images.
- GenericImageReader sometimes returned an invalid DPI.
- Fixed support for .tif files.
- Fixed images corrupting files in rare cases.
- Ensured ungrouping the last drawing in a group deletes the group shape.
- Ensured valid xml for leader lines in charts.
- Ensured SetImage method did not swap width and height when switching between .svg and .png.
- Inserting and deleting cells now updates chart references. Ensuring charts continue pointing to the moved cells.
- Fixed numerous issues with array formulas and CalculatedColumnFormulas in tables related to inserting and deleting.
License keys
EPPlus 8 introduces license keys for commercial licenses and a new interface for providing license information. See this page for Commercial Use and this page for Noncommercial/Personal Use
7.7.0
Major update to the calculation engine to support array formulas. See EPPlus7 features
Improved performance and better support for cross-worksheet references in conditional formatting.
Added target .NET 9.
Downgraded .NET 8, NET Standard 2 & 2.1, to use 8.. packages instead of the .NET 9, from 7.7.0
Bug fixes.
Release is available on Nuget.org per 20250317 : https://www.nuget.org/packages/EPPlus/
7.6.1
Major update to the calculation engine to support array formulas. See EPPlus7 features
Improved performance and better support for cross-worksheet references in conditional formatting.
Added target .NET 9.
Downgraded .NET 8, to use 8.. packages instead of the .NET 9, from 7.6.0
Bug fixes.
Release is available on Nuget.org per 20250206 : https://www.nuget.org/packages/EPPlus/
8.0.0-beta
Features
- Support for OLE objects (Linked or Embedded files).
- Support for digital signing workbooks and signature lines.
- In-cell pictures / support for the IMAGE function.
- Sensitivity Label API to integrate with MIP (Microsoft Information Protection SDK).
Minor features
- Autofit columns optimization.
- Range Copy now supports fill.
- EPPlus now rounds decimal numbers more true to Excels precision.
- Added ExcelRange.IsEmpty method.
- Shape adjustments points support.
- ExcelRangeBase.BorderAround now override borders for adjacent cells.
- InsertRange now returnes the new inserted range.
- In-cell checkboxes now renders in the HTML export.
- Improved API for Tables to access data via column names.
- Added a new rounding that is more true to Excels precision. You can switch between .Net and Excel precision with ParsingContext.
- Added IsEmpty() method on ExcelRange. Can test for value, comments, threaded comments and formulas.
- Override borders in Adjacent cells in BorderAround method.
License keys
EPPlus 8 introduces license keys for commercial licenses and a new interface for providing license information. See this page for Commercial Use and this page for Noncommercial/Personal Use
7.6.0
Major update to the calculation engine to support array formulas. See EPPlus7 features
Improved performance and better support for cross-worksheet references in conditional formatting.
Added target .NET 9.
Bug fixes.
Release is available on Nuget.org per 20250206 : https://www.nuget.org/packages/EPPlus/
7.5.3
Major update to the calculation engine to support array formulas. See EPPlus7 features
Improved performance and better support for cross-worksheet references in conditional formatting.
7.5
Added signature to EPPlus dll's and Nuget package.
7.1-7.4
Conditional formatting's in pivot tables.
Linked imaged files in Picture drawings.
New feature in EPPlus
Precision as Displayed in Formula Calculation.
Calculation of pivot table's
Html export now supports all conditional formatting's - Icon sets and Data bars
Added support for importing and exporting fixed width text files.
Copy of drawings.
Transpose functionality in Copy and Load/Save methods.
16 new functions.
Release is available on Nuget.org per 20250116 : https://www.nuget.org/packages/EPPlus/