Tables in ACP

<<Back to Analytica Cloud Platform

Copy/paste

To copy cells from a 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).

Sorting and Filtering by Column

• New to ACP Build 174 You can sort and filter the cells displayed in a result table using the table filtering functionality.
  • There is an AcpStyle to turn this feature off - TableFiltering:false
• Click on the filtering icon to see the table filtering popup.
  • The filtering opens with sections for sorting, contains and search.

Sorting is ascending or descending
Contains allows you to select only rows with the values you enter< br /> Search has a search box and also allows you to select < br />

Show or hide the totals column/row

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

{For the columns, the icon is only present when index menus are showing}

Sort columns

This has been replaced by the table filtering functionality above, except when the AcpStyle is false.

• When you click on a column mouse over header, a sort icon appears which you can click to sort by that column. Also shows an up or down arrow icon letting you know that it is sorted by that column.
• 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.

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