The Slickgrid module is an implementation of Michael Leibman's jquery slickgrid plugin , a lightening fast JavaScript grid/spreadsheet. It defines a slickgrid view style, so views can be output as an editable grid.
Slickgrid views can be customised to allow:
Editing
Field grouping
Collaspible taxonomy fields (tree structures)
Resize, reorder & hide columns
Delete nodes via the grid
Async editor loading for large datasets.
Auto edit (if an cell editor is defined, activate on entry to the cell; otherwise double click to edit)
Force fit columns (to fill the available column space)
Multi edit (checkboxes will be displayed in the rows. When you edit a row, all selected rows will be updated with the same value)
Undo (undo previous changes - uses node revisions)
Viewport height
Row height
At the front end, users can show/hide, resize, reorder columns & resize the height of the grid. These settings will be stored per user and used next time the grid is shown. Saving the view (via the usual views UI) will reset these settings.
For every field defined in the view, you can set its column width, whether it's sortable, and formatters (how the cell data is displayed), an editor, a validator and filters (for filtering the column data). This module implements a hook_slickgrid_plugin so other modules can define additional formatters, editors etc.,
This modules comes with the following plugins ready to use:
Editors:
Text cell editor (for editing inline in the grid, used for text_textfield, text_textarea, node_title & date_text fields)
Simple textarea (a popup textarea, used for text_textarea and node body fields)
Popup node form (pops up the portion of the node form for the field, can be used for all fields)
Validators:
Required field
Filters:
Text filter (case-insensitive text filter - if the column cell contains the text it will be displayed)
Formatters:
TODO
Requirements & recommendations
This module requires:
Views
Ajax load
Beautytips
If using the grid as an editor, it's best used with Editor views so nodes can be filtered based on edit & delete permissions.
Warning
The slickgrid plugin requires jquery 1.4.3 & jquery UI 1.8.5. These libraries are included as part of Slickgrid, and added to all slickgrid views pages.
(Actively maintained, Under active development, Modules, Content, Filters/Editors, JavaScript Utilities, Third-party Integration, Utility, Views)