SpreadsheetVisualEditor Class Methods

In This Topic

For a list of all methods of this type, see SpreadsheetVisualEditor.

Public Methods

	Name	Description
	AddChart	Overloaded. Adds the chart to the focused worksheet.
	AddDefinedName	Overloaded. Adds the defined name.
	AddHyperlink	Adds the hyperlink to the focused sheet drawing or selected cells.
	AddPicture	Adds the picture to the focused worksheet.
	AddStandardChart	Adds the standard chart to the focused worksheet.
	AddWorksheet	Adds new worksheet to the spreadsheet document after focused worksheet.
	AutoFitColumnWidth	Overloaded. Automatically fits the width of columns using the specifed cells.
	AutoFitRowHeight	Overloaded. Automatically fits the height of rows using specifed cells.
	BeginInit	Signals the object that initialization is starting. (Inherited from VintasoftControl)
	BeginInvoke	Overloaded. Executes a delegate asynchronously on the thread that the control's underlying handle was created on. (Inherited from VintasoftControl)
	CalculateRowAutoHeight	Overloaded. Calculates the height of selected rows, which height must be calculated automatically, on focused worksheet.
	CancelEditCellValue	Cancels the editing of cell value.
	ChangeFocusedCells	Chnages FocusedCells (and last item in SelectedCells) to the specified value.
	ChangeStyleProperties	Changes the style properties for SelectedCells.
	ChangeWorksheetIndexes	Changes the worksheet indexes.
	ChartSwitchRowColumn	Switches the rows and columns of focused chart.
	ClearCells	Clears selected cells.
	ClearCellsContents	Clears contents (value and formula) of selected cells.
	ClearCellsStyle	Clears format (style) of selected cells.
	CloseDocument	Closes the spreadsheet document.
	CommitFocusedCellValue	Commits the value of focused cell to the spreadsheet document.
	Copy	Executes Copy operation.
	CopyCells	Copies the focused cells (FocusedCells).
	CopyWorksheet	Overloaded. Copies the focused worksheet.
	Cut	Executes Cut operation.
	CutCells	Cuts the focused cells (FocusedCells).
	DisableScrolling	Disables the scrolling using the ScrollToRect(VintasoftRect) and ScrollToRect(VintasoftRect,VintasoftSize) methods. (Inherited from VintasoftScrollableControl)
	Dispose	Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from VintasoftControl)
	DoKeyDown	Does the OnKeyDown(VintasoftControlKeyEventArgs) method. (Inherited from VintasoftControl)
	DoKeyUp	Does the OnKeyUp(VintasoftControlKeyEventArgs) method. (Inherited from VintasoftControl)
	DoMouseClick	Does the DoMouseClick(VintasoftControlMouseEventArgs) method. (Inherited from VintasoftControl)
	DoMouseDown	Does the OnMouseDown(VintasoftControlMouseEventArgs) method. (Inherited from VintasoftControl)
	DoMouseLeave	Does the OnMouseLeave(VintasoftControlEventArgs) method. (Inherited from VintasoftControl)
	DoMouseMove	Does the DoMouseMove(VintasoftControlMouseEventArgs) method. (Inherited from VintasoftControl)
	DoMouseUp	Does the DoMouseUp(VintasoftControlMouseEventArgs) method. (Inherited from VintasoftControl)
	Draw	Draws the spreadsheet visual editor on specified drawing engine.
	EnableScrolling	Enables the scrolling using the ScrollToRect(VintasoftRect) and ScrollToRect(VintasoftRect,VintasoftSize) methods. (Inherited from VintasoftScrollableControl)
	EndInit	Overloaded. Signals the object that initialization is complete. (Inherited from VintasoftControl)
	ExecuteHyperlinkAction	Executes the hyperlink action.
	ExecuteNavigationAction	Executes the spreadsheet editor action.
	FillCells	Fills selected cells content along specified direction.
	FinishEditCellValue	Finishes the editing of cell value.
	FinishEditing	Overloaded. Finishes the editing.
	GetActualValueByDefinedName	Returns the actual value by defined name.
	GetCellBoundingBox	Returns the cell bounding box, in control space.
	GetCellByLocation	Returns the cell that is located in specified point.
	GetCellsBoundingBox	Returns the cells bounding box, in control space.
	GetCellValue	Returns cell text or formula.
	GetCommentByLocation	Returns the CellComment that is located in specified point.
	GetCommonCellsStyleProperties	Returns the common style properties for SelectedCells.
	GetCursor	Returns the cursor by location.
	GetDrawingByLocation	Returns the SheetDrawing that is located in specified point.
	GetFixedSelectedCells	Returns the selected cell set as a fixed cell set.
	GetFocusedWorksheetDefinedNames	Returns defined names, which can be used in focused worksheet.
	GetHyperlinkByDefinedName	Returns the hyperlink by name, which is defined in DefinedNames.
	HideAllComments	Hides all comments on focused worksheet.
	HideColumns	Hides the selected columns on focused worksheet.
	HideComments	Hides the comments, which are associated with cells from SelectedCells.
	HideRows	Hides the selected rows on focused worksheet.
	InitializeFindReplace	Initializes the text replacer.
	InsertCellsAndShiftDown	Inserts empty cells in range of selected cells and shifts rows to down.
	InsertCellsAndShiftRight	Inserts empty cells in range of selected cells and shifts columns to the right.
	InsertEmptyColumns	Inserts the column on focused worksheet at position of selected cells.
	InsertEmptyRows	Inserts the rows on focused worksheet in range of selected cells.
	InsertFormulaInFocusedCell	Inserts the formula in focused cell.
	Invalidate	Overloaded. Invalidates the specified rectangle of the control (adds it to the control's update region, which is the area that will be repainted at the next paint operation), and causes a paint message to be sent to the control. (Inherited from VintasoftControl)
	Invoke	Overloaded. Executes a delegate on the thread that owns the control's underlying window handle. (Inherited from VintasoftControl)
	MergeCells	Merges the selected cells.
	MergeCellsAcross	Merges across the selected cells.
	MergeCellsAndCenterText	Merges the selected cells and centers the text in merged cell.
	MoveWorksheet	Overloaded. Moves the worksheet at specified index to the new index.
	NewDocument	Creates new spreadsheet document.
	OpenDocument	Overloaded. Opens the spreadsheet document from specified file.
	Paste	Executes Paste operation.
	PasteCells	Overloaded. Pastes cells from to the .
	PasteCellsContent	Pastes cells values and formulas from CellsClipboard to the FocusedCell.
	PasteCellsFormula	Pastes cells formula from CellsClipboard to the FocusedCell.
	PasteCellsStyle	Pastes cells style from CellsClipboard to the FocusedCell.
	PasteCellsValue	Pastes cells value from CellsClipboard to the FocusedCell.
	PasteCellsValueAndStyle	Pastes cells value from CellsClipboard to the FocusedCell.
	PerformFormulaErrorCorrection	Performs the error correction in specified formula.
	PerformStylePaint	Overloaded. Performs the style painting of focused cells ().
	RemoveCellsAndShiftLeft	Removes selected cells and shifts columns to the left.
	RemoveCellsAndShiftUp	Removes selected cells and shifts rows to up.
	RemoveColumns	Overloaded. Removes the columns on focused worksheet at position of selected cells.
	RemoveComments	Removes the comments, which are associated with cells from SelectedCells.
	RemoveFocusedComment	Removes the focused comment.
	RemoveFocusedDrawing	Removes the focused drawing object.
	RemoveHyperlinks	Overloaded. Removes hyperlinks from sepeicied cells set.
	RemoveRows	Removes the rows on focused worksheet at position of selected cells.
	RemoveWorksheet	Overloaded. Removes worksheet at specified index.
	RenameWorksheet	Renames the focused worksheet.
	SaveDocumentAs	Overloaded. Saves the spreadsheet document to the specified stream.
	SaveDocumentChanges	Saves changes in the spreadsheet document.
	SaveDocumentChangesAsync	Saves changes in the spreadsheet document.
	SaveDocumentTo	Overloaded. Saves the spreadsheet document to the specified stream.
	SaveWorksheetViews	Saves the worksheet views.
	ScrollTo	Overloaded. Scrolls to the specified cells to make cells visible.
	ScrollToControl	Scrolls to the specified rectangle in the control space.
	ScrollToRect	Overloaded. Scrolls the viewer to the specified rectangle on viewer area. (Inherited from VintasoftScrollableControl)
	ScrollToSheet	Scrolls to the specified rectangle in the sheet space.
	SetCellComment	Sets the comment for cell that is specified by cell comment.
	SetCellsStyle	Overloaded. Sets the style of selected cells.
	SetCellValue	Sets cell text or formula.
	SetComment	Sets the comment for focused cell.
	SetCommentIsVisible	Sets the visibility status for comment of focused cell.
	SetCommentLocation	Sets the location for comment of focused cell.
	SetDefinedName	Sets the defined name.
	SetDocumentCulture	Sets the document culture.
	SetDrawingDescription	Sets the description for the focused drawing object.
	SetDrawingLocation	Sets the location for the focused drawing object.
	SetDrawingName	Sets the name for the focused drawing object.
	SetDrawingPicture	Sets the picture for the focused drawing object.
	SetDrawingRotation	Sets the rotation angle for the focused drawing object.
	SetFocusedAndSelectedCells	Overloaded. Sets and to the specified value.
	SetRowAutoHeight	Sets the automatic height of selected cells on focused worksheet.
	SetSynchronizationContext	Sets the synchronization provider. (Inherited from VintasoftControl)
	SetWorksheetFormat	Sets the specified format to the worksheet.
	ShowAllComments	Shows all comments on focused worksheet.
	ShowColumns	Shows the selected columns on focused worksheet.
	ShowComments	Shows the comments, which are associated with cells from SelectedCells.
	ShowRows	Shows the selected rows on focused worksheet.
	StartEditFocusedCellFormula	Starts the editing of focused cell formula.
	StartEditFocusedCellValue	Starts the editing of focused cell value.
	StartEditing	Overloaded. Starts the editing.
	TryFinishEditCellFormula	Tries to finish the editing of cell formula.
	UnmergeCells	Unmerges the selected cells.

Protected Methods

	Name	Description
	GetNextFocusedCellHorizontal	Returns the next focused cell in horizontal direction.
	GetNextFocusedCellVertical	Returns the next focused cell in vertical direction.
	GetPrevFocusedCellHorizontal	Returns the previous focused cell in horizontal direction.
	GetPrevFocusedCellVertical	Returns the previous focused cell in vertical direction.
	InvalidateInteraction	Invalidates the interaction.
	OnCellClick	Raises the CellClick event.
	OnCellCommentClick	Raises the CellCommentClick event.
	OnCellErrorClick	Raises the CellErrorClick event.
	OnCellsClipboardChanged	Raises the CellsClipboardChanged event.
	OnCellsStylePropertiesChanged	Raises the CellsStylePropertiesChanged event.
	OnChartTemplatesRequest	Raises the ChartTemplatesRequest event.
	OnClientSizeChanged	Raises the ClientSizeChanged event. (Inherited from VintasoftControl)
	OnContextMenuOpen	Raises the ContextMenuOpen event.
	OnCursorChanged	Raises the CursorChanged event. (Inherited from VintasoftControl)
	OnDocumentSavingFinished	Raises the DocumentSavingFinished event.
	OnDocumentSavingStarted	Raises the DocumentSavingStarted event.
	OnDocumentSourceChanged	Raises the DocumentSourceChanged event.
	OnEditCellValueFinished	Raises the EditCellValueFinished event.
	OnEditCellValueStarted	Raises the EditCellValueStarted event.
	OnEditorChanged	Raises the EditorChanged event.
	OnEditorChanging	Raises the EditorChanging event.
	OnFocusedCellChanged	Raises the FocusedCellChanged event.
	OnFocusedCellEditingValueChanged	Raises the FocusedCellEditingValueChanged event.
	OnFocusedCellsChanged	Raises the FocusedCellsChanged event.
	OnFocusedCommentChanged	Raises the FocusedCommentChanged event.
	OnFocusedDrawingChanged	Raises the FocusedDrawingChanged event.
	OnFocusedWorksheetChanged	Raises the FocusedWorksheetChanged event.
	OnFormulaSyntaxError	Raises the FormulaSyntaxError event.
	OnHoveredCellChanged	Raises the HoveredCellChanged event.
	OnHoveredCommentChanged	Raises the HoveredCommentChanged event.
	OnHoveredDrawingChanged	Raises the HoveredDrawingChanged event.
	OnHoveredHyperlinkChanged	Raises the HoveredHyperlinkChanged event.
	OnHyperlinkClick	Raises the HyperlinkClick event.
	OnInitializationFinished	Raises the InitializationFinished event.
	OnInitializationStarted	Raises the InitializationStarted event.
	OnInvalidating	Raises the Invalidating event. (Inherited from VintasoftControl)
	OnInvalidCellReferences	Raises the InvalidCellReferences event.
	OnKeyDown	Raises the KeyDown event.
	OnKeyUp	Raises the KeyUp event.
	OnMouseClick	Raises the MouseClick event. (Inherited from VintasoftControl)
	OnMouseDown	Raises the MouseDown event.
	OnMouseLeave	Raises the MouseLeave event. (Inherited from VintasoftControl)
	OnMouseMove	Raises the MouseMove event.
	OnMouseUp	Raises the MouseUp event.
	OnScrollPositionChanged	Raises the ScrollPositionChanged event.
	OnScrollSizeChanged	Raises the ScrollSizeChanged event. (Inherited from VintasoftScrollableControl)
	OnSizeChanged	Raises the SizeChanged event.
	OnSynchronizationException	Raises the SynchronizationException event.
	OnSynchronizationFinished	Raises the SynchronizationFinished event.
	OnSynchronizationStarted	Raises the SynchronizationStarted event.
	OnTextEditingFinished	Raises the TextEditingFinished event. (Inherited from VintasoftControl)
	OnTextEditingStarting	Raises the TextEditingStarting event. (Inherited from VintasoftControl)
	OnUndoManagerStateChanged	Raises the UndoManagerStateChanged event.
	OnUriOpen	Raises the UriOpen event.
	OnZoomChanged	Raises the ZoomChanged event.
	ProcessHotKeys	Processes hot keys.
	SetScrollSize	Sets the size of scroll area. (Inherited from VintasoftScrollableControl)

Reference

SpreadsheetVisualEditor Class
Vintasoft.Imaging.Office.Spreadsheet.UI Namespace

Send Feedback