Spread WPF 18
GrapeCity.Wpf.SpreadSheet Namespace / BuiltInCommands Class
Fields

In This Topic
    BuiltInCommands Class Members
    In This Topic

    The following tables list the members exposed by BuiltInCommands.

    Public Fields
     NameDescription
    Public Fieldstatic (Shared in Visual Basic)  
    Public Fieldstatic (Shared in Visual Basic)Apply the built-in cell style number format with two decimal places.  
    Public Fieldstatic (Shared in Visual Basic)Apply filter for current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Alt-=] Places SUM formula(s) below the selection.  
    Public Fieldstatic (Shared in Visual Basic)[Backspace] Enters cell edit mode with empty text in the cell.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-B] [Ctrl-2] Toggles bolding on and off for the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[F9] Calculate all worksheets in all open workbooks. [Shift-F9] Calculate the active worksheet only.  
    Public Fieldstatic (Shared in Visual Basic)[Esc] Pressing the escape key while editing a cell aborts the operation and leaves the cell in it's original state.  
    Public Fieldstatic (Shared in Visual Basic)Check AutoFilter and Sort availability.  
    Public Fieldstatic (Shared in Visual Basic)Check AutoFilter availability.  
    Public Fieldstatic (Shared in Visual Basic)Clear all from selected cells  
    Public Fieldstatic (Shared in Visual Basic)Clear sort filter for current selected autofilter.  
    Public Fieldstatic (Shared in Visual Basic)Clear format from selected cells  
    Public Fieldstatic (Shared in Visual Basic)  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-'] Copies the formula in the cell above to the active (current) current cell and leaves the cell in edit mode.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-C] Copy puts everything on the clipboard: text, formulas, formatting, borders, fills, etc.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-"] Copies the value in the cell above to the selected cell and leaves the cell in edit mode. If the cell above is a formula, only the value is copied.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-$] Apply the Currency format with two decimal places.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-X] Cut puts everything on the clipboard: text, formulas, formatting, borders, fills, etc.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-#] Apply the Date format with the day, month, and year.  
    Public Fieldstatic (Shared in Visual Basic)[Delete] Deletes the cell value.  
    Public Fieldstatic (Shared in Visual Basic)[F2] Enters cell edit mode with the cursor at the end of the last line of text in the cell.  
    Public Fieldstatic (Shared in Visual Basic)Start editing name of the active worksheet.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-Enter] Enter an array formula.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Enter] With multiple cells selected, this shortcut will enter the same data in all cells in the selection at once. With a single cell selected, this shortcut will enter a value and leave the same cell selected.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-Down] Extend the entire bottom edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-Left] Extend the entire left edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-Right] Extend the entire right edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-Up] Extend the entire top edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Shift-Down] Extend the entire bottom edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Shift-Left] Extend the entire left edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Shift-Right] Extend the entire right edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Shift-Up] Extend the entire top edge of the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Shift-PgDn] The distance moved down depends on the size of the worksheet window.  
    Public Fieldstatic (Shared in Visual Basic)[Alt-Shift-PgUp] Extends the current selection one screen to the left.  
    Public Fieldstatic (Shared in Visual Basic)[Alt-Shift-PgDn] Extends the current selection one screen to the right.  
    Public Fieldstatic (Shared in Visual Basic)[Shift-PgUp] The distance moved up depends on the size of the worksheet window.  
    Public Fieldstatic (Shared in Visual Basic)  
    Public Fieldstatic (Shared in Visual Basic)Adjust selection cells Vertical/Horizontal Alignment  
    Public Fieldstatic (Shared in Visual Basic)  
    Public Fieldstatic (Shared in Visual Basic)  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-1] Displays the Format Cells dialog box with the "last tab used" selected.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-~] Apply the General number format.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-0] Hide columns that intersect the current selection. [Ctrl-9] Hide rows that intersect the current selection. [Ctrl-Shift-0] Unhide any hidden columns that intersect the current selection. [Ctrl-Shift-9] Unhide any hidden rows that intersect the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-;] Insert the current date as a fixed value.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-:] Insert the current time as a fixed value.  
    Public Fieldstatic (Shared in Visual Basic)  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-I] [Ctrl+3] Toggles italics on and off for the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Enter] Cycle through every cell in a selection, moving from top left to bottom right. [Shift-Enter] Cycle through every cell in a selection, moving from bottom right to top left. [Tab] Move the active cell right one cell when there are multiple cells selected. [Shift-Tab] Move the active cell left one cell when there are multiple cells selected. [Ctrl-.] Cycle through every cell in a selection, moving from top left to bottom right.  
    Public Fieldstatic (Shared in Visual Basic)[Down] Moves current selection one cell below the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[PgDn] Moves current selection one screen below the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Down] If the active cell is empty, Spread will stop on the first non-empty cell below the active cell. If the active cell is non-empty, Spread will stop on the last non-empty cell below the active cell.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl + Down] Moves the current selection to the next non empty row in column data cell;  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl + Left] Moves current selection to the previous non empty column in row data cell;  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl + Right] Moves the current seleciton to the next non empty column in row data cell;  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl + Up] Moves the current selection to the previous non empty row in column data cell;  
    Public Fieldstatic (Shared in Visual Basic)[Left] Moves current selection one cell to the left of the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[Alt-PgUp] Moves current selection one screen to the left of the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Left] If the active cell is empty, Spread will stop on the first non-empty cell to the left. If the active cell is non-empty, Spread will stop on the last non-empty cell to the left..  
    Public Fieldstatic (Shared in Visual Basic)[Right] Moves current selection one cell to the right of the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[Alt-PgDn] Moves current selection one screen to the right of the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Right] If the active cell is empty, Spread will stop on the first non-empty cell to the right. If the active cell is non-empty, Spread will stop on the last non-empty cell to the right.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl+Home] If freeze pane is enabled, this shortcut will go to the upper left cell in the current pane. If freeze pane is not enabled, this shortcut will go the cell upper left cell in the worksheet (A1).  
    Public Fieldstatic (Shared in Visual Basic)[Home] Moves to beginning of row.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl+End] The last cell is at the intersection of the last row that contains data and the last column that contains data. The last cell may or may not contain data.  
    Public Fieldstatic (Shared in Visual Basic)[End] Moves to ending of row.  
    Public Fieldstatic (Shared in Visual Basic)[Up] Moves current selection one above the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[PgUp] Moves current selection one screen above the active selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Up] If the active cell is empty, Spread will stop on the first non-empty cell above the active cell. If the active cell is non-empty, Spread will stop on the last non-empty cell above the active cell.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-!] Apply the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.  
    Public Fieldstatic (Shared in Visual Basic)  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-V] Paste will paste everything on the clipboard, both content and formatting.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-%] Apply the Percentage format with no decimal places.  
    Public Fieldstatic (Shared in Visual Basic)Re-apply sort filter for current selected autofilter.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-^] Apply the Scientific number format with two decimal places.  
    Public Fieldstatic (Shared in Visual Basic)[Shift+Backspace] When multiple cells are selected, this shortcut will leave only the active cell selected.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Space] Select the entire column of the current selection. If the current selection spans multiple columns, all columns that intersect the selection will be selected.  
    Public Fieldstatic (Shared in Visual Basic)[Shift-Space] Select the entire row of the current selection. If the current selection spans multiple rows, all rows that intersect the selection will be selected.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-A] Select the entire table or worksheet.  
    Public Fieldstatic (Shared in Visual Basic)Bring shape forward.  
    Public Fieldstatic (Shared in Visual Basic)Bring shape to the front.  
    Public Fieldstatic (Shared in Visual Basic)Group the selected drawing object.  
    Public Fieldstatic (Shared in Visual Basic)Re-group the drawing objects.  
    Public Fieldstatic (Shared in Visual Basic)Send shape backward.  
    Public Fieldstatic (Shared in Visual Basic)Send shape to the back.  
    Public Fieldstatic (Shared in Visual Basic)Un-group the selected drawing object.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl+Backspace] Scroll the screen to show the active cell on the worksheet.  
    Public Fieldstatic (Shared in Visual Basic)[Alt - Down] Show subeditor if celltype has sub editor.  
    Public Fieldstatic (Shared in Visual Basic)Sort by Ascending/Descending for current selection.  
    Public Fieldstatic (Shared in Visual Basic)Enters a value and leave the same cell selected.  
    Public Fieldstatic (Shared in Visual Basic)Enters a value and leave the same sheet's tab selected.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-5] Toggles strikethrough on and off for the current selection.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-Shift-@] Apply the Time format with the hour and minute, and indicate A.M. or P.M.  
    Public Fieldstatic (Shared in Visual Basic)[Ctrl-U] [Ctrl+4] Toggles underlining on and off for the current selection.  
    Public Fieldstatic (Shared in Visual Basic)  
    Top
    See Also