Released: Dec 12, 2025

v8.4.0 での更新項目

機能

• Added support for .NET 10.

不具合の修正

• Fixed an issue where the DATEDIF function returned incorrect results for the number of months.
• Fixed an issue where EPPlus incorrectly evaluated the expression TRUE equals 1 as TRUE instead of FALSE.
• Resolved various issues in CEILING, ISOCEILING, CEILING.PRECISE, CEILING.MATH and FLOOR, FLOOR.PRECISE, FLOOR.MATH functions, especially when handling negative multiples. The TIME function was previously limited to the range 00:00:00–23:59:59. It now behaves similar to Excel, supporting overflow and negative values.
• Fixed an issue where the TIME function did not handle array input correctly.
• Fixed issue where Chart Style Manager reset the series color cycle when multiple chart types or a secondary axis were used.
• Direct input of errors like #DIV/0, #NAME?, #NULL or #GETTING_DATA was not supported in formulas and arrays.
• ISBLANK("") incorrectly returned true.
• ERROR.TYPE returned a #VALUE error when supplying a #DIV/0 error.
• INDIRECT("") now returns a #REF error.
• CONCATENATE(TRUE,FALSE) now returns the bool-strings in upper case, as Excel.
• REPT("ab",-1) now returns a #VALUE error.
• Fixed several issues with the MOD function and negative arguments.
• POWER(0,0) now returns a #NUM error.
• Added support for preserving conditional formatting in pivot tables placed in the element.
• The ISNUMBER now returns false on Boolean values.
• Fixed issue where the CHOOSE function incorrectly returned error (i.e. #DIV/0), if supplies as conditional arguments.
• Fixed issue where The UNICHAR function didn't return the correct character.
• Fixed issue where the TEXT function failed if a null value was supplied as format argument.
• Fixed issue where VLOOKUP could fail to find an item in the cell if the first row was the header. Excel ignores header values in the binary search.
• Fixed issue where 'ExcelRangeBase.DimensionByValue' returned the wrong range in rare cases.
• Fixed issue where 'ExcelRangeBase.Richtext' caused a null 'NullReferenceException' when it had been disposed.