Released: Sep 24, 2025

v8.2.0 버젼 업데이트

기능

• Added new properties: TabRatio, Visibility, and FirstSheet to the ExcelWorkbookView class.
• Added support for 8 new LAMBDA-based functions in workbook calculations. See Using LAMBDA functions for details:
  • LAMBDA
  • MAKEARRAY
  • SCAN
  • MAP
  • REDUCE
  • BYROW
  • BYCOL
  • ISOMITTED
  • Support for defining LAMBDA functions via defined names.

수정사항

• The GETPIVOTDATA function sometimes returned an incorrect #REF error.
• The Underline property of the ExcelComment.Font object incorrectly returned false when it should have...

Released: Sep 9, 2025

v8.1.1 버젼 업데이트

기능

• Performance for getting and setting the value of cells that had no styling or value was drastically improved via caching.
• An array of values can no longer be set to a single cell. Instead, the first value in the array is assumed to be the intended value.

수정사항

• Fixed issue where the 'SUMIF', 'SUMIFS', and 'AVERAGEIF' functions could return invalid addresses in the dependency chain, causing some dependent cells not to recalculate correctly.
• Fixed issue where 'RichText.HtmlText' returned...

Released: Aug 15, 2025

v8.1.0 버젼 업데이트

기능

• Added support for adding Shapes and Pictures to charts using the ExcelChartStandard.Drawings collection.
• Added a new interface for styling headers and footers more easily.
• Added the ability to change chart axis type on standard charts using the ChangeAxisType(eAxisType). Mainly intended to change between value- and date- axis, used to change the axis appearance.
• Added several new methods to the ExcelNamedRange class to change its value between a range, formula or a fixed value.
• Added...

Released: Jul 22, 2025

v8.0.8 버젼 업데이트

기능

• Removed usage of reflection in VBA modules to improve AOT support.

수정사항

• Fixed issue regarding FileLoadException due to System.Memory referenced by RecyclableMemoryStream.
• Fixed issue where conditional formatting could cause invalid XML due to not using InvarianCulture when setting the numeric values.
• Fixed issue where ExcelRangeBase - LoadFromCollection/LoadFromDataTable sometimes cleared formulas outside the range.
• Fixed issue where the OFFSET function did not set height or width from...

Released: Jul 2, 2025

v8.0.7 버젼 업데이트

기능

• Added validation for number formats (brackets) during formula calculation. Also affects the Range.Text property.
• The ROUND function now rounds to a better precision.

수정사항

• Fixed REF errors in the OFFSET function.
• Fixed issue where the wrong data type is returned from Bin2Hex function (Decimal->String).
• Fixed issue where custom icon sets with 4 or more icons sometimes becoming a 3 icon set.
• Fixed issues in SORT, SUMIFS and LEFT with dynamic arrays.
• Fixed issue where the ANCHORARRAY function...

Released: Jun 18, 2025

v8.0.6 버젼 업데이트

기능

• Added support for including new items in manual filter for pivot table when refreshing a cache.
• Changed to use "PackageLicenseExpression" in the NuGet package.
• The SORT function now works more like Excel. The function now orders the results with matching values after their original sorting.

수정사항

• Fixed issue where ExcelRangeBase.LoadFromDataTable sometimes cleared data outside the loaded range.
• Fixed issue where IFERROR did not handle arrays in the second argument correctly.
• Fixed issue where...

Released: May 15, 2025

v8.0.5 버젼 업데이트

수정사항

• Fixed an issue with external links not getting saved in EPPlus 8.0.4.

Released: May 14, 2025

v8.0.4 버젼 업데이트

수정사항

• SUMIFS, AVERAGEIFS and COUNTIFS sometimes miscalculate due to returning the incorrect addresses to the dependency chain.
• Range.Sort did not sort update formula addresses in some cases.
• Fixed array support for the SUBSTITUTE, SUMIFS, AVERAGEIFS and COUNTIFS functions.
• Incorrect handing of meta data strings caused a corrupt workbook in some situations.
• License key validation did not work in Blazor WASM.
• The ExcelPicture.Image.Bounds was not set when loading drawings.
• Pivot cache fields...

Released: Apr 30, 2025

v8.0.3 버젼 업데이트

기능

• Added custom number formats where the formatId is not a built-in format.

수정사항

• Fixed issue where SUMIFS and AVERAGEIFS sometimes miscalculated with multiple arguments.
• Fixed issue when sorting a range with threaded comments, removing and adding a threaded comment sometimes throws an exception.
• Fixed issue where cell meta data loaded from a workbook was cleared on formula calculation, causing some dynamic array formulas to become legacy array formulas.

Released: Apr 16, 2025

v8.0.2 버젼 업데이트

수정사항

• The CHOOSECOLS and CHOOSEROWS functions did not support ranges as a row/col selection argument.
• When reading a string with '_xb36' from a cell, a string error was returned.
• Pivot selection in the worksheet view was not removed when a pivot table was refreshed, causing the pivot table to become corrupt.
• The SUMIFS and COUNTIFS functions did not consider the criteria range when checking for circular references.
• Copying a cell after deleting and adding a comment sometimes caused an exception...