Unplanned
Last Updated: 11 Jan 2021 16:10 by pradeep
pradeep
Created on: 11 Jan 2021 16:10
Category: Spreadsheet
Type: Bug Report
0
The Spreadsheet SLOPE and INTERCEPT functions do not calculate if arrays passed as parameters contain blank or string cells

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

  • Kendo UI version: 2020.3.118
  • Browser: [all]
0 comments