Grid

Top  Previous  Next

Many of software features show its data on the grid.
You do not have to learn it, the grid is  a common control included in all modern programs and is rather intuitive to use.
However we will describe it in more details.

Example:

wagers_standard

 

Some features only displays the data while some other lets you edit the data directly on the grid.
 

Edit Grid Cells
Do one of the following:

Click a cell.
Focus a cell (for instance, via the keyboard), and press ENTER or F2.
Focus a cell and press any alpha-numeric key. The editor will be invoked and its contents will be replaced with the pressed character.

 

Select and Deselect Cell Text

Press F2 or CTRL+A

 

Close Cell Editor and Accept Changes Made

Do one of the following:

Press ENTER.
Focus other cell
 

Sort Grid Rows

To sort records by a column's values and replace existing sort conditions that are applied to the current or other columns, click the target column's header, until an Up or Down Arrow icon is displayed within the header. The Up and Down Arrows indicate ascending and descending sort orders respectively.
Not always available. Some data cannot be sorted

 

Data Grouping

To group by a specific column, do one of the following:

Drag a column header from the column header panel to the group panel whenever available
Right-click a column header and select Group By This Column from the context menu:

 

To ungroup data by a grouping column, do one of the following:

Drag a column header from the group panel to the column header panel:
Right-click a grouping column's header and select Ungroup from the context menu:

 

To remove grouping by all columns, right click the group panel and select Clear Grouping from the context menu:

To change group order, move a grouping column header to another position within the group panel:

 

Filter Grid Data

In Grids hover over the column header. Click the filter button (img7501 if available) within the column header that appears.
Select the required filter value in the filter drop down list

The filter drop down list will be immediately closed, and the grid will display the data which contain the specified value in the specified column.

To clear the filter applied to a specific column, do one of the following:

Invoke the filter drop down list (see below) and click (All).
In Grid right-click the column header and select Clear Filter

 

 

Common Navigation Operations

 

Clicking a data cell

Moves focus to the clicked cell.

Clicking a data row's indicator cell

Moves focus to the corresponding row preserving the column focus.

Clicking a group row (or its indicator cell)

Moves focus to the clicked row.

Pressing the DOWN ARROW key

Moves focus to the next row preserving the column focus. If an expanded master row is currently focused, navigates to the detail View restoring its focused cell/row.

If the last row of a detail View is currently focused, navigates to the next master row within the master View.

Pressing the UP ARROW key

Moves focus to the previous row preserving the column focus.    If the currently focused row is under an expanded detail, navigates to the detail View restoring its focused cell/row.

If the first row of a detail View is currently focused, navigates to the corresponding master row

 

Pressing the CTRL+UP ARROW key

If the Auto Filter Row is visible and the top data row is currently focused, moves focus to the auto-filter row.

Pressing the HOME key

Moves focus to the first cell within the current row.

Pressing the END key

Moves focus to the last cell within the current row.

Pressing the PAGE DOWN key

Moves row focus one page down preserving the column focus

Pressing the PAGE UP key

Moves row focus one page up preserving the column focus

Pressing the CTRL + HOME key

Moves focus to the first cell within the first row

Pressing the CTRL + END key

Moves focus to the last cell within the last row.

 

Grouping

Dragging a column header from the column header panel to the group panel

Groups the View's data by the column's values.

Dragging a column header from the group panel to the column header panel

Ungroup the View's data and displays the column's values.

Selecting the "Group By This Field"/"Ungroup" item of the column header context menu

Groups/ungroup the View's data by the column's values.

Moving a column header within the group panel

Changes the group order.

Selecting the "Clear Grouping" item of the group panel context menu

Ungroup the View's data.

 

Using Navigation Options

 

TAB

Moves focus to the next cell within the focused row

CONTROL+TAB

Moves focus away from the Grid Control to the next control on software window

SHIFT+TAB

Moves focus to the previous cell within the focused row

ENTER

If a cell value is being edited, closes the active editor and moves focus to the next cell within the focused row

 

Data Editing

 

 

ENTER

Activates the focused cell's editor or closes it saving the changes made

F2

Activates the focused cell's editor. A character key Activates the focused cell's editor and replaces its content with the character typed (this includes the SPACE key also).

ESC

Closes the active editor discarding changes made.

CTRL+DOWN ARROW

Activates the focused cell's editor and opens its popup window (for editors with popup windows only).

 

Selecting Records (when feature allow multiple selections)

 

