EPPlus v7.2.1

Released: Jul 2, 2024

v7.2.1 での更新項目

機能

  • Added new static property 'ExcelPackageSettings.CultureSpecificBuildInNumberFormats' to specify culture specific number formats for individual cultures.
  • Added new call-back function 'ExcelWorkbook.NumberFormatToTextHandler' to override the default Text value.
  • Added support for DateOnly and TimeOnly (supported from Microsoft .NET 6 and later).
  • Changed thread locking object in the cell store.
  • Added support for new functions in formula calculations:
    • YIELDDISC.
    • LOGINV.
    • CHITEST.
    • TDIST.
    • GAMMAINV.
    • GAMMA.INV.

不具合の修正

  • Fixed several issues with the ExcelRangeBase.Text function.
  • Pivot Table Calculation threw an exception if a field was sorted and contained empty cells.
  • Using implicit intersection (@) between two ranges did not work correctly in the formula parser.
  • Fixed some conditional formatting's not automatically extending when a row was inserted underneath them.
  • Fixed issue where conditional formatting on pivot tables would cause corrupt worksheet when read and saved in some cases.