EPPlus Lançamentos

EPPlus SoftwareControles de Planilha.NET
Versão v8.6.3 (24 de jul. de 2026)

Veja o que há de novo em cada versão, com detalhes sobre recursos, melhorias e problemas solucionados.

jan.
fev.
mar.
abr.
mai.
jun.
jul.
ago.
set.
out.
nov.
dez.
EPPlus v8.6.324 de jul. de 2026
Recursos
  • Security:
    • Updated System.Security.Cryptography.Xml to address five security vulnerabilities in the .NET XML signing dependency: four denial of service vulnerabilities (CVE-2026-47302, CVE-2026-50525, CVE-2026-50527, CVE-2026-50648) and one security feature bypass (CVE-2026-47304). The package is updated to 8.0.4 (.NET Framework, .NET 8 and .NET Standard), 9.0.18 (.NET 9) and 10.0.10 (.NET 10).
EPPlus v8.6.221 de jul. de 2026
Recursos
  • Added property AlwaysRefreshImageFunction to ParsingConfiguration, to disable download of external content in the calculation of the IMAGE function.
  • AppVersion in OfficeProperties can now be set to null, to remove the value.
  • Added a WrappedTextAutofitMode property to ExcelTextSettings, backed by a new eWrappedTextAutofitMode enum, giving control over how cells with WrapText enabled contribute to column width in AutoFitColumns().
Correções
  • Fixed unhandled InvalidOperationException when loading an icon set conditional formatting with formula cfvo from extLst.
  • Fixed an issue where the SEARCH function did not handle arrays in the third argument.
  • Fixed NullReferenceException in GetStyleId after multiple InsertColumn calls.
  • Fixed drawing hyperlink reassignment crash and tooltip setting.
  • Fixed KeyNotFoundException / ArgumentException on drawing rename and removal.
  • Fixed unhandled IndexOutOfRangeException when importing text using the ExcelRangeBase.LoadFromText method, when text file has more columns than specified DataTypes argument.
  • Fixed an issue when positioning shapes in charts.
EPPlus v8.6.116 de jun. de 2026
Recursos
  • Added 3 new functions:
    • REGEXEXTRACT
    • REGEXREPLACE
    • REGEXTEST
Correções
  • Fixed mismatch in conditional formatting when loading a workbook.
  • Fixed several issues in the HTML export.
  • Text rotated vertically in cells now adjusts column widths more appropriately.
  • Borders sometimes disappeared when having rotate the text.
  • Fixed bug where the positions/visuals of images would sometimes not appear.
  • Pattern fills with empty colors did not pick the correct theme color.
  • Merged cells did not render border correctly on the right and bottom edges.
  • Workbooks with group shapes in charts sometimes failed to load.
  • Images in charts sometimes got stretched.
  • ExcelRangeBase.ClearDataValidation threw an InvalidOperationException if when there were no data validations.
  • Fixed case-sensitivity parsing on ExcelChartAxisStandard enums, MajorTickMark and MinorTickMark (Fix by Lieven De Foor).
  • ExcelWorksheets.Delete threw NotSupportedException on chart worksheets. (Fix by Lieven De Foor).
  • Using full row/column addresses in formulas referencing external workbooks caused bad performance.
  • The VLOOKUP and HLOOKUP function sometimes returned the wrong value on unsorted data.
EPPlus v8.6.029 de mai. de 2026
Recursos
  • Added 9 new functions:
    • GROUPBY
    • PIVOTBY
    • TRIMRANGE
    • WRAPROWS
    • WRAPCOLS
    • USDOLLAR
    • CODE
    • ENCODEURL
    • ISFORMULA
  • Added support for the trim reference operators.
  • Ranges can now convert their values to rich text via ConvertToRichText() e.g. ws.Cells["A1"].ConvertToRichText().
  • Calculation of dynamic array formulas now support dirty cell recalculation inside other dirty cell calculations.
Correções
  • Fixed a cache issue with the IF function when recalculation dynamic array formulas with dirty cells.
  • ExcelPackage.LoadAsync failed with an unhandled exception, if a package had a package part larger than 2GB.
  • Fixed copy of absolute positioned drawings and group shapes.
  • Fixed a performance issue related to copying using full row/column addresses.
  • Fixed stale values when using newer worksheet functions (e.g. ARRAYTOTEXT) by adding required features to the workbook XML.
  • CompareOptions.Culture in RangeSortOptions was not honored when sorting ranges (thanks to lievendf).
  • Copied "Text length data validations" no longer becomes "Int data validations" in the output workbook.
  • Several issues related to Rich Text in ranges. Accessing the ExcelRangeBase.RichText property no longer casts the cell value to string.
EPPlus v8.5.430 de abr. de 2026
Recursos
  • Added IncludeInHtmlOnly option to the ePictureInclude enum. This allows the HTML Exporter to include pictures directly in the HTML output rather than in the CSS.
  • Upgraded several referenced packages.
Correções
  • When recalculating spilling dynamic array formulas EPPlus did not always follow new dependent addresses.
  • The SUMIFS/COUNTIFS/AVERAGEIFS functions now evaluate date string literal criteria correctly.
  • Workbooks containing extended charts or unsupported drawing types (like diagrams), included in group shapes, failed to load.