Clicking a row holding the CTRL key pressed

Toggles the row's selected state preserving the previous selection

Pressing the CTRL+ARROW KEY combination

Enables to move cell focus preserving the current selection

Pressing the CTRL+SPACE key combination

Toggles the focused row's selected state preserving the previous selection.

Clicking a row holding the SHIFT key pressed

Selects all rows between the clicked and the previously focused ones. The previous selection is cleared

Pressing the SHIFT+UP/SHIFT+DOWN key combinations repeatedly

Enables to select a continuous range of rows. When starting such operations, the previous selection is cleared.

Clicking a row holding the CTRL and SHIFT keys pressed

Selects the range of rows between the one clicked, and those previously focused. The previous selection is preserved.

Pressing the CTRL+SHIFT+UP/CTRL+SHIFT+DOWN key combinations

Enables to select a continuous range of rows. The previous selection is preserved.

Clicking a row indicator cell and dragging up/down

Enables to select a continuous range of rows. The previous selection is cleared.

Pressing the CTRL+A key combination

Selects all rows within the View.

 

Expanding and Collapsing Rows and Cards

The following keyboard shortcuts can be used by end-users to change the expanded state of group rows and master rows

RIGHT ARROW

Expands the focused group row.

LEFT ARROW

Collapses the focused group row

CTRL+PLUS

Expands the focused group/master row

CTRL+MINUS

Collapses the focused group/master row.

                                       

The expanded state of rows can also be changed using the following mouse actions:

Clicking a group expand button

Expands/collapses the corresponding group row and focuses it.

Selecting the "Full Expand" item of the group panel context menu

Expands all group rows within a View.        

Selecting the "Full Collapse" item of the group panel context menu

Collapses all group rows within a View.

Clicking a master-detail expand button

Expands/collapses the corresponding master row and focuses it.

Double-clicking a row indicator cell

Expands/collapses the corresponding group/master row.

Double-clicking a group row

Expands/collapses the corresponding group row.

 

Copying Selected Records to the Clipboard

Pressing the CTRL+C key combination - Copies the selected records to the clipboard as text.

 

Resizing Columns and Bands

 

 

Dragging a column header edge

Changes the column's width. Dragging a band header edge Changes the band's width

Double clicking a column header edge

Changes the column's width to 'best fit' its content

Double clicking a band header edge

Changes the band's width so that child columns 'best fit' their contents

Selecting the "Best Fit"/"Best Fit (all columns)" item from the column header context menu

Applies best fit to the corresponding column/all columns.

 

 

Reordering Columns and Bands

Dragging a column header and dropping it to the new position within the column header panel.
Dragging a band header and dropping it to the new position within the band header panel.

 

Sorting (if available)

In a Grid View, clicking a column header.

In a Card View, clicking a Sort button within the Customization drop down.

In a Layout View, clicking a Field Sort Button.

Sorts by the column's values by replacing any existing sort conditions

Holding the SHIFT key down while:

- clicking a column header in a Grid View;

- clicking a Sort button within the Customization drop down in a Card View.

- clicking a Field Sort Button in a Layout View.

 

Sorts by the column's values by amending or creating the sort conditions.

 

Holding the CTRL key down while:

- clicking a column header in a Grid View;

- clicking a Sort button within the Customization drop down in a Card View.

- clicking a Field Sort Button in a Layout View.

 

Removes sorting by the column's values but preserves other sort conditions.

 

Selecting the "Sort Ascending"/"Sort Descending" item of the column header context menu

 

Applies sorting by this column's values in ascending/descending order. Existing sort conditions are preserved.

 

 

Filtering

The following operations can be performed to change the filter conditions applied to a View. (if available)

 

Clicking a filter button within a Grid View's column header.

Clicking the Filter button within the Customization drop down in a Card View.

Clicking a Field Filter Button in a Layout View.

Invokes the filter drop down.  Note: if filtering is applied, the filter drop down only displays values which match the filter criteria.

Holding the SHIFT key down while:

- clicking a filter button within a Grid View's column header;

- clicking the Filter button within the Customization drop down in a Card View.

- clicking a Field Filter Button in a Layout View.

Invokes the filter drop down. The values list doesn't depend upon the filtering conditions applied.

Selecting the "Clear Filter" item from the column header context menu

Cancels the filtering applied by that column.

Clicking the close button within the filter panel

Clears all the filtering conditions applied to a View.