Pivot Grid provides a way to present and manipulate data in a pivot table view.

Gets/Sets whether to auto-generate the pivot configuration based on the provided data.

autoGenerateConfig: boolean

Gets/Sets the array of data that populates the component.

data: any[]

Gets/Sets the default expand state for all rows.

defaultExpandState: boolean

Gets/Sets a custom template when pivot grid is empty.

emptyPivotGridTemplate: (ctx: void) => React.ReactNode

Gets/Sets the pivot configuration with all related dimensions and values.

pivotConfiguration: IgrPivotConfiguration
rowDimensionHeaderTemplate: (ctx: IgrColumnTemplateContext) => React.ReactNode

Enables a super compact theme for the component.

superCompactMode: boolean

Gets/Sets a custom template for the value chips.

valueChipTemplate: (ctx: IgrPivotGridValueTemplateContext) => React.ReactNode

Gets the full list of dimensions.

get allDimensions(): IgrPivotDimension[]

Returns IgrPivotDimension[]

Gets the sorting expressions generated for the dimensions.

get dimensionsSortingExpressions(): IgrSortingExpression[]

Returns IgrSortingExpression[]

get selectedRows(): any[]

Returns any[]

get addRowEmptyTemplate(): (ctx: void) => React.ReactNode

Returns (ctx: void) => React.ReactNode

Gets/Sets a custom template for adding row UI when grid is empty.

set addRowEmptyTemplate(value: (ctx: void) => React.ReactNode): void

Parameters

  • value: (ctx: void) => React.ReactNode

Returns void

get advancedFilteringExpressionsTree(): IgrFilteringExpressionsTree

Returns IgrFilteringExpressionsTree

Gets/Sets the advanced filtering state.

set advancedFilteringExpressionsTree(value: IgrFilteringExpressionsTree): void

Parameters

Returns void

get allowAdvancedFiltering(): boolean

Returns boolean

Gets/Sets a value indicating whether the advanced filtering is enabled.

set allowAdvancedFiltering(value: boolean): void

Parameters

  • value: boolean

Returns void

get allowFiltering(): boolean

Returns boolean

Gets/Sets if the filtering is enabled.

set allowFiltering(value: boolean): void

Parameters

  • value: boolean

Returns void

get autoGenerate(): boolean

Returns boolean

Gets/Sets whether to auto-generate the columns.

set autoGenerate(value: boolean): void

Parameters

  • value: boolean

Returns void

get autoGenerateExclude(): string[]

Returns string[]

Gets/Sets a list of property keys to be excluded from the generated column collection

set autoGenerateExclude(value: string[]): void

Parameters

  • value: string[]

Returns void

get batchEditing(): boolean

Returns boolean

Gets/Sets whether the grid has batch editing enabled. When batch editing is enabled, changes are not made directly to the underlying data. Instead, they are stored as transactions, which can later be committed w/ the commit method.

set batchEditing(value: boolean): void

Parameters

  • value: boolean

Returns void

get cellMergeMode(): GridCellMergeMode

Returns GridCellMergeMode

Gets/Sets cell merge mode.

set cellMergeMode(value: GridCellMergeMode): void

Parameters

Returns void

get cellSelection(): GridSelectionMode

Returns GridSelectionMode

Gets/Sets cell selection mode.

set cellSelection(value: GridSelectionMode): void

Parameters

Returns void

get clipboardOptions(): IgrClipboardOptions

Returns IgrClipboardOptions

Controls the copy behavior of the grid.

set clipboardOptions(value: IgrClipboardOptions): void

Parameters

Returns void

get columnList(): IgrColumnComponent[]

Returns IgrColumnComponent[]

Gets an array of columns.

get columns(): IgrColumnComponent[]

Returns IgrColumnComponent[]

get columnSelection(): GridSelectionMode

Returns GridSelectionMode

Gets/Sets column selection mode

set columnSelection(value: GridSelectionMode): void

Parameters

Returns void

get columnWidth(): string

Returns string

Gets/Sets the default width of the columns.

set columnWidth(value: string): void

Parameters

  • value: string

Returns void

get dataCloneStrategy(): IgrDataCloneStrategy

Returns IgrDataCloneStrategy

Gets/Sets the data clone strategy of the grid when in edit mode.

set dataCloneStrategy(value: IgrDataCloneStrategy): void

Parameters

Returns void

A list of currently rendered grid row's.

get dataRowList(): IgrRowDirective[]

Returns IgrRowDirective[]

Returns the currently transformed paged/filtered/sorted/grouped/pinned/unpinned row data, displayed in the grid.

get dataView(): any[]

Returns any[]

Gets the default row height.

get defaultRowHeight(): number

Returns number

get dragGhostCustomTemplate(): (ctx: IgrGridRowDragGhostContext) => React.ReactNode

Returns (ctx: IgrGridRowDragGhostContext) => React.ReactNode

Gets the custom template, if any, used for row drag ghost.

