SpreadActions Class | Spread Windows Forms 17

SpreadActions Class Members

In This Topic

The following tables list the members exposed by SpreadActions.

Public Constructors

	Name	Description
	SpreadActions Constructor

Top

Public 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.
	CalculateEntireWorkbook
	CalculateSheet
	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.
	ClipboardPasteAsLink	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.
	CSEStopEditing	Turns off edit mode.
	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
	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 GrapeCity.CalcEngine.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.

Top

Reference

SpreadActions Class
FarPoint.Win.Spread Namespace