Released: May 29, 2026

v8.6.0 버젼 업데이트

기능

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

수정사항

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