NPOI 2.7.1

NPOI Tutorial Waitlist

Nuget
Release notes

What's Changed

• Some patches ported from poi by @antony-liu in #1290
• CT_CellFormula.Write: fix writing the si attribute by @artem-iron in #1291
• Some patches ported from poi by @antony-liu in #1306
• Patches about VBAMacroReader from poi by @antony-liu in #1309
• [github-164] Fix Bug in XSSFTable.setCellReferences when table is single cell. by @superrnovae in #1283
• Update SharpZipLib to v1.4.2 by @Bykiev in #1313
• Update SixLabors.ImageSharp to 2.1.8. CVE-2024-32036 by @DontFretBrett in #1317
• Avoid NullReference exception when saving workbook with XML Map by @antony-liu in #1314
• Add RemoveDataValidation method by @artem-iron in #1262
• Fix reading document variables by @Bykiev in #1307
• [Bug 67785] Make XSSFExcelExtractor output more like that from XSSFEventBasedExcelExtractor by @superrnovae in #1281
• XLS - Fix adding cell comment by @Bykiev in #1303
• Opening existing workbook with pictures, adding new ones and saving it should not throw an exception by @superrnovae in #1284
• Some patches ported from poi by @antony-liu in #1316
• Fix TempFile usage while temp dir was deleted in same process by @Bykiev in #1132
• Fix ROUNDDOWN function by @Bykiev in #1310
• [POI-Bug-67475] Better support for edge cases in TEXT function. by @superrnovae in #1287
• Revert "[POI-Bug-67475] Better support for edge cases in TEXT function." by @tonyqus in #1333
• Fix NPE issue in PackageRelationshipCollection by @tonyqus in #1330
• Do not include xfId in CellStyleXfs XML by @jones-gareth in #1325
• [Bug 68237] CustomHeight attribute of row for SXSSFWorkbook is wrong by @superrnovae in #1282
• fix : Make Free Form coordinates closer to the original by @mino-alpha in #1269
• Implement Cell function by @tonyqus in #1335
• Patches ported from poi 3.16 by @antony-liu in #1322
• Implement Concat Function by @dcjxdd123 in #1341
• Expose Package Readonly argument for XSSFWorkbook constructor by @tonyqus in #1336
• Implement forecast function by @ken-swyfft in #1324
• Implement T.INV Function by @dcjxdd123 in #1345
• Upgrade BouncyCastle.Cryptography to version 2.3.1 by @lahma in #1348
• Upgrade benchmark and test NuGet references by @lahma in #1349
• More patches ported from poi 3.16 by @antony-liu in #1342
• Fixed bug raised in issue #1358 by @hahschaa in #1362
• Some patches ported from poi by @antony-liu in #1354
• Fix fontsize of the Math formula in XWPF by @dcjxdd123 in #1364
• Update ExtendedNumerics.BigDecimal by @Bykiev in #1350
• Use Directory.Build.props as single source of version information by @lahma in #1373
• Fix RepositoryUrl in Directory.Build.props by @lahma in #1378

New Contributors

• @DontFretBrett made their first contribution in #1317
• @jones-gareth made their first contribution in #1325
• @dcjxdd123 made their first contribution in #1341
• @ken-swyfft made their first contribution in #1324
• @hahschaa made their first contribution in #1362

Full Changelog: 2.7.0-rc1...2.7.1-rc1

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

NPOI 2.6.2 - for my daughter Chris

This release is to celebrate my daughter's birthday. Wish she can grow up healthily and happily.

Nuget link
Release notes

What's Changed

• Fix issue #983 INT(1.99) doesn't return correct rounded value by @deleteJ in #1109
• Fix copying empty row by @Bykiev in #1154
• Fix leaveOpen option of SXSSFWorkbook by @Bykiev #1152
• Failed to open word file(.docx) when Text box on header or footer by @tonyqus #1067
• Failed to open excel(.xlsx) with NPOI(2.5.6) with some specific graphs by @tonyqus #1059
• Fix checking if cell is locked by @Bykiev #1125
• Fix removing hyperlinks by @Bykiev #1128
• Fix XSSFSheet.RemoveHyperlink method by @artem-iron #1171
• Update Text.cs to handle StringEval in arg0 by @fred2020-net #1131
• Fix Remove method of XSSFWorkbook by @Bykiev #1151
• Fix removing cell comments in SXSSF @Bykiev #1136
• Update SearchFind.cs to not throw an unhandled exception by @fred2020-net #1134
• Countifs fail to evaluate correctly by @deleteJ #1115
• Enabling setuping the sheet to scroll to top in XSSFSheet by @tonyqus #985
• Fix Drawing shape by @mino-alpha #1080
• Fix auto size columns by @Bykiev #1130
• exception on loading : An item with the same key has already been added by@tonyqus #1121
• Support replacing docx text within embedded tables by @smackysnacks #1120

