SpreadJS includes many different cell types you can apply to any individual cell. Cell Types allow you to define the type of information that can be entered and displayed in the cell. You can also use predefined dropdowns to make it easier for your users to select and enter valid data.
The combo box cell type allows you to add a drop-down list to any cell which can be non-editable or editable. Type in the edit portion of the cell, and the matching item is selected automatically.
The radio button cell type allows you to add radio button lists to any cell. Users can select one item from the available options. Customize the list display options, including text alignment, layout, direction, and spacing.
The button list cell type can add multiple buttons to any cell to select data. Provide users with the flexibility to choose one or multiple items from various options while working with spreadsheets.
The rich text feature can format text with different styles, text-decoration, text alignment, text in a vertical direction, word wrap, and text-indent. Utilize built-in JSON features with serialization, auto fit, and more.
Quickly and easily select data with the cell dropdown menu feature. Create input form controls, advanced structured forms, and other interactive forms and dashboards within the spreadsheet. The cell dropdown options currently available in SpreadJS:
Developers can create this drop down by specifying a data source and column information, and then setting the style. The PROPERTY function can be especially useful for parsing the returned object, which is described in the PROPERTY Function section of this blog.
Group Cascade List Dropdown
A text list with cascading sub-items and groups. This is a combination of the previous two vertical group lists, utilizing both groups and sub-items in those groups that cascade open.
Vertical Tree List Dropdown Collapse
A text list with vertical, collapsible tree items. Items in this list can be grouped similar to other lists, but with the ability to collapse and expand the items.
A slider dropdown with a vertical sliding scale. Similar to the horizontal slider dropdown, the different points on the slider can be defined specifically, and can be used for creating things like thermometers.
SpreadJS v16.2 is available. This release offers several great new features, some of which include:
And Much More!