Grid Context Menus
Grid Menu
Right clicking the grid gives you shortcuts to edit the values and create quick filters:
- Edit the value of the clicked column for all selected rows
- Edit multiple items in a numbered sequence
- Copy Value of the clicked cell
- Copy...: create custom value range with or without headers
- Select All: select the entire grid (so that you can copy/paste)
- Select in 3D: select the matches of the clicked row in 3D
- Select Same: filter the data on clicked value and select matches in the viewer
- Filter Same: filter the data on clicked value
- Filter Orphans: filter the data only on items that do not have a match in the viewer
Header Menu
Right clicking the columns headers in the grid give you access to several commands:
- Columns: Open the Layout definition to pick change column visibility, order etc.
- Calculated Column: Create a new Calculated Column or edit an existing one
- Data Pivot: Edit the DataView Data Pivot
- Colour Filter: Create a new Colour Filter for the clicked column
- Clear Column Filter: Clears all columns filters
- Custom Filters: Create a Custom Filter for the column with custom operators like GreaterThan, LessThan, LessOrEqualTo etc.
- Values Tree Filter: Modify the Column Filter
Sorting
The data can be sorted by clicking on the column headers.
Hold the Control Key pressed to sort by multiple columns consecutively.