Skip to content

Navigation Menu

Sign in
Appearance settings

Search code, repositories, users, issues, pull requests...

Provide feedback

We read every piece of feedback, and take your input very seriously.

Saved searches

Use saved searches to filter your results more quickly

Appearance settings

Fixes for 2210 #2215

Copy link
Copy link
@swmal

Description

@swmal
Issue body actions

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 workingSomething isn't working

Type

Projects

Status

Backlog
Show more project fields

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions

    Morty Proxy This is a proxified and sanitized view of the page, visit original site.