| Name | Description | |
|---|---|---|
 | WebSpreadsheetEditorControlJS | Initializes a new instance of the WebSpreadsheetEditorControlJS class. |
WebSpreadsheetEditorControlJS Class Members
In This Topic
The following tables list the members exposed by WebSpreadsheetEditorControlJS.
Public Constructors
Methods
| Name | Description | |
|---|---|---|
 | addWorksheet | Adds new worksheet to the spreadsheet document. New worksheet is added after the focused worksheet. |
| autoFitColumnWidth | Automatically fits the width of columns using selected cells. |
| autoFitRowHeight | Automatically fits the height of rows using selected cells. |
| cancelCellValueEditing | Cancels the editing of cell value. |
| clearCellsContents | Clears contents (value and formula) of selected cells. |
| clearCellsStyle | Clears format (style) of selected cells. |
| copyWorksheet | Overloaded. Copies the focused worksheet in spreadsheet document. |
| deleteComment | Deletes the focused comment. |
| doCopy | Copies content (selected cells, cell text, etc) to the clipboard. |
| doCut | Cuts content (selected cells, cell text, etc) to the clipboard. |
| doPaste | Pastes content (selected cells, cell text, etc) from the clipboard. |
| editComment | Edits the focused comment. |
| focusCommentFromFocusedCell | Sets the focus to the comment of focused cell. |
| get_BordersColor | Gets the border color of focused cell. |
| get_CanRedo | Gets a value indicating whether the undo manager can execute redo action. |
| get_CanUndo | Gets a value indicating whether the undo manager can execute undo action. |
| get_CommentAuthor | Gets the author of focused comment. |
| get_CommentShowAuthor | Gets a value indicating whether the autor comment must be shown. |
| get_CommentText | Gets the text of focused comment. |
| get_FileId | Gets the identifier of opened XLSX file. |
| get_FillColor | Gets the fill color of focused cell. |
| get_FocusedCellValue | Gets value or formula of focused cell. |
| get_FocusedWorksheetIndex | Gets the index of the focused worksheet. |
| get_FontColor | Gets the font color of focused cell. |
| get_FontName | Gets the font name for focused cell. |
| get_FontSize | Gets the font size for focused cell. |
| get_InteractionMode | Gets the interaction mode of the spreadsheet visual editor. |
| get_InteractionPointRadius | Gets the radius of interaction point (resize points). |
| get_IsCellHasComment | Gets a value indicating whether focused cell has comment. |
| get_IsCommentFocused | Gets a value indicating whether comment is focused. |
| get_IsEnabled | Gets a value indicating whether the control is enabled. |
| get_IsFontBold | Gets a value indicating whether focused cell has bold font. |
| get_IsFontItalic | Gets a value indicating whether focused cell has italic font. |
| get_IsFontStrikeout | Gets a value indicating whether focused cell has strikeout font. |
| get_IsFontUnderline | Gets a value indicating whether focused cell has underline font. |
| get_NumberFormatDecimalPlaces | Gets the amount of decimal places in number format of focused cell. |
| get_NumberingFormat | Gets the number format of focused cell. |
| get_RedoDescription | Gets the description of redo action. |
| get_TextHorizontalAlign | Gets the text horizontal alignment of focused cell. |
| get_TextVerticalAlign | Gets the text vertical alignment of focused cell. |
| get_UndoDescription | Gets the description of undo action. |
| get_UndoMaxActions | Gets the maximum number of undo actions. |
| get_WrapText | Gets a value indicating whether the focused cell has wrapped text. |
| get_Zoom | Gets the zoom, in percents. |
| getCellBoundingBox | Returns the cell's bounding box in spreadsheet viewer space. |
| getFocusedCellName | Returns the name of focused cell. |
| getFocusedWorksheetName | Returns the name of focused worksheet. |
| getWorksheetNames | Returns the names of all worksheets. |
| hideColumns | Hides the selected columns on focused worksheet. |
| hideComment | Hides comment of focused cell. |
| hideRows | Hides the selected rows on focused worksheet. |
| 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. |
| insertColumns | Insert columns into the focused worksheet. |
| insertComment | Inserts new comment to the focused cell. |
| insertFormulaInFocusedCell | Inserts the formula in focused cell. |
| insertRows | Insert rows into the focused worksheet. |
| mergeCells | Merges the selected cells. |
| moveWorksheets | Changes the position of worksheet. |
| nextComment | Navigates to the next comment. |
| openDocument | Opens XLSX document. |
| prevComment | Navigates to the previous comment. |
| redo | Redoes the action. |
| removeCellsAndShiftLeft | Removes selected cells and shifts columns to the left. |
| removeCellsAndShiftUp | Removes selected cells and shifts rows to up. |
| removeColumns | Removes columns in the focused worksheet. |
| removeDrawing | Removes the focused drawing. |
| removeHyperlinks | Removes hyperlinks from focused sheet drawing or selected cells. |
| removeRows | Removes rows in the focused worksheet. |
| removeWorksheet | Overloaded. Removes the specified worksheet from spreadsheet document. |
| renameWorksheet | Renames the worksheet. |
| set_FillColor | Sets the fill color of selected cells. |
| set_FocusedCellValue | Sets value of selected cells. |
| set_FocusedWorksheetIndex | Sets the index of the focused worksheet. |
| set_FontColor | Sets the font color of focused cell. |
| set_FontName | Sets the font name for selected cells. |
| set_FontSize | Sets the font size for selected cells. |
| set_InteractionMode | Sets the interaction mode of the spreadsheet visual editor. |
| set_InteractionPointRadius | Sets the radius of interaction point (resize points). |
| set_IsEnabled | Sets a value indicating whether the control is enabled. |
| set_IsFontBold | Sets the bold font for selected cells. |
| set_IsFontItalic | Sets the italic font for selected cells. |
| set_IsFontStrikeout | Sets the strikeout font for selected cells. |
| set_IsFontUnderline | Sets the underline font for selected cells. |
| set_NumberFormatDecimalPlaces | Sets the amount of decimal places in number format of selected cells. |
| set_NumberingFormat | Sets the number format of selected cells. |
| set_TextHorizontalAlign | Sets the text horizontal alignment of selected cells. |
| set_TextVerticalAlign | Sets the text vertical alignment of selected cells. |
| set_UndoMaxActions | Sets the maximum number of undo actions. |
| set_WrapText | Sets a value indicating whether the selected cells has wrapped text. |
| set_Zoom | Sets the zoom, in percents. |
| setFocusedAndSelectedCells | Sets the selected cells and focused cells to the specified value. |
| setTextInputForCellValueEmbeddedEditor | Sets the text input for embedded editor of cell value. |
| setTextInputForCellValueExternalEditor | Sets the text input for external editor of cell value. |
| showColumns | Shows the selected columns on focused worksheet. |
| showComment | Shows comment of focused cell. |
| showRows | Shows the selected rows on focused worksheet. |
| tryFinishEditCellFormula | Tries to finish the editing of cell formula. |
| undo | Undoes the action. |
| unmergeCells | Unmerges the selected cells. |
Events
| Name | Description | |
|---|---|---|
 | cellClicked | Occurs when cell is clicked in spreadsheet viewer. |
| focusedCellChanged | Occurs when the focused cell is changed in spreadsheet viewer. |
| focusedCommentChanged | Occurs when the focused comment is changed in spreadsheet viewer. |
| formulaSyntaxError | Occurs when the the formula syntax error occurs in spreadsheet viewer. |
| synchronizationException | Occurs when the synchronization exception occurs. |
See Also