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
None of this is written in stone but the general idea is that a new Rich Data Grid component would provide user-interface capabilities similar to a spreadsheet (without the calculating etc., just UI presentation and capabilities).
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.
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
| Field | Original Value | New Value |
|---|---|---|
| Estimated Complexity | High | |
| Fix Version/s | 2.0 [ 10032 ] | |
| Affects | [Documentation (User Guide, Ref. Guide, etc.), Sample App./Tutorial] |
| Description |
None of this is written in stone but the general idea is that a new Rich Data Grid component would provide user-interface capabilities similar to a spreadsheet (without the calculating etc., just UI presentation and capabilities). 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. * 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. The technical capabilities required to support such a rich component should be provided by the new Component Development Platform 2.0 initiative. |
None of this is written in stone but the general idea is that a new Rich Data Grid component would provide user-interface capabilities similar to a spreadsheet (without the calculating etc., just UI presentation and capabilities). 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. The technical capabilities required to support such a rich component should be provided by the new Component Development Platform 2.0 initiative. |
| Description |
None of this is written in stone but the general idea is that a new Rich Data Grid component would provide user-interface capabilities similar to a spreadsheet (without the calculating etc., just UI presentation and capabilities). 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. The technical capabilities required to support such a rich component should be provided by the new Component Development Platform 2.0 initiative. |
None of this is written in stone but the general idea is that a new Rich Data Grid component would provide user-interface capabilities similar to a spreadsheet (without the calculating etc., just UI presentation and capabilities). 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 The technical capabilities required to support such a rich component should be provided by the new Component Development Platform 2.0 initiative. |
| Description |
None of this is written in stone but the general idea is that a new Rich Data Grid component would provide user-interface capabilities similar to a spreadsheet (without the calculating etc., just UI presentation and capabilities). 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 The technical capabilities required to support such a rich component should be provided by the new Component Development Platform 2.0 initiative. |
None of this is written in stone but the general idea is that a new Rich Data Grid component would provide user-interface capabilities similar to a spreadsheet (without the calculating etc., just UI presentation and capabilities). 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. |
| Assignee | Adnan Durrani [ adnan.durrani ] |
| Attachment | GridMatrix.doc [ 11064 ] |
| Attachment | GridMatrix.doc [ 11064 ] |
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.
Show
Jason Porter
added a comment - 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.
| Assignee | Adnan Durrani [ adnan.durrani ] |
Please consider to also add the possibility to paste from eg. Excel. a rectangle of cells!
Show
Wolfgang Röckelein
added a comment - 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.
Show
Sergey Petrov
added a comment - 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.
Show
Arran Mccullough
added a comment - 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?
Show
Marcel Groeneweg
added a comment - 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.
Show
Arran Mccullough
added a comment - Feature Request: Add in support for percentage column widths.
| Salesforce Case | [50070000007cTit] |
Feature Request: Add the ability to natively read (Excel) .xls files as well as txt, (comma separated) csv, and (tab separated) tsv files.
Show
Robert Smith
added a comment - 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
Show
Marla Martin
added a comment - 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.
| 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. | |
| Workaround Exists | [Yes] |
| Fix Version/s | 2.0.0 [ 10230 ] | |
| Fix Version/s | 2.0-Alpha3 [ 10032 ] |
| Fix Version/s | 2.0.0 [ 10230 ] |
| Fix Version/s | 2.1 [ 10241 ] |
| Fix Version/s | 3.1 [ 10312 ] | |
| Fix Version/s | 3.0 [ 10241 ] |
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.
Show
Ken Fyten
added a comment - 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.
| Status | Open [ 1 ] | Resolved [ 5 ] |
| Fix Version/s | 3.0 [ 10241 ] | |
| Fix Version/s | 3.1 [ 10312 ] | |
| Resolution | Fixed [ 1 ] |
| Status | Resolved [ 5 ] | Closed [ 6 ] |
How about moveable rows as well? Dragging rows from one table to another, or manually resorting the row order through dragging would be great!