SpreadJS Documentation
SpreadActions class
Represents all the SpreadJS undo and redo actions.
Syntax
var instance = new GcSpread.Sheets.SpreadActions();
function SpreadActions;
Inheritance Hierarchy

Object
   GcSpread.Sheets.SpreadActions

Constructors
 NameDescription
public ConstructorSpreadActions ConstructorRepresents all the SpreadJS undo and redo actions.  
Top
Methods
 NameDescription
public Methodstatic (Shared in Visual Basic)cancelInputStops cell editing and cancels input.  
public Methodstatic (Shared in Visual Basic)changeFormulaReferenceSwitches the formula reference between relative, absolute, and mixed when editing formulas.  
public Methodstatic (Shared in Visual Basic)clearClears the cell value.  
public Methodstatic (Shared in Visual Basic)clearAndEditingClears the active cell value and enters edit mode.  
public Methodstatic (Shared in Visual Basic)commitArrayFormulaCommits the cell editing and sets the array formula to the active range.  
public Methodstatic (Shared in Visual Basic)commitInputNavigationDownStops cell editing and moves the active cell to the next row.  
public Methodstatic (Shared in Visual Basic)commitInputNavigationUpStops cell editing and moves the active cell to the previous row.  
public Methodstatic (Shared in Visual Basic)copyCopies the selected item text to the Clipboard.  
public Methodstatic (Shared in Visual Basic)cutCuts the selected item text to the Clipboard.  
public Methodstatic (Shared in Visual Basic)moveToNextCellMoves the active cell to the next cell.  
public Methodstatic (Shared in Visual Basic)moveToNextCellThenControlIf the active cell is the last visible cell, selects the next control; otherwise, moves the active cell to the next cell.  
public Methodstatic (Shared in Visual Basic)moveToPreviousCellMoves the active cell to the previous cell.  
public Methodstatic (Shared in Visual Basic)moveToPreviousCellThenControlIf the active cell is the first visible cell, selects the previous control; otherwise, moves the active cell to the previous cell.  
public Methodstatic (Shared in Visual Basic)navigationBottomMoves the active cell to the last row.  
public Methodstatic (Shared in Visual Basic)navigationDownMoves the active cell to the next row.  
public Methodstatic (Shared in Visual Basic)navigationEndMoves the active cell to the last column.  
public Methodstatic (Shared in Visual Basic)navigationEnd2Moves the active cell to the last column without regard to frozen trailing columns.  
public Methodstatic (Shared in Visual Basic)navigationFirstMoves the active cell to the first cell in the sheetview.  
public Methodstatic (Shared in Visual Basic)navigationHomeMoves the active cell to the first column.  
public Methodstatic (Shared in Visual Basic)navigationHome2Moves the active cell to the first column without regard to frozen columns.  
public Methodstatic (Shared in Visual Basic)navigationLastMoves the active cell to the last cell in the sheetview.  
public Methodstatic (Shared in Visual Basic)navigationLeftMoves the active cell to the previous column.  
public Methodstatic (Shared in Visual Basic)navigationNextSheetMoves the active sheet to the next sheet.  
public Methodstatic (Shared in Visual Basic)navigationPageDownMoves the active cell down one page of rows.  
public Methodstatic (Shared in Visual Basic)navigationPageUpMoves the active cell up one page of rows.  
public Methodstatic (Shared in Visual Basic)navigationPreviousSheetMakes the active sheet to the previous sheet.  
public Methodstatic (Shared in Visual Basic)navigationRightMoves the active cell to the next column.  
public Methodstatic (Shared in Visual Basic)navigationTopMoves the active cell to the first row.  
public Methodstatic (Shared in Visual Basic)navigationUpMoves the active cell to the previous row.  
public Methodstatic (Shared in Visual Basic)pastePastes the selected items from the Clipboard to the current sheet.  
public Methodstatic (Shared in Visual Basic)redoPerforms a redo of the most recently undone edit or action.  
public Methodstatic (Shared in Visual Basic)selectionBottomExtends the selection to the last row.  
public Methodstatic (Shared in Visual Basic)selectionDownExtends the selection down one row.  
public Methodstatic (Shared in Visual Basic)selectionEndExtends the selection to the last column.  
public Methodstatic (Shared in Visual Basic)selectionFirstExtends the selection to the first cell.  
public Methodstatic (Shared in Visual Basic)selectionHomeExtends the selection to the first column.  
public Methodstatic (Shared in Visual Basic)selectionLastExtends the selection to the last cell.  
public Methodstatic (Shared in Visual Basic)selectionLeftExtends the selection one column to the left.  
public Methodstatic (Shared in Visual Basic)selectionPageDownExtends the selection down to include one page of rows.  
public Methodstatic (Shared in Visual Basic)selectionPageUpExtends the selection up to include one page of rows.  
public Methodstatic (Shared in Visual Basic)selectionRightExtends the selection one column to the right.  
public Methodstatic (Shared in Visual Basic)selectionTopExtends the selection to the first row.  
public Methodstatic (Shared in Visual Basic)selectionUpExtends the selection up one row.  
public Methodstatic (Shared in Visual Basic)selectNextControlSelects the next control.  
public Methodstatic (Shared in Visual Basic)selectPreviousControlSelects the previous control.  
public Methodstatic (Shared in Visual Basic)undoPerforms an undo of the most recent edit or action.  
Top
See Also

Reference

GcSpread.Sheets Namespace
addKeyMap Method

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.