Grid

<< Click to Display Table of Contents >>

Navigation:  Using Cimera > How Lists of Items are Displayed >

Grid

Previous pageReturn to chapter overviewNext page

The Grid lists items, in the same way that the standard Item List does, but provides more functionality for filtering, grouping sorting, arranging.

 

The grid may be presented in its own window or as a tab in the Query Results pane (see Query Window)

 

Clicking an item will open the Item Details window for that item, unless the grid is displaying results from a Reporting DB Query.

 

Grid Window

 

1 Column Grouping

 

By dragging a column header onto the header bar the items will be grouped by that value.

Dragging multiple columns will give sub groups etc

 

 

2 Column Actions

 

The icons on the column header provide standard Excel Filter style sorting, filtering and pinning.

Click-and-dragging the column header allows column re-ordering.

 

3 Actions

 

The Actions button provides access to a sub-menu:

 

Grid Actions Menu

 

Show or hide columns

 

Select which columns are displayed

 

Resize all visible rows

 

Resize columns to fit data on all rows that are visible

 

Resize all rows

 

Resize columns to fit data on all rows regardless of whether they are visible or not

 

Include header text when resizing

 

Whether to include or ignore the width of the column header text when resizing

 

Print with preview

 

Print grid with option to select columns and preview before printing

 

List

 

Open a new window with a Cimera list containing the items

 

Export to Excel

 

Export the grid to a .xls (Excel 97-2003) file and open in Excel. Any grouping will be preserved and

 

Remove all colours (for exporting)

 

Remove any cell colouring

 

Toggle card view

 

Change to / from card view mode:

 

Grid card view

 

Expand group 1

 

Expand the first group (in the example - Owner)

 

Expand all

 

Expand all groups (in the example - Owner and Status)

 

Collapse all

 

Collapse all groups