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.

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!