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...

Released: May 28, 2024

v7.1.3 中的更新

修補程式

• DXF styles on tables got corrupt if a style contained an alignment and border element.
• When calculating formulas, you could get a CircularReferenceException, if a formula referenced a non-existing worksheet.
• Conditional formatting's with the pivot flag set was incorrectly handled if they had no worksheet address set.
• Clearing data validations on cells, could cause an exception when trying to add new data validations to these cells.
• Conditional formatting icon sets now handles all operators...

Released: Apr 23, 2024

v7.1.2 中的更新

修補程式

• Defined Names with ' " ' symbols no longer get extraneous ' " ' added when saving in EPPlus.
• Reading RichText data on in-line strings now works as expected.
• Negations of Defined Names and Ranges in shared formulas sometimes received the wrong sign in the calculation as the negation flag was not cleared.
• 'ExcelRangeBase.ToCollection()' auto-mapping sometimes threw an exception as the wrong property type was used.
• Using 'ExcelRangeBse.LoadFromCollection()' with Nullable property members in a...

Released: Apr 8, 2024

v7.1.1 中的更新

特性

• Added new Rotation, HorizontalFilp and VerticalFlip properties to ExcelShapeBase and ExcelPicture.
• Added new SetColor() method to ExcelDxfColor.

修補程式

• Fixed an issue where RichText wasn't set properly on a multicell range.
• Escape character before an apostrophe in date formats are no longer removed by EPPlus.
• The GenericImageReader failed to read some jpeg/exif images.
• Setting the TextBody.Rotation on Chart DataLabel's caused the workbook to become corrupt in some cases.
• Fixed issue applying...