NPOI 2.6.2 Release Notes

[tonyqus]

Release Date: Sep 12, 2023

Nuget Package Update

• Update SixLabors.Fonts version to 1.0 #1164
• Update NuGetizer to 1.1.0 to get rid of SponsorLink #1165
• Bring .NET 6 and .NET framework 4.7.2 support back

Supported .NET Framework

• .NET Framework 4.7.2+
• .NET Standard 2.0
• .NET Standard 2.1
• .NET 6
• .NET 7

Enhancement

• Improve package publish logic #1173
• How to setup the sheet to scroll to top in XSSFSheet #985
• Include all projects in NuGet package #1103

Bug Fixes

• NullBufferedCipher Broken #1153
• SetCellValue with DateOnly does not work on .NET 7 project #1118
• Failed to open excel(.xlsx) with NPOI(2.5.6) with some specific graphs #1059
• Failed to open word file(.docx) when Text box on header or footer #1067
• Fix leaveOpen option of SXSSFWorkbook #1152
• exception on loading : An item with the same key has already been added. #1121
• Auto Size Column Not Working In 2.6.0 #1022
• Support replacing docx text within embedded tables #1120
• Unexpected ROUNDDOWN function Result  #1055
• Fix copying empty row #1154
• INT(1.99) doesn't return correct rounded value #983
• Writing to locked cell results in cell being unlocked and workbook structure protection being lost #738
• Remove Hyperlinks not working #690
• Update Text.cs to handle StringEval in arg0 #1131
• XSSFWorkbook.Remove will not remove sheet actually #1146
• Fix removing cell comments in SXSSF #1136
• Update SearchFind.cs to not throw an unhandled exception  #1134
• Countifs fail to evaluate correctly #825
• Countifs fail to evaluate correctly #825 #1115
• Fix Drawing shape #1080
• fix issue #983 INT(1.99) doesn't return correct rounded value #1109
• Fix XSSFSheet.RemoveHyperlink method. #1171
• Fix removing hyperlinks #1128
• Fix Remove method of XSSFWorkbook #1151
• Fix checking if cell is locked #1125

[rick-yang1987]

你好，我在使用NPOI操作XLSX文件时，有个别文件在2.4.1之前版本保存后用EXCEL打开会提示损坏需要修复，修复后的文件无法再通过NPOI保存。使用2.6.2操作时第一次可以正常保存，文件也不会提示损坏，但是第二次再通过NPOI保存会提示“可为空的对象必须具有一个值。如有需要我可以提供问题文件

[tonyqus]

你去Issues里面开个问题，上传能重现问题的文件，我会去看的。

[rick-yang1987]

好的，另外我想咨询一下，如何通过NPOI删除EXCEL、WORD文件中插入的图片？