Last Updated: 18 Jan 2024 09:41 by ADMIN
Release 2024 Q1
Created on: 23 Mar 2023 14:25
Category: Spreadsheet
Type: Bug Report
The INDEX formula does not work correctly with LINEST in Spreadsheet

Bug report

When the INDEX formula is used in combination with LINEST the Spreadsheet displays an empty cell. In case such formula is imported from Excel file '#VALUE' is displayed.

Reproduction of the problem

  1. Open the Dojo
  2. Observe the content of the cell with the pink background.

behavior when importing:

  1. Import the file in the Spreadsheet demos

Current behavior

The content of the formula cell that includes LINEST and INDEX is empty. When clicking on the cell the formula is displayed in the formula bar. When importing the content in some cases the content is '#VALUE'.

Expected/desired behavior

The LINEST should work as expected in combination with the INDEX formula.


  • Kendo UI version: 2023.1.314
  • Browser: [all]
Posted on: 15 Jun 2023 09:24

Hello Heather,

Thank you very much for providing your findings. We really appreciate that.

I will keep the bug report open as still in the Dojo example the cell where the formula is used is empty, although the power operator is not used. The used formula is formula: "=INDEX(LINEST(C2:C13,B2:B13),1)".

Progress Telerik

As of R2 2023, the default icon type will be SVG instead of Font. See this blogpost for more information.
Posted on: 11 Jun 2023 16:05

One of our engineers looked at this and figured out a workaround. I am including his writeup that worked out a alternate calculation. He wanted me to pass in that the POWER function is not implemented to work as like Excel. His writeup is below. 

This is NOT a bug in Kendo – it’s simply something that the Kendo spreadsheet doesn’t support.  Specifically, you can’t do a power operator (either ^ or the POWER function) over a range to generate a result matrix.


In the Kendo spreadsheet, ^ is used to raise ONE NUMBER to a power.  It cannot be used with a range for the first argument, nor can it be used with a second argument that is a range.  It won’t generate a matrix – that’s simply not allowed.  So, LINEST is never called. 


You’re trying to use formulas similar to this, which won’t work due to the use of the power function (^) to try to create a matrix of powers:


=INDEX(LINEST(B2:B8, A2:A8^{ 1, 2 }), 1)


You can work around this pretty easily.  Just set up a square matrix in the spreadsheet itself with the values you want.


For example, I can set up cells A10 – A16 as =A2, =A3, =A4, etc., then set up cells B10 – B16 as =A2^2, =A3^2, =A4^2, etc.  Then, the call to LINEST would look like this:


=INDEX(LINEST(B2:B8, A10:B16), 1)


Doing this works properly for every equation you have.

Posted on: 09 Jun 2023 19:06

We have a customer with a use case of calculations for a range of X,Y coordinates entered by the operator in a spreadsheet phase.

The use case is an in-process lab test result calculation, which requires calculation of correlation coefficient and the a,b,c constant values for a second order polynomial curve. The results are used in further calculations.

We are relying on this fix to be able to further progress with our customer's project.

I understand this has yet to be planned for a release. We would greatly appreciate a fix as soon as possible as we are currently stuck. Thanks!

Posted on: 08 Jun 2023 20:43
please resolve asap