NPOI 2.4.1

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 #121
• AVERAGEIF and AVERAGEIFS functions by @jundenilson in #124

New Contributors

• @jundenilson made their first contribution in #124

Full Changelog: 2.4.0...2.4.1