search

telerik / kendo-ui-core

An HTML5, jQuery-based widget library for building modern web apps.
http://www.telerik.com/kendo-ui
Other
2.54k stars 1.91k forks source link

The Spreadsheet SLOPE and INTERCEPT functions do not calculate if arrays passed as parameters contain blank or string cells #6226

Open aleksandarevangelatov opened 3 years ago

aleksandarevangelatov commented 3 years ago

Bug report

The Spreadsheet SLOPE and INTERCEPT functions do not calculate if arrays passed as parameters contain blank or string cells

Reproduction of the problem

  1. Run this dojo

Current behavior

  1. Note that cell B3, B4, and B5 return errors as a result of the calculation
  2. Same data passed to the SLOPE and INTERCEPT functions in Excel returns a valid result

Expected/desired behavior

Calculation of the SLOPE and INTERCEPT functions should be consistent with Excel

Environment

IvanDanchev commented 3 years ago

The same behavior is exhibited by the VLOOKUP function. It returns #N/A! when the range contains blank cells. Ticket ID: 1504320