Skip to content

Fixes for 2210 #2215

@swmal

Description

@swmal

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.

Metadata

Metadata

Assignees

Labels

bugSomething isn't working

Type

Projects

Status

Backlog

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions