[]
        
(Showing Draft Content)

FarPoint.Win.Spread.SpreadActions

SpreadActions Class

Represents the actions available for input maps.

Inheritance
SpreadActions
Namespace: FarPoint.Win.Spread
Assembly: FarPoint.Win.Spread.dll
Syntax
public class SpreadActions
Public Class SpreadActions

Constructors

Name Description
SpreadActions()

Initializes a new instance of the SpreadActions class.

Fields

Name Description
ActivateNextChild

Activates the next object in the draw order.

ActivateNextShape

Activates the next shape in the draw order.

ActivatePreviousChild

Activates the previous object in the draw order.

ActivatePreviousShape

Activates the previous shape in the draw order.

AutoSum

Enters a formula (that uses the SUM function) to sum the numbers automatically.

CSEStopEditing

Turns off edit mode.

CalculateEntireWorkbook

Calculate the entire workbook.

CalculateSheet

Calculate the entire sheet.

CancelCommentThreaded

Cancel adding/replying a threaded comment.

CancelEditing

Turns off edit mode and removes the changes.

CancelProcessing

Cancel all processing.

ClearCell

Removes all of the contents of the active cell.

ClearSelectedCells

Removes all of the contents of the selected cell.

ClearSelectedCellsData

Clears the selected cells which have data or formulas.

ClipboardCopy

Copies the selected items to the Clipboard.

ClipboardCopyActiveSheet

Copies the active sheet to the Clipboard.

ClipboardCopyAsString

Copies the selected items to the Clipboard as a string.

ClipboardCopyAsStringSkipHidden

Copies the selected items to the Clipboard as a string skipping hidden rows and columns.

ClipboardCopyFormatting

Copies only the selected items' formatting to the Clipboard.

ClipboardCopyFormulas

Copies only the selected items' formulas to the Clipboard.

ClipboardCopyShape

Copies the active shape to the Clipboard.

ClipboardCopyValues

Copies only the selected items' values to the Clipboard.

ClipboardCut

Cuts the selected items to the Clipboard.

ClipboardCutActiveSheet

Cuts the active sheet to the Clipboard.

ClipboardCutAsString

Cuts the selected items to the Clipboard as a string.

ClipboardCutAsStringSkipHidden

Cuts the selected items to the Clipboard as a string skipping hidden cells.

ClipboardCutDataOnly

Cuts only the data of selected items to the Clipboard.

ClipboardCutFormatting

Cuts the selected items formatting to the Clipboard.

ClipboardCutFormulas

Cuts the selected items formulas to the Clipboard.

ClipboardCutShape

Cuts the active shape to the Clipboard.

ClipboardCutValues

Cuts the selected items values to the Clipboard.

ClipboardInsert

Inserts the clipboard data to range of cells.

ClipboardPaste

Pastes the selected items from the Clipboard to the current sheet based on the setting of ClipboardPasteOptions.

ClipboardPasteAll

Pastes everything from the Clipboard (data and formatting) to the current sheet.

Pastes only the link references from the Clipboard to the current sheet.

ClipboardPasteAsString

Pastes only the text from the Clipboard to the current cell.

ClipboardPasteAsStringSkipHidden

Pastes only the text from the Clipboard to the current cell, skipping hidden rows and columns.

ClipboardPasteFormatting

Pastes only the formatting from the Clipboard to the current sheet.

ClipboardPasteFormulas

Pastes only the formulas from the Clipboard to the current sheet.

ClipboardPasteShape

Pastes the shape from the Clipboard.

ClipboardPasteSheet

Pastes a sheet from the clipboard.

ClipboardPasteValues

Pastes only the values from the Clipboard to the current sheet.

ComboShowList

Displays the combo box list of the current cell.

CreateComment

Adds a comment to the cell.

CreateTable

Create a table from a cell range.

DataValidationShowList

Displays the data validation list of the current cell.

DateTimeNow

Sets the cell's value to the date-time value of Now.

DeactivateChild

Deactivates the currently selected object.

DeactivateShape

Deactivates the currently selected shape.

DecreaseChildHeight

Decreases the height of the active object.

DecreaseChildWidth

Decreases the width of the active object.

DecreaseShapeHeight

Decreases the height of the active shape.

DecreaseShapeWidth

Decreases the width of the active shape.

DeleteCells

Deletes a range of cells from the worksheet.

DeleteChild

Deletes the active object.

DeleteCommentThreaded

Deletes a new modern threaded comment.

DeleteShape

Deletes the active shape.

DisplayFormulas

Display the formula in each cell instead of the resulting value.

EditMultipleCells

Edits multiple cells.

ExtendToFirstCell

Extends the selection to include the first cell.

ExtendToFirstColumn

Extends the selection to the first column.

ExtendToFirstItem

Extends the selection to include the first item.

ExtendToFirstRow

Extends the selection to the first row.

ExtendToLastCell

Extends the selection to include the last cell.

ExtendToLastCellWithData

Extends the selection to include the last cell that contains data.

ExtendToLastColumn

Extends the selection to the last column.

ExtendToLastColumnWithData

Extends the selection to the last column that contains data.

ExtendToLastItem

Extends the selection to include the last item.

ExtendToLastItemWithData

Extends the selection to include the last item with data.

ExtendToLastRow

Extends the selection to the last row.

ExtendToLastRowWithData

Extends the selection to the last row that contains data.

ExtendToNextColumn

Extends the selection one column to the right.

ExtendToNextColumnVisual

Extends the selection one column to the right.

ExtendToNextColumnWithData

Extends the selection right to next column with data.

ExtendToNextItem

Extends the selection to include the next item.

ExtendToNextPageOfColumns

Extends the selection to include the columns one page to the right.

ExtendToNextPageOfItems

Extends the selection to include the next page of items.

ExtendToNextPageOfRows

Extends the selection down to include one page of rows.

ExtendToNextRow

Extends the selection down one row.

ExtendToNextRowWithData

Extends the selection down to next row with data.

ExtendToPreviousColumn

Extends the selection one column to the left.

ExtendToPreviousColumnVisual

Extends the selection one column to the left.

ExtendToPreviousColumnWithData

Extends the selection left to previous column with data.

ExtendToPreviousItem

Extends the selection to include the previous item.

ExtendToPreviousPageOfColumns

Extends the selection to include the columns one page to the left.

ExtendToPreviousPageOfItems

Extends the selection to include the previous page of items.

ExtendToPreviousPageOfRows

Extends the selection up to include one page of rows.

ExtendToPreviousRow

Extends the selection up one row.

ExtendToPreviousRowWithData

Extends the selection up to previous row with data.

FormatsTextAsBold

Make your text bold.

FormatsTextAsItalic

Italicize your text.

FormatsTextAsPercent

Format text as a percent style.

FormatsTextAsUnderline

Underline your text.

Group

Group rows or columns, or automatically create an outline.

IncreaseChildHeight

Increases the height of the active object.

IncreaseChildWidth

Increases the width of the active object.

IncreaseShapeHeight

Increases the height of the active shape.

IncreaseShapeWidth

Increases the width of the active shape.

MergeCells

Merge selected cell.

MergeCellsAcross

Merge selected cell in same row.

MergeCellsCenter

Merge selected cell and center content.

MoveChildDown

Moves the active object down.

MoveChildLeft

Moves the active object left.

MoveChildRight

Moves the active object right.

MoveChildUp

Moves the active object up.

MoveShapeDown

Moves the active shape down.

MoveShapeLeft

Moves the active shape left.

MoveShapeRight

Moves the active shape right.

MoveShapeUp

Moves the active shape up.

MoveToFirstCell

Moves the active cell to the first cell in the sheet.

MoveToFirstColumn

Moves the active cell to the first column.

MoveToFirstItem

Moves to the first item.

MoveToFirstRow

Moves the active cell to the first row.

MoveToLastCell

Moves the active cell to the last cell in the sheet.

MoveToLastCellWithData

Moves the active cell to the last cell that contains data.

MoveToLastColumn

Moves the active cell to the last column.

MoveToLastColumnWithData

Moves the active cell to the last column that contains data.

MoveToLastItem

Moves to the last item.

MoveToLastItemWithData

Moves to the last item with data.

MoveToLastRow

Moves the active cell to the last row.

MoveToLastRowWithData

Moves the active cell to the last row that contains data.

MoveToNextCellThenControl

Moves the active cell to next cell then the next control.

MoveToNextColumn

Moves the active cell to the right one column.

MoveToNextColumnFirstRow

Moves the active cell to the first row of the next column.

MoveToNextColumnVisual

Moves the active cell to the right one column.

MoveToNextColumnWithData

Moves the active cell to next column with data.

MoveToNextColumnWrap

Moves the active cell to the right one column.

MoveToNextItem

Moves down one item.

MoveToNextPageOfColumns

Moves the active cell right one page of columns.

MoveToNextPageOfItems

Moves down one page of items.

