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
autofill
autoRow
autoRowHead
autoRowSum
bootstrap
bubble
collapsible
colModel
align
cb
cls
collapsible
colModel
copy
dataIndx
dataType
denyAgg
denyGroup
denyPivot
editable
editModel
editor
exportRender
filter
format
formula
groupable
groupChange
halign
hidden
maxWidth
minWidth
nodrag
nodrop
parent
postRender
render
resizable
sortable
sortType
summary
title
tpCls
tpHide
type
validations
width
columnBorders
columnTemplate
copyModel
dataModel
beforeSend
contentType
data
dataType
error
getData
getUrl
location
method
postData
postDataOnce
recIndx
url
detailModel
dragColumns
draggable
editable
editModel
editor
fillHandle
filterModel
flex
formulas
formulasModel
freezeBorders
freezeCols
freezeRows
groupModel
height
historyModel
hoverMode
hwrap
maxHeight
maxWidth
mergeCells
minWidth
numberCell
pageModel
pasteModel
postRenderInterval
resizable
roundCorners
rowBorders
rowHt
rowHtHead
rowHtSum
rowInit
scrollModel
selectionModel
showBottom
showHeader
showTitle
showTop
showToolbar
sortable
sortModel
stringify
stripeRows
summaryData
summaryOptions
summaryTitle
swipeModel
title
toolbar
toolPanel
trackModel
treeModel
trigger
validation
virtualX
virtualY
warning
width
wrap
Methods
addClass
addRow
attr
collapse
Columns
commit
copy
createTable
data
deleteRow
destroy
disable
editCell
editFirstCellInRow
enable
expand
exportCsv
exportExcel
exportData
filter
flex
focus
getCell
getCellHeader
getCellsByClass
getCellIndices
getChanges
getColIndx
getColumn
getColModel
getData
getEditCell
getEditCellData
getInstance
getRow
getRowData
getRowIndx
getRowsByClass
getViewPortIndx
goToPage
Group
hasClass
hideLoading
History
hscrollbar
importWb
isDirty
isEditableRow
isEditableCell
isValid
isValidChange
loadState
off
on
one
option
pageData
pager
paste
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
vscrollbar
widget
Events
beforeCheck
beforeColumnCollapse
beforeExport
beforeFillHandle
beforeGroupExpand
beforePaste
beforeRowExpand
beforeRowSelect
beforeSort
beforeTableView
beforeTreeExpand
beforeValidate
cellBeforeSave
cellClick
cellKeyDown
cellDblClick
cellRightClick
cellSave
change
check
columnCollapse
columnDrag
columnOrder
columnResize
complete
create
dataReady
editorBegin
editorBlur
editorEnd
editorFocus
editorKeyDown
editorKeyPress
editorKeyUp
exportData
filter
group
groupChange
groupOption
headerCellClick
history
load
refresh
refreshHeader
refreshRow
render
rowClick
rowDblClick
rowRightClick
rowSelect
scroll
scrollStop
selectChange
selectEnd
sort
toggle
treeExpand
Utility Methods
aggregate
exportWb
eachCell
importXl
formatNumber
tableToArray
xmlToArray
xmlToJson
Version: 5.1.0
pqGrid
pqPager
pqSelect
ParamQuery Grid Pro API Documentation for Version 5.x
Options
Methods
Events
Utility Methods