npoi

Release Notes

What's Changed

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

New Contributors

• @Zbyszard made their first contribution in https://github.com/nissl-lab/npoi/pull/1207
• @TimLee88 made their first contribution in https://github.com/nissl-lab/npoi/pull/1211
• @robertcoltheart made their first contribution in https://github.com/nissl-lab/npoi/pull/1183
• @obimelo made their first contribution in https://github.com/nissl-lab/npoi/pull/1192

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.6.2-rc1...2.7.0-rc1

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

Nuget link - not final link
Release notes

What's Changed

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

New Contributors

• @deleteJ made their first contribution in https://github.com/nissl-lab/npoi/pull/1109
• @mino-alpha made their first contribution in https://github.com/nissl-lab/npoi/pull/1080
• @fred2020-net made their first contribution in https://github.com/nissl-lab/npoi/pull/1131
• @smackysnacks made their first contribution in https://github.com/nissl-lab/npoi/pull/1120

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.6.1-rc2...2.6.2-rc1

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

New Contributors

• @rdscfh made their first contribution in https://github.com/nissl-lab/npoi/pull/947
• @karakasa made their first contribution in https://github.com/nissl-lab/npoi/pull/960
• @Crowbar90 made their first contribution in https://github.com/nissl-lab/npoi/pull/958
• @mycroes made their first contribution in https://github.com/nissl-lab/npoi/pull/1034
• @superrnovae made their first contribution in https://github.com/nissl-lab/npoi/pull/1046
• @lahma made their first contribution in https://github.com/nissl-lab/npoi/pull/1061
• @acsteitz made their first contribution in https://github.com/nissl-lab/npoi/pull/1058
• @SamuelPlentz made their first contribution in https://github.com/nissl-lab/npoi/pull/1072
• @sikanderiqbal made their first contribution in https://github.com/nissl-lab/npoi/pull/1054
• @Fantasy-Dash made their first contribution in https://github.com/nissl-lab/npoi/pull/1089
• @apetukhov made their first contribution in https://github.com/nissl-lab/npoi/pull/1077
• @mus65 made their first contribution in https://github.com/nissl-lab/npoi/pull/1102
• @Jontino made their first contribution in https://github.com/nissl-lab/npoi/pull/1005

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.6.0-rc3...2.6.1-rc2

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

New Contributors

• @pragmaware made their first contribution in https://github.com/nissl-lab/npoi/pull/687
• @houlongchao made their first contribution in https://github.com/nissl-lab/npoi/pull/640
• @PatriceDargenton made their first contribution in https://github.com/nissl-lab/npoi/pull/723
• @thepirat000 made their first contribution in https://github.com/nissl-lab/npoi/pull/714
• @KnyazSh made their first contribution in https://github.com/nissl-lab/npoi/pull/708
• @sml2 made their first contribution in https://github.com/nissl-lab/npoi/pull/727
• @pbvs made their first contribution in https://github.com/nissl-lab/npoi/pull/745
• @YulerB made their first contribution in https://github.com/nissl-lab/npoi/pull/791
• @CollinAlpert made their first contribution in https://github.com/nissl-lab/npoi/pull/839
• @maxkoshevoi made their first contribution in https://github.com/nissl-lab/npoi/pull/865
• @aboryczko made their first contribution in https://github.com/nissl-lab/npoi/pull/893
• @dontbyte made their first contribution in https://github.com/nissl-lab/npoi/pull/898

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.5.5...2.6.0-rc3

nuget link

Release notes

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.5.5...2.5.6

Nuget link
Release notes

What's Changed

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

New Contributors

• @datadiode made their first contribution in https://github.com/nissl-lab/npoi/pull/569
• @MagicAndre1981 made their first contribution in https://github.com/nissl-lab/npoi/pull/496
• @itsvse made their first contribution in https://github.com/nissl-lab/npoi/pull/591
• @drmason789 made their first contribution in https://github.com/nissl-lab/npoi/pull/565
• @Itamaram made their first contribution in https://github.com/nissl-lab/npoi/pull/576
• @jonopare made their first contribution in https://github.com/nissl-lab/npoi/pull/519

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.5.4...2.5.5

What's Changed