New Contributors

• @deleteJ made their first contribution in #1109
• @mino-alpha made their first contribution in #1080
• @fred2020-net made their first contribution in #1131
• @smackysnacks made their first contribution in #1120

Full Changelog: 2.6.1-rc2...2.6.2-rc1

NPOI 2.6.1

What's new in NPOI 2.6.1

Nuget link

Release notes

What's Changed

• Add AddColor method to CT_Font by @artem-iron in #924
• Update Chart.cs by @PBrunot in #938
• Fix ')' missing in CT_NumVal.Write method by @artem-iron in #940
• if statement is duplicate by @rdscfh in #947
• Fix PackageRelationship.GetHashCode Exception because the source can be null by @GGJason in #948
• Add correction to row height and column width obtained in SheetUtil methods by @artem-iron in #941
• Refactoring XSSFRow by @artem-iron in #949
• Able to open files with ill-formed datetime, exported by SAS by @karakasa in #960
• Fixes internationalization bugs #930 #944 #376 by @PBrunot in #945
• Create zip for SXSSFWorkbook setting Use64bit=Off by @Crowbar90 in #958
• Fix delete and add chart throws exception by @artem-iron in #990
• Add docx comment support by @9rnsr in #1006
• fix POI Bug 60197 - setSheetOrder doesn't update names scope by @9rnsr in #1014
• Handle the exception when system has no fonts by @artem-iron in #1019
• Stop MutableSection from setting null MutableProperty by @artem-iron in #953
• fix Ambiguous project name error while restoring NuGet packages. by @9rnsr in #1027
• Build process maintenance by @9rnsr in #1028
• Build process maintenance 2nd by @9rnsr in #1031
• Exception cleanup by @mycroes in #1034
• Remove unused exception captures by @mycroes in #1036
• Build process maintenance 3rd by @9rnsr in #1032
• Fix XWPFTable row cannot insert to the last position of table by @GGJason in #998
• Implement Area and Pie chart types by @artem-iron in #866
• Build process maintenance 4th by @9rnsr in #1037
• Abstract styling of XSSFPivotTable by @superrnovae in #1046
• Skip WINDOW2 validation when reading possibly non-compliant XLS by @lahma in #1061
• Fixed RandBetween by @acsteitz in #1058
• feat: Get hyperlinks from footer and footnotes by @BenjaminMichaelis in #1074
• Refactoring and code cleanup for XSSFSheet, XSSFRowColShifter, RowShifter and ColumnHelper classes by @artem-iron in #1066
• Add null reference check in UpdateHeaders() to allow formatting existing data as table by @superrnovae in #1035
• Update SheetDataWriter.cs by @SamuelPlentz in #1072
• Update SXSSFRow.cs by @SamuelPlentz in #1073
• Update XSSFCellStyle.cs by @sikanderiqbal in #1054
• Fix some warnings in test projects by @artem-iron in #1078
• Fix bug with cashed chart axis name not being XMLEncoded on save by @artem-iron in #1079
• Fix exception thrown when reading file with closing
  tag in drawing.vml by @artem-iron in #1081
• fix EmbeddedResource access on net472 by @9rnsr in #1083
• FormulaCellCacheEntry: Optimize ChangeConsumingCells method by @EmilienDup in #939
• Add NUKE build infrastructure by @lahma in #1062
• NUKE improvements by @lahma in #1084
• Change RBG->RGB by @Fantasy-Dash in #1089
• Enable tests in CI runs by @lahma in #1092
• Add benchmarks project by @lahma in #1091
• Improve packaging procedures by @lahma in #1097
• Remove unused package references by @lahma in #1098
• Fix XSSFCellStyle.CloneStyleFrom by @apetukhov in #1077
• Switch to BouncyCastle.Cryptography by @mus65 in #1102
• POI 65543 Support SST records with incorrect string count not at the end of the stream by @Jontino in #1005
• Install required font on Linux CI run by @lahma in #1101
• Include all projects in NuGet package by @lahma in #1103

