Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong calculation in DAYS formula in Spreadsheet #6672

Closed
nelito987 opened this issue Jan 7, 2022 · 0 comments
Closed

Wrong calculation in DAYS formula in Spreadsheet #6672

nelito987 opened this issue Jan 7, 2022 · 0 comments
Labels
Bug C: Spreadsheet FP: Completed Sync status with associated Feedback Item jQuery SEV: Low
Milestone

Comments

@nelito987
Copy link
Contributor

Bug report

When the =DAYS() formula is used in Spreadsheet the result has the opposite sign compared to Excel. For example, if the result in Excel is 100, the result with the same dates in Spreadsheet is -100. If the result in Excel is -100, the result in Spreadsheet is 100.

Reproduction of the problem

  1. Open the Dojo example. The formula used in C1 is =DAYS(A1, B1). The result is 365.
  2. The same dates and formula are used in the linked Excel file
    DaysFormula.xlsx
    The result is -365

Current behavior

The DAYS formula in Spreadsheet gives a result with an opposite sign compared to Excel when the same dates are used.

Expected/desired behavior

The result of the DAYS formula should be the same as Excel.

Environment

  • Kendo UI version: 2021.3.1207
  • Browser: [all ]
@kendo-bot kendo-bot added FP: Planned Sync status with associated Feedback Item FP: In Development Sync status with associated Feedback Item and removed FP: Planned Sync status with associated Feedback Item labels Feb 21, 2022
@Dimitar-Goshev Dimitar-Goshev added this to the 2022.R1.SP.next milestone Mar 10, 2022
@kendo-bot kendo-bot added FP: Completed Sync status with associated Feedback Item and removed FP: In Development Sync status with associated Feedback Item labels Mar 10, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Bug C: Spreadsheet FP: Completed Sync status with associated Feedback Item jQuery SEV: Low
Projects
None yet
Development

No branches or pull requests

3 participants