Released: Nov 15, 2024

v7.5.0 中的更新

特性

• Added signatures to the EPPlus.dll's and the EPPlus NuGet package.
• Added new RepeatItemLabels and InsertBlankRow properties to ExcelPivotTableField.
• Added AllowDuplicateColumnNames to ToDataTableOptions. This allows the exported range in the ToDataTable method to have duplicate column names.

修補程式

• A NullReferenceException was sometimes thrown when saving line charts with droplines.
• Fix for cells with null values and no style id getting incorrect styling.
• Fixed an issue where two VLOOKUPs on...

Released: Oct 28, 2024

v7.4.2 中的更新

特性

• Added support for the array attribute on table column formulas:
  • Added new property 'ExcelTableColumn.IsCalculatedFormulaArray'.
  • EPPlus automatically updates the IsCalculatedFormulaArray if a table formula is identified as an array formula in the calculation.
• You can now add mappings for error values as a string in the ToDataTableOptions.

修補程式

• Rich text strings in the shared strings XML did not support both text and RichText elements in the same item.
• The dynamic array formula flag was not set...

Released: Oct 11, 2024

v7.4.1 中的更新

修補程式

• Updated for vulnerability in System.Text.Json 8.0.4 - Microsoft.Extensions.Configuration.Json 8.0.0 -> 8.0.1.
• Having more than three minus symbols before an error value adds an extra minus to a formula when inserting rows or columns.

Released: Oct 2, 2024

v7.4.0 中的更新

特性

• Added support for Conditional Formatting in Pivot tables via Pivot Areas.
• Added support for multiple addresses in function arguments, i.e Sum((A1:A2,A4:A5)) should be handled as a single argument.
• Added support for linked pictures in the ExcelDrawings.AddPicture method using the 'PictureLocation' argument.
• Added new functions:
  • AREAS.
  • TDIST.

修補程式

• Loading a VML drawing without the Anchor element caused EPPlus to throw an Exception.
• Removed unused classes ParsingScope and ParsingScopes and the...

Released: Sep 17, 2024

v7.3.2 中的更新

特性

• Upgraded Microsoft.IO.RecyclableMemoryStream from version 3.0.0 to 3.0.1.

修補程式

• Upgraded System.Text.Json to version 8.0.4 and System.Formats.Asn1 to version 8.0.1 to address vulnerabilities in previous versions of these libraries.
• Fixed an issue with the MATCH function when a range was sorted in descending order.
• When inserting columns, shifting right into a range, an Exception was thrown in rare cases.

Released: Sep 5, 2024

v7.3.1 中的更新

修補程式

• Fixed duplication of conditional formatting which could occur on repeated saves in some cases.
• Fixed issues with Boolean values in functions COUNTIFS, SUMIFS and AVERAGEIFS.
• ExcelWorksheet.DimensionByValue sometimes gave an incorrect address.
• EPPlus crashed on loading a workbook, if style Fills contained less than 2 items.
• ExcelRange.Insert did not shift formula address on other worksheets.
• The formula tokenizer failed when having a minus before an Error value (i.e. #REF) in some cases...

Released: Aug 20, 2024

v7.3.0 中的更新

特性

• Added support for 'Precision As Displayed' when calculating formulas, via the 'ExcelWorkbook.FullPrecision' property.
• Added new functions:
  • GROWTH.
  • DPRODUCT.
  • DSTDEV.
  • DSTDEVP.
• EPPlus now supports reading workbooks encoded with other encodings than UTF8.
• Added new parameter to ExcelRangeBase.CreateArrayFormula for dynamic array formulas, to set meta data for the cell.

修補程式

• Deleting all pivot tables in a workbook caused the workbook to become corrupt as the pivotCache element was not deleted...

Released: Jul 24, 2024

v7.2.2 中的更新

特性

• Added new functions to calculate multiple pivot tables. Using these methods will make sure any shared pivot cache is only refreshed once.
  • ExcelWorkbook.CalculateAllPivotTables(refresh).
  • ExcelPivotTableCollection.Calculate(refresh).
• Added new functions which are now supported in formula calculations.
  • LINEST.
  • LOGEST.
  • TREND.

修補程式

• Worksheet references in formulas proceeded by '-' now work as expected.
• Theme templates now appropriately apply theme colors to charts.
• LoadFromCollections with...

Released: Jul 2, 2024

v7.2.1 中的更新

特性

• Added new static property 'ExcelPackageSettings.CultureSpecificBuildInNumberFormats' to specify culture specific number formats for individual cultures.
• Added new call-back function 'ExcelWorkbook.NumberFormatToTextHandler' to override the default Text value.
• Added support for DateOnly and TimeOnly (supported from Microsoft .NET 6 and later).
• Changed thread locking object in the cell store.
• Added support for new functions in formula calculations:
  • YIELDDISC.
  • LOGINV.
  • CHITEST.
  • TDIST.
  • GAMMAINV...

Released: Jun 18, 2024

v7.2.0 中的更新

特性

• Added support for calculating pivot tables:
  • Supports calculation of data fields on column and row fields.
    • Page field filtering.
    • Filters.
    • Slicers.
    • Show data as on data fields.
    • Calculated fields.
  • Access calculated pivot table data via the ExcelPivotTable.CalculatedData property of the ExcelPivotTable.GetPivotData function.
• Added support for copying drawings.
  • The types of drawings include:
    • Shapes.
    • Charts.
    • Pictures.
    • Controls.
    • Slicers.
    • Group Shapes.
  • You can copy individual drawings.
  • Copying a...