NPOI 2.7.3 Release Notes

[tonyqus]

Release Date: Mar 23, 2025

Before this release, there was a community accident.

• I'm bullied by a Microsoft MVP in Mar, 2025 #1514

Package Update

• Update SixLabors.ImageSharp package to 2.1.10  #1505

CI/CD Update

• Update Unit tests from .NET 6 to .NET 8 #1476
• Upgrade to NUKE 9 and replace obsolete NET 6 targets with NET 8 #1482
• Add test case for issue #1057 #1488
• Reduce warning output during build and treat new warnings as errors #1513

Enhancement

• [FluentAPI] Return ICell type for SetXXX methods of ICell interface #1450
• [POI 66093 & POI 62373] Support FREQUENCY function and subfunctions to SUBTOTAL function #1492
• Implement GetCells interface for ISheet #1460
• POI 66090 add support for D* functions #1504
• Poi bug 60605: convert Workbook.SHEET_STATE_* to SheetVisibility enum #1446
• Excel Function Implementation II #1023

Performance Enhancement

• Use TryGetValue instead of ContainsKey and indexing #1500
• Add readonly modifier for suitable fields #1501
• Use Array.Empty<T> instead of allocating an empty array #1502
• Replace casts with pattern variable #1509
• Seal private and internal types #1508

Bug Fixes

• Fix Clone sheet when the sheet contains hyperlinks #1441
• Inconsistent formatting when reading multiple XLS files concurrently (#1469) #1470
• fix: avoid corrupting docx file with comments #1486
• Fix int overflowing in ExcelGeneralNumberFormat #1497
• Fix ShiftMergedRegions #1462

POI Bug Fixes

• POI Bug #56822 fix COUNTIFS() #1461
• POI Bug 59893 & 60742 #1463
• Poi bug 51519 and 45353 #1464
• bug 59227: parse dates formatted in Japanese or Chinese.  #1456
• poi: #60626 - ArrayIndexOutOfBoundsException in EvilUnclosedBRFixingInputStream #1451
• Port POI patches #1434
• Patches from poi 3.16 #1477
• poi bug 60031: DataFormatter parses months incorrectly when put at the end of date segment.  #1447
• POI 66090 add support for D* functions #1504
• Poi bug 60605: convert Workbook.SHEET_STATE_* to SheetVisibility enum #1446
• [POI 66093 & POI 62373] Support FREQUENCY function and subfunctions to SUBTOTAL function #1492