The following issues are fixed in this issue which is based on #2210:
- 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=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.
The following issues are fixed in this issue which is based on #2210: