addCheckbox | adds a checkbox into a cell |
addImage | adds an image into a cell |
addRadio | adds a radio button into a cell |
addSheet | adds a new sheet into a SpreadSheet |
addSparkline | adds a sparkline into a cell |
addStyle | creates a new style |
adjust | adjusts the component to the size of the parent HTML container |
alert | creates an alert box |
attachEvent | attaches the handler to an inner event of the component |
bind | binds components |
blockEvent | temporarily blocks triggering of ALL events of the calling object |
callEvent | calls an inner event |
changeDecimals | increases/decreases decimal places |
clearRange | clears a range of cells (either selected cells or specified in the parameter) |
clearSheet | clears the content of the currently active sheet |
combineCells | merges several adjacent cells |
compactStyles | removes unused styles for the current sheet |
confirm | creates a confirm box |
define | redefines a single configuration property (or a object with properties) |
deleteColumn | deletes a column by its id |
deleteRow | deletes a row by its id |
destructor | destructs the calling object |
detachEvent | detaches a handler from an event (which was attached before by the attachEvent method) |
disable | disables the calling view (makes it dimmed and unclickable) |
eachSelectedCell | iterates over all selected cells in the table |
editSheet | selects the sheet name for editing |
enable | enables the calling view that was disabled by the 'disable' method |
filterSpreadSheet | invokes SpreadSheet filtering by all existing filters |
freezeColumns | fixes the specified amount of columns at runtime, starting from one on the rear left side |
freezeRows | fixes the specified amount of rows at runtime, starting from the first one |
getActiveSheet | returns the name of the currently active sheet |
getCellEditor | returns the editor set in a cell |
getCellFilter | returns the filter set in a cell |
getCellValue | returns the value of the cell |
getChildViews | returns child views of the calling component |
getColumn | returns the configuration object of the specified SpreadSheet column |
getFormView | returns master form for the input |
getNode | returns the main HTML container for the calling object |
getParentView | returns the parent view of the component |
getRangeValue | returns values from the range |
getRow | returns the row data by its id |
getSelectedId | returns the first cell in the selected area |
getSelectedRange | returns the range of selected cells |
getSheetData | allows accessing data and ranges of any sheet |
getSheetState | returns the state of visibility of a sheet |
getStyle | returns the style set for the cell |
getTopParentView | returns the top parent view |
groupUndo | marks several actions so that they will be undone together |
hasEvent | checks whether the component has the specified event handler |
hide | hides the view |
hideColumn | hides or shows the column |
hideGridlines | hides or shows the gridlines of the sheet |
hideHeaders | hides all headers of rows and columns on the sheet |
hideRow | hides or shows the row |
ignoreUndo | excludes actions from the history of changes |
innerId | returns the inner ID of an item by its public (real) ID |
insertColumn | inserts an empty column to the left of the specified one |
insertRow | inserts an empty row above the specified one |
isCellLocked | checks whether the cell is locked |
isColumnVisible | checks whether the specified column is visible |
isEnabled | checks whether the view is enabled |
isRowVisible | checks whether the specified row is visible |
isVisible | checks whether the view is visible |
load | loads data from an external data source |
lockCell | protects a cell or a range of cells from editing |
mapEvent | routes events from one object to another |
markCheckbox | marks the specified checkbox |
markRadio | marks the specified radio button |
parse | loads data to the component from an inline data source |
queryView | returns inner element/elements of a widget that correspond(s) to the defined parameters |
recalculate | recalculates all formulas in the current sheet |
redo | repeats the action that was reverted by the undo action |
refresh | repaints spreadsheet |
registerMathMethod | adds a custom function that will be used in formulas |
removeFilters | removes filters from the sheet |
removeSheet | removes a sheet by name |
renameSheet | renames the sheet |
reset | resets the SpreadSheet settings to the initial state |
resetUndo | clears the Undo history |
resize | adjusts the view to a new size |
saveCell | saves changes made in the cell |
serialize | serializes SpreadSheet data to a JSON object |
setCellEditor | creates an editor in a cell |
setCellFilter | creates a select filter |
setCellValue | sets a value for the cell |
setColumnWidth | sets the width of spreadsheet columns |
setFormat | sets a custom format for a cell |
setPlaceholder | fills placeholders in a table with data |
setRangeStyle | sets a style for a range of cells |
setRangeValue | sets a value for the range |
setRowHeight | sets the height of the spreadsheet row |
setSheetState | sets the visibility of a sheet |
setStyle | sets a style for a cell |
show | makes the component visible |
showCell | shifts the focus to the specified cell |
showFormulas | hides or shows formulas inside cells |
showPrintBorders | hides or shows printing borders |
showSheet | shows a sheet by its name |
sortRange | sorts a range of cells |
splitCell | splits merged cells |
ui | allows creating a new UI, the ID of which will be locked in the parent ID space |
unbind | breaks "bind" link |
unblockEvent | cancels events blocking that was enabled by the 'blockEvent' command |
undo | reverts the last operation in SpreadSheet |
zoom | zooms the sheet in |