NPOI 2.7.1

NPOI Tutorial Waitlist

Nuget
Release notes

What's Changed

• Some patches ported from poi by @antony-liu in #1290
• CT_CellFormula.Write: fix writing the si attribute by @artem-iron in #1291
• Some patches ported from poi by @antony-liu in #1306
• Patches about VBAMacroReader from poi by @antony-liu in #1309
• [github-164] Fix Bug in XSSFTable.setCellReferences when table is single cell. by @superrnovae in #1283
• Update SharpZipLib to v1.4.2 by @Bykiev in #1313
• Update SixLabors.ImageSharp to 2.1.8. CVE-2024-32036 by @DontFretBrett in #1317
• Avoid NullReference exception when saving workbook with XML Map by @antony-liu in #1314
• Add RemoveDataValidation method by @artem-iron in #1262
• Fix reading document variables by @Bykiev in #1307
• [Bug 67785] Make XSSFExcelExtractor output more like that from XSSFEventBasedExcelExtractor by @superrnovae in #1281
• XLS - Fix adding cell comment by @Bykiev in #1303
• Opening existing workbook with pictures, adding new ones and saving it should not throw an exception by @superrnovae in #1284
• Some patches ported from poi by @antony-liu in #1316
• Fix TempFile usage while temp dir was deleted in same process by @Bykiev in #1132
• Fix ROUNDDOWN function by @Bykiev in #1310
• [POI-Bug-67475] Better support for edge cases in TEXT function. by @superrnovae in #1287
• Revert "[POI-Bug-67475] Better support for edge cases in TEXT function." by @tonyqus in #1333
• Fix NPE issue in PackageRelationshipCollection by @tonyqus in #1330
• Do not include xfId in CellStyleXfs XML by @jones-gareth in #1325
• [Bug 68237] CustomHeight attribute of row for SXSSFWorkbook is wrong by @superrnovae in #1282
• fix : Make Free Form coordinates closer to the original by @mino-alpha in #1269
• Implement Cell function by @tonyqus in #1335
• Patches ported from poi 3.16 by @antony-liu in #1322
• Implement Concat Function by @dcjxdd123 in #1341
• Expose Package Readonly argument for XSSFWorkbook constructor by @tonyqus in #1336
• Implement forecast function by @ken-swyfft in #1324
• Implement T.INV Function by @dcjxdd123 in #1345
• Upgrade BouncyCastle.Cryptography to version 2.3.1 by @lahma in #1348
• Upgrade benchmark and test NuGet references by @lahma in #1349
• More patches ported from poi 3.16 by @antony-liu in #1342
• Fixed bug raised in issue #1358 by @hahschaa in #1362
• Some patches ported from poi by @antony-liu in #1354
• Fix fontsize of the Math formula in XWPF by @dcjxdd123 in #1364
• Update ExtendedNumerics.BigDecimal by @Bykiev in #1350
• Use Directory.Build.props as single source of version information by @lahma in #1373
• Fix RepositoryUrl in Directory.Build.props by @lahma in #1378

New Contributors

• @DontFretBrett made their first contribution in #1317
• @jones-gareth made their first contribution in #1325
• @dcjxdd123 made their first contribution in #1341
• @ken-swyfft made their first contribution in #1324
• @hahschaa made their first contribution in #1362

Full Changelog: 2.7.0-rc1...2.7.1-rc1