NPOI 2.7.0 Release Notes

[tonyqus]

Planned Release Date: Mar 24, 2024

Nuget Package Update

• Update to latest version of MathNet.Numerics,5.0.0 ? #1195
• Upgrade Microsoft.IO.RecyclableMemoryStream to version 3.0.0 #1238
• Update transitive reference to Cryptography.Pkcs library #1183
• Update SixLabors dependencies #1264
• Upgrade BouncyCastle.Cryptography to version 2.3.0 #1280
• Update SixLabors.ImageSharp (CVE-2024-27929) #1288

Enhancement

• Reduce string allocations when writing documents #1095
• Make it possible to set UseZip64 flag #1207
• Copy RepeatingRows and RepeatingColumns #1187
• Small speedup on autosizing column width #1178
• Add caching to IFont2Font #1179
• Remove reflections in HSSFColor #1158
• [POI-66083 & POI-66094] Support (FLOOR|CEILING).MATH & (VAR|STDEV).(P|S) functions #1135
• Add DateOnlyCellValue and TimeOnlyCellValue #1119
• Change regex usage to manual parsing #1094
• Advance XWPF functionalities to POI 3.16 #1048
• Specify the Culture while searching the font #1129
• XWPF - Compatiblity mode #882
• When shift a row, the row of comments anchors (ct_shape) need to be also shifted #1192
• Insert table at the specified location in word document #606

Bug Fixes

• [XSSF] The style does not apply to the cell #1234
• IWorkBook.SetSheetName method will clear sheet.RepeatingRows #1182
• CopyRow throws System.NullReferenceException #1051
• NPOI corrupt Excel files containing Array function / Data table #913
• Reading xls throws out of boundary exception #874
• copy sheet chart error #654
• Update XSSFRowColShifter.cs #1214
• Update MultiOperandNumericFunction.cs #1211
• Fix DefaultColumnWidth #1181
• Fix reading xls #1127
• Fix Linux font installation with proper NotoColorEmoji-Regular.ttf  #1124
• Fix auto size columns #1130
• Workbook Evaluator bug fix on checking an IF without a third param #1176
• Fix typo olivergreen in IndexedColors #1263
• EvaluateAllFormulaCells invokes function with wrong number of parameters #1184
• AutoSizeColumn became extremely slow after upgrading from npoi 2.6.0 to 2.6.2 #1204
• Improve performance of Workseet CopyTo #942
• XSSFRichTextString.ApplyFont() works incorrectly #1246
• Fix saving docx in compatibility mode #1213

POI Bug Fixes Sync

• POI Bug-61281: ExportToXML(Stream,String,bool)@XSSFExportToXml can have export issues: #1228
• POI Bug 64348: A possible IndexOutOfBoundsException from GetWatermarkParagraph(String,int)@XWPFHeaderFooterPolicy #1225
• POI Bug 66425: OnDocumentRead()@XWPFDocument can throw an excepiton. #1222
• POI 58237 Unable to add image to a word document header using XWPF
• POI: 60337: XWPFTableRow.isRepeatHeader throws NullPointerException
• POI: 60465: Cannot specify interline spacing for a Paragraph in XWPF
• POI: 60293 -- Handle illegal "Odd" header/footer in XWPF
• POI: 60337: XWPFTableRow.isRepeatHeader throws NullPointerException
• POI: 57366: XWPFTable to Header / Footer

Breaking Changes

• Due to Add DateOnlyCellValue and TimeOnlyCellValue #1119, ICell.DateCellValue return DateTime? instead of DateTime

Known Issue

• Formula openxml gets corrupted after opened and saved by NPOI 2.7.0 #1315

[Bykiev]

Hi, is any news about release?

[tonyqus]

Thank you for pushing me. I added you a Triage role in this repo.

https://www.nuget.org/packages/NPOI/2.7.0 is released.

[tonyqus]

Btw, do you have Linkedin? I'd like to connect

[Bykiev]

Thank you, unfortunately I've no Linkedin profile and it's blocked in my country

[McBussloo]

Hi. Where can I find the breaking changes?

[Bykiev]

Hi, there is no other breaking changes in this release except the changes with DefaultColumnWidth. But it's more a bug fix.

[McBussloo]

My code does not compile with this version.
ICell.DateCellValue (/main/SS/UserModel/Cell.cs) is now of type DateTime? instead of DateTime. So references to properties fail.

[Bykiev]

Indeed, it was changed #1119

@tonyqus, it seems we need to add a breaking changes section in release notes

[tonyqus]

@McBussloo Thank you for reporting this. I've added the breaking changes section to this notes.