ParamQuery Pro API Documentation

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
Tutorial
FAQ
Download / Buy
Forum

Contact

PQGrid 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
- 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

Copyright © 2012 - Paramvir Dhindsa (http://paramquery.com)