NPOI 2.8.1 Release Notes

[tonyqus]

CI/CD

• SkiaSharp reference update #1856
• Microsoft.Build.Tasks.Git is listed as Vulnerable #1870

Enhancements/Performance

• Implemented multi-range cells in NCellRange #1838
• Add ForceFormulaRecalculation method for IWorkbook #1817
• Optimize PngUtils.MatchesPngHeader() #1815
• Optimize Number.BitCount() on newer runtimes #1814
• Bump System.Security.Cryptography.Xml and System.Formats.Asn1 to 10.0.10 (fixes CI) #1826
• Whole-column lookup references (A:A) cause O(sheet size) scans instead of O(used range) #1845
• Add AreaReference support for structured table references #1750

Bugs

• XSSFWorkbook XSSFSheet.AutoSizeRow is not working correctly. #1748
• Formula evaluation fails (ErrorCode 15) when using TEXT() function with date #1787
• LazyStyles_UntouchedStylesPreservedOnSave() always fail in windows-latest Action #1788
• Fix System.Security.Cryptography.Xml vulnerability (CVE-2026-26171, CVE-2026-33116) #1802
• Package 'System.Security.Cryptography.Xml' 10.0.5 has a known low severity vulnerability, #1800
• Excel file generated using template reports error #1824
• Avoid empty custDash node in theme.xml #1831
• Wrong namespace for txBody node in drawing.xml #1839
• Whole-column lookup references (A:A) cause O(sheet size) scans instead of O(used range) #1845
• XSSF: SST streaming parser drops self-closing <si/> entries, shifting all subsequent shared string indices (2.8.0 regression) #1860
• NPOI setting a new workbook ThemesTable copied from another workbook ThemesTable does nothing #1380
• XDDFValueAxis Minimum = 0 is serialized as <c:min/> instead of <c:min val="0"/> #1842
• Side effect in RGBWithTint #1816
• Fix culture-sensitive numeric conversion in XDDF Chart data #1812
• Use RandomNumberGenerator for encryptor ConfirmPassword(string) material generation #1872
• ExcelStyleDateFormatter incorrect Format result #863

POI Bugs

• POI Bug Github-1172: Add XWPFRun.IsRtl property #1851
• POI Bug 68183: SXSSFWorkbook: dispose temp files automatically on Close() #1852
• POI Bug Github-733: MIRR - align rate argument order with Excel and correct PV/FV discounting math #1853
• Implement POI Bug Github-803 - Sheet function #1828
  POI Bug 59623 code inspired from Axel Richter on StackOverflow
  POI Bug Github-144 Added more chart supports.