Matrix
The "matrix" type which can be used in the custom JavaScript functions (primitives) in formulas.
Definition
Package:@progress/kendo-angular-spreadsheet
Methods
Returns the determinant of this matrix. The matrix should contain only numbers and be square. Note that there are no checks for this.
number
Iterates through elements of the matrix and calling the func for each element (first columns, then rows).
The function which will be called for each element.
includeEmptybooleanIf true, it will call the function for empty (null) elements as well. Otherwise, it only calls it where a value exists.
Returns the element at a given location.
any
Returns the inverse of this matrix. The matrix should contain only numbers and be square.
Note that there are no checks for this. If the inverse does not exist, the determinant is zero, then it returns null.
Similar to each, but produces a new matrix of the same shape as the original one with the values returned by the function.
The function which will be called for each element.
includeEmptybooleanIf true, it will call the function for empty (null) elements as well. Otherwise, it only calls it where a value exists.
Sets the element at a given location.
Returns the transposed matrix. The rows of the original matrix become columns of the transposed one.