• Word processing fields issue by @crabouif in https://github.com/nissl-lab/npoi/pull/108
• Fix: AutoFilter colId is required even when 0 by @mikaelweave in https://github.com/nissl-lab/npoi/pull/112
• Fix issue with removing multiple cells from CalculationChain when iSpecified is false by @jacobmalliet in https://github.com/nissl-lab/npoi/pull/107
• Bug 47245: Comment out check and exception in case row-records are mi… by @Fr1z2r in https://github.com/nissl-lab/npoi/pull/109
• Fix: MathX.Round() - fixing some instances of incorrect rounding and addin… by @tristanjthompson in https://github.com/nissl-lab/npoi/pull/111
• Add DateAxis for category axis. Add support for drawing bar chart. Fix a bug that XSSFChartAxis property IsVisible is opposite to its real value. Fix a bug that "AddPicture to Word" failed. Support line and bar mixed chart. Add set color for XSSFBarChartData and XSSFLineChartData. Add set MajorTickMark for Axis and add set DispBlanksAs for XSSFChart. by @tomtdev in https://github.com/nissl-lab/npoi/pull/113
• Fix: NUnit Test Adapter for Visual Studio doesn't work well. by @jsakamoto in https://github.com/nissl-lab/npoi/pull/106
• Delete conversion of day format 'dddd' to 'EEEE' in date format. by @Matsuyanagi in https://github.com/nissl-lab/npoi/pull/117
• generalDecimalNumFormat should be "0.##########". by @Matsuyanagi in https://github.com/nissl-lab/npoi/pull/116
• Convert .NET Core class libraries to .NET Standard by @LarsKemmann in https://github.com/nissl-lab/npoi/pull/122
• Copy Sheet Functionality for XSSF by @Sappharad in https://github.com/nissl-lab/npoi/pull/123

New Contributors

• @crabouif made their first contribution in https://github.com/nissl-lab/npoi/pull/108
• @mikaelweave made their first contribution in https://github.com/nissl-lab/npoi/pull/112
• @jacobmalliet made their first contribution in https://github.com/nissl-lab/npoi/pull/107
• @Fr1z2r made their first contribution in https://github.com/nissl-lab/npoi/pull/109
• @tristanjthompson made their first contribution in https://github.com/nissl-lab/npoi/pull/111
• @tomtdev made their first contribution in https://github.com/nissl-lab/npoi/pull/113
• @Matsuyanagi made their first contribution in https://github.com/nissl-lab/npoi/pull/117
• @LarsKemmann made their first contribution in https://github.com/nissl-lab/npoi/pull/122

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.3.0...2.4.0

nuget link
Release Notes

What's Changed

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

New Contributors

• @robvanuden made their first contribution in https://github.com/nissl-lab/npoi/pull/528
• @stevenxi made their first contribution in https://github.com/nissl-lab/npoi/pull/510
• @saulobmansur made their first contribution in https://github.com/nissl-lab/npoi/pull/538
• @AnonymousWalker made their first contribution in https://github.com/nissl-lab/npoi/pull/582

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.5.3...2.5.4

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 https://github.com/nissl-lab/npoi/pull/332
• improve performance of CreateRow for bigger excel sheets by @ThomasZitzler in https://github.com/nissl-lab/npoi/pull/339
• Bug found in LocaleUtil.cs. by @wylermat in https://github.com/nissl-lab/npoi/pull/352
• AutoSizeColumnTracker to Lazy, fix build errors by @msvprogs in https://github.com/nissl-lab/npoi/pull/377
• Add license scan report and status by @fossabot in https://github.com/nissl-lab/npoi/pull/389
• fix: Rich strings hash for texts with the color set as RGB by @MaQy in https://github.com/nissl-lab/npoi/pull/413
• Fixed typo in indexed color ("lemonchilffon" instead of "lemonchiffon") by @Bykiev in https://github.com/nissl-lab/npoi/pull/420

New Contributors

• @Bykiev made their first contribution in https://github.com/nissl-lab/npoi/pull/332
• @ThomasZitzler made their first contribution in https://github.com/nissl-lab/npoi/pull/339
• @wylermat made their first contribution in https://github.com/nissl-lab/npoi/pull/352
• @fossabot made their first contribution in https://github.com/nissl-lab/npoi/pull/389
• @MaQy made their first contribution in https://github.com/nissl-lab/npoi/pull/413

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.5.1...2.5.2

