New to Kendo UI for Angular? Start a free 30-day trial

Context

Class

The context object of the custom JavaScript functions (primitives) in formulas.

Definition

Package:@progress/kendo-angular-spreadsheet

Methods

asMatrix

Converts the given argument to a matrix, if possible. It accepts a RangeRef object or a plain JavaScript non-empty array. Additionally, if a Matrix object is provided, it is returned as is.

Parameters:argMatrix | RangeRef | RangeRef[]Returns:

Matrix

cellValues

Returns as a flat array the values in any reference that exist in the given array. Elements that are not references are copied over.

Parameters:arrayRef | Matrix | Ref | Matrix[]Returns:

any

getRefData

Returns the data that is the value in the given reference. If a CellRef is given, it returns a single value. For a RangeRef or UnionRef, it returns a flat array of values.

Parameters:refRangeRef | CellRef | UnionRefReturns:

any

Verifies that all references in the given array are resolved before invoking your callback—that is, executes any formula. If this array turns out to include the cell where the current formula lives, it returns a #CIRCULAR! error. Elements that are not references are ignored.

Parameters:arrayRef[] | Ref[][]callback() => anyReturns:

any

workbook

Returns the Workbook object where the current formula is evaluated.

Returns:

Workbook