| Name | Description | |
|---|---|---|
 | SpreadsheetEditor | Overloaded. Initializes a new instance of the |
SpreadsheetEditor Class Members
In This Topic
The following tables list the members exposed by SpreadsheetEditor.
Public Constructors
Public Properties
| Name | Description | |
|---|---|---|
 | AsyncEdit | Gets a value indicating whether editor must edit the spreadsheet document asynchronously. |
| Document | Gets the spreadsheet document. |
| DocumentEditor | Gets the editor of spreadsheet document. |
| DocumentInformation | Gets or sets the document information. |
| FormattingProperties | Gets the document formatting properties. |
| IsEditing | Gets a value indicating whether editing is started. |
| IsInitialized | Gets a value indicating whether this editor is initialized. |
| IsInitializing | Gets a value indicating whether this editor is initializing. |
| IsSynchronizing | Gets a value indicating whether syncronization with source is executing. |
| IsVirtual | Gets a value indicating whether this editor is created on a virtual document. |
| MaxActionCompositionCount | Gets or sets the maximum number of operations in a single action. |
| Settings | Gets the editor settings. |
| UndoManager | Gets the undo/redo manager. |
Public Methods
| Name | Description | |
|---|---|---|
 | AddChart | Overloaded. Adds the standard chart. |
| AddDefinedName | Adds the defined name. |
| AddHyperlink | Adds the hyperlink to the cells from specified cells set. |
| AddPicture | Adds a picture to the worksheet. |
| AddWorksheet | Overloaded. Adds the new (empty) worksheet. |
| ChangeCellsStyleProperties | Changes the style properties for specified cells set. |
| ChangeWorksheetIndexes | Changes the worksheet indexes. |
| ChartSwitchRowColumn | Switches the rows and columns of specified chart. |
| CheckIsSynchronizing | Checks whether the synchronizing is started. |
| CheckMaxActionCompositionCount | Checks the maximum action composition count. |
| ClearCells | Clears (content, styles, hyperlinks and comments) of specified cells. |
| ClearCellsContent | Clears value and formula of specified cells. |
| ClearCellsContents | Clears content (value and formula) of specified cells. |
| ClearCellsFormat | Clears format (style) of specified cells. |
| ClearHyperlinks | Removes the hyperlinks, which are located in specified cells set. |
| CopyCells | Overloaded. Copies cells of source worksheet to the specified location on destination worksheet. |
| CopyWorksheet | Copies the worksheet at sepcified index. |
 | CreateEditor | Overloaded. Synchronously creates the spreadsheet editor for new XLSX document. |
