Grid

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 ( 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.