Released: Nov 20, 2025

Aggiornamenti in v8.3.0

Funzionalità

External Connections and Query Tables

• Added support for adding external connections and query tables.
• Supports adding, updating and removing connections:
  • Power query connections.
  • Database connections.
  • OLAP connections.
  • Web connections.
  • Text connections.
• Supports adding, updating and removing range and table query tables.
• Supports adding pivot tables with external connections as source.
• Added 3 new functions: 'PERCENTOF', 'VALUETOTEXT' and 'BASE'.

Correzioni

• Fixed issue where 'RichText.Clear' caused any previous reference to the RichText object not to work.
• EPPlus will now throw a 'ObjectDisposedException' when a rich text object has been disposed.
• Implemented the shifting of multi-addresses in defined names on insert/delete (i.e. a1:a3,c1:c3).
• Fixed issue regarding new constructor for 'ExcelAddressBase' taking a list of addresses.
• Fixed several formatting issues in the 'ARRAYTOTEXT' function.
• Fixed an issue with the incorrect mapping of formula columns in the 'ExcelRangeBase.LoadFromCollection' method.
• Fixed issue where 'ExcelRangeBase.InsertColumn' could throw an unhandled exception in rare cases, when a formula contains references to external workbooks.
• Fixed issue where 'ExcelRange.DeleteRow' could throw an unhandled exception when having conditional formatting color scale rules with an empty formula.
• Fixed issue where a calculated column formula of a table could not be set after it had been cleared.
• Fixed issue where 'ExcelWorksheet.DimensionByValue' sometimes returned an incorrect range.
• Fixed issue where COUNTIF did not compare numeric strings as numeric.
• Fixed issue where SUMIF and AVERAGEIF did not take empty cells into account in the criteria.
• Fixed issue where deleting a data validation and then add a new one to the same range sometimes failed.