Handsontable Plugin Hook Event

Hook plugin

AfterChange ( changes: Array , source: String ): The value of one or more cells is changed after the call

Changes: is a 2-dimensional array that contains ROW,PROP,OLDVAL,NEWVAL4 properties.

Source: Its value is a string and the value can be: alter,empty,populatefromarray,loaddata,autofill,paste

BeforeChange ( changes: Array , source: String ): Called before starting to change cells

Changes: is a 2-dimensional array, including the 4 public property columns [Row,prop,oldval,newval]

Source is the name of the resource being changed

Aftercellmetareset (): Call after resetting cell

Aftercolumnmove ( oldIndex: Number , newIndex: Number ): Triggered when column order is moved

Afterrowmove ( oldIndex: Number , newIndex: Number ): Call after line is moved

Afterrowresize ( col: Number , size: Number ): Call after row height change

Afterremovecol ( index: Number , amount: Number ): Called when one or more columns are moved

where index is the amount of the column to start moving, the total number of columns moved

Afterremoverow ( index: Number , amount: Number ): Called when one or more rows are moved

where index is the indexed of the moved row, amount is the total number of rows moved

Beforeremovecol ( index: Number , amount: Number ): Called before one or more columns are moved

Beforeremoverow ( index: Number , amount: Number ): Called before one or more lines are moved

Aftercolumnsort ( column: Number , order: Boolean ): Called after column sort

Beforecolumnsort ( column: Number , order: Boolean ): Called before column sort

Order: The value is true when ascending, false is descending

Aftercreatecol ( index: Number , amount: Number ): Called after a row has been added

Index: Indexes of new columns

Amount: Number of new columns

Aftercreaterow ( index: Number , amount: Number ): Called after a row has been added

Index: The indexes of the new row

Amount: Number of new rows

Aftergetcellmeta ( row: Number , col: Number cellProperties: Object ): Gets the configuration information of the cell after it is called

Beforegetcellmeta ( row: Number , col: Number , cellProperties: Object ): Called before getting cell properties

Aftersetcellmeta (,, row: Number col: Number key: String , value: * ): Called when the cell style is changed

Aftergetcolheader ( col: Number , TH: DOM Node ): Called after getting column header information

Aftergetcolwidth ( col: Number , response: Object ): Called After getting the column width

Aftercolumnresize ( col: Number , size: Number ): The column width is modified manually after the call

Aftercopylimit ( selectedRowsCount: Number , selectedColsCount: Number , copyRowsLimit: Number , copyColsLimit: Number )

copyRowsLimit called when or when copyColumnsLimit implemented

Afterdestroy (): Called when the Handsontable instance is destroyed

Afterinit (): handsontable instance is initialized after it is called

Beforeinit (): Called before handsontable instance is initialized

Beforeinitwalkontable (): Called before walkontable instance is initialized

Afterloaddata (): The new data is called after it is loaded into the data resource

Afteroncellcornermousedown (event): Called when the mouse clicks the corner of a cell

Afteroncellmousedown ( event: Object , coords: Object TD: Object ): Called after clicking on a cell or a wardrobe/column header

Note: The coordinates of the index are negative after clicking on the Wardrobe or column header. For example, if you click the column header cell (0,0), the coordinates after the call are (0,-1).

Afteroncellmouseover ( event: Object , coords: Object TD: Object ): Called when the mouse hovers over a cell or a wardrobe/column header

Note: The coordinates of the index are negative after clicking on the Wardrobe or column header. For example, if you click on a wardrobe cell (0,0), the coordinates after the call are (0,-1).

AfterRender ( isForced: Boolean ): Called after rendering the table

Isforced: When its value is true indicates that rendering is caused by altering the configuration or data, indicating that the render is caused by scrolling or moving, or by selecting

BeforeRender ( isForced: Boolean ): called before rendering

Afterrenderer (,,,, TD: Object row: Number col: Number prop: String value: String cellProperties: Object ): called after manual rendering

Beforechangerender (): Called before rendering is changed

Afterdeselect (): Called when the current cell is unchecked

Afterselection ( r: Number , c: Number , r2: Number , c2: Number ): Called when one or more cells are selected

where R: The starting row of the selected cell, R2: The terminating row of the selected cell

C: The starting column of the selected cell, C2: The terminating column of the selected cell

Afterselectionbyprop (,, r: Number p: String r2: Number , p2: String ): Called when a cell is selected by a property name

Afterselectionend (,, r: Number c: Number r2: Number , c2: Number ): Called when the mouse is lifted when the cell is selected

Afterselectionendbyprop (,, r: Number p: String r2: Number , p2: String ): Called when the mouse is lifted by selecting cells from the property

Afterupdatesettings (): Configuration parameter with modified call

aftervalidate ( isvalid:boolean ,   value:mixed , & nbsp Row:number ,   prop:string , source:string )

    Called when a validator is invoked, validating the result as the first parameter.

beforevalidate ( value:mixed ,   row:number ,   prop : String ,   source:string ): The authenticator was called before the event was called

 

beforeautofill ( start:object ,   end:object ,   Data:array ): Start auto-fill before transfer

   start: is a first populated cell object, for example: {row:4,col:3}

   end: Is the last populated cell object, for example: {row:7,col:5}

   data: is a 2-d array

beforekeydown ( event:object ): Press the button before it is called

Beforeset ( var: Object ): Called before a single configuration value is set

Beforesetrangeend ( coords: Array ): set to be called before the range ends

Coords: is the range coordinate

Modifycol ( col: Number ): Called when the column is modified

Modifyrow ( row: Number ): Called when rows are modified

Modifycolwidth ( width: Number , col: Number ): Called when column width is modified

Modifyrowheight ( height: Number , row: Number ): Called when row height is modified

Undoredo Plug-in

Clear (): Clear Revocation History

Isredoavailable (): Determine if Undo is available

Isundoavailable (): Determine if the undo operation is available

Undo (): Undo the last edit operation

Redo (): Cancel undo Operation

Handsontable Plugin Hook Event