MoveToNextPageOfRows

Moves the active cell down one page of rows.

MoveToNextRow

Moves the active cell down one row.

MoveToNextRowFirstColumn

Moves the active cell to the first column of the next row.

MoveToNextRowWithData

Moves the active cell to next row with data.

MoveToNextRowWrap

Moves the active cell down one row.

MoveToNextSheet

Moves the active cell to the next sheet.

MoveToPreviousCellThenControl

Moves the active cell to previous cell then the previous control.

MoveToPreviousColumn

Moves the active cell to the left one column.

MoveToPreviousColumnFirstRow

Moves the active cell to the first row of the previous column.

MoveToPreviousColumnVisual

Moves the active cell to the left one column.

MoveToPreviousColumnWithData

Moves the active cell to previous column with data.

MoveToPreviousColumnWrap

Moves the active cell to the left one column.

MoveToPreviousItem

Moves up one item.

MoveToPreviousPageOfColumns

Moves the active cell left one page of columns.

MoveToPreviousPageOfItems

Moves up one page of items.

MoveToPreviousPageOfRows

Moves the active cell up one page of rows.

MoveToPreviousRow

Moves the active cell up one row.

MoveToPreviousRowFirstColumn

Moves the active cell to the first column of the previous row.

MoveToPreviousRowWithData

Moves the active cell to previous row with data.

MoveToPreviousRowWrap

Moves the active cell up one row.

MoveToPreviousSheet

Moves the active cell to the previous sheet.

None

Does not perform an action.

PasteName

Shows paste name dialog.

Redo

Performs a redo of the most recently undone edit or action.

RotateReference

Rotate the editing reference in editing mode.

RotateShapeClockwise

Rotates the active shape one degree clockwise.

RotateShapeCounterClockwise

Rotates the active shape one degree counter-clockwise.

ScrollToFirstCell

Scrolls to display the first cell.

ScrollToFirstColumn

Scrolls to display the first column.

ScrollToFirstRow

Scrolls to display the first row.

ScrollToLastCell

Scrolls to display the last cell.

ScrollToLastCellWithData

Scrolls to display the last cell with data.

ScrollToLastColumn

Scrolls to display the last column.

ScrollToLastColumnWithData

Scrolls to display the last column with data.

ScrollToLastRow

Scrolls to display the last row.

ScrollToLastRowWithData

Scrolls to display the last row with data.

ScrollToNextColumn

Scrolls right one column.

ScrollToNextColumnVisual

Scrolls right one column.

ScrollToNextPageOfColumns

Scrolls right one page of columns.

ScrollToNextPageOfRows

Scrolls down one page of rows.

ScrollToNextRow

Scrolls down one row.

ScrollToPreviousColumn

Scrolls left one column.

ScrollToPreviousColumnVisual

Scrolls left one column.

ScrollToPreviousPageOfColumns

Scrolls left one page of columns.

ScrollToPreviousPageOfRows

Scrolls up one page of rows.

ScrollToPreviousRow

Scrolls up one row.

SelectColumn

Selects the column that contains the active cell.

SelectEntireTableOrWorksheet

Select the entire table or worksheet.

SelectFirstItem

Selects the first item.

SelectLastItem

Selects the last item.

SelectLastItemWithData

Selects the last item with data.

SelectNextItem

Selects the next item.

SelectNextPageOfItems

Selects the next page of items.

SelectPreviousItem

Selects the previous item.

SelectPreviousPageOfItems

Selects the previous page of items.

SelectRow

Selects the row that contains the active cell.

SelectSheet

Selects the entire sheet.

ShowActivateSheetDialog

Show the dialog to activate sheet.

ShowCard

Show details information of IRichValue object.

ShowFormatCellsDialog

Show the FormatCells dialog.

ShowHyperlinkDialog

Show the Hyperlink dialog.

ShowNameManager

Show Name Manager dialog.

ShowSubEditor

Shows the subeditor control of the current cell.

StartAddingCommentThreaded

Start adding a new modern threaded comment.

StartEditing

Turns on edit mode.

StartEditingFormula

Allows the user to start entering a formula.

StartReplyingToCommentThreaded

Start replying to threaded comment.

StopEditing

Turns off edit mode.

ToggleInsertFunction

Toggles the insert function dialog.

ToggleItem

Toggles the selection for the item.

ToggleTableTotalRow

Toggle the table total row.

Undo

Performs an undo of the most recent edit or action.

Ungroup

Ungroup a range of cells that were previously grouped.

UnmergeCells

Split current merged cell.