nuget link
Release notes

What's Changed

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

New Contributors

• @alexeysankov made their first contribution in https://github.com/nissl-lab/npoi/pull/444
• @macite made their first contribution in https://github.com/nissl-lab/npoi/pull/448
• @tony1223 made their first contribution in https://github.com/nissl-lab/npoi/pull/437

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.5.2...2.5.3

nuget link

• #302 Deleted text is stilll extracted from Word document
• #283 XWPFTableCell.GetParagraphArray(0) always return null
• #256 ISheet.CopyRow() throws NullReferenceException
• #187 customHeight attribute of row for SXSSFWorkbook wrong
• #225 Infinite Loop in Substitute.ReplaceAllOccurrences on empty searchStr
• #199 SXSSFCell: numeric value is serialized with CurrentCulture rules
• #141 XSSFFont.FontHeight setting bug
• #165 Excel warns if we use a font without setting its size
• #203 Add XWPFRun.AddSvg
• #200 Optimizations and bugfixes of SXSSF logic
• #198 Add XWPFStyles.GetStyleWithName(string styleName)
• #325 Fix XSSFDataValidationHelper.CreateValidation to use all CellRangeAddresses.

What's Changed

• Fix XSSFDataValidationHelper.CreateValidation to use all CellRangeAddresses. by @tkakisu in https://github.com/nissl-lab/npoi/pull/325
• Add XWPFStyles.GetStyleWithName(string styleName) by @bleis-tift in https://github.com/nissl-lab/npoi/pull/198
• Optimizations and bugfixes of SXSSF logic by @msvprogs in https://github.com/nissl-lab/npoi/pull/200
• Add XWPFRun.AddSvg by @bleis-tift in https://github.com/nissl-lab/npoi/pull/203

New Contributors

• @tkakisu made their first contribution in https://github.com/nissl-lab/npoi/pull/325
• @bleis-tift made their first contribution in https://github.com/nissl-lab/npoi/pull/198

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.5.0...2.5.1

What's Changed

• use guid not random by @sreedy in https://github.com/nissl-lab/npoi/pull/169
• Fix POI bug 57423 ShiftRows() produces a corrupted xlsx file by @lionelplessis in https://github.com/nissl-lab/npoi/pull/173
• Update XSSFWorkbook.cs - IsDate1904() by @amnz1 in https://github.com/nissl-lab/npoi/pull/185
• ST_OnOff by @marcusvcs in https://github.com/nissl-lab/npoi/pull/176
• #201 - XSSFFont CloneStyleFrom generates NPE if passed in src is null by @davija in https://github.com/nissl-lab/npoi/pull/202
• Porting crypt code by @antony-liu in https://github.com/nissl-lab/npoi/pull/270
• added SpacingBetween (XWPFParagraph) by @BryanHo10 in https://github.com/nissl-lab/npoi/pull/237
• Fix setting DateTime cell value for SXSSFCell by @lethnie in https://github.com/nissl-lab/npoi/pull/263
• Advance to POI 3.15 by @antony-liu in https://github.com/nissl-lab/npoi/pull/290
• Fix some test cases by @antony-liu in https://github.com/nissl-lab/npoi/pull/291
• Remove PivotTables and PivotCache definitions. by @dotnetninja74 in https://github.com/nissl-lab/npoi/pull/265
• Fix XSSFExcelExtractor to emit empty cells by @toddlucas in https://github.com/nissl-lab/npoi/pull/241
• Fix Issue #232 Corrupted xlsx when CurrentCulture time separator is n… by @workgroupengineering in https://github.com/nissl-lab/npoi/pull/233
• Update XSSFCellStyle.cs by @totpero in https://github.com/nissl-lab/npoi/pull/221
• Update HSSFCellStyle.cs by @totpero in https://github.com/nissl-lab/npoi/pull/222
• OMath: Degree and Superscript creation/edit support by @cratu in https://github.com/nissl-lab/npoi/pull/184
• Fix some bugs. by @antony-liu in https://github.com/nissl-lab/npoi/pull/293
• Fix proper function by @antony-liu in https://github.com/nissl-lab/npoi/pull/294
• Fix some test cases by @antony-liu in https://github.com/nissl-lab/npoi/pull/295
• Fix some bugs. by @antony-liu in https://github.com/nissl-lab/npoi/pull/296
• Fix test cases of namespace TestCases.XWPF by @antony-liu in https://github.com/nissl-lab/npoi/pull/297
• Fix some test cases by @antony-liu in https://github.com/nissl-lab/npoi/pull/299
• Fix some bugs by @antony-liu in https://github.com/nissl-lab/npoi/pull/303
• Provide generic sheet enumerator for IWorkbook by @antony-liu in https://github.com/nissl-lab/npoi/pull/304
• Fix all test case of TestSXSSFSheet by @antony-liu in https://github.com/nissl-lab/npoi/pull/305
• Fix some test cases. by @antony-liu in https://github.com/nissl-lab/npoi/pull/307
• Fix some test cases. by @antony-liu in https://github.com/nissl-lab/npoi/pull/308
• Fix some test cases. by @antony-liu in https://github.com/nissl-lab/npoi/pull/309
• Fix some test cases. by @antony-liu in https://github.com/nissl-lab/npoi/pull/310
• More test cases by @antony-liu in https://github.com/nissl-lab/npoi/pull/311
• Fix more test cases by @antony-liu in https://github.com/nissl-lab/npoi/pull/312
• More test cases by @antony-liu in https://github.com/nissl-lab/npoi/pull/314
• Fix URI with Chinese Charset Issue by @kema221 in https://github.com/nissl-lab/npoi/pull/212
• Added check for empty searchStr in ReplaceAllOccurrences. by @hbrowser in https://github.com/nissl-lab/npoi/pull/229

