Home
Docs
Download
Pricing
GitHub
Sign in

Getting started
Basic usage
Developer guide
Community
- GitHub
- Forum

Wrappers

Wrapper for React

Installation
Basic examples
Using the HotColumn component
Custom Context Menu example
Custom editor example
Custom renderer example
Language change example
Redux example
Referencing the Handsontable instance

Wrapper for Angular

Installation
Basic example
Custom ID
Custom Context Menu example
Custom editor example
Custom renderer example
Language change example
Referencing the Handsontable instance

Wrapper for Vue

Installation
Basic example
Using the hot-column component
Custom ID, Class, Style and other attributes
Custom Context Menu example
Custom editor example
Custom renderer example
Language change example
Vuex example
Referencing the Handsontable instance

Demos

Rows and columns

Scrolling
Fixing
Resizing
Moving
Header tooltips
Pre-populating rows
Stretching columns
Freezing columns
Fixing bottom rows
Hiding rows
Hiding columns
Trimming rows
Bind rows with headers
Collapsing columns
Nested headers
Dropdown menu

Data operations

Sorting
Multi-column sorting
Searching
Filtering
Summary calculations

Cell features

Data validation
Auto fill
Merged cells
Alignment
Read-only
Disabled editing

Cell types

Custom renderers
Numeric
Date
Time
Checkbox
Select
Dropdown
Autocomplete
Password
Handsontable

Utilities

Context menu
Custom buttons
Spreadsheet icons
Comments
Copy & Paste
Export to file

Appearance

Conditional formatting
Customizing borders
Selecting ranges
Highlighting selection
Mobiles and tablets

Experimental features

Gantt chart
Formula support
Nested rows

API Reference

Core

Core

Basic usage

Methods

Hooks

Basic usage

Methods

add
createEmptyBucket
deregister
destroy
getBucket
getRegistered
has
isRegistered
once
register
remove
run

Events

Options

Basic usage

Members

Methods

isEmptyCol
isEmptyRow

Plugins

AutoColumnSize

Basic usage

Members

inProgress
widths

Methods

calculateAllColumnsWidth
calculateColumnsWidth
clearCache
destroy
disablePlugin
enablePlugin
getColumnWidth
getFirstVisibleColumn
getLastVisibleColumn
getSyncCalculationLimit
isEnabled
isNeedRecalculate
recalculateAllColumnsWidth
updatePlugin

AutoRowSize

Basic usage

Members

heights
inProgress

Methods

calculateAllRowsHeight
calculateRowsHeight
clearCache
clearCacheByRange
destroy
disablePlugin
enablePlugin
getColumnHeaderHeight
getFirstVisibleRow
getLastVisibleRow
getRowHeight
getSyncCalculationLimit
isEnabled
isNeedRecalculate
recalculateAllRowsHeight

Autofill

Basic usage

Members

autoInsertRow

Methods

destroy
disablePlugin
enablePlugin
isEnabled
updatePlugin

BindRowsWithHeaders

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled
updatePlugin

CollapsibleColumns

Basic usage

Methods

collapseAll
collapseSection
destroy
disablePlugin
enablePlugin
expandAll
expandSection
isEnabled
toggleAllCollapsibleSections
toggleCollapsibleSection

ColumnSorting

Basic usage

Methods

clearSort
destroy
disablePlugin
enablePlugin
getSortConfig
isEnabled
isSorted
setSortConfig
sort

ColumnSummary

Basic usage

Methods

disablePlugin
enablePlugin
isEnabled

Comments

Basic usage

Members

range

Methods

clearRange
destroy
disablePlugin
enablePlugin
getComment
getCommentAtCell
getCommentMeta
hide
isEnabled
refreshEditor
removeComment
removeCommentAtCell
setComment
setCommentAtCell
setRange
show
showAtCell
updateCommentMeta
updatePlugin

ContextMenu

Basic usage

Members

DEFAULT_ITEMS

Methods

close
destroy
disablePlugin
enablePlugin
executeCommand
isEnabled
open
updatePlugin

CopyPaste

Basic usage

Members

columnsLimit
focusableElement
pasteMode
rowsLimit

Methods

