Released: Jan 16, 2025

Aggiornamenti in v7.5.3

Funzionalità

• Improved COUNTIF performance, if full column addresses was used.
• Added null as valid GetByValue for pivot table field items.
• Added support for [h]:mm number format.
• Improved sorting for pivot table slicer cache.
• Added Drawings.AddTextBox for easier creation of textboxes.

Correzioni

• If having a workbook with no reference to a font in the styles.xml, caused an corrupt workbook.
• ZipEntry's containing the zip data descriptor header could result in a BadReadException.
• Fixed comment indices when sorting cells after deleting a row.
• Fixed bug where adding a comment via ExcelWorksheet.Cells.AddComment and then adding a comment to the same cell via ExcelWorksheet.Comments.Add would generate corrupt workbook.
• Sheet protection style properties was not set correctly in some cases.
• Renaming a worksheet could causes formulas to become corrupt, if the name contained spaces or other reserved characters.
• Inserting into a cell range, shifting right, could cause conditional formatting to move incorrectly.
• The LoadFromCollection method did not load ExcelHyperLink types as hyperlinks, if the 'members' argument was used.
• Formula did not calculate when using named ranges to access a spreadsheet.
• Fixed incorrect handling of multi-char delimiters and escape characters in TEXTBEFORE and TEXTAFTER.
• The VLOOKUP and HLOOKUP function did not return #REF if the lookup address was out of bounds.
• Inserting a row in a shared formula sometimes updated the addresses incorrectly.
• Fixed an issue with the Save dialog in Excel showing when closing an unchanged workbook.
• When inserting rows/columns, EPPlus incorrectly set a #REF value if a function was used with a colon to create an address.