Methods

addFilter adds a filter into a cell
addImage adds an image 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
getRow returns the row data by its id
getSelectedId returns the ids of all cells in the select area
getSelectedRange returns the range of selected cells
getSheetData allows accessing data and ranges of any 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
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
removeFilter 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
setStyle sets a style for a cell
show makes the component visible
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
Back to top