NPOI 2.7.1 Release Notes

[tonyqus]

To learn how NPOI succeeds, you can read this post

Release Date: July 3, 2024

Package Update

• Update SixLabors.ImageSharp to 2.1.8. CVE-2024-32036 #1317
• Update SharpZipLib to v1.4.2 #1313
• Upgrade BouncyCastle.Cryptography to version 2.3.1 #1348
• Update ExtendedNumerics.BigDecimal package #1350

CICD Update

• Upgrade benchmark and test NuGet references #1349
• Fix RepositoryUrl in Directory.Build.props #1378

Formula Bug Fixes/Ehancement

• Custom created class as NPOI doesn't implement CELL. #817
• Implement Cell function #1335
• Fix ROUNDDOWN function #1310
• CT_CellFormula.Write: fix writing the si attribute #1291
• TRANSPOSE function with non numeric values not working #1177
• Implement Concat Function #1341
• Implement T.INV Function #1345
• Implement forecast function #1324

Bug Fixes

• [github-164] Fix Bug in XSSFTable.setCellReferences when table is single cell. #1283
• Overwrite existing Excel results in problem with content #1311
• docVars not correctly parsed #1199
• Fix reading document variables #1307
• Add RemoveDataValidation method #1262
• Do not include xfId in CellStyleXfs XML #1325
• fix : Make Free Form coordinates closer to the original #1269
• Several possible NPE #1229
• Add more image wrapping support #973
• Why is the VBAMacroExtractor and VBAMacroReader classes not available? #321
• XSSF AddPicture Slow #1299
• NullReferenceException when importing data into an Excel spreadsheet containing a table and XML Map. #1070
• Fix TempFile usage while temp dir was deleted in same process #1132
• The xlsx file cannot be saved again after inserting a new picture #1252
• Opening existing workbook with pictures, adding new ones and saving it should not throw an exception #1284
• TypeLoadException: “NPOI.XSSF.UserModel.XSSFSheet.RemoveDataValidation” hasn't been implemented in “NPOI.OOXML, Version=2.7.0.0," #1321
• XLS - Fix adding cell comment #1303
• Formula openxml gets corrupted after opened and saved by NPOI 2.7.0 #1315
• Fix reading document variables #1307
• Error 0x800A03EC when opening with Excel.Application after saving with NPOI #1308
• Avoid NullReference exception when saving workbook with XML Map #1314
• Word Formatting changes after saving with NPOI #1276
• Two identical results for FillPattern  #1188
• Fix NPE issue in PackageRelationshipCollection #1330
• Fix fontsize of the Math formula in XWPF #1364

POI Bug Fixes

• POI Bug 68237 [Bug 68237] CustomHeight attribute of row for SXSSFWorkbook is wrong  #1282
• POI Bug 60253 - XSSFValidationConstraint.prettyPrint() changed from 3.14 to 3.15
• POI Bug 56781 - XSSFName.validateName(String) Only Checks for the First Character's Validity and Presence of Spaces
• POI Bug 60246 - XSSFName.validateName() does not allow DOT as name
• POI Bug 60255 - createDrawingPatriarch does not take next correct next drawing index number
• POI Bug 59830 - "Skipped only -1 while trying to skip 67116544 bytes. This should never happen." IOException in VBAMacroReader
• POI Bug 59858 - NullPointerException thrown by VBAMacroReader
• POI Bug 60273 - UnsupportedCharsetException in VBAMacroReader
• POI Bug 60158 - AIOOBE in VBAMacroReader
• POI Bug 53028 - [Patch] Broken auto fit row height in the cells with word wrap
• POI Bug 59958 - [PATCH] Add cells on the fly to the evaluation sheet cache on cache miss
• POI Bug 60187 - RegionUtil should use new enum style classes
• POI Bug 59687 - XSSFSheet.RemoveRow doesn't handle row gaps properly when removing row comments (typo)
• POI Bug 55075 - [PATCH] SXSSF: Pictures skewed on rows which have non-default height
• POI Bug 51233 - Image is incorrectly resized if custom row height is set
• POI Bug 59026 - NullPointerException when try to Exports XLSX data using Custom XML Mapping
• POI Bug 60289 - UTF decoding in XSSFRichTextString does not work when the code is lowercase
• POI Bug 60315 - Allow date of format yyyy-MM-dd
• POI Bug 53611 - Incorret dimension set in created workbook sheet xml file
• POI Bug 60331 - Remove deprecated classes (POI 3.16)
• POI Bug 60370 - XSSFDataValidation, promptBox, \n ignored (no multiline)
• POI Bug 60329 - Avoid NPE when styleid is null

[Eug-Mart]

I am using NPOI (v2.7.1) to work with an Excel file that contains a formula using XLOOKUP along with other functions like IF. While the XLOOKUP support was introduced in PR #815, when I attempt to evaluate the formula using FormulaEvaluator.EvaluateFormulaCell(cell), it returns the formula instead of the calculated value. I would appreciate any suggestions on resolving this issue or confirming if there's a problem with XLOOKUP implementation in NPOI.