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 MeasureWrappedTextCells to ExcelTextSettings (package.Settings.TextSettings).
• Added methods CopyValues and CopyFormulas to ExcelRangeBase, to more easily copy values and formulas only.
• Added validation to restrict adding multi-cell array formulas to tables.
• ExcelRangeBase.Copy has a new overload for copying specific objects using the ExcelRangeCopyOnly enum.
• ExcelWorksheet.View.FreezePanes now takes hidden cells and columns into account when freezing panes.
• Lookup functions such as Vlookup and Hlookup can now consistently handle searching through null-values in cells above and below the target value cell.
• Improved performance for column lookups and conditional formatting.

수정사항

• Fixed issue where copying a worksheet or a range to a new workbook, the relevant defined names are also copied.
• Fixed issue where certain advanced conditional formatting (Databar, ColorScale, Iconsets) did not update addresses in their formulas appropriately when columns were deleted.
• Fixed the referencing of table columns and rows using the structured reference so it now works outside the table range.
• Fixed issue where the GETPIVOTDATA function did not identify the pivot table if the pivot address was set on the page filter rows, as Excel does.