| Dispose | Performs application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. |
| FillCells | Fills specified cells along specified direction. |
| FinishEditing | Overloaded. Finishes the document editing. |
| GetCellsBorders | Returns the cells borders of specified cells. |
| GetCommonCellsStyleProperties | Returns common style properties for specified cells set. |
| GetWorksheetEditor | Returns the editor of specified worksheet. |
| HideColumnRange | Hides the columns in the specified worksheet. |
| HideColumns | Hides the columns in the specified worksheet. |
| HideRowRange | Hides the rows in the specified worksheet. |
| HideRows | Hides the rows in the specified worksheet. |
| Initialize | Initializes this spreadsheet editor. |
| InsertCellsAndShiftDown | Inserts empty cells at specified cells and shifts rows down. |
| InsertCellsAndShiftRight | Inserts empty cells at specified cells and shifts columns to the right. |
| InsertEmptyColumnRange | Inserts columns in the specified worksheet. |
| InsertEmptyColumns | Inserts empty columns in the specified worksheet. |
| InsertEmptyRowRange | Inserts empty rows in the specified worksheet. |
| InsertEmptyRows | Inserts empty rows in the specified worksheet. |
| InsertNewWorksheet | Overloaded. Inserts the new (empty) worksheet at spceified index. |
| MergeCells | Merges the specified cells. |
| MergeCellsAcross | Merges the specified cells in the same row into one large cell. |
| MoveWorksheet | Moves the worksheet at specified index to the new index. |
| PasteCells | Pastes or cuts the cells from cell clipboard. |
| RemoveCellsAndShiftLeft | Removes cells at specified cells and shifts columns to the left. |
| RemoveCellsAndShiftUp | Removes cells at specified cells and shifts rows up. |
| RemoveColumnRange | Removes columns in the specified worksheet. |
| RemoveColumns | Removes columns in the specified worksheet. |
| RemoveComments | Removes the comments, which are associated with cells from specified cell set. |
| RemoveDefinedName | Removes the defined name from the worksheet. |
| RemoveDefinedNameAt | Removes the defined name at specified index. |
| RemoveDrawing | Removes the drawing object from worksheet. |
| RemoveHyperlinks | Removes the hyperlinks, which are intersected with specified cells set. |
| RemoveRowRange | Removes rows in the specified worksheet. |
| RemoveRows | Removes rows in the specified worksheet. |
| RemoveWorksheet | Removes the worksheet at specified index. |
| RenameWorksheet | Renames worksheet at specified index. |
| SaveAs | Overloaded. Saves spreadsheet document to the specified file and changes the spreadsheet document source to this file. |
| SaveChanges | Saves changes in the spreadsheet document. |
| SaveTo | Overloaded. Saves spreadsheet document to the specified file. |
| SetBorders | Sets the Borders property for specified cells set. |
| SetBordersColor | Sets the Color property for specified cells set. |
| SetCellComment | Sets the comment for focused cell. |
| SetCellsStyle | Sets the cells style index to the style with specified index. |
| SetCellsStyleIndex | Sets the cells style index to the style with specified index. |
| SetCellValue | Overloaded. Sets cell value. |
| SetColumnsIsHidden | Sets the hidden property of colums for specified cells set. |
| SetColumnsWidth | Sets the width of colums for specified cells set. |
| SetComment | Sets the comment for specified cell. |
| SetCommentIsVisible | Sets the IsVisible property value. |
| SetCommentLocation | Sets the location for comment in editor. |
| SetCommentsIsVisible | Sets the visibility status for comments, which are associated with specified cell set. |
| SetDefinedName | Sets the defined name at specified index. |
| SetDocumentView | Sets the document view. |
| SetDrawingDescription | Sets the description for drawing object. |
| SetDrawingLocation | Sets the location for drawing object. |
| SetDrawingName | Sets the name for drawing object. |
| SetDrawingPicture | Sets a picture for the drawing object. |
| SetDrawingRotation | Sets the rotation angle for drawing object. |
| SetFillColor | Sets the FillColor property for specified cells set. |
| SetFontColor | Sets the Color property for specified cells set. |
| SetFontIsBold | Sets the IsBold property for specified cells set. |
| SetFontIsItalic | Sets the IsItalic property for specified cells set. |
| SetFontIsStrikeout | Sets the IsStrikeout property for specified cells set. |
| SetFontIsUnderline | Sets the IsUnderline property for specified cells set. |
| SetFontName | Sets the Name property for specified cells set. |
| SetFontSize | Sets the Size property for specified cells set. |
| SetHyperlink | Sets the hyperlink for specified sheet drawing. |
| SetNumberFormat | Sets the NumberFormat property for specified cells set. |
| SetRowAutoHeight | Sets the automatic height of specified cells set. |
| SetRowsHeight | Sets the height of rows for specified cells set. |
| SetRowsIsHidden | Sets the hidden property of rows for specified cells set. |
| SetTextHorizontalAlign | Sets the HorizontalAlign property for specified cells set. |
| SetTextIndent | Sets the Indent property for specified cells set. |
| SetTextVerticalAlign | Sets the VerticalAlign property for specified cells set. |
| SetTextWordWrap | Sets the WrapText property for specified cells set. |
| SetWorksheetView | Sets the view properties of specified worksheet. |
| ShowColumnRange | Shows the columns in the specified worksheet. |
| ShowColumns | Shows the columns in the specified worksheet. |
| ShowRowRange | Shows the rows in the worksheet. |
| ShowRows | Shows the rows in the specified worksheet. |
| StartEditing | Overloaded. Starts the document editing. |
| UnmergeCells | Unmerges the specified cells. |
Protected Methods
| Name | Description | |
|---|---|---|
 | InitializeVirtualDocument | Initializes the virtual document (when editor source is null). |
| OnChartTemplatesRequest | Raises the ChartTemplatesRequest event. |
| OnDocumentChanged | Raises the DocumentChanged event. |
| OnDocumentSourceChanged | Raises the DocumentChanged event. |
| OnEditingFinished | Raises the EditingFinished event. |
| OnEditingStarted | Raises the EditingStarted event. |
| OnInitializationFinished | Raises the InitializationFinished event. |
| OnInitializationStarted | Raises the InitializationStarted event. |
| OnSynchronizationException | Raises the SynchronizationException event. |
| OnSynchronizationFinished | Raises the SynchronizationFinished event. |
| OnSynchronizationStarted | Raises the SynchronizationStarted event. |
| ValidateDefinedName | Checks whether the specified defined name is valid. |
Public Events
| Name | Description | |
|---|---|---|
 | ChartTemplatesRequest | Occurs when chart templates request requires. |
| DocumentChanged | Occurs when Document is changed. |
| DocumentSourceChanged | Occurs when spreadsheet document source is changed. |
| EditingFinished | Occurs when editing is finished. |
| EditingStarted | Occurs when editing is started. |
| InitializationFinished | Occurs when initialization is finished. |
| InitializationStarted | Occurs when initialization is started. |
| SynchronizationException | Occurs when synchronization exception occurs. |
| SynchronizationFinished | Occurs when synchronization is finished. |
| SynchronizationStarted | Occurs when synchronization is started. |
See Also