NPOI 2.7.2 Releases Notes

[tonyqus]

Release Date: Nov 9, 2024

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

Package Update

• Upgrade SixLabors.ImageSharp to version 2.1.9 #1402
• Security vulnerabilities in SixLabors.ImageSharp  #1394
• Update version of System.Security.Cryptography #1430

CICD Update

• Upgrade to NUKE 8.1 #1414
• Convert to use Central Package Management #1390
• Remove System.Configuration.ConfigurationManager as NuGet dependency #1400

Enhancements

• XSSFColumn class implementation #1329
• Support adding line endings when a string containing \n is added to the document #1260
• FindAndReplaceText will now also work for tables within a documents h… #1391

Bug Fixes

• bugfix: ExcelToHtmlConverter throw exception when cell has background… #805
• fixing a type error #1376
• Inconsistent new lines in worksheets #1401
• CalculateRate(double,double,double,double,double,double)@Rate can calculate a wrong rate. #1226
• Backport commits that fix rate function giving incorrect results #1286
• Reading Docs With DesignType，throw POIXMLException Error  #1392
• The numFmt tag in the workbook file is missing the formatCode attribute value #1412
• maxRows is usefull for AutoSizeColumn and GetColumnWidth #1403
• fix: Inconsistent new lines in worksheets #1408
• fix: AddStyleClass no update newClassValue #1407
• The backport of POI Bug 60370 introduces a bug with PromptBox and ErrorBox text encoding #1386
• Fix EncodeUtf method #1387
• Fixing wrong logging message #1375
• ByteArrayOutputStream is not disposed in IOUtils.ToByteArray method #1389
• fixed SXSSFWorkbook can not clear temp files when it called Dispose() on the IWorkbook interface. #1385
• Patches from poi #1433
• More patches ported from poi v3.16 #1371
• Reduce array allocations by usage MemoryStream.GetBuffer() instead of ToArray() #1435

POI Bug Fixes

• POI Bug 60452 - WorkdayCalculator calculateWorkdays does return wrong value for same day input
• POI Bug 60512 - Add missing XSSFRelation.CUSTOM_PROPERTY
• POI Bug 60369 - Adjust pattern to better handle non-ASCII characters in Month-names which can appear since Java 8
• POI Bug 60219 - FormulaParser can't parse external references when sheet name is quoted
• POI Bug 60520 - Provide *SSF functionality via Common SS