New Contributors

• @rdscfh made their first contribution in #947
• @karakasa made their first contribution in #960
• @Crowbar90 made their first contribution in #958
• @mycroes made their first contribution in #1034
• @superrnovae made their first contribution in #1046
• @lahma made their first contribution in #1061
• @acsteitz made their first contribution in #1058
• @SamuelPlentz made their first contribution in #1072
• @sikanderiqbal made their first contribution in #1054
• @Fantasy-Dash made their first contribution in #1089
• @apetukhov made their first contribution in #1077
• @mus65 made their first contribution in #1102
• @Jontino made their first contribution in #1005

Full Changelog: 2.6.0-rc3...2.6.1-rc2

NPOI 2.6.0 - Slava Ukraini

What's new in NPOI 2.6.0

nuget link

Release Notes

What's Changed

• Fix the order of children of the AutoFilter xml element by @pragmaware in #687
• Add null check by @houlongchao in #640
• GetColumnWidth: no need to explore the whole sheet by @PatriceDargenton in #723
• Adding CloneStyleFrom to avoid losing custom style properties by @thepirat000 in #714
• Add minimal support Pivot tables, Fix #419, Fix #262 by @KnyazSh in #708
• fix Hyperlink without Remove by @sml2 in #727
• Added parsing word table properties Caption and Description by @pbvs in #745
• implement XSSFTableColumn and XSSFTableStyle by @tonyqus in #753
• Fix minValue and maxValue in SharedItems in CT_PivotCacheDefinition by @KnyazSh in #786
• Address cves for sharp zip lib by @YulerB in #791
• Fix structure CT_PivotTableDefinition and CT_PivotCache by @KnyazSh in #804
• implement Xlookup and xmatch function by @tonyqus in #815
• Pivot table openxml implementation by @tonyqus in #783
• Matrix and Array function by @tonyqus in #833
• Add DateOnly support. by @CollinAlpert in #839
• Add max date check in IsValidExcelDate by @maxkoshevoi in #865
• fix/test27405 by @EmilienDup in #857
• fix IndexOutOfRangeException thrown in FormulaCellCacheEntrySet by @EmilienDup in #852
• Expose out list of styles for use by @BenjaminMichaelis in #870
• Fix ShiftRows destroys merged cell issue by @tonyqus in #877
• Pivot tables serialization fixes by @artem-iron in #867
• Fix for #892 by @aboryczko in #893
• Get rid of drawing common by @tonyqus in #894
• Enable xlsx decryption by @KnyazSh in #883
• Instead of throwing exception just get first available font by @artem-iron in #903
• fix #909 by @PBrunot in #910
• add null check in match function by @houlongchao in #905
• Remove limit of 3 conditional formatting rules by @dontbyte in #898
• fix #911 by @PBrunot in #912
• Implement AutoSizeRow method by @artem-iron in #907

New Contributors

• @pragmaware made their first contribution in #687
• @houlongchao made their first contribution in #640
• @PatriceDargenton made their first contribution in #723
• @thepirat000 made their first contribution in #714
• @KnyazSh made their first contribution in #708
• @sml2 made their first contribution in #727
• @pbvs made their first contribution in #745
• @YulerB made their first contribution in #791
• @CollinAlpert made their first contribution in #839
• @maxkoshevoi made their first contribution in #865
• @aboryczko made their first contribution in #893
• @dontbyte made their first contribution in #898

Full Changelog: 2.5.5...2.6.0-rc3

NPOI 2.5.6 - Shanghai Lockdown

nuget link

Release notes

Full Changelog: 2.5.5...2.5.6

NPOI 2.5.5

Nuget link
Release notes

What's Changed