set dragGhostCustomTemplate(value: (ctx: IgrGridRowDragGhostContext) => React.ReactNode): void

Parameters

Returns void

get dragIndicatorIconTemplate(): (ctx: IgrGridEmptyTemplateContext) => React.ReactNode

Returns (ctx: IgrGridEmptyTemplateContext) => React.ReactNode

The custom template, if any, that should be used when rendering the row drag indicator icon

set dragIndicatorIconTemplate(value: (ctx: IgrGridEmptyTemplateContext) => React.ReactNode): void

Parameters

Returns void

get emptyFilteredGridMessage(): string

Returns string

Gets/Sets the message displayed when there are no records and the grid is filtered.

set emptyFilteredGridMessage(value: string): void

Parameters

  • value: string

Returns void

get emptyGridMessage(): string

Returns string

Get/Sets the message displayed when there are no records.

set emptyGridMessage(value: string): void

Parameters

  • value: string

Returns void

get emptyGridTemplate(): (ctx: IgrGridTemplateContext) => React.ReactNode

Returns (ctx: IgrGridTemplateContext) => React.ReactNode

Gets/Sets a custom template when empty.

set emptyGridTemplate(value: (ctx: IgrGridTemplateContext) => React.ReactNode): void

Parameters

Returns void

get excelStyleHeaderIconTemplate(): (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

Returns (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

Gets the excel style header icon.

set excelStyleHeaderIconTemplate(value: (ctx: IgrGridHeaderTemplateContext) => React.ReactNode): void

Parameters

Returns void

get expansionStates(): Map<any, boolean>

Returns Map<any, boolean>

Gets/Sets a list of key-value pairs [row ID, expansion state].

set expansionStates(value: Map<any, boolean>): void

Parameters

  • value: Map<any, boolean>

Returns void

Returns an array of objects containing the filtered data.

get filteredData(): any

Returns any

Returns an array containing the filtered sorted data.

get filteredSortedData(): any[]

Returns any[]

get filteringExpressionsTree(): IgrFilteringExpressionsTree

Returns IgrFilteringExpressionsTree

Gets/Sets the filtering state.

set filteringExpressionsTree(value: IgrFilteringExpressionsTree): void

Parameters

Returns void

get filteringLogic(): FilteringLogic

Returns FilteringLogic

Gets/Sets the filtering logic of the grid.

set filteringLogic(value: FilteringLogic): void

Parameters

Returns void

get filterMode(): FilterMode

Returns FilterMode

Gets/Sets the filter mode.

set filterMode(value: FilterMode): void

Parameters

Returns void

get filterStrategy(): IgrFilteringStrategy

Returns IgrFilteringStrategy

Gets/Sets the filtering strategy of the grid.

set filterStrategy(value: IgrFilteringStrategy): void

Parameters

Returns void

get headerCollapsedIndicatorTemplate(): (ctx: IgrGridTemplateContext) => React.ReactNode

Returns (ctx: IgrGridTemplateContext) => React.ReactNode

Gets the row collapse indicator template.

set headerCollapsedIndicatorTemplate(value: (ctx: IgrGridTemplateContext) => React.ReactNode): void

Parameters

Returns void

get headerExpandedIndicatorTemplate(): (ctx: IgrGridTemplateContext) => React.ReactNode

Returns (ctx: IgrGridTemplateContext) => React.ReactNode

Gets the header expand indicator template.

set headerExpandedIndicatorTemplate(value: (ctx: IgrGridTemplateContext) => React.ReactNode): void

Parameters

Returns void

get headSelectorTemplate(): (ctx: IgrHeadSelectorTemplateContext) => React.ReactNode

Returns (ctx: IgrHeadSelectorTemplateContext) => React.ReactNode

Gets the header row selector template.

set headSelectorTemplate(value: (ctx: IgrHeadSelectorTemplateContext) => React.ReactNode): void

Parameters

Returns void

get height(): string

Returns string

Gets/Sets the height.

set height(value: string): void

Parameters

  • value: string

Returns void

Gets the number of hidden columns.

get hiddenColumnsCount(): number

Returns number

get hideRowSelectors(): boolean

Returns boolean

Gets/Sets if the row selectors are hidden.

set hideRowSelectors(value: boolean): void

Parameters

  • value: boolean

Returns void

get isLoading(): boolean

Returns boolean

Gets/Sets whether the grid is going to show a loading indicator.

set isLoading(value: boolean): void

Parameters

  • value: boolean

Returns void

Represents the last search information.

get lastSearchInfo(): IgrSearchInfo

Returns IgrSearchInfo

get loadingGridTemplate(): (ctx: IgrGridTemplateContext) => React.ReactNode

Returns (ctx: IgrGridTemplateContext) => React.ReactNode

Gets/Sets a custom template when loading.

set loadingGridTemplate(value: (ctx: IgrGridTemplateContext) => React.ReactNode): void

Parameters

Returns void

get locale(): string

Returns string

Gets/Sets the locale.

set locale(value: string): void

Parameters

  • value: string

Returns void

get mergeStrategy(): IgrGridMergeStrategy

Returns IgrGridMergeStrategy

Gets/Sets the merge strategy of the grid.

set mergeStrategy(value: IgrGridMergeStrategy): void

Parameters

Returns void

get moving(): boolean

Returns boolean

Controls whether columns moving is enabled in the grid.

set moving(value: boolean): void

Parameters

  • value: boolean

Returns void

Gets/Sets the outlet used to attach the grid's overlays to.

set outlet(value: IgrOverlayOutletDirective): void

Parameters

Returns void

get paginationComponents(): IgrPaginatorComponent[]

Returns IgrPaginatorComponent[]

get pagingMode(): GridPagingMode

Returns GridPagingMode

set pagingMode(value: GridPagingMode): void

Parameters

Returns void

Gets an array of the pinned columns.

get pinnedColumns(): IgrColumnComponent[]

Returns IgrColumnComponent[]

Gets the number of pinned columns.

get pinnedColumnsCount(): number

Returns number

Gets an array of the pinned to the right columns.

get pinnedEndColumns(): IgrColumnComponent[]

Returns IgrColumnComponent[]

Gets an array of the pinned rows.

get pinnedRows(): IgrGridRowComponent[]

Returns IgrGridRowComponent[]

Gets an array of the pinned to the left columns.

get pinnedStartColumns(): IgrColumnComponent[]

Returns IgrColumnComponent[]

get pinning(): IgrPinningConfig

Returns IgrPinningConfig

Gets/Sets the initial pinning configuration.

set pinning(value: IgrPinningConfig): void

Parameters

Returns void

get primaryKey(): string

Returns string

Gets/Sets the primary key.

set primaryKey(value: string): void

Parameters

  • value: string

Returns void

get resourceStrings(): IgrGridResourceStrings

Returns IgrGridResourceStrings

Gets/Sets the resource strings.

set resourceStrings(value: IgrGridResourceStrings): void

Parameters

Returns void

get rowAddTextTemplate(): (ctx: IgrGridEmptyTemplateContext) => React.ReactNode

Returns (ctx: IgrGridEmptyTemplateContext) => React.ReactNode

Gets the row add text template.

set rowAddTextTemplate(value: (ctx: IgrGridEmptyTemplateContext) => React.ReactNode): void

Parameters

Returns void

get rowClasses(): any

Returns any

Sets a conditional class selector to the grid's row element. Accepts an object literal, containing key-value pairs, where the key is the name of the CSS class and the value is either a callback function that returns a boolean, or boolean, like so:

set rowClasses(value: any): void

Parameters

  • value: any

Returns void

get rowCollapsedIndicatorTemplate(): (ctx: IgrGridRowTemplateContext) => React.ReactNode

Returns (ctx: IgrGridRowTemplateContext) => React.ReactNode

Gets the row collapse indicator template.

set rowCollapsedIndicatorTemplate(value: (ctx: IgrGridRowTemplateContext) => React.ReactNode): void

Parameters

Returns void

get rowDraggable(): boolean

Returns boolean

Gets/Sets whether rows can be moved.

set rowDraggable(value: boolean): void

Parameters

  • value: boolean

Returns void

get rowEditable(): boolean

Returns boolean

Gets/Sets whether the rows are editable.

set rowEditable(value: boolean): void

Parameters

  • value: boolean

Returns void

get rowEditActionsTemplate(): (ctx: IgrGridRowEditActionsTemplateContext) => React.ReactNode

Returns (ctx: IgrGridRowEditActionsTemplateContext) => React.ReactNode

Gets the row edit actions template.

set rowEditActionsTemplate(value: (ctx: IgrGridRowEditActionsTemplateContext) => React.ReactNode): void

Parameters

Returns void

get rowEditTextTemplate(): (ctx: IgrGridRowEditTextTemplateContext) => React.ReactNode

Returns (ctx: IgrGridRowEditTextTemplateContext) => React.ReactNode

Gets the row edit text template.

set rowEditTextTemplate(value: (ctx: IgrGridRowEditTextTemplateContext) => React.ReactNode): void

Parameters

Returns void

get rowExpandedIndicatorTemplate(): (ctx: IgrGridRowTemplateContext) => React.ReactNode

Returns (ctx: IgrGridRowTemplateContext) => React.ReactNode

Gets the row expand indicator template.

set rowExpandedIndicatorTemplate(value: (ctx: IgrGridRowTemplateContext) => React.ReactNode): void

Parameters

Returns void

get rowHeight(): number

Returns number

Gets/Sets the row height.

set rowHeight(value: number): void

Parameters

  • value: number

Returns void

A list of grid row.

get rowList(): IgrRowDirective[]

Returns IgrRowDirective[]

get rowSelection(): GridSelectionMode

Returns GridSelectionMode

Gets/Sets row selection mode

set rowSelection(value: GridSelectionMode): void

Parameters

Returns void

get rowSelectorTemplate(): (ctx: IgrRowSelectorTemplateContext) => React.ReactNode

Returns (ctx: IgrRowSelectorTemplateContext) => React.ReactNode

Gets the row selector template.

set rowSelectorTemplate(value: (ctx: IgrRowSelectorTemplateContext) => React.ReactNode): void

Parameters

Returns void

get rowStyles(): any

Returns any

Sets conditional style properties on the grid row element. It accepts an object literal where the keys are the style properties and the value is an expression to be evaluated.

set rowStyles(value: any): void

Parameters

  • value: any

Returns void

get selectRowOnClick(): boolean

Returns boolean

Gets/Sets whether clicking over a row should select/deselect it

set selectRowOnClick(value: boolean): void

Parameters

  • value: boolean

Returns void

get shouldGenerate(): boolean

Returns boolean

Gets/Sets whether the columns should be auto-generated once again after the initialization of the grid

set shouldGenerate(value: boolean): void

Parameters

  • value: boolean

Returns void

get showSummaryOnCollapse(): boolean

Returns boolean

Controls whether the summary row is visible when groupBy/parent row is collapsed.

set showSummaryOnCollapse(value: boolean): void

Parameters

  • value: boolean

Returns void

get snackbarDisplayTime(): number

Returns number

Gets/Sets the display time for the row adding snackbar notification.

set snackbarDisplayTime(value: number): void

Parameters

  • value: number

Returns void

get sortAscendingHeaderIconTemplate(): (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

Returns (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

The custom template, if any, that should be used when rendering a header sorting indicator when columns are sorted in asc order.

set sortAscendingHeaderIconTemplate(value: (ctx: IgrGridHeaderTemplateContext) => React.ReactNode): void

Parameters

Returns void

get sortDescendingHeaderIconTemplate(): (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

Returns (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

The custom template, if any, that should be used when rendering a header sorting indicator when columns are sorted in desc order.

set sortDescendingHeaderIconTemplate(value: (ctx: IgrGridHeaderTemplateContext) => React.ReactNode): void

Parameters

Returns void

get sortHeaderIconTemplate(): (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

Returns (ctx: IgrGridHeaderTemplateContext) => React.ReactNode

Gets custom template, if any, that should be used when rendering a header sorting indicator when columns are not sorted.

set sortHeaderIconTemplate(value: (ctx: IgrGridHeaderTemplateContext) => React.ReactNode): void

Parameters

Returns void

get sortingExpressions(): IgrSortingExpression[]

Returns IgrSortingExpression[]

Gets/Sets the sorting state.

set sortingExpressions(value: IgrSortingExpression[]): void

Parameters

Returns void

get sortingOptions(): IgrSortingOptions

Returns IgrSortingOptions

Gets/Sets the sorting options - single or multiple sorting. Accepts an ISortingOptions object with any of the mode properties.

set sortingOptions(value: IgrSortingOptions): void

Parameters

Returns void

get sortStrategy(): IgrGridSortingStrategy

Returns IgrGridSortingStrategy

Gets/Sets the sorting strategy of the grid.

set sortStrategy(value: IgrGridSortingStrategy): void

Parameters

Returns void

get summaryCalculationMode(): GridSummaryCalculationMode

Returns GridSummaryCalculationMode

Gets/Sets the summary calculation mode.

set summaryCalculationMode(value: GridSummaryCalculationMode): void

Parameters

Returns void

get summaryPosition(): GridSummaryPosition

Returns GridSummaryPosition

Gets/Sets the summary position.

set summaryPosition(value: GridSummaryPosition): void

Parameters

Returns void

get summaryRowHeight(): number

Returns number

Get/Set summary row height

set summaryRowHeight(value: number): void

Parameters

  • value: number

Returns void

get toolbar(): IgrGridToolbarComponent[]

Returns IgrGridToolbarComponent[]

get totalRecords(): number

Returns number

Returns the total number of records.

set totalRecords(value: number): void

Parameters

  • value: number

Returns void

Get transactions service for the grid.

get transactions(): TransactionService

Returns TransactionService

Gets an array of unpinned columns.

get unpinnedColumns(): IgrColumnComponent[]

Returns IgrColumnComponent[]

get validationTrigger(): GridValidationTrigger

Returns GridValidationTrigger

Gets/Sets the trigger for validators used when editing the grid.

set validationTrigger(value: GridValidationTrigger): void

Parameters

Returns void

Returns the state of the grid virtualization.

get virtualizationState(): IgrForOfState

Returns IgrForOfState

Returns an array of visible columns.

get visibleColumns(): IgrColumnComponent[]

Returns IgrColumnComponent[]

get width(): string

Returns string

Gets/Sets the width of the grid.

set width(value: string): void

Parameters

  • value: string

Returns void

Auto-sizes row dimension cells.

autoSizeRowDimension(dimension: IgrPivotDimension): void

Parameters

Returns void

Filters a single IPivotDimension.

filterDimension(dimension: IgrPivotDimension, value: any, conditionOrExpressionTree: IgrFilteringExpressionsTree | IgrFilteringOperation): void

Parameters

Returns void

getColumnGroupExpandState(col: IgrColumnComponent): void

Parameters

  • col: IgrColumnComponent

Returns void

Inserts dimension in target collection by type at specified index or at the collection's end.

insertDimensionAt(dimension: IgrPivotDimension, targetCollectionType: PivotDimensionType, index: number): void

Parameters

  • dimension: IgrPivotDimension

    The dimension that will be added.

  • targetCollectionType: PivotDimensionType

    The target collection type to add to. Can be Row, Column or Filter.

  • index: number

    The index in the collection at which to add. This parameter is optional. If not set it will add it to the end of the collection.

Returns void

Inserts value at specified index or at the end.

insertValueAt(value: IgrPivotValue, index: number): void

Parameters

  • value: IgrPivotValue

    The value definition that will be added.

  • index: number

    The index in the collection at which to add. This parameter is optional. If not set it will add it to the end of the collection.

Returns void

Move dimension from its currently collection to the specified target collection by type at specified index or at the collection's end.

moveDimension(dimension: IgrPivotDimension, targetCollectionType: PivotDimensionType, index: number): void

Parameters

  • dimension: IgrPivotDimension

    The dimension that will be moved.

  • targetCollectionType: PivotDimensionType

    The target collection type to move it to. Can be Row, Column or Filter.

  • index: number

    The index in the collection at which to add. This parameter is optional. If not set it will add it to the end of the collection.

Returns void

Move value from its currently at specified index or at the end.

moveValue(value: IgrPivotValue, index: number): void

Parameters

  • value: IgrPivotValue

    The value that will be moved.

  • index: number

    The index in the collection at which to add. This parameter is optional. If not set it will add it to the end of the collection.

Returns void

Notifies for dimension change.

notifyDimensionChange(regenerateColumns: boolean): void

Parameters

  • regenerateColumns: boolean

Returns void

Removes dimension from its currently collection.

removeDimension(dimension: IgrPivotDimension): void

Parameters

Returns void

Removes value from collection.

removeValue(value: IgrPivotValue): void

Parameters

Returns void

Sort the dimension and its children in the provided direction.

sortDimension(dimension: IgrPivotDimension, sortDirection: SortingDirection): void

Parameters

Returns void

toggleColumn(col: IgrColumnComponent): void

Parameters

  • col: IgrColumnComponent

Returns void

Toggles the dimension's enabled state on or off.

toggleDimension(dimension: IgrPivotDimension): void

Parameters

Returns void

toggleRowGroup(col: IgrColumnComponent, newState: boolean): void

Parameters

  • col: IgrColumnComponent
  • newState: boolean

Returns void

Toggles the value's enabled state on or off.

toggleValue(value: IgrPivotValue): void

Parameters

Returns void

Creates a new grid row and adds the data record to the end of the data source.

addRow(data: any): void

Parameters

  • data: any

Returns void

Enters add mode by spawning the UI under the specified row by rowID.

beginAddRowById(rowID: any, asChild: boolean): void

Parameters

  • rowID: any

    The rowID to spawn the add row UI for, or null to spawn it as the first record in the data view

  • asChild: boolean

    Whether the record should be added as a child. Only applicable to igxTreeGrid.

Returns void

Enters add mode by spawning the UI at the specified index.

beginAddRowByIndex(index: number): void

Parameters

  • index: number

    The index to spawn the UI at. Accepts integers from 0 to this.grid.dataView.length

Returns void

Deselect selected cells.

clearCellSelection(): void

Returns void

If name is provided, clears the filtering state of the corresponding column.

clearFilter(name: string): void

Parameters

  • name: string

Returns void

Removes all the highlights in the cell.

clearSearch(): void

Returns void

If name is provided, clears the sorting state of the corresponding column.

clearSort(name: string): void

Parameters

  • name: string

Returns void

Closes the advanced filtering dialog.

closeAdvancedFilteringDialog(applyChanges: boolean): void

Parameters

  • applyChanges: boolean

    indicates whether the changes should be applied

Returns void

Collapses all rows.

collapseAll(): void

Returns void

Collapses the row by its id.

collapseRow(rowID: any): void

Parameters

  • rowID: any

    The row id - primaryKey value or the data record instance.

Returns void

Removes the grid row and the corresponding data record by primary key.

deleteRow(rowSelector: any): any

Parameters

  • rowSelector: any

Returns any

Deselects all columns

deselectAllColumns(): void

Returns void

Deselects all rows

deselectAllRows(onlyFilterData: boolean): void

Parameters

  • onlyFilterData: boolean

Returns void

Deselect specified columns by field.

deselectColumns(columns: string[] | IgrColumnComponent[]): void

Parameters

  • columns: string[] | IgrColumnComponent[]

Returns void

Deselect specified rows by ID.

deselectRows(rowIDs: any[]): void

Parameters

  • rowIDs: any[]

Returns void

Disable summaries for the specified column.

disableSummaries(rest: any[]): void

Parameters

  • rest: any[]

Returns void

Enables summaries for the specified column and applies your customSummary.

enableSummaries(rest: any[]): void

Parameters

  • rest: any[]

Returns void

Finishes the row transactions on the current row and returns whether the grid editing was canceled.

endEdit(commit: boolean, evt: any): boolean

Parameters

  • commit: boolean
  • evt: any

Returns boolean

Expands all rows.

expandAll(): void

Returns void

Expands the row by its id.

expandRow(rowID: any): void

Parameters

  • rowID: any

    The row id - primaryKey value or the data record instance.

Returns void

Filters a single column.

filter(name: string, value: any, conditionOrExpressionTree: IgrFilteringExpressionsTree | IgrFilteringOperation, ignoreCase: boolean): void

Parameters

Returns void

Filters all the column in the grid with the same condition.

filterGlobal(value: any, condition: any, ignoreCase: any): void

Parameters

  • value: any
  • condition: any
  • ignoreCase: any

Returns void

Finds the next occurrence of a given string in the grid and scrolls to the cell if it isn't visible.

findNext(text: string, caseSensitive: boolean, exactMatch: boolean): number

Parameters

  • text: string

    the string to search.

  • caseSensitive: boolean

    optionally, if the search should be case sensitive (defaults to false).

  • exactMatch: boolean

    optionally, if the text should match the entire value (defaults to false).

Returns number

Finds the previous occurrence of a given string in the grid and scrolls to the cell if it isn't visible.

findPrev(text: string, caseSensitive: boolean, exactMatch: boolean): number

Parameters

  • text: string

    the string to search.

  • caseSensitive: boolean

    optionally, if the search should be case sensitive (defaults to false).

  • exactMatch: boolean

    optionally, if the text should match the entire value (defaults to false).

Returns number

Returns the column by field name.

getColumnByName(name: string): IgrColumnComponent

Parameters

  • name: string

Returns IgrColumnComponent

getColumnByVisibleIndex(index: number): IgrColumnComponent

Parameters

  • index: number

Returns IgrColumnComponent

Gets the width to be set on grid header group.

getHeaderGroupWidth(column: IgrColumnComponent): string

Parameters

  • column: IgrColumnComponent

Returns string

Returns ICellPosition which defines the next cell, according to the current position, that match specific criteria.

getNextCell(currRowIndex: number, curVisibleColIndex: number, callback: any): IgrCellPosition

Parameters

  • currRowIndex: number
  • curVisibleColIndex: number
  • callback: any

Returns IgrCellPosition

Gets calculated width of the pinned areas.

getPinnedEndWidth(takeHidden: boolean): void

Parameters

  • takeHidden: boolean

    If we should take into account the hidden columns in the pinned area.

Returns void

Gets calculated width of the pinned areas.

getPinnedStartWidth(takeHidden: boolean): void

Parameters

  • takeHidden: boolean

    If we should take into account the hidden columns in the pinned area.

Returns void

Returns ICellPosition which defines the previous cell, according to the current position, that match specific criteria.

getPreviousCell(currRowIndex: number, curVisibleColIndex: number, callback: any): IgrCellPosition

Parameters

  • currRowIndex: number
  • curVisibleColIndex: number
  • callback: any

Returns IgrCellPosition

Returns the data that is contained in the row component.

getRowData(rowSelector: any): any

Parameters

  • rowSelector: any

    correspond to rowID

Returns any

Returns an array of the current columns selection in the form of [{ column.field: cell.value }, ...].

getSelectedColumnsData(formatters: boolean, headers: boolean): void

Parameters

  • formatters: boolean
  • headers: boolean

Returns void

Returns an array of the current cell selection in the form of [{ column.field: cell.value }, ...].

getSelectedData(formatters: boolean, headers: boolean): void

Parameters

  • formatters: boolean
  • headers: boolean

Returns void

Get the currently selected ranges in the grid.

getSelectedRanges(): IgrGridSelectionRange[]

Returns IgrGridSelectionRange[]

Returns whether the record is pinned or not.

isRecordPinnedByIndex(rowIndex: number): void

Parameters

  • rowIndex: number

    Index of the record in the filteredSortedData collection.

Returns void

Triggers change detection for the grid. Calling markForCheck also triggers the grid pipes explicitly, resulting in all updates being processed. May degrade performance if used when not needed, or if misused:

markForCheck(): void

Returns void

Places a column before or after the specified target column.

moveColumn(column: IgrColumnComponent, target: IgrColumnComponent, pos: DropPosition): void

Parameters

  • column: IgrColumnComponent
  • target: IgrColumnComponent
  • pos: DropPosition

Returns void

Navigates to a position in the grid based on provided rowindex and visibleColumnIndex.

navigateTo(rowIndex: number, visibleColIndex: number, cb: any): void

Parameters

  • rowIndex: number
  • visibleColIndex: number
  • cb: any

Returns void

Opens the advanced filtering dialog.

openAdvancedFilteringDialog(overlaySettings: IgrOverlaySettings): void

Parameters

Returns void

Pins a column by field name.

pinColumn(columnName: string, index: number, pinningPosition: ColumnPinningPosition): boolean

Parameters

Returns boolean

Pin the row by its id.

pinRow(rowID: any, index: number, row: IgrRowType): boolean

Parameters

  • rowID: any

    The row id - primaryKey value or the data record instance.

  • index: number

    The index at which to insert the row in the pinned collection.

  • row: IgrRowType

Returns boolean

Recalculates all widths of columns that have size set to auto.

recalculateAutoSizes(): void

Returns void

Recalculates grid width/height dimensions.

reflow(): void

Returns void

Reapplies the existing search.

refreshSearch(updateActiveInfo: boolean, endEdit: boolean): number

Parameters

  • updateActiveInfo: boolean
  • endEdit: boolean

Returns number

Selects all columns

selectAllColumns(): void

Returns void

Selects all rows

selectAllRows(onlyFilterData: boolean): void

Parameters

  • onlyFilterData: boolean

Returns void

Select specified columns.

selectColumns(columns: string[] | IgrColumnComponent[], clearCurrentSelection: boolean): void

Parameters

  • columns: string[] | IgrColumnComponent[]
  • clearCurrentSelection: boolean

    if true clears the current selection

Returns void

Get current selected columns.

selectedColumns(): IgrColumnComponent[]

Returns IgrColumnComponent[]

Select range(s) of cells between certain rows and columns of the grid.

selectRange(arg: IgrGridSelectionRange[]): void

Parameters

Returns void

Select specified rows by ID.

selectRows(rowIDs: any[], clearCurrentSelection: boolean): void

Parameters

  • rowIDs: any[]
  • clearCurrentSelection: boolean

    if true clears the current selection

Returns void

Sort a single column.

sort(expression: IgrSortingExpression[]): void

Parameters

Returns void

Toggles the specified column's visibility.

toggleColumnVisibility(args: IgrColumnVisibilityChangedEventArgs): void

Parameters

Returns void

Toggles the row by its id.

toggleRow(rowID: any): void

Parameters

  • rowID: any

    The row id - primaryKey value or the data record instance.

Returns void

Unpins a column by field name. Returns whether the operation is successful.

unpinColumn(columnName: string, index: number): boolean

Parameters

  • columnName: string
  • index: number

Returns boolean

Unpin the row by its id.

unpinRow(rowID: any, row: IgrRowType): boolean

Parameters

  • rowID: any

    The row id - primaryKey value or the data record instance.

  • row: IgrRowType

Returns boolean

Updates the grid row and the corresponding data record by primary key.

updateCell(value: any, rowSelector: any, column: string): void

Parameters

  • value: any

    the new value which is to be set.

  • rowSelector: any

    corresponds to rowID.

  • column: string

    corresponds to column field.

Returns void

Updates the grid row

updateRow(value: any, rowSelector: any): void

Parameters

  • value: any
  • rowSelector: any

    correspond to rowID

Returns void

onActiveNodeChange(args: CustomEvent<IgrActiveNodeChangeEventArgs>): void

Parameters

Returns void

onAdvancedFilteringExpressionsTreeChange

Section titled "onAdvancedFilteringExpressionsTreeChange"
onAdvancedFilteringExpressionsTreeChange(args: CustomEvent<IgrFilteringExpressionsTree>): void

Parameters

Returns void

onCellClick(args: CustomEvent<IgrGridCellEventArgs>): void

Parameters

Returns void

onCellEdit(args: CustomEvent<IgrGridEditEventArgs>): void

Parameters

Returns void

onCellEditDone(args: CustomEvent<IgrGridEditDoneEventArgs>): void

Parameters

Returns void

onCellEditEnter(args: CustomEvent<IgrGridEditEventArgs>): void

Parameters

Returns void

onCellEditExit(args: CustomEvent<IgrGridEditDoneEventArgs>): void

Parameters

Returns void

onColumnInit(args: CustomEvent<IgrColumnComponent>): void

Parameters

Returns void

onColumnMoving(args: CustomEvent<IgrColumnMovingEventArgs>): void

Parameters

Returns void

onColumnMovingEnd(args: CustomEvent<IgrColumnMovingEndEventArgs>): void

Parameters

Returns void

onColumnMovingStart(args: CustomEvent<IgrColumnMovingStartEventArgs>): void

Parameters

Returns void

onColumnPin(args: CustomEvent<IgrPinColumnCancellableEventArgs>): void

Parameters

Returns void

onColumnPinned(args: CustomEvent<IgrPinColumnEventArgs>): void

Parameters

Returns void

onColumnResized(args: CustomEvent<IgrColumnResizeEventArgs>): void

Parameters

Returns void

onColumnSelectionChanging(args: CustomEvent<IgrColumnSelectionEventArgs>): void

Parameters

Returns void

onColumnVisibilityChanged(args: CustomEvent<IgrColumnVisibilityChangedEventArgs>): void

Parameters

Returns void

onColumnVisibilityChanging(args: CustomEvent<IgrColumnVisibilityChangingEventArgs>): void

Parameters

Returns void

onContextMenu(args: CustomEvent<IgrGridContextMenuEventArgs>): void

Parameters

Returns void

onDataChanged(args: CustomEvent<IgrForOfDataChangeEventArgs>): void

Parameters

Returns void

onDataChanging(args: CustomEvent<IgrForOfDataChangeEventArgs>): void

Parameters

Returns void

onDimensionInit(args: CustomEvent<IgrPivotDimension>): void

Parameters

Returns void

onDimensionsChange(args: CustomEvent<IgrDimensionsChange>): void

Parameters

Returns void

onDimensionsSortingExpressionsChange

Section titled "onDimensionsSortingExpressionsChange"
onDimensionsSortingExpressionsChange(args: CustomEvent<IgrSortingExpression[]>): void

Parameters

Returns void

onDoubleClick(args: CustomEvent<IgrGridCellEventArgs>): void

Parameters

Returns void

onExpansionStatesChange(args: CustomEvent<Map<any, boolean>>): void

Parameters

Returns void

onFiltering(args: CustomEvent<IgrFilteringEventArgs>): void

Parameters

Returns void

onFilteringDone(args: CustomEvent<IgrFilteringExpressionsTree>): void

Parameters

Returns void

onFilteringExpressionsTreeChange(args: CustomEvent<IgrFilteringExpressionsTree>): void

Parameters

Returns void

onFormGroupCreated(args: CustomEvent<IgrGridFormGroupCreatedEventArgs>): void

Parameters

Returns void

onGridCopy(args: CustomEvent<IgrGridClipboardEvent>): void

Parameters

Returns void

onGridKeydown(args: CustomEvent<IgrGridKeydownEventArgs>): void

Parameters

Returns void

onGridScroll(args: CustomEvent<IgrGridScrollEventArgs>): void

Parameters

Returns void

onPivotConfigurationChange(args: CustomEvent<IgrPivotConfigurationChangedEventArgs>): void

Parameters

Returns void

onRangeSelected(args: CustomEvent<IgrGridSelectionRange>): void

Parameters

Returns void

onRendered(args: CustomEvent<boolean>): void

Parameters

Returns void

onRowAdd(args: CustomEvent<IgrRowDataCancelableEventArgs>): void

Parameters

Returns void

onRowAdded(args: CustomEvent<IgrRowDataEventArgs>): void

Parameters

Returns void

onRowClick(args: CustomEvent<IgrGridRowEventArgs>): void

Parameters

Returns void

onRowDelete(args: CustomEvent<IgrRowDataCancelableEventArgs>): void

Parameters

Returns void

onRowDeleted(args: CustomEvent<IgrRowDataEventArgs>): void

Parameters

Returns void

onRowDragEnd(args: CustomEvent<IgrRowDragEndEventArgs>): void

Parameters

Returns void

onRowDragStart(args: CustomEvent<IgrRowDragStartEventArgs>): void

Parameters

Returns void

onRowEdit(args: CustomEvent<IgrGridEditEventArgs>): void

Parameters

Returns void

onRowEditDone(args: CustomEvent<IgrGridEditDoneEventArgs>): void

Parameters

Returns void

onRowEditEnter(args: CustomEvent<IgrGridEditEventArgs>): void

Parameters

Returns void

onRowEditExit(args: CustomEvent<IgrGridEditDoneEventArgs>): void

Parameters

Returns void

onRowPinned(args: CustomEvent<IgrPinRowEventArgs>): void

Parameters

Returns void

onRowPinning(args: CustomEvent<IgrPinRowEventArgs>): void

Parameters

Returns void

onRowSelectionChanging(args: CustomEvent<IgrRowSelectionEventArgs>): void

Parameters

Returns void

onRowToggle(args: CustomEvent<IgrRowToggleEventArgs>): void

Parameters

Returns void

onSelected(args: CustomEvent<IgrGridCellEventArgs>): void

Parameters

Returns void

onSelectedRowsChange(args: CustomEvent<any[]>): void

Parameters

Returns void

onSorting(args: CustomEvent<IgrSortingEventArgs>): void

Parameters

Returns void

onSortingDone(args: CustomEvent<IgrSortingExpression[]>): void

Parameters

Returns void

onSortingExpressionsChange(args: CustomEvent<IgrSortingExpression[]>): void

Parameters

Returns void

onToolbarExporting(args: CustomEvent<IgrGridToolbarExportEventArgs>): void

Parameters

Returns void

onValidationStatusChange(args: CustomEvent<IgrGridValidationStatusEventArgs>): void

Parameters

Returns void

onValueInit(args: CustomEvent<IgrPivotValue>): void

Parameters

Returns void

onValuesChange(args: CustomEvent<IgrValuesChange>): void

Parameters

Returns void