Object
GC.Spread.Sheets.Commands
Object
GC.Spread.Sheets.Commands
Name | Description | |
---|---|---|
autoFitColumn | Represents the command used to automatically resize the column in a sheet. | |
autoFitRow | Represents the command used to automatically resize the row in a sheet. | |
cancelInput | Represents the command used to stop cell editing and cancel input. | |
changeFormulaReference | Represents the command used to switch the formula reference between relative, absolute, and mixed when editing formulas. | |
clear | Represents the command used to clear the cell value. | |
clearAndEditing | Represents the command used to clear the active cell value and enters edit mode. | |
clearValues | Represents the command used to clear cell values on a worksheet. | |
clipboardPaste | Represents the command used for a Clipboard paste on the worksheet. | |
commitArrayFormula | Represents the command used to commit the cell editing and sets the array formula to the active range. | |
commitInputNavigationDown | Represents the command used to stop cell editing and moves the active cell to the next row. | |
commitInputNavigationUp | Represents the command used to stop cell editing and moves the active cell to the previous row. | |
copy | Represents the command used to copy the selected item text to the Clipboard. | |
cut | Represents the command used to cut the selected item text to the Clipboard. | |
deleteFloatingObjects | Represents the command for deleting the floating objects. | |
dragCopyFloatingObjects | Represents the command used to drag and copy the floating objects on the sheet. | |
dragDrop | Represents the command used to drag a range and drop it onto another range on the worksheet. | |
editCell | Represents the command used to apply a new value to a cell on the worksheet. | |
expandColumnOutline | Represents the command to expand or collapse a column range group. | |
expandColumnOutlineForLevel | Represents the command used to expand or collapse column range groups on the same level. | |
expandRowOutline | Represents the command to expand or collapse a row range group. | |
expandRowOutlineForLevel | Represents the command used to expand or collapse row range groups on the same level. | |
fill | Represents the command used to drag and fill a range on the sheet. | |
moveFloatingObjects | Represents the command for moving floating objects. | |
moveToNextCell | Represents the command used to move the active cell to the next cell. | |
moveToNextCellThenControl | Represents the command used to select the next control if the active cell is the last visible cell; otherwise, move the active cell to the next cell. | |
moveToPreviousCell | Represents the command used to move the active cell to the previous cell. | |
moveToPreviousCellThenControl | Represents the command used to select the previous control if the active cell is the first visible cell; otherwise, move the active cell to the previous cell. | |
navigationBottom | Represents the command used to move the active cell to the last row. | |
navigationDown | Represents the command used to move the active cell to the next row. | |
navigationEnd | Represents the command used to move the active cell to the last column. | |
navigationEnd2 | Represents the command used to move the active cell to the last column without regard to frozen trailing columns. | |
navigationFirst | Represents the command used to move the active cell to the first cell in the sheet. | |
navigationHome | Represents the command used to move the active cell to the first column. | |
navigationHome2 | Represents the command used to move the active cell to the first column without regard to frozen columns. | |
navigationLast | Represents the command used to move the active cell to the last cell in the sheet. | |
navigationLeft | Represents the command used to move the active cell to the previous column. | |
navigationNextSheet | Represents the command used to move the active sheet to the next sheet. | |
navigationPageDown | Represents the command used to move the active cell down one page of rows. | |
navigationPageUp | Represents the command used to move the active cell up one page of rows. | |
navigationPreviousSheet | Represents the command used to move the active sheet to the previous sheet. | |
navigationRight | Represents the command used to move the active cell to the next column. | |
navigationTop | Represents the command used to move the active cell to the first row. | |
navigationUp | Represents the command used to move the active cell to the previous row. | |
outlineColumn | Represents the command for grouping a column outline (range group) on a sheet. | |
outlineRow | Represents the command for grouping a row outline (range group) on a sheet. | |
paste | Represents the command used to paste the selected items from the Clipboard to the current sheet. | |
pasteFloatingObjects | Represents the command for pasting the floating objects on the sheet. | |
redo | Represents the command used to perform a redo of the most recently undone edit or action. | |
removeColumnOutline | Represents the command for ungrouping a column outline (range group) on a sheet. | |
removeRowOutline | Represents the command for ungrouping a row outline (range group) on a sheet. | |
renameSheet | Represents the command used to rename a worksheet. | |
resizeColumn | Represents the command used to resize the column on a worksheet. | |
resizeFloatingObjects | Represents the command for resizing floating objects. | |
resizeRow | Represents the command used to resize the row on a worksheet. | |
selectionBottom | Represents the command used to extend the selection to the last row. | |
selectionDown | Represents the command used to extend the selection down one row. | |
selectionEnd | Represents the command used to extend the selection to the last column. | |
selectionFirst | Represents the command used to extend the selection to the first cell. | |
selectionHome | Represents the command used to extend the selection to the first column. | |
selectionLast | Represents the command used to extend the selection to the last cell. | |
selectionLeft | Represents the command used to extend the selection one column to the left. | |
selectionPageDown | Represents the command used to extend the selection down to include one page of rows. | |
selectionPageUp | Represents the command used to extend the selection up to include one page of rows. | |
selectionRight | Represents the command used to extend the selection one column to the right. | |
selectionTop | Represents the command used to extend the selection to the first row. | |
selectionUp | Represents the command used to extend the selection up one row. | |
selectNextControl | Represents the command used to select the next control. | |
selectPreviousControl | Represents the command used to select the previous control. | |
undo | Represents the command used to perform an undo of the most recent edit or action. | |
zoom | Represents the command used to zoom the sheet. |
Name | Description | |
---|---|---|
endTransaction | Ends a transaction. During the transaction, the changes of the data model will be saved. | |
startTransaction | Starts a transaction. During the transaction, the changes of the data model will be saved. | |
undoTransaction | Undo the changes made in a transaction. |