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
•  (Un)Freeze: Freeze or Unfreeze the column during horizontal scroll
• 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.