• HWPF.Model.CHPBinTable.Rebuild(): Don't try to operate on an invalida… by @datadiode in #569
• Fix XSSFExcelExtractor regression to emit empty cells by @toddlucas in #506
• Fixes for NPOI 2.5.4 by @tonyqus in #588
• added SourceLink #495 by @MagicAndre1981 in #496
• bug fix: no need to pass argument when calling GetFirstKey function by @Yvees in #608
• 修复文件夹路径拼写问题，单反斜杠（Windows），单斜杠（Linux） by @itsvse in #591
• #564 avoidance of exceptions for flow control to substantially reduce time to debug tests by @drmason789 in #565
• XSSFFont.CloneStyleFrom now always clones by @Itamaram in #576
• Get a copy of the CT_Border when about to mutate it by @jonopare in #519
• DocFixes merges by @tonyqus in #643
• Copy cell styles fixes by @tonyqus in #647
• Docx fixes by @tonyqus in #646

New Contributors

• @datadiode made their first contribution in #569
• @MagicAndre1981 made their first contribution in #496
• @itsvse made their first contribution in #591
• @drmason789 made their first contribution in #565
• @Itamaram made their first contribution in #576
• @jonopare made their first contribution in #519

Full Changelog: 2.5.4...2.5.5

2.5.4

nuget link
Release Notes

What's Changed

• Fix typo by @robvanuden in #528
• Fix the file corruption relate to the image wrapping in docx. https:/… by @stevenxi in #510
• fix CT_AbsoluteCellAnchor.Write by @saulobmansur in #538
• Table of Contents - Completion by @AnonymousWalker in #582

New Contributors

• @robvanuden made their first contribution in #528
• @stevenxi made their first contribution in #510
• @saulobmansur made their first contribution in #538
• @AnonymousWalker made their first contribution in #582

Full Changelog: 2.5.3...2.5.4

NPOI 2.5.3

nuget link
Release notes

What's Changed

• Update RANDBETWEEN by @alexeysankov in #444
• fix Match function for compatible by @Yvees in #410
• Add ifs, maxifs, minifs functions to analysis tool pack by @macite in #448
• Update dotnet core versions by @macite in #446
• fix issue #436 skipped cell issue by @tony1223 in #437
• Fix Bug: Paragraph ReplaceText/SearchText In Several Runs by @GGJason in #404
• SXSSFWorkbook possible performance overhead #434 by @tony1223 in #435
• Bug Fix: Wrong calculation of IFERROR and Match function by @Yvees in #408
• Ensure tests run linux and macOS by @macite in #447

New Contributors

• @alexeysankov made their first contribution in #444
• @macite made their first contribution in #448
• @tony1223 made their first contribution in #437

Full Changelog: 2.5.2...2.5.3

NPOI 2.5.2

Nuget link

#448 Add ifs, maxifs, minifs functions to analysis tool pack
#410 fix Match function for compatible
#423 AddPicture doesn't work, corrupts DOCX file
#397 LocalUtil.GetUserTimeZone NullReferenceException
#167 Unable to add image to a word document header or footer using XWPF
#346 NullReferenceException when copying sheet in some Excel files
#413 fix: Rich strings hash for texts with the color set as RGB
#444 Update RANDBETWEEN
#158 NPOI Excel Merging Causing “Repaired Records”
#345 Excel unreadable content error after editing existing file
#358 Remove static locale state
#367 fix incorrect footnote handling
#372 NPOI requires GDI+ dependency even on sheet creation without using column auto-sizing
#281 InvalidOperationException on XSSFSheet.GetColumnStyle
#377 AutoSizeColumnTracker to Lazy, fix build errors
#339 improve performance of CreateRow for bigger excel sheets

What's Changed

• Update samples and packages by @Bykiev in #332
• improve performance of CreateRow for bigger excel sheets by @ThomasZitzler in #339
• Bug found in LocaleUtil.cs. by @wylermat in #352
• AutoSizeColumnTracker to Lazy, fix build errors by @msvprogs in #377
• Add license scan report and status by @fossabot in #389
• fix: Rich strings hash for texts with the color set as RGB by @MaQy in #413
• Fixed typo in indexed color ("lemonchilffon" instead of "lemonchiffon") by @Bykiev in #420

New Contributors

• @Bykiev made their first contribution in #332
• @ThomasZitzler made their first contribution in #339
• @wylermat made their first contribution in #352
• @fossabot made their first contribution in #389
• @MaQy made their first contribution in #413

Full Changelog: 2.5.1...2.5.2