Difference between revisions of "Tables in ACP"

Revision as of 10:56, 8 April 2021

Tables in ACP

Sorting by Column or Row

Hover the mouse in any column or row header cells (including above row index & total column). A sort ascending button appears in the cell. The button goes through 3 states: Ascending sort, Descending sort, no sort.

Show or hide the totals column/row

When you hover over the row or column index label, a totals icon appears. Click it to toggle showing the totals column or totals row.

When you click on a column or row header, the table sorts according to that column or row, and shows an up or down arrow icon letting you know that it is sorted by that column.

Notes: The sort is treated as very transient. Sort is cancelled by pivoting, changing cells in edit table, etc.

@@ Line 3: / Line 3: @@
 ==Sorting by Column or Row==
+*Hover the mouse in any column or row header cells (including above row index & total column). A sort ascending button appears in the cell. The button goes through 3 states: Ascending sort, Descending sort, no sort.
 ==Show or hide the totals column/row==
-Add a feature to sort the rows of a table with a click in the column header.
+*When you hover over the row or column index label, a totals icon appears. Click it to toggle showing the totals column or totals row.
-The ability to sort the rows of a table by a selected column is a very common (nearly ubiquitous) feature of online tables. We should have the same. An example is the table of issues in Enterprise Wizard. When you click on a column header, the table sorts according to that column, and shows an up or down arrow icon letting you know that it is sorted by that column.
-In our case, we probably want to do it by having a small icon to the right of the column label. We don't want the column label to be used for this, because we sometimes use the column label to hyperlink by identifier. Also, it is especially important to have this in the cell above a row index, since that is the column that would be one of the most common ones to sort on.
-We need a way to sort ascending and descending. Most sites use a toggle. Also, we need a way to stop sorting and return to the original. The design needs to take into account that we will eventually have multiple column indexes.
-We will also probably want to eventually have two other similar icons: Filter and Totals (The Totals would apply only to a row index).
-I suggest that this feature would support single-column sorts only -- i.e., no 2nd column sort for breaking ties, etc.
+When you click on a column or row header, the table sorts according to that column or row, and shows an up or down arrow icon letting you know that it is sorted by that column.
-Click X2 for result table
+Notes: The sort is treated as very transient. Sort is cancelled by pivoting, changing cells in edit table, etc.
-Hover mouse in any of the column header cells (including above row index & total column)
-{ Expected: A sort ascending button appears in the cell }
-{ Expected: The button goes through 3 states: Ascending sort, Descending sort, no sort }
-Comments:
-c.f. 682 - A very closely related feature.
-Notes: The sort is treated as very transient. Sort cancelled by pivoting, changing cells in edit table, etc.