Check documentation for the latest version of dhtmlxSuite Methods DHTMLX Docs

Methods

addRow adds a row to the grid
addRowFromClipboard allows the user to add a new row from clipboard
adjustColumnSize adjusts a column's size to make all content visible
attachEvent adds any user-defined handler to available events
attachFooter attaches an additional line to the footer
attachHeader attaches an additional line to the header
attachToObject attaches Grid to some object in DOM
cellById gets dhtmlXGridCellObject object
cellByIndex gets dhtmlXGridCellObject object
cellToClipboard copies the value of a cell to the clipboard
cells gets dhtmlXGridCellObject object
cells2 gets dhtmlXGridCellObject object
changePage changes the current page in grid
changePageRelative changes the current page in grid
changeRowId changes id of the row to the new one
checkAll checks all checkboxes in the grid
clearAll deletes all rows in the grid
clearAndLoad clears the existing grid state and loads data from an external file ( xml, json, jsarray, csv )
clearChangedState clears wasChanged state for all cells in grid (and wasAdded state as well, if called with a parameter)
clearConfigCookie clears cookie with grid config details
clearSelection removes selection from the grid
collapseAllGroups collapses all groups
collapseColumns collapses a group of columns
collapseGroup collapses a group of rows
collectValues gets all possible values of a column
copyBlockToClipboard copies the content of a block selection into clipboard in CSV format (delimiter as set for CSV serialization)
copyRowContent copies a row's content to another existing row
deleteColumn deletes a column
deleteRow deletes a row from the grid
deleteSelectedRows deletes selected row(s)
destructor destructor, removes the grid and cleans used memory
detachEvent removes an event handler
detachFooter removes a footer line from the grid (opposite to attachFooter)
detachHeader removes a header line from the grid (opposite to attachHeader)
disableCell disables the specified cell
disableUndoRedo disables the Undo/Redo functionality in the grid
doRedo executes the redo operation
doUndo executes the undo operation
doesRowExist determines if a row with the specified id exists
editCell creates an Editor object and switches the selected cell to the edit mode, if allowed
editStop returns the value from the editor(if presents) to the cell and closes the editor
enableAccessKeyMap enables Access keyboard navigation
enableAlterCss sets css styles for even/odd rows
enableAutoHeight enables autoheight of the grid
enableAutoHiddenColumnsSaving enables automatic saving of a column's state ( hidden/shown )
enableAutoSaving enables automatic saving of size, sorting order and columns order
enableAutoSizeSaving enables automatic size saving to cookie
enableAutoWidth changes the size of grid's container on the fly to fit total width of grid's columns
enableBlockSelection enables block selection mode in grid
enableCSVAutoID enables the mode in which IDs for the rows loaded from CSV are autogenerated
enableCSVHeader enables recognizing the first row in CSV as the header
enableCellIds enables/disables unique ids for cells (id will be automatically created by the template: 'c_[RowId]_[colIndex]')
enableColSpan enables/disables colspan support
enableColumnAutoSize adjusts column size to make all content visible on the header doublclick
enableColumnMove enables the move column functionality
enableContextMenu enables/disables context menu
enableDistributedParsing enables/disables distributed parsing (rows are parsed portion by portion with some timeout)
enableDragAndDrop enables/disables drag-and-drop
enableDragOrder switches to the mode in which dragged items drop in the target location in the same order as they were in the source grid
enableEditEvents enables/disables events which invoke excell editing
enableEditTabOnly enables/disables the mode when readonly cell is not available with tab
enableExcelKeyMap enables Excel keyboard navigation
enableHeaderImages specifies if the values passed to Header are images' file names
enableHeaderMenu enables a popup menu which allows hidding/showing columns
enableKeyboardSupport enables/disables hot keys in grid
enableLightMouseNavigation enables/disables light mouse navigation mode (row selection with mouse over, editing with single click)
enableMarkedCells sets the marked cells support to enabled/disabled state
enableMathEditing enables/disables editing of math cells
enableMathSerialization enables/disables serialization of math formulas
enableMercyDrag enables drag without removing (copy instead of move)
enableMultiline sets the multiline rows support to enabled/disabled state
enableMultiselect sets multiselect mode to enabled or disabled state
enableOrderSaving enables automatic column order saving to cookie
enablePaging enables smart paging mode
enablePreRendering enables pre-rendering rows during scrolling.
enableResizing enables/disables resizing for specified colums
enableRowsHover enables/disables hovering on a row on mouse over
enableRowspan enables rowspan in treegrid
enableSmartRendering enables smart rendering mode
enableSortingSaving enables automatic saving of the sorting state to cookie
enableStableSorting enables stable sorting algorithm
enableTooltips enables/disables tooltips for specified colums
enableUndoRedo enables the Undo/Redo functionality in grid
enableValidation enable validation in the grid
expandAllGroups expands all groups
expandColumns expands a group of columns
expandGroup expands a group of rows
filterBy filters Grid by mask
filterByAll forces Grid filtering by registered inputs (created by # starting shortcuts, or by the makeFilter function)
findCell finds cell in the grid by its value
forEachCell executes the code for each cell in a row
forEachRow executes code for each row in the grid
forEachRowInGroup iterates through all rows in some group
forceFullLoading loads all data in the grid, which is in dyn. srnd or dyn. paging mode
forceLabelSelection affects block selection, so it will copy/paste only the visible text, not the values behind
getAllRowIds gets the list of all row ids in the grid
getCellExcellType returns the excell type of the cell in question
getChangedRows gets the list of IDs of the changed rows
getCheckedRows gets the list of ids of all the rows with checked exCell in the specified column
getColIndexById gets column index by column id
getColLabel gets the label of the column specified by index
getColType gets column type by column index
getColTypeById gets the column type by its ID
getColWidth gets the width of the specified column in pixels
getColumnCombo returns dhtmlXCombo column object
getColumnId gets the id of the column specified by index
getColumnLabel gets the label of the column specified by index
getColumnsNum returns the number of columns in the grid (including [hidden columns](setColumnHidden))
getCombo gets Combo object of the specified column
getCustomCombo gets the combobox specific for the cell in question
getFilterElement returns the input object of the filter linked to the column in question by index
getFilterElementById returns the input object of the filter linked to the column in question by id
getFooterLabel gets the label of the footer specified by index
getHeaderMenu returns dhtmlXMenu object of the grid header menu
getMarked returns an array of marked cells (pairs of row id and column index)
getRedo gets length of available ReDo operations
getRowAttribute returns the row attribute's value which was set in the XML tag
getRowData returns the row data
getRowId gets the row id by the row index
getRowIndex gets the row index by the row id (grid only)
getRowsNum returns the number of rows in the grid (in case of dynamic mode it will return an expected number of rows)
getSelectedBlock returns the attributes of the current block selection
getSelectedCellIndex returns the index of the selected cell or -1, if there is no selected cell
getSelectedRowId returns the id of the selected row (a list of ids with default delimiter) or null, if there are no selected rows
getSortingState gets the sorting state of the grid
getStateOfView returns details about current grid state
getUndo gets length of available UnDo operations
getUserData gets user data
gridFromClipboard initializes grid from CSV stored in the clipboard
gridToClipboard copies grid in CSV to the clipboard
gridToGrid redefine this method in your code to specify how grid row values should be used in another grid
gridToTreeElement redefine this method in your code to define how grid row values should be used in tree
groupBy groups grid content by values of the specified column
groupStat returns the result of aggregation for a column
init initializes grid
insertColumn adds a new column to the grid
isColumnHidden gets the shown/hidden status of the column
load loads data from an external file ( xml, json, jsarray, csv )
loadHiddenColumnsFromCookie loads the sorting order from cookie
loadOpenStates loads open state of TreeGrid into cookie
loadOrderFromCookie loads sorting order from cookie
loadSizeFromCookie loads grid layout from cookie
loadSortingFromCookie loads sorting order from cookie
lockRow locks/unlocks a row for editing
makeFilter makes a filter from any input element (text filter), select (dropdown) or DIV (combobox based on dhtmlxCombo)
makeSearch makes a search box (sets selection on the row with the found value) from any input
mark marks/unmarks the specified cell
moveColumn moves the column of the specified index to a new position
moveRow moves a row
moveRowDown moves a row one position down, if possible
moveRowTo moves a row
moveRowUp moves a row one position up, if possible
parse loads data from a local data source (XML string, CSV string, XML island, XML object, JSON object, javascript array)
pasteBlockFromClipboard pastes the content of the clipboard into a block selection of the grid
post allows sending POST requests by loading data from external file ( xml, json, jsarray, csv )
preventIECaching prevents caching in IE by adding random values to URL string
printView generates the print friendly view
refreshComboColumn updates the cells of the combo column
refreshFilters refreshes the lists of values in all the filters created by shortcuts or by makeFilter calls
refreshMath restores math after column moving
registerCList registers an array of options for a multiselect column ("clist") of the grid
resetColumnsOrder resets the default order of grid columns after swapping
rowToClipboard copies the value of a row to the clipboard
rowToDragElement redefine this method in your code to specify how grid row values should be displayed during the dragging
saveHiddenColumnsToCookie saves hidden columns to cookie
saveOpenStates stores open state of TreeGrid in cookie
saveOrderToCookie saves the columns' order to cookie
saveSizeToCookie saves grid layout to cookie
saveSortingToCookie saves the sorting order to cookie
selectAll selects all rows in the grid, doesn't trigger any events
selectBlock selects a block in the Grid, according to the specified rows' ids and columns' indexes
selectCell sets selection to the specified row-cell
selectRow selects a row (and its first cell)
selectRowById selects row by ID
serialize gets actual xml of the grid
serializeToCSV serializes to CSV string
setActive sets the grid active to make key navigation possible
setAwaitedRowHeight applies a custom height of a row which will be used in the smart rendering mode for row calculation
setCSVDelimiter changes csv delimiter
setCellExcellType sets an excell type for the cell in question
setCellTextStyle sets a style for a cell
setCheckedRows sets a value for all checkboxes in the specified column
setColAlign aligns values in columns
setColLabel sets a new label for the column header
setColSorting sets the types of column sort
setColTypes sets column types
setColVAlign sets vertical align for columns
setColValidators assigns validators to the related column
setColWidth sets the width for the specified column in pixels (doesn't work with the percentage based grid)
setColspan dynamically sets colspan in a row starting from the specified column index
setColumnColor colors the background of columns
setColumnExcellType sets an excell type for all the cells in the specified column
setColumnHidden hides/shows a column
setColumnId sets id for the specified column
setColumnIds sets id for every column
setColumnLabel sets a new column header label
setColumnMinWidth sets the minimum column width (works only for manual resizing)
setColumnsVisibility sets the list of visible/hidden columns
setCustomSorting sets a custom sorting
setDateFormat sets a mask for date formatting in the grid (works for "dhxCalendar" and "dhxCalendarA" types only)
setDelimiter sets a delimiter character used in list values (default is ",")
setDragBehavior sets Drag-And-Drop behavior
setEditable manages the editability of the grid
setExternalTabOrder sets elements which get focus when the Tab button is pressed in the last or in the first (Tab+Shift) cell
setFieldName allows defining an input's name which will be used for data sending,
setFooterLabel sets a new label for a cell in the footer
setHeader sets the header label and default params for new headers
setIconsPath sets the path to external images used in the grid (tree and img column type)
setIconset sets the font awesome iconset
setImagesPath defines the path to the imgs folder
setInitWidths sets the width of columns in pixels
setInitWidthsP sets the width of columns in percents
setMathRound enables/disables rounding during the math calculations
setNoHeader creates a grid without header
setNumberFormat sets a mask for formatting numeric data (works for **"edn"**, **"ron"** excell only)
setPagingSkin allows setting a custom paging skin
setPagingTemplates allows setting paging templates for the default skin
setPagingWTMode configures the paging with toolbar mode
setRowAttribute sets a row attribute
setRowColor sets the background color of a row (via the bgcolor attribute)
setRowData sets new data for row's columns
setRowExcellType sets an excell type for all cells in the specified row
setRowHidden hides/shows a row
setRowId sets a new id for a row by its index
setRowTextBold sets the text of a row BOLD
setRowTextNormal sets the text weight of a row to normal
setRowTextStyle sets the style of a row
setRowspan sets rowspan of the specified length starting from the specified cell
setSerializableColumns specifies which column must be serialized (if you don't use this method, all columns will be serialized)
setSerializationLevel configures XML serialization
setSizes resets sizes of the grid's elements
setSkin sets one of the predefined skins ("material" (default),"skyblue","web","terrace")
setSortImgState sets the position and visibility of a sort arrow
setStyle modifies the default style of the grid and its elements
setSubGrid attaches a grid-like editor to a grid's column
setSubTree attaches a tree-like editor to a grid's column
setTabOrder sets the tab order of columns
setUserData sets user data for a row
setXMLAutoLoading enables dynamic loading from XML
showRow scrolls a grid to make the specified row visible
sortRows sorts the Grid by the specified column
splitAt splits the grid
startFastOperations starts the fast operation mode
stopFastOperations turns off the fast operation mode, needs to be executed to normalize the view
submitAddedRows includes additional data with the info about which rows were added and which ones deleted, enabled by default
submitColumns sets the list of columns the data of which will be updated
submitOnlyChanged includes only the changed rows into the form submit
submitOnlyRowID includes only rows' IDS into the form submit
submitOnlySelected includes only the selected rows into the form submit
submitSerialization includes a serialized grid as a part of the form submit
toExcel exports data from dhtmxlGrid to an Excel document
toPDF exports data from dhtmxlGrid to a PDF document
treeToGridElement redefine this method in your code to specify how tree node values should be used in the grid
uid returns the unique ID
unGroup ungroups the grid to return it into the plain view
uncheckAll unchecks all checkboxes of the grid
unmarkAll removes selection from all the marked cells
unselectRowById unselects row by ID
updateCellFromClipboard sets the value of a cell from the clipboard
updateFromXML refreshes grid from XML (doesn't work for buffering, tree grid or rows in smart rendering mode)
updateGroups forces grid grouping by registered parameters
updateRowFromClipboard sets the value of a row from the clipboard
validateCell forces validation of a specific cell
Back to top