NPOI 2.6.1 Release Notes

[tonyqus]

Nuget Package Update

• update Enums.NET package to 4.0.1
• update SixLabors.Fonts package to 1.0.0-beta19
• update SixLabors.ImageSharp to 2.1.4
• update Microsoft.IO.RecyclableMemoryStream to 2.3.2
• Switch to BouncyCastle.Cryptography #1102

Supported .NET Framework

.NET Standard 2.0
.NET Standard 2.1

New Features

#1046 Abstract styling of XSSFPivotTable
#866 Implement Area and Pie chart types
#1006 Add docx comment support
#924 Add AddColor method to CT_Font
#1074 Get hyperlinks from footer and footnotes for XWPF
#1018 Enable global text placement in XWPFDocument

Bug Fixes

#998 Fix XWPFTable row cannot insert to the last position of table
#953 Stop MutableSection from setting null MutableProperty
#988 XSSFExcelExtractor.Text throws System.ArgumentOutOfRangeException
#802 Excel styles not retained after edit and save using NPOI
#990 Fix delete and add chart throws exception
#958 Create zip for SXSSFWorkbook setting Use64bit=Off
#945 Fixes internationalization bugs
#941 Add correction to row height and column width obtained in SheetUtil methods
#948 Fix PackageRelationship.GetHashCode Exception because the source can be null
#1010 Link in picture breaks NPOI template edit
#1079 Fix bug with cashed chart axis name not being XMLEncoded on save
#1081 Fix exception thrown when reading file with closing br tag in drawing.vml
#1061 Skip WINDOW2 validation when reading possibly non-compliant XLS
#1058 Fixed RandBetween
#1035 Add null reference check in UpdateHeaders() to allow formatting existing data as table
#1077 Fix XSSFCellStyle.CloneStyleFrom

Improvement

#1078 Fix some warnings in test projects
#1074 Get hyperlinks from footer and footnotes
#1034 Exception cleanup

POI Bug Fixes

#931 POI 60197 setSheetOrder doesn't update names scope
#727 POI 52447 Unable to Open Excel XLS with hyperlink cells.
#1005 POI 65543 Support SST records with incorrect string count not at the end of the stream