Details
-
Type:
New Feature
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: None
-
Fix Version/s: 3.0
-
Component/s: ICE-Components
-
Labels:None
-
Environment:All
-
Affects:Documentation (User Guide, Ref. Guide, etc.), Sample App./Tutorial
-
Workaround Exists:Yes
-
Workaround Description:The ICEfaces EE Composite Components includes an editable dataTable component that provides some of the features of the new Rich Data Grid, and is available now as part of the ICEfaces Enterprise Edition release.
Description
Potential features include:
* Resizable rows and columns (height and width)
* Moveable columns (users can optionally change the order of the columns)
* Editable cells (users can click to edit the cell, the component used to edit the cell would be dependent on the data type of the cell (selectInputDate for dates, inputText for text, Checkbox for boolean, etc.) Leaving the edited cell (focus) or pressing Enter would leave edit mode.
* Ability to apply validators to columns based on data-type (or custom).
* Ability to insert and delete rows (configurable)
* Ability to scroll and/or paginate the table contents
* Ability to freeze or split the table columns into two regions with separate horizontal scrollbars for each region.
* Select rows (single or multi) using mouse and keyboard.
* Filter grid data by entering filter criteria for one or more columns (e.g.
http://www.teamdev.com/quipukit/demo/datatable/DataTable_filteringAndPaging.jsf )
* Complete event model for all component events that the application listen for and intercept, etc.
* Ability to work with very large data-set sizes seamlessly - use live-scrolling technique to dynamically load additional data into the view as required.
* Support the 'scope' attribute for 'tr' and 'td' tags in order to allow the creation of accessible data grids
* Include an autoSort=[true/false/default] attribute which enables automatic sorting of columns
The technical capabilities required to support such a rich component should be provided by the new Component Development Platform 2.0 initiative.
Issue Links
Activity
- All
- Comments
- History
- Activity
- Remote Attachments
- Subversion
Would this be better as a couple of different components or just one component? I could see a bunch of this functionality being really nice in a regular data table, but maybe I don't want everything each time.
Please consider to also add the possibility to paste from eg. Excel. a rectangle of cells!
Supporting random cell selection/Cut & Paste functionality would be a killer feature for such grid.
Imagine the scenario: user selects random set of cells with a mouse gesture and hits Ctrl-C. Grid component calls an app-specific listener on the server side and passes the selection of cells. At this point the server-side Java code is free to form Excel spreadsheet out of them or do whatever it needs to do.
That is the functionality that currently cannot be easily implemented with a set of already existing components. It really adds value.
Feature Request: Allow flexible positioning for the sorting icon. Currently the commandSortHeader component's arrow icon can't be postitioned dynamically in applications where table column widths are not explicitly set.
It would also be very nice if a cell could turn into a drop down list when it becomes editable.
Providing the list of available values could be tricky, provide at column level?
Feature Request: Add in support for percentage column widths.
Feature Request: Add the ability to natively read (Excel) .xls files as well as txt, (comma separated) csv, and (tab separated) tsv files.
I'm interested in this functionality. Is it going to be a new plugin? Is there a place from where to download it to try?
Many Thanks
The new Rich Data Grid is not implemented yet, but is on the roadmap for ICEfaces 2.0 Component Suite this year.
This component has essentially appeared with the ace:dataTable and supporting components in the ICEfaces 3.0 release.
Supported features include:
- Resizable columns
- Moveable columns (users can optionally change the order of the columns)
- Editable rows / cells
- Ability to scroll and/or paginate the table contents
- Ability to freeze headers and footers when scrolling dataTable contents
- Select rows (single or multi) using mouse and keyboard.
- Filter data by entering filter criteria for one or more columns
- Complete event model for all component events that the application listen for and intercept, etc.
- Ability to work with very large data-set sizes seamlessly - use live-scrolling technique to dynamically load additional data into the view as required.
- Includes full multi-column sorting support.
- Optional user configuration popup to hide/show cols, set sort order, etc.
- Expandable rows or panels
- Support for n-level nested dataTables.
How about moveable rows as well? Dragging rows from one table to another, or manually resorting the row order through dragging would be great!