NPOI 2.6.0 Release Notes

[tonyqus]

To learn how NPOI succeeds, you can read this post

Release Date: Nov 17, 2022

Nuget Package Update

• Add reference Microsoft.IO.RecyclableMemoryStream 2.2.0
• Add reference Enums.NET package 4.0.0
• Add reference MathNet.Numerics.Signed package 4.15.0
• Add reference SixLabors.ImageSharp 2.1.3
• Add reference SixLabors.Fonts 1.0.0-beta18
• Remove System.Drawing.Common
• Update reference Portable.BouncyCastle to 1.9.0

Supported .NET Framework
.NET Framework 4.7.2+ (no support for .NET Framework 4.5 anymore)
.NET Standard 2.0
.NET Standard 2.1
.NET 6

New Features

• IWorkbook and XWPFDocument implements IDisposable
• Add DateOnly support. #839
• optimize memory consumption by using RecyclableMemoryStream
• implement XSSFTableColumn and XSSFTableStyle #753
• XLOOKUP and XMATCH functions support #811
• Pivot table openxml implementation #783
• System.Drawing.Common is deprecated on non-Windows platforms #656
• Get rid of drawing common #894
• Enable xlsx decryption #883
• Implement AutoSizeRow method #907
• new leaveOpen parameter for IWorkbook.Write

Bug Fixes

• SXSSFSheet AutoSizeColumn only considering last lines, missing call in SXSSFRow? #547
• Border style unintentionally shared between CellStyle instances #288
• CT_WebPublishing.Parse fails to parse targetScreenSize attribute #739
• Making a deep copy of a table row in Word #598
• Do not close MemoryStream in IWorkbook.Write(Stream) #585
• Avoid unnecessary memory consumption in clonesheet and copysheet.
• Unable to Open Excel XLS with hyperlink cells #726
• Duplicate Keys Item when use SXSSF #445
• Sheet.CopyRowTo mess the style of the sheet #587
• Wrong style.xml  #731
• Tint value is not read correctly #695
• Hyperlink on picture using CT_Hyperlink not working properly #864
• Excel 2007 Shared formula Error after setting cell formula to null #829
• Invalid hyperlink throws exception - Invalid URI: The hostname could not be parsed. #851
• XWPFDocument clone table row error #855
• Incorrect array bounds check in NPOI.XSSF.Model.StylesTable.GetCellStyleXfAt #892
• Fix ShiftRows destroys merged cell issue #877
• Word: Order of SdtBlock elements is not correct #911
• XWPFDocument : line breaks converted to page breaks. #909
• Remove limit of 3 conditional formatting rules #898
• Instead of throwing exception just get first available font #903
• Pivot tables serialization fixes #867

POI Bugs Fixes

• Github 107 Add AREAS function
• POI 61063 Use of arrays of values leads to non empty stack
• POI 63984 AND / OR should treat missing parameters as FALSE
• POI 62254 OFFSET function fails when 2nd or 3rd arguments are missing
• POI 63819 Spreadsheet DATEVALUE function missing
• POI 62857 DOLLAR function not implemented entirely
• POI 65606 Bug in evaluating WEEKNUM
• POI 65846 Add support for NUMBERVALUE function
• POI 65879 Add support for WORKDAY.INTL functions
• POI 65871 Add support for DOLLARDE and DOLLARFR functions
• POI 65870 Add support for BESSELJ function
• POI 49202 add support for the function 'PERCENTRANK'
• POI 64258 Provide implementation for TDIST function
• POI 65850 Add support for Normal Distribution functions
• POI 60029 Fix problem with Days360 method for the month of february
• POI 64238 Make LOOKUP functions deal with empty last arg correctly
• POI 64393 Handle MissingArgEval in relational operators
• 63013 add XWPFRun setLang method
• github-114 Better support for Footnotes and Endnotes
• POI 49202 add support for the function 'PERCENTRANK'
• POI Github 69 Numeric Array Formula and Matrix Function Patch

[503049007-bh]

Hi, will 2.5.6 also contain Apache POI 5.2.X Changes?
I'm asking specifically for XLOOKUP and XMATCH functions support introduced in POI 5.2.0

[503049007-bh]

Thanks very much for your reply. I'll keep checking updates next days/weeks.

[tonyqus]

@503049007-bh Please follow #811

[tonyqus]

@503049007-bh 2.6.0 rc is released. If you have time, please help check if XLOOKUP function works in your case.

[nguyeny123]

Hi, when I use
SXSSFWorkbook workbook = new SXSSFWorkbook();
ISheet sheet = workbook.CreateSheet("Sheet1");

// Write a large number of rows and columns to cause OutOfMemoryException
for (int rowNumber = 0; rowNumber < 10; rowNumber++) // Increase this number for more rows
{
IRow row = sheet.CreateRow(rowNumber);
for (int colNumber = 0; colNumber < 100; colNumber++) // Increase this number for more columns
{
ICell cell = row.CreateCell(colNumber);
cell.SetCellValue($"Row {rowNumber + 1}, Column {colNumber + 1}");
}
}

// Write the workbook data to a MemoryStream
using (var stream = new MemoryStream())
{
workbook.Write(stream, leaveOpen: true);
// Since we are deliberately causing OutOfMemoryException, this line will not be reached
Console.WriteLine("Workbook data written to MemoryStream successfully.");
}
why stream is still closed right after workbook.Write

[tonyqus]

@nguyeng123 Let's discuss in this issue: #1140