Release 8.0.1 · EPPlusSoftware/EPPlus (original) (raw)

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