Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major 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.

        Issue Links

          Activity

          Ken Fyten created issue -
          Ken Fyten made changes -
          Field Original Value New Value
          Estimated Complexity High
          Fix Version/s 2.0 [ 10032 ]
          Affects [Documentation (User Guide, Ref. Guide, etc.), Sample App./Tutorial]
          Ken Fyten made changes -
          Link This issue blocks ICE-707 [ ICE-707 ]
          Ken Fyten made changes -
          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.
          Michael Thiem made changes -
          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.
          Michael Thiem made changes -
          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.
          Hide
          Tim Lawson added a comment -

          How about moveable rows as well? Dragging rows from one table to another, or manually resorting the row order through dragging would be great!

          Show
          Tim Lawson added a comment - How about moveable rows as well? Dragging rows from one table to another, or manually resorting the row order through dragging would be great!
          Ken Fyten made changes -
          Assignee Adnan Durrani [ adnan.durrani ]
          Adnan Durrani made changes -
          Attachment GridMatrix.doc [ 11064 ]
          Ken Fyten made changes -
          Attachment GridMatrix.doc [ 11064 ]
          Hide
          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.

          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.
          Ken Fyten made changes -
          Assignee Adnan Durrani [ adnan.durrani ]
          Hide
          Wolfgang Röckelein added a comment -

          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!
          Hide
          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.

          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.
          Hide
          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.

          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.
          Hide
          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?

          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?
          Hide
          Arran Mccullough added a comment -

          Feature Request: Add in support for percentage column widths.

          Show
          Arran Mccullough added a comment - Feature Request: Add in support for percentage column widths.
          Arran Mccullough made changes -
          Salesforce Case [50070000007cTit]
          Hide
          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.

          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.
          Hide
          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

          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
          Hide
          Ken Fyten added a comment -

          The new Rich Data Grid is not implemented yet, but is on the roadmap for ICEfaces 2.0 Component Suite this year.

          Show
          Ken Fyten added a comment - The new Rich Data Grid is not implemented yet, but is on the roadmap for ICEfaces 2.0 Component Suite this year.
          Ken Fyten made changes -
          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]
          Ken Fyten made changes -
          Fix Version/s 2.0.0 [ 10230 ]
          Fix Version/s 2.0-Alpha3 [ 10032 ]
          Hide
          Ken Fyten added a comment -

          Will not make ICEfaces 2.0.0 release.

          Show
          Ken Fyten added a comment - Will not make ICEfaces 2.0.0 release.
          Ken Fyten made changes -
          Fix Version/s 2.0.0 [ 10230 ]
          Ken Fyten made changes -
          Link This issue depends on ICE-6030 [ ICE-6030 ]
          Hide
          Ken Fyten added a comment -

          Add another desired feature for this new component.

          Show
          Ken Fyten added a comment - Add another desired feature for this new component.
          Ken Fyten made changes -
          Fix Version/s 2.1 [ 10241 ]
          Ken Fyten made changes -
          Fix Version/s 3.1 [ 10312 ]
          Fix Version/s 3.0 [ 10241 ]
          Hide
          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.
          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.
          Ken Fyten made changes -
          Status Open [ 1 ] Resolved [ 5 ]
          Fix Version/s 3.0 [ 10241 ]
          Fix Version/s 3.1 [ 10312 ]
          Resolution Fixed [ 1 ]
          Ken Fyten made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              Unassigned
              Reporter:
              Ken Fyten
            • Votes:
              72 Vote for this issue
              Watchers:
              33 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: