Toggle navigation
ParamQuery Pro
Demos
Demos 9.x
Demos 8.x
Demos 7.x
Demos 6.x
Demos 5.6
Demos 5.1
Demos 4.x
Demos 3.3.x - 3.4.x
Demos 3.2
Demos 2.x
API
API 9.x
API 8.x
API 7.x
API 6.x
API 5.2.0 - 5.6.0
API 5.1
API 4.x
Excel formulas
Excel workbook
API 3.3.0 - 3.4.x
API 3.2.0
API 2.x
Upgrade
Upgrade 9.0.0
Upgrade 8.0.0
Upgrade 7.3.0
Upgrade 7.2.0
Upgrade 7.0.0
Upgrade 6.0.0
Upgrade 5.2.0
Upgrade 5.0.0
Upgrade 4.0.0
Upgrade 3.3.0
Upgrade 3.2.0
Upgrade 3.0.0
Upgrade 2.x
Tutorial
FAQ
Download / Buy
Forum
Contact
PQ
Grid
Best javascript grid
Options
animModel
autofill
autoRow
autoRowHead
autoRowSum
bootstrap
bubble
collapsible
colModel
align
attrHead
cb
cbId
cls
clsHead
collapsible
colModel
copy
dataIndx
dataType
deFormat
denyAgg
denyGroup
denyPivot
editable
editModel
editor
exportRender
filter
filterFn
format
formatRaw
formula
groupable
groupChange
halign
hidden
hvalign
maxWidth
menuIcon
menuUI
menuInClose
menuInDisable
menuInHide
minWidth
nodrag
nodrop
parent
pivotSortFn
postRender
render
renderLabel
resizable
showifOpen
sortable
sortType
style
styleHead
summary
title
tpCls
tpHide
type
useLabel
validations
valign
width
columnBorders
columnTemplate
contextMenu
copyModel
dataModel
beforeSend
contentType
data
dataType
error
getData
getUrl
location
method
postData
postDataOnce
recIndx
url
detailModel
dimsRelativeTo
dragColumns
draggable
dragModel
dropModel
editable
editModel
editor
fillHandle
filterModel
flex
formulas
formulasModel
freezeBorders
freezeCols
freezeRows
groupModel
height
historyModel
hoverMode
hwrap
locale
maxHeight
maxWidth
mergeCells
menuIcon
menuUI
minWidth
numberCell
pageModel
pasteModel
pics
postRenderInterval
reactive
resizable
roundCorners
rowBorders
rowHt
rowHtHead
rowHtSum
rowInit
rowResizable
scrollModel
selectionModel
showBottom
showHeader
showTitle
showTop
showToolbar
sortable
sortModel
stateColKeys
stateKeys
s
stringify
stripeRows
summaryData
summaryOptions
summaryTitle
title
toolbar
toolPanel
trackModel
treeModel
trigger
validation
virtualX
virtualY
warning
width
wrap
Methods
addClass
addNodes
addRow
attr
Checkbox
collapse
Columns
commit
copy
data
deleteNodes
deleteRow
destroy
disable
Drag
editCell
editFirstCellInRow
enable
expand
exportCsv
exportExcel
exportData
filter
flex
focus
Formulas
getDataCascade
getCell
getCellFilter
getCellHeader
getCellsByClass
getCellIndices
getChanges
getColIndx
getColumn
getCMPrimary
getColModel
getData
getEditCell
getEditCellData
getHeadIndices
getInstance
getRow
getRowData
getRowIndx
getRowsByClass
getState
getViewPortIndx
goToPage
Group
hasClass
hideLoading
History
importWb
isDirty
isEditable
isEditableCell
isEditableRow
isValid
isValidChange
loadState
moveNodes
off
on
one
option
pageData
pager
paste
Pic
quitEditMode
Range
refresh
refreshCell
refreshCM
refreshColumn
refreshDataAndView
refreshHeader
refreshHeaderFilter
refreshRow
refreshToolbar
refreshView
removeAttr
removeClass
removeData
reset
rollback
rowCollapse
rowExpand
rowInvalidate
saveEditCell
saveState
scrollCell
scrollColumn
scrollRow
scrollX
scrollXY
scrollY
search
Selection
SelectRow
setSelection
showLoading
sort
toggle
toolbar
ToolPanel
Tree
updateRow
widget
Events
autoRowHeight
beforeCellKeyDown
beforeCheck
beforeColAdd
beforeColMove
beforeColRemove
beforeColumnCollapse
beforeExport
beforeFillHandle
beforeFilter
beforeGroupExpand
beforeHideCols
beforePaste
beforeRowExpand
beforeRowSelect
beforeSort
beforeTableView
beforeTreeExpand
beforeValidate
cellBeforeSave
cellClick
cellKeyDown
cellDblClick
cellRightClick
cellSave
change
check
colAdd
colMove
colRemove
columnCollapse
columnDrag
columnOrder
columnResize
complete
context
create
dataReady
editorBegin
editorBlur
editorEnd
editorFocus
editorKeyDown
editorKeyPress
editorKeyUp
exportData
filter
group
groupChange
groupData
groupHideRows
groupOption
headerCellClick
headRightClick
hideCols
history
load
moveNode
pivotCM
refresh
refreshHeader
refreshRow
render
rowClick
rowDblClick
rowRightClick
rowSelect
scroll
scrollStop
selectChange
selectEnd
sort
toggle
treeExpand
Utility Methods
aggregate
deFormatNumber
exportWb
eachCell
importXl
formatNumber
tableToArray
toLetter
xmlToArray
xmlToJson
Version: 9.x
pqGrid
pqPager
pqSelect
ParamQuery Grid Pro API Documentation for Version 7.x
Options
Methods
Events
Utility Methods