EPPlus v8.5.216 de abr. de 2026
Recursos
  • Updated System.Security.Cryptography.Xml for .NET 9 and 10 to address a security vulnerability (CVE-2026-26171 and CVE-2026-33116).
Correções
  • ExcelRange.LoadFromCollection: DisplayAttribute.Name was used directly instead of DisplayAttribute.GetName(), causing resource keys to appear as column headers instead of localized values when ResourceType was set.
  • ExcelRange.LoadFromCollection: EpplusTableColumnAttribute.Order was ignored when DisplayAttribute was also present.
  • Fixed various issues with the LAMBDA function and variable expressions.
  • Fixed an issue with the VSTACK and HSTACK functions when the argument is a single-cell range.
  • The IFS function did not handle arrays in the condition arguments.
  • The SORTBY function now preserves the original order of rows/columns when the sort key is not unique.
  • EPPlus will now throw a NotSupportedException if opening workbooks saved in the Strict OpenXML format.
EPPlus v8.5.316 de abr. de 2026
Correções
  • Fixed issue where updated .NET 8 references incorrectly update to 9.x to 8.x in EPPlus 8.5.2.
EPPlus v8.5.130 de mar. de 2026
Correções
  • Negation of numeric string values now returns the negated number instead of a #VALUE! error in the formula calculation.
  • 'ExcelPackage.Configure' now sets 'IConfiguration' for license info.
  • The WEEKDAY function now handles optional return-types 12-17 correctly.
  • Inserting rows or columns when a named range is on the maximum row is now handled correctly. Absolute referenced defined names become #REF! when pushed outside the maximum.
  • NUMBERVALUE function now parses decimal and group separators for numbers correctly.
  • Conditional formatting priority now remains correct after loading workbook with conditional formatting rules and add new.
EPPlus v8.5.06 de mar. de 2026
Recursos
  • Added 'CancellationToken' to Calculate.
  • Added property 'ValueFromCellsRange' and the 'SetValueFromCellsRange' method to data labels on chart series.
  • Improved performance for SUMIFS, AVERAGEIFS, COUNTIFS.
  • Improved performance for formula calculation with full column references (e.g. A:A, $B:$B).
  • Breaking Changes:
    • Setting dataLabelPosition.Top on BarCharts corrupted the Excel file when saved. Trying to set this now throws an error instead.
    • NumberFormatToTextArgs.NumberFormat now returns the interface IExcelNumberFormat rather than the ExcelNumberFormatXml class. All public variables remain the same and it can be safely cast to 'ExcelNumberFormatXml' as long as 'Package.Workbook.NumberFormatToTextHandler' is null.
Correções
  • Fixed issue where deleting pictures in cells, caused a corrupt workbook in rare cases.
  • Fixed several formatting issues when reading and writing tables with checkboxes in them.
  • Fixed several issues when using a custom ExcelPackage.Workbook.NumberFormatToTextHandler.
  • Fixed unary minus coercion on dynamic array results.
  • Fixed off-by-one in 'InsertAndShift' resize condition. This caused an 'ArgumentException' when calling 'InsertColumn' on xlsx files where the number of defined columns was at the array boundary.
  • Fixed culture-specific DateTime in PowerQuery metadata.
  • Calculated field computation in pivot tables did not work correctly in some cases.
  • Copying a Connection shape from one workbook to another caused an unhandled exception.
  • Having the wrong content type/extension on an image in the workbook package, caused an unhandled exception on load.
EPPlus v8.4.24 de fev. de 2026
Correções
  • Fixed an issue where the ExcelRange.Text property could format negative values with double minus signs in rare cases.
  • Fixed a performance issue when using FollowDependencyChain set to false in the Calculate method. With this option, EPPlus no longer calculates dependent cells or dynamic array formula spills.
  • Fixed an issue where the ExcelPowerQueryMetadataItem class parsed dates using the supplied culture instead of the invariant culture, which could cause an unhandled exception.
  • Fixed an issue where a workbook could become corrupt when EPPlus adjusted the XML ignorable namespace list.
  • Fixed an unhandled exception that occurred when saving a workbook containing a customXml property file without a schemaRefs file.
EPPlus v8.4.112 de jan. de 2026
Correções
  • Fixed several issues related to expanding (spilling) and contracting dynamic array formulas.
    • Changing cell dependencies were not taken into account when recalculating dirty cells from dynamic array formulas.
    • Clearing dynamic array formulas that reduced in size did not work correctly.
    • Cells containing formulas with the INDIRECT function are now always treated as dynamic.
  • Invalid UTF-16 surrogate sequences in comment text are now sanitized before XML generation to prevent 'XmlException'.
  • Using the [@page] attribute in headers or footers did not return the next character in some cases.
  • The FILTER function always returned the third parameter if it contained an error value (for example, #VALUE).
  • The FACT function returned (n-1) instead of n.
  • Formula inline arrays did not correctly convert scientific notation (for example, 1.0E-305) to numbers.
  • Defined names could use the wrong scope when a name existed in both worksheet and workbook scope and a formula was calculated using the 'Calculate(formula)' method.
  • Using the ^ operator on non-numeric values returned 0 instead of #VALUE.
  • Inserting columns into an empty worksheet throw an 'ArgumentException' when inserting more than 8 columns.
  • GROWTH and TREND did not handle a single-value newX parameter correctly.