NPOI 2.7.0 - Long ETH

NPOI Tutorial Waitlist

Nuget link
Release Notes

What's Changed

• Advance XWPF functionalities to POI 3.16 by @9rnsr in #1048
• Reduce string allocations when writing documents by @lahma in #1095
• Add DateOnlyCellValue and TimeOnlyCellValue by @tonyqus in #1119
• Fix reading xls by @Bykiev in #1127
• Fix warnings on comparing value types to null by @karakasa in #1141
• Fix Linux font installation with proper NotoColorEmoji-Regular.ttf by @lahma in #1124
• Remove reflections in HSSFColor by @karakasa in #1158
• Specify the Culture while searching the font by @Bykiev in #1129
• Support (FLOOR|CEILING).MATH & (VAR|STDEV).(P|S) functions by @karakasa in #1135
• Change regex usage to manual parsing by @lahma in #1094
• Add caching to IFont2Font by @lahma in #1179
• Copy RepeatingRows and RepeatingColumns by @Bykiev in #1187
• Fix DefaultColumnWidth by @Bykiev in #1181
• Small speedup on autosizing column width by @Bykiev in #1178
• Workbook Evaluator bug fix on checking an IF without a third param by @fred2020-net in #1176
• Update MathNet.Numerics (v5) by @Bykiev in #1205
• Make it possible to set UseZip64 flag by @Zbyszard in #1207
• Update MultiOperandNumericFunction.cs by @TimLee88 in #1211
• Update XSSFRowColShifter.cs by @TimLee88 in #1214
• fix: Do not save Style with index 0 by @workgroupengineering in #1235
• Update transitive reference to Cryptography.Pkcs library by @robertcoltheart in #1183
• Upgrade Microsoft.IO.RecyclableMemoryStream to version 3.0.0 by @lahma in #1238
• Improve performance of Workseet CopyTo by @EmilienDup in #942
• feat freeform for shapes by @mino-alpha in #1197
• Fix saving docx in compatibility mode by @Bykiev in #1213
• Fix typo olivergreen in IndexedColors by @Bykiev in #1263
• Update SixLabors dependencies by @Bykiev in #1264
• Upgrade to NUKE 8 by @lahma in #1268
• Upgrade BouncyCastle.Cryptography to version 2.3.0 by @lahma in #1280
• Fix XSSFRichTextString.ApplyFont by @Bykiev in #1266
• Update SixLabors.ImageSharp (CVE-2024-27929) by @Bykiev in #1288
• When shift a row, the row of comments anchors (ct_shape) need to be also shifted by @obimelo in #1192
• Insert table at the specified location in word document @cbs-cbt #606

New Contributors

• @Zbyszard made their first contribution in #1207
• @TimLee88 made their first contribution in #1211
• @robertcoltheart made their first contribution in #1183
• @obimelo made their first contribution in #1192

Full Changelog: 2.6.2-rc1...2.7.0-rc1