This object allows setting options for the grid view.
grid: { type: string, title: string, showFilter: boolean, showHeaders: boolean, showTotals: string, showGrandTotals: string, grandTotalsPosition: string, showHierarchies: boolean, showHierarchyCaptions: boolean, drillThroughMaxRows: number, showReportFiltersArea: boolean, dragging: boolean, showAutoCalculationBar: boolean }
Property/Type | Description |
---|---|
type String |
optional The selected grid’s type. The following grid types are supported: "compact" , "classic" , and "flat" .Default value: "compact" .
|
title String |
optional The title of the grid. Default value: "" . |
showFilter Boolean |
optional Indicates whether column/row filter controls and report filter controls are visible on the grid (true ) or not (false ).Default value: true . |
showHeaders Boolean |
optional Indicates whether the spreadsheet headers are visible (true ) or not (false ).Default value: true .
|
showTotals String |
optional Specifies where to show totals: in rows ("rows" ), in columns ("columns" ), in rows and columns ("on" ), or not at all ("off" ).Default value: "on" . |
showGrandTotals String |
optional Specifies where to show grand totals: in rows ("rows" ), in columns ("columns" ), in rows and columns ("on" ) or not at all ("off" ).Default value: "on" . |
grandTotalsPosition String |
optional Indicates whether the grand totals are displayed at the top of the table ("top" ) or at the bottom ("bottom" ).Only for the flat view. Default value: "top" . |
showHierarchies Boolean |
optional Specifies how to show drillable hierarchy cells on the grid: with a link on the right (true ) or with an icon on the left (false ).Default value: true . |
showHierarchyCaptions Boolean |
optional Indicates whether the hierarchy captions are visible (true ) on the grid or not (false ).Default value: true . |
drillThroughMaxRows Number |
optional Sets the maximum number of rows for the drill-through pop-up window. Only for "api" , "microsoft analysis services" , and "elasticsearch" data source types.Default value: 1000 . |
showReportFiltersArea Boolean |
optional Indicates whether the reports filtering cells on the grid should be visible (true ) or not (false ).Default value: true .
|
dragging Boolean |
optional Indicates whether the hierarchies on the grid can be dragged (true ) or not (false ).Default value: true . |
showAutoCalculationBar Boolean |
optional Indicates whether the autoCalculationBar feature is turned on (true ) or not (false ).Default value: true . |
Options guide
OptionsObject
ChartOptionsObject
getOptions()
setOptions()