Template:Grid

Grid Basics

Every grid in WireCAD has the same basic functionality. Some functionality is disabled in some grids.

• Not all grids display the filter pane.
• Not all grids display the Add New pane.
• Not all grids display the Group panel.

Exporting Data

Any grid can export data to the following formats:

• Excel
• XML
• HTML
• Text

Data is exported with the current column display order, grouping and sorting applied.

Definitions

Overview

Column Header: The caption at the top of the grid column.
Row: Grid row.
Active Row: The current row that may or may not be editing.
Active Cell: The current cell that is involved in an edit. It has focus.
Selection: Highlighted array of cells upon which an action may be performed.

Sorting

Sorting

Clicking any column header will sort by that column. Clicking it again will change the sort direction.

Grouping

Grouping

Dragging any column header and dropping it onto the Group Panel groups the grid by that column.

Reordering Columns

Reorder Columns

Dragging any column header and dropping in on another column header moves that column.

Display/Hide Columns

Choose Columns

1. Right-click any column header.
2. Select [Choose Columns].
3. Drag existing column headers to the dialog to hide them.
4. Drag columns from the dialog to the grid to show them.

Filtering Data

Using the Filter Pane (if visible)

Filter Editor

Filter on existing item