Difference between revisions of "Tables in ACP"

(Created page with " Tables in ACP ==Sorting by Column or Row== ==Show or hide the totals column/row== Add a feature to sort the rows of a table with a click in the column header. The ability...")
 
(One intermediate revision by the same user not shown)
Line 2: Line 2:
 
Tables in ACP
 
Tables in ACP
  
==Sorting by Column or Row==
+
==Copy/paste==
==Show or hide the totals column/row==
+
===To copy cells from an edit table to the clipboard ===
Add a feature to sort the rows of a table with a click in the column header.
+
*For a single cell, single click on one cell and then [CTRL + C].
 +
*For a range of cells, single click on a cell at one corner of the range of cells you want to copy, then [SHIFT+Click] on a cell at the other corner to select the entire range of included cells, and CTRL+C.
  
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.
+
===To paste into an Edit table from the clipboard===
 +
*To paste into an edit table from the clipboard, single click on the cell you want to paste into (for a single cell) or the top left cell of the range you want to paste into and CTRL+V - the cells will paste into the edit table.  
 +
*If you double click the edit table cell and paste, the entire contents of the clip board will paste into the single cell with the contents selected (as it does in Excel).
  
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.
+
===Copying cells from a result table===
 +
This functionality is currently incomplete.
  
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.
+
==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.
  
We will also probably want to eventually have two other similar icons: Filter and Totals (The Totals would apply only to a row index).
+
==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.
  
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.
 

Revision as of 03:01, 7 January 2023

Tables in ACP

Copy/paste

To copy cells from an edit table to the clipboard

  • For a single cell, single click on one cell and then [CTRL + C].
  • For a range of cells, single click on a cell at one corner of the range of cells you want to copy, then [SHIFT+Click] on a cell at the other corner to select the entire range of included cells, and CTRL+C.

To paste into an Edit table from the clipboard

  • To paste into an edit table from the clipboard, single click on the cell you want to paste into (for a single cell) or the top left cell of the range you want to paste into and CTRL+V - the cells will paste into the edit table.
  • If you double click the edit table cell and paste, the entire contents of the clip board will paste into the single cell with the contents selected (as it does in Excel).

Copying cells from a result table

This functionality is currently incomplete.

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.

Comments


You are not allowed to post comments.