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