Spreadsheet API

The Spreadsheet API lists the methods and events a plugin can use when working with a spreadsheet in ONLYOFFICE Docs. To work with the spreadsheet content directly, such as worksheets and ranges, run Office API code in callCommand. See Spreadsheet API.

Methods

The following table lists the available methods.

Method	Returns	Description
AddComment	string | null	Adds a comment to the workbook.
AddOleObject	None	Adds an OLE object to the current document position.
ChangeComment	boolean	Changes the specified comment.
CoAuthoringChatSendMessage	None	Sends a message to the co-authoring chat.
EditOleObject	None	Edits an OLE object in the document.
EndAction	None	Specifies the end action for long operations.
FocusEditor	None	Returns focus to the editor.
GetAllComments	comment[]	Returns all the comments from the document.
GetCustomFunctions	string	Returns a library of local custom functions.
GetFileToDownload	string	Returns the current file to download in the specified format.
GetFontList	FontInfo[]	Returns the fonts list.
GetImageDataFromSelection	ImageData	Returns the image data from the first of the selected drawings.
GetInstalledPlugins	PluginData[]	Returns all the installed plugins.
GetMacros	Macros	Returns the document macros.
GetSelectedContent	string	Returns the selected content in the specified format.
GetSelectedOleObjects	OLEProperties[]	Returns an array of the selected OLE objects.
GetSelectedText	string	Returns the selected text from the document.
GetSelectionType	SelectionType	Returns the type of the current selection.
GetVBAMacros	string | null	Returns all VBA macros from the document.
GetVersion	string	Returns the editor version.
InputText	None	Inserts text into the document.
InstallPlugin	object	Installs a plugin using the specified plugin config.
MouseMoveWindow	None	Sends an event to the plugin when the mouse button is moved inside the plugin iframe.
MouseUpWindow	None	Sends an event to the plugin when the mouse button is released inside the plugin iframe.
OnDropEvent	None	Implements the external drag&drop emulation.
OnEncryption	None	Encrypts the document.
PasteHtml	None	Pastes text in the HTML format into the document.
PasteText	None	Pastes text into the document.
PutImageDataToSelection	None	Replaces the first selected drawing with the image specified in the parameters.
RemoveComments	None	Removes the specified comments.
RemoveOleObject	None	Removes the OLE object from the workbook by its internal ID.
RemovePlugin	object	Removes a plugin with the specified GUID.
ReplaceTextSmart	boolean	Replaces each paragraph (or text in cell) in the select with the corresponding text from an array of strings.
SetCustomFunctions	None	Updates a library of local custom functions.
SetMacros	None	Sets macros to the document.
SetPluginsOptions	None	Configures plugins from an external source.
SetProperties	None	Sets the properties to the document.
ShowButton	None	Shows or hides buttons in the header.
ShowError	None	Shows an error/warning message.
ShowInputHelper	None	Shows the input helper.
StartAction	None	Specifies the start action for long operations.
UnShowInputHelper	None	Unshows the input helper.
UpdatePlugin	object	Updates a plugin using the specified plugin config.

Events

The following table lists the available events.

Event	Description
onChangeCurrentSheet	The function called when the current sheet has changed.
onChangeRestrictions	The function called when the restrictions in the editor are changed.
onClick	The function called when the user clicks the element.
onDocumentContentReady	The function called when the document is completely loaded.
onEnableMouseEvent	The function called to turn the mouse or touchpad events on/off.
onExternalMouseUp	The function called when the mouse button is released outside the plugin iframe.
onTargetPositionChanged	The function called when the target position in the editor is changed.