Fixes

• When clearing a formula and then insert a row into the worksheet an exception was thrown.
• Having a pivot field with string grouping caused an Exception on loading a workbook.
• ExcelExternalWorkbook.UpdateCache() throw an NullReferenceException if a worksheet name did not exist.
• Applying a style for a worksheet that has a style set on the column level, did not retain the style for the last columns in some cases.
• Could not delete the last row (1048576) in a worksheet.
• Group drawings did not update children when rows were resized.

Fixes

• Fixed an issue with Roman function.
• Fixed a performance issue with calculated table columns.
• Having hyperlinks longer than 2079 characters resulted in a corrupt workbook. EPPlus will now crop hyperlinks over 2079 characters.
• Date functions Month, Day, Hour,Second and DateDiff used InvariantCulture instead of CurrentCulture.
• Checkboxes in the style dialog for named styles was not retained after a workbook was saved with EPPlus.
• Iterating over a range with multiple comma-separated ranges iterated the first range twice.
• Creating Array Formulas via the ExcelRange.CreateArrayFormula did not create the formula correctly.
• Custom row heights not copied correctly.

Features

• Added Target Framework Microsoft .NET 7.
• Added support for linking a cell to a chart title text.

Fixes

• EPPlus did not preserve "Host Extender Info" in the vba project.
• VBA signing failed on new workbooks.
• ExcelTable sorting corrupted relative formulas.
• Images in a group did not change position when row height changed.
• RichText.Color and ExcelColor.LookupColor did not return the correct color if the color was Auto or Theme and did not always adjust for Tint.

Features

• Added support for new types of VBA signing:
  • Agile VBA Signing.
  • V3 VBA Signing.
• Change hash algorithm on a VBA signature. This supports MD5, SHA1, SHA256, SHA384 and SHA512.
• Added ExcelRange.ToCollection method to export data from a spreadsheet into an IEnumerable<T> where T is a class.
• Added new methods to group, ungroup, collapse and expand rows and columns:
  • Group method.
  • Ungroup method.
  • CollapseChildren method.
  • ExpandChildren method.
  • SetVisibleOutlineLevel method.
• Added new overloads of Drawings.AddPicture which read the signature of the image from a stream to identify the type of image:
  • AddPicture(string, Stream).
  • AddPicture(string, Stream, Uri).
• These overloads have been deprecated:
  • AddPicture(string, Stream, ePictureType).
  • AddPicture(string, Stream, ePictureType, Uri).
• Added the ability to preserve 'Table' formula properties (Created via the What-If Analysis-Data Table).
• Other changes:
  • Target framework, Microsoft .NET 5.0 has been removed as it is out of support by Microsoft.

Fixes

• Invalid formatted hyperlinks were not loaded and saved correctly.
• Rows to repeat is not copied when adding a worksheet with another worksheet as template.
• Rows with the default height got an incorrect height when copied to a new worksheet if the Normal style had a font other than the default.
• The GenericImageHandler failed to load images in .NET in Unity as System.Drawing was not available.
• EpplusTableColumnAttribute NumberFormat is ignored when Header contains space.
• Workbooks with color styles not having any attributes, failed to load.