Last Updated: 31 Jan 2023 13:30 by ADMIN
José Carlos
Created on: 17 Jan 2023 16:45
Category: Spreadsheet
Type: Bug Report
Formula returns a different result in Spreadsheet and Excel

Bug report

Reproduction of the problem

Dojo example: https://dojo.telerik.com/UWicoqeJ

  1. Focus an empty cell and paste the following formula: =IF(AND(H4-I4>=B4, H4+I4<=C4), "OK", "NO OK")

Current behavior

The cell will display: "NO OK"

Expected/desired behavior

The cell should display: "OK" as it does in Excel.


  • Kendo UI version: 2022.3.1109
  • jQuery version: x.y
  • Browser: [all]
1 comment
Ivan Danchev
Posted on: 31 Jan 2023 13:30

Another example of the formula returning a different result in the Spreadsheet: https://dojo.telerik.com/UmotayUL

Focus an empty cell and paste:

=IF(E12-J12>=C12,IF(E12+J12<=D12,IF(F12-J12>=C12,IF(F12+J12<=D12,IF(G12-J12>=C12,IF(G12+J12<=D12,IF(H12-J12>=C12,IF(H12+J12<=D12,"OK","NO OK"),"NO OK"),"NO OK"),"NO OK"),"NO OK"),"NO OK"),"NO OK"),"NO OK")

The Spreadsheet shows "NO OK" result, whereas Excel shows "OK".

Additional examples of formulas returning different results in Ticket ID: 1593790 (the post from 30 Jan 2023 7:19 PM)