New Contributors

• @sreedy made their first contribution in https://github.com/nissl-lab/npoi/pull/169
• @lionelplessis made their first contribution in https://github.com/nissl-lab/npoi/pull/173
• @amnz1 made their first contribution in https://github.com/nissl-lab/npoi/pull/185
• @marcusvcs made their first contribution in https://github.com/nissl-lab/npoi/pull/176
• @davija made their first contribution in https://github.com/nissl-lab/npoi/pull/202
• @BryanHo10 made their first contribution in https://github.com/nissl-lab/npoi/pull/237
• @lethnie made their first contribution in https://github.com/nissl-lab/npoi/pull/263
• @dotnetninja74 made their first contribution in https://github.com/nissl-lab/npoi/pull/265
• @workgroupengineering made their first contribution in https://github.com/nissl-lab/npoi/pull/233
• @totpero made their first contribution in https://github.com/nissl-lab/npoi/pull/221
• @kema221 made their first contribution in https://github.com/nissl-lab/npoi/pull/212
• @hbrowser made their first contribution in https://github.com/nissl-lab/npoi/pull/229

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.4.1...2.5.0

nuget link

New features

• NET Standard 2.0 support
• Add Excel function support for AVERAGEIF and AVERAGEIFS
• CopySheet support in XSSFSheet
• Implemented OMath formula edit/creation in XWPF
• stop .NET Framework 2.0 support (some contributed code start using System.Linq)
• Add Excel function support for AVERAGEIF and AVERAGEIFS
• CopySheet support in XSSFSheet
• Implemented OMath formula edit/creation in XWPF
• Support line and bar mixed chart

BUG Fixes

• Fix SharpZipLib 0.86 dependency issue in .NET Framework 4 and .NET 4.5
• Fix FontHeight property issue in XSSF and HSSF
• solve SecurityRules issue since .NET 4.0 while using AllowPartiallyTrustedCallers
• AutoFilter colId must have value even when it equals 0
• Fix NUnit Test cases in VS2017 (development purpose only)
• MathX.Round() - fixing some instances of incorrect rounding and adding
• Fix Word processing fields issue in XWPF
• Fix a bug of 'adding picture to word' failed

What's Changed

• Added methods for set top, left, right border at cell. Implemented OMath formula edit/creation with example. by @cratu in https://github.com/nissl-lab/npoi/pull/121
• AVERAGEIF and AVERAGEIFS functions by @jundenilson in https://github.com/nissl-lab/npoi/pull/124

New Contributors

• @jundenilson made their first contribution in https://github.com/nissl-lab/npoi/pull/124

Full Changelog: https://github.com/nissl-lab/npoi/compare/2.4.0...2.4.1