copy
cut
destroy
disablePlugin
enablePlugin
getRangedCopyableData
getRangedData
isEnabled
paste
setCopyableText
updatePlugin

CustomBorders

Basic usage

Methods

clearBorders
destroy
disablePlugin
enablePlugin
getBorders
isEnabled
setBorders
updatePlugin

DragToScroll

Basic usage

Members

boundaries

Methods

check
destroy
disablePlugin
enablePlugin
isEnabled
setBoundaries
setCallback
updatePlugin

DropdownMenu

Basic usage

Members

DEFAULT_ITEMS

Methods

close
destroy
disablePlugin
enablePlugin
executeCommand
isEnabled
open
updatePlugin

ExportFile

Basic usage

Typedefs

ExportOptions

Methods

downloadFile
exportAsBlob
exportAsString
isEnabled

Filters

Basic usage

Methods

addCondition
clearConditions
destroy
disablePlugin
enablePlugin
filter
getDataMapAtColumn
getSelectedColumn
isEnabled
removeConditions

HeaderTooltips

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled

HiddenColumns

Basic usage

Methods

destroy
disablePlugin
enablePlugin
hideColumn
hideColumns
isColumnDataValid
isEnabled
isHidden
showColumn
showColumns
updatePlugin

HiddenRows

Basic usage

Methods

destroy
disablePlugin
enablePlugin
hideRow
hideRows
isEnabled
isHidden
isRowDataValid
showRow
showRows
updatePlugin

ManualColumnFreeze

Basic usage

Methods

destroy
disablePlugin
enablePlugin
freezeColumn
isEnabled
unfreezeColumn
updatePlugin

ManualColumnMove

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled
moveColumn
moveColumns
persistentStateLoad
persistentStateSave
updatePlugin

ManualColumnResize

Basic usage

Methods

clearManualSize
disablePlugin
enablePlugin
isEnabled
loadManualColumnWidths
saveManualColumnWidths
setManualSize
updatePlugin

ManualRowMove

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled
moveRow
moveRows
persistentStateLoad
persistentStateSave
updatePlugin

ManualRowResize

Basic usage

Methods

disablePlugin
enablePlugin
isEnabled
loadManualRowHeights
saveManualRowHeights
setManualSize
updatePlugin

MergeCells

Basic usage

Methods

clearCollections
disablePlugin
enablePlugin
isEnabled
merge
mergeSelection
unmerge
unmergeSelection
updatePlugin

MultiColumnSorting

Basic usage

Methods

clearSort
disablePlugin
enablePlugin
getSortConfig
isEnabled
isSorted
setSortConfig
sort

NestedHeaders

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled
updatePlugin

ObserveChanges

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled

PersistentState

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled
loadValue
resetValue
saveValue
updatePlugin

Search

Basic usage

Methods

destroy
disablePlugin
enablePlugin
getCallback
getQueryMethod
getSearchResultClass
isEnabled
query
setCallback
setQueryMethod
setSearchResultClass
updatePlugin

TrimRows

Basic usage

Methods

destroy
disablePlugin
enablePlugin
isEnabled
isTrimmed
isValidConfig
trimRow
trimRows
untrimAll
untrimRow
untrimRows
updatePlugin

UndoRedo

Basic usage

Methods

clear
isRedoAvailable
isUndoAvailable
redo
undo

Experimental

Formulas

Basic usage

Methods

destroy
disablePlugin
enablePlugin
getCellValue
getVariable
hasComputedCellValue
isEnabled
recalculate
recalculateFull
recalculateOptimized
setVariable

GanttChart

Basic usage

Methods

addRangeBar
cacheRangeBarMeta
checkDependencies
destroy
disablePlugin
enablePlugin
getRangeBarCoordinates
getRangeBarData
isEnabled
removeAllRangeBars
removeRangeBarByColumn
removeRangeBarByDate
setRangeBarColors
setYear
updatePlugin
updateRangeBarData

NestedRows

Basic usage

Methods

disablePlugin
enablePlugin
isEnabled
updatePlugin

No results found

Highlighting selection

Use options currentRowClassName and currentColumnClassName

This documentation is licensed under CC BY 4.0. Terms of use

Tutorial: Highlighting selection