Released: Mar 28, 2025

Aggiornamenti in v8.0.1

Funzionalità

• EPPlus version 8 and later commercial licenses now require a license key to be specified before using EPPlus. This must be set both in the development and in the runtime environments.
• 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).
• Autofit columns optimization.
• The Range Copy method now supports fills and the option to copy visible cells only.
• 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.
• Added new properties ProgId, ExternalLink and Image to the ExcelOleObject.
• Added DeleteAll method with predicate to ExcelWorkbook, ExcelRange, ExcelRangeRow and ExcelRangeColumn.

Correzioni

• 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:
  • Removed ExcelOleObjectParameters.Extension and use extension from the file name.
  • Fixed issue with duplicate images.
• 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.
• 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.