class anychart.core.ui.DataGrid Improve this Doc
Extends: anychart.core.VisualBaseWithBounds
Data grid element.
The Data grid is a part of Gantt chart but it also can be used independently.
Methods Overview
Specific settings | |
buttons() | DataGrid button settings. |
column() | Column settings. |
endIndex() | End index. |
fixedColumns() | Gets fixed columns mode. |
onEditEnd() | onEditStart function. |
onEditStart() | onEditStart function. |
startIndex() | Start index. |
Coloring | |
backgroundFill() | Background fill settings. |
columnStroke() | Column stroke settings. |
headerFill() | Row fill settings. |
rowEvenFill() | Row even fill settings. |
rowFill() | Row fill settings. |
rowHoverFill() | Row fill settings in hover mode. |
rowOddFill() | Row odd fill settings. |
rowSelectedFill() | Row fill settings in selected mode. |
Data | |
data() | Data settings. |
Interactivity | |
edit() | Live edit settings. |
enabled() | Element state (enabled or disabled). |
horizontalScrollBar() | Horizontal scroll bar settings. |
tooltip() | Tooltip settings. |
Size and Position | |
bottom() | Bottom bound settings. |
bounds() | Bounds settings. |
getPixelBounds() | Returns pixel bounds. |
height() | Height settings. |
horizontalOffset() | Horizontal offset. |
left() | Left bound settings. |
maxHeight() | Maximum height. |
maxWidth() | Maximum width. |
minHeight() | Minimum height. |
minWidth() | Minimum width. |
right() | Right bound settings. |
top() | Top bound settings. |
verticalOffset() | Vertical offset |
width() | Width settings. |
zIndex() | Z-index of the element. |
Miscellaneous | |
draw() | Draws data grid. |
Methods Description
backgroundFill
Returns:
anychart.graphics.vector.Fill | string - Background fill.Try it:
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Fill | Array.<(anychart.graphics.vector.GradientKey|string)> | null | Color as an array, an object or a string. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Params:
Name | Type | Default | Description |
---|---|---|---|
color | string | 'none' | Color as a string. |
opacity | number | Color opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Gradient keys. |
angle | number | Gradient angle. |
mode | boolean | anychart.graphics.vector.Rect | Object | Gradient mode. |
opacity | number | Gradient opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Color-stop gradient keys. |
cx | number | X ratio of center radial gradient. |
cy | number | Y ratio of center radial gradient. |
mode | anychart.graphics.math.Rect | If defined then userSpaceOnUse mode, else objectBoundingBox. |
opacity | number | Opacity of the gradient. |
fx | number | X ratio of focal point. |
fy | number | Y ratio of focal point. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
imageSettings | anychart.graphics.vector.Fill | Object with settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
bottom
Returns:
number | string | undefined - Element's bottom bound setting.Params:
Name | Type | Default | Description |
---|---|---|---|
bottom | number | string | null | null | Bottom bound settings for the element. |
Returns:
anychart.core.ui.DataGrid - Returns self for method chaining.Try it:
bounds
Returns:
anychart.core.utils.Bounds - Bounds of the element.Params:
Name | Type | Description |
---|---|---|
bounds | anychart.utils.RectObj | anychart.math.Rect | anychart.core.utils.Bounds | Bounds of element. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Default | Description |
---|---|---|---|
x | number | string | null | X-coordinate. |
y | number | string | null | Y-coordinate. |
width | number | string | null | Width. |
height | number | string | null | Height. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
buttons
Params:
Name | Type | Description |
---|---|---|
settings | Object | Button settings to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
column
Gets column by index or creates a new one if column doesn't exist yet.
Params:
Name | Type | Description |
---|---|---|
index | number | Column index. |
Returns:
anychart.core.ui.DataGrid.Column - Column by index.Try it:
Params:
Name | Type | Description |
---|---|---|
settings | anychart.core.ui.DataGrid.Column | Object | Column settings to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
index | number | Column index. |
settings | anychart.core.ui.DataGrid.Column | Object | Column settings to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
columnStroke
Returns:
string | anychart.graphics.vector.Stroke - Column stroke.Try it:
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Stroke | string | '#cecece' | Stroke color to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
settings | Object | Stroke settings from anychart.graphics.vector.Stroke. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
data
Params:
Name | Type | Description |
---|---|---|
data | anychart.data.Tree | New data tree. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
draw
edit
Returns:
anychart.core.gantt.edit.StructureEdit - Live edit settings.Try it:
- boolean - disable or enable live edit.
- object - sets live edit settings.
Params:
Name | Type | Default | Description |
---|---|---|---|
settings | Object | boolean | false | Live edit settings to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.enabled
Returns:
boolean - Element state.Try it:
Params:
Name | Type | Default | Description |
---|---|---|---|
enabled | boolean | true | Enabled state to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.if (!element.enabled()) element.enabled(true);
Try it:
endIndex
If full data doesn't fit into visible area, DataGrid will show a range of display data ended by this value.
Note: Has higher priority than anychart.core.ui.DataGrid#startIndex.
Params:
Name | Type | Default | Description |
---|---|---|---|
index | number | 0 | End index to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
fixedColumns
Params:
Name | Type | Default | Description |
---|---|---|---|
value | boolean | false | Value to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
getPixelBounds
Returns:
anychart.math.Rect - Pixel bounds of the element.headerFill
Returns:
anychart.graphics.vector.Fill | string - Returns header fill color.var headerFill = dataGrid.headerFill()
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Fill | Array.<(anychart.graphics.vector.GradientKey|string)> | '#fff' | Color as an object, an array or a string. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Params:
Name | Type | Description |
---|---|---|
color | string | Color as a string. |
opacity | number | Color opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Gradient keys. |
angle | number | Gradient angle. |
mode | boolean | anychart.graphics.vector.Rect | Object | Gradient mode. |
opacity | number | Gradient opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Color-stop gradient keys. |
cx | number | X ratio of center radial gradient. |
cy | number | Y ratio of center radial gradient. |
mode | anychart.graphics.math.Rect | If defined then userSpaceOnUse mode, else objectBoundingBox. |
opacity | number | Opacity of the gradient. |
fx | number | X ratio of focal point. |
fy | number | Y ratio of focal point. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
imageSettings | anychart.graphics.vector.Fill | Object with settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
height
Returns:
number | string | undefined - Element's height setting.Params:
Name | Type | Default | Description |
---|---|---|---|
height | number | string | null | null | Height settings for the element. |
Returns:
anychart.core.ui.DataGrid - Returns self for method chaining.Try it:
horizontalOffset
Params:
Name | Type | Default | Description |
---|---|---|---|
offset | number | 0 | Horizontal offset to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
horizontalScrollBar
Params:
Name | Type | Description |
---|---|---|
settings | Object | Horizontal scroll bar settings to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
left
Returns:
number | string | undefined - Element's left bound setting.Params:
Name | Type | Default | Description |
---|---|---|---|
left | number | string | null | null | Left bound setting for the element. |
Returns:
anychart.core.ui.DataGrid - Returns self for method chaining.Try it:
maxHeight
Returns:
number | string | null - Element's maximum height.Params:
Name | Type | Default | Description |
---|---|---|---|
height | number | string | null | null | Maximum height to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
maxWidth
Returns:
number | string | null - Element's maximum width.Params:
Name | Type | Default | Description |
---|---|---|---|
width | number | string | null | null | Maximum width to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
minHeight
Returns:
number | string | null - Element's minimum height.Params:
Name | Type | Default | Description |
---|---|---|---|
height | number | string | null | null | Minimum height to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
minWidth
Returns:
number | string | null - Element's minimum width.Params:
Name | Type | Default | Description |
---|---|---|---|
width | number | string | null | null | Minimum width to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
onEditEnd
Returns:
function():Object|undefined - Returns onEditEnd function.var dataGrid = chart.dataGrid(); var onEditEnd = dataGrid.onEditEnd();
The function is called when changing the focus or pressing the enter key.
When the editing is canceled (pressing the escape key), the function isn't called and the changes aren't applied, the input disappears.
Params:
Name | Type | Default | Description |
---|---|---|---|
onEditEndFunction | function():Object|undefined | function() { return this[columnIndex] == 1 ? {itemMap: {name: this['value']}} : {cancelEdit: true}; } | OnEditEnd function to set. Function that looks like: function(){ // this.columnIndex - The column index for the editing. Type is a number // this.item - Corresponding dataItem. Type is anychart.data.Tree.DataItem // this.value - The value entered by the user. Type is a string return Object with a map itemMap or null/undefined; // Data changes don't occur at all when: - the function returns null or undefined - the object contains 'cancelEdit' field set to 'true': {'cancelEdit': true} } |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
onEditStart
Returns:
function():Object|undefined - Returns onEditStart function.var dataGrid = chart.dataGrid(); var onEditStart = dataGrid.onEditStart();
On appear, input contains text defined by the 'value'-field of the object returned by the onEditStart function.
In order for an input to appear, the function must return an object with the string field 'value', the value of which is set in the appeared input.
Params:
Name | Type | Default | Description |
---|---|---|---|
onEditStartFunction | function():Object|undefined | function() { return this[columnIndex] < 1 ? {cancelEdit: true} : {'value: this['value']}; } | OnEditStart function to set. Function that looks like: function(){ // this.columnIndex - The column index from anychart.core.ui.DataGrid#column method. Type is a number // this.item - DataItem (literally corresponding row). Type is anychart.data.Tree.DataItem // this.value - The current text value of a cell. Type is a string return Object or null/undefined; // The input editing doesn't appear: - if the function returns null or undefined - if the object contains 'cancelEdit' field set to 'true': {'cancelEdit': true} } |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
right
Returns:
number | string | undefined - Element's right bound setting.Params:
Name | Type | Default | Description |
---|---|---|---|
right | number | string | null | null | Right bound setting for the element. |
Returns:
anychart.core.ui.DataGrid - Returns self for method chaining.Try it:
rowEvenFill
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Fill | Array.<(anychart.graphics.vector.GradientKey|string)> | '#fafafa' | Color as an object, an array or a string. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Params:
Name | Type | Description |
---|---|---|
color | string | Color as a string. |
opacity | number | Color opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Gradient keys. |
angle | number | Gradient angle. |
mode | boolean | anychart.graphics.vector.Rect | Object | Gradient mode. |
opacity | number | Gradient opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Color-stop gradient keys. |
cx | number | X ratio of center radial gradient. |
cy | number | Y ratio of center radial gradient. |
mode | anychart.graphics.math.Rect | If defined then userSpaceOnUse mode, else objectBoundingBox. |
opacity | number | Opacity of the gradient. |
fx | number | X ratio of focal point. |
fy | number | Y ratio of focal point. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
imageSettings | anychart.graphics.vector.Fill | Object with settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
rowFill
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Fill | Array.<(anychart.graphics.vector.GradientKey|string)> | '#fff' | Color as an object, an array or a string. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Params:
Name | Type | Description |
---|---|---|
color | string | Color as a string. |
opacity | number | Color opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Gradient keys. |
angle | number | Gradient angle. |
mode | boolean | anychart.graphics.vector.Rect | Object | Gradient mode. |
opacity | number | Gradient opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Color-stop gradient keys. |
cx | number | X ratio of center radial gradient. |
cy | number | Y ratio of center radial gradient. |
mode | anychart.graphics.math.Rect | If defined then userSpaceOnUse mode, else objectBoundingBox. |
opacity | number | Opacity of the gradient. |
fx | number | X ratio of focal point. |
fy | number | Y ratio of focal point. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
imageSettings | anychart.graphics.vector.Fill | Object with settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
rowHoverFill
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Fill | Array.<(anychart.graphics.vector.GradientKey|string)> | '#edf8ff' | Color as an object, an array or a string. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Params:
Name | Type | Description |
---|---|---|
color | string | Color as a string. |
opacity | number | Color opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Gradient keys. |
angle | number | Gradient angle. |
mode | boolean | anychart.graphics.vector.Rect | Object | Gradient mode. |
opacity | number | Gradient opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Color-stop gradient keys. |
cx | number | X ratio of center radial gradient. |
cy | number | Y ratio of center radial gradient. |
mode | anychart.graphics.math.Rect | If defined then userSpaceOnUse mode, else objectBoundingBox. |
opacity | number | Opacity of the gradient. |
fx | number | X ratio of focal point. |
fy | number | Y ratio of focal point. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
imageSettings | anychart.graphics.vector.Fill | Object with settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
rowOddFill
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Fill | Array.<(anychart.graphics.vector.GradientKey|string)> | '#fff' | Color as an object, an array or a string. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Params:
Name | Type | Description |
---|---|---|
color | string | Color as a string. |
opacity | number | Color opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Gradient keys. |
angle | number | Gradient angle. |
mode | boolean | anychart.graphics.vector.Rect | Object | Gradient mode. |
opacity | number | Gradient opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Color-stop gradient keys. |
cx | number | X ratio of center radial gradient. |
cy | number | Y ratio of center radial gradient. |
mode | anychart.graphics.math.Rect | If defined then userSpaceOnUse mode, else objectBoundingBox. |
opacity | number | Opacity of the gradient. |
fx | number | X ratio of focal point. |
fy | number | Y ratio of focal point. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
imageSettings | anychart.graphics.vector.Fill | Object with settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
rowSelectedFill
Returns:
anychart.graphics.vector.Fill | string - Select row fill.Try it:
Params:
Name | Type | Default | Description |
---|---|---|---|
color | anychart.graphics.vector.Fill | Array.<(anychart.graphics.vector.GradientKey|string)> | function(){return this.sourceColor} | Color as an array, an object or a string. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Params:
Name | Type | Description |
---|---|---|
color | string | Color as a string. |
opacity | number | Color opacity. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Gradient keys. |
angle | number | Gradient angle. |
mode | boolean | anychart.graphics.vector.Rect | Object | Gradient mode. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
keys | Array.<(anychart.graphics.vector.GradientKey|string)> | Color-stop gradient keys. |
cx | number | X ratio of center radial gradient. |
cy | number | Y ratio of center radial gradient. |
mode | anychart.graphics.math.Rect | If defined then userSpaceOnUse mode, else objectBoundingBox. |
opacity | number | Opacity of the gradient. |
fx | number | X ratio of focal point. |
fy | number | Y ratio of focal point. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
Params:
Name | Type | Description |
---|---|---|
imageSettings | anychart.graphics.vector.Fill | Object with settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
startIndex
If full data doesn't fit into the visible area, DataGrid will show a range of display data started from this value.
Params:
Name | Type | Default | Description |
---|---|---|---|
index | number | 0 | Start index to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
tooltip
- null/boolean - disable or enable tooltip.
- object - sets tooltip settings.
Params:
Name | Type | Default | Description |
---|---|---|---|
settings | Object | boolean | null | true | Tooltip settings. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.top
Returns:
number | string | undefined - Element's top bound setting.Params:
Name | Type | Default | Description |
---|---|---|---|
top | number | string | null | null | Top bound setting for the element. |
Returns:
anychart.core.ui.DataGrid - Returns self for method chaining.Try it:
verticalOffset
Gantt Chart defines vertical offset for data grid automatically and you can't customize it by instance.
Params:
Name | Type | Default | Description |
---|---|---|---|
offset | number | 0 | Vertical offset to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it:
width
Returns:
number | string | undefined - Element's width setting.Params:
Name | Type | Default | Description |
---|---|---|---|
width | number | string | null | null | Width settings for the element. |
Returns:
anychart.core.ui.DataGrid - Returns self for method chaining.Try it:
zIndex
Params:
Name | Type | Default | Description |
---|---|---|---|
zIndex | number | 0 | Value to set. |
Returns:
anychart.core.ui.DataGrid - Self instance for method chaining.Try it: