Sort Table Rows Action
Event Function: TableSort
The Sort Table Row action allows the rows in a specified table to be sorted by the method indicated. Header and total rows can be excluded from the sort.
Using the Events tab
Under | Enter | Example |
---|---|---|
Run Skip Condition |
If desired, enter skip conditions for the event. When the "Run Skip Condition" is evaluated to be true, the action is not performed. |
|
Table Name |
The table label of the table to be sorted. Data must be entered as there is no default. |
"ABC" |
Order |
"Ascending" "Descending" "Manual" |
"Ascending" Ascending Order |
Sort Column 1 |
Column of cells to sort by. |
2 |
Sort Column 2 |
Optional second sort key to sort by. The default is 0. |
3 |
Skip first rows |
Do not include this many rows at the table beginning in sorting. Defaults to zero so that no rows skip. |
2 |
Skip last rows |
Do not include this many rows at the table end in sorting. Defaults to zero so that no rows skip. |
1 |
Syntax (if entering it in the Equation bar)
ACTION("TableSort",expr1,expr2,expr3,expr4,expr5)
Where
expr1 = entry under Table Name
expr2 = entry under Order
expr3 = entry under Sort Column 1
expr4 = entry under Sort Column 2
expr5 = entry under Skip first rows
expr6 = entry under Skip last rows
How the example will appear in the Equation bar
ACTION("TableSort","ABC", "Ascending", 2, 3, 2, 1)
Sorts in ascending order using cells in columns 2 as the primary sort key, and cells in column 3 to resolve sorting order for duplicate cells in column 3, ignoring the first 2 header rows and one footer row in the table.
Notes
-
If you rename a table, none of the related events (sort, insert, delete row) for that table gets an updated name. However, you can use the celltable() function to create a reference to the table. If the event is within a table, you can use celltable() to get the table label automatically. If the event is outside of the table, you can use celltable(abc.a1), where abc.a1 is a cell number, to get the table label.
This function always returns the table label even when table abc is renumbered.
- Table sorts cannot be done on tables that span more than one section since sorting the table could require rows not in the section be sorted above rows that are in the section. If the section covers the entire sort group, the sort is allowed.