Properties

animate defines the type of animation, with which the view is shown, if it is a Multiview cell
borderless used to hide the component borders
bottombar enables a bottombar for switching between sheets
buttons contains the names of blocks that contain lists of button names
clipboard enables/disables clipboard support on desktop devices
clipboardDecimalDelimiter sets a decimal delimiter for correct copy/paste of numbers between SpreadSheet and Excel
clipboardNumberFormat sets a format for correct copy/paste of numbers between SpreadSheet and Excel
columnCount the number of columns in the SpreadSheet
columnWidth defines the default width for columns (in pixels)
conditionStyle specifies a set of conditional styles
container an HTML container (or its ID) where the component should be initialized
css the name of the CSS class or the object with styles that will be applied to the view container
data JavaScript array containing data for the component
datatype the type of loaded data
disabled indicates whether an item is enabled
gravity sets the view gravity
height sets the height of the component
hidden defines whether the view will be hidden initially
id the ID of a widget
liveEditor toggles the formula editor in spreadsheet
maxHeight sets the maximum height for the view
maxWidth sets the maximum width for the view
menu adds a dropdown menu at the top of SpreadSheet
minHeight sets the minimal height for the view
minWidth sets the minimal width for the view
on allows attaching custom handlers to inner events of the component
padding defines the space between the element borders and content (applies the specified value to all sides).
paddingX sets the right and left padding (applies the specified value to both sides)
paddingY sets the top and bottom padding (applies the specified value to both sides)
prepareData prepares data before parsing
readonly makes SpreadSheet readonly
resizeCell defines whether cells of spreadsheet can be resized
rowCount the number of rows in the SpreadSheet
rowHeight sets the default height for rows
save defines a path to the server to save cell changes to
sheetStubs takes into account styles in empty cells when loading Excel files
sheetTabWidth sets the width of a sheet tab
strict defines whether math calculations should behave similarly to Excel
subbar adds a view between the toolbar and the datatable
toolbar sets toolbar mode and configuration
type defines the layout borders
url the URL which the component will use to load data after its initialization
width sets the width of a widget
Back to top