Grid - Customize

The Customize Grid dialog box is used in many places within the program. Almost every grid can be customized. Setttings to a particular gird are generally saved between invocations of the grid.

Span Available Width

When checked, all fields (i.e., columns) are shown within the width of the grid. If the grid width is too small, fields are compressed and may not be easily visible. If the grid width is too large, fields are padded with blank space.

Word Wrap

When checked, text data may be wrapped onto following lines within the grid row. This increases the height of the affected grid rows.

Best Fit - All Columns

Invokes the grid's autofit function to best fit the data within the grid.

Modify Columns

Invokes the Grid Column Editor to modify which fields are visible, their position within the grid, and their width.

Default All

Sets all fields to their default visibility, width, and position within the grid.

Show All

Makes all columns visible, even those that may be hidden and of internal use to the program.

Filter Editor

Allows a custom filter to be applied to the data in the grid. This is rarely used, and only necessary for large datasets in which a customized filter is desired.

Font Size

Specifies the font size for the text in the grid

Export...

Allows the grid to be exported in HTML, PDF, RTF, TXT, XLS, or XLSX format.

Clear Filters

Clears all filters currently applied to the grid. All grid rows will be shown.

Expand All

If the grid is grouped by one or more columns, all rows in all groups will be shown.

Collapse All

If the grid is grouped by one or more columns, all rows in all groups will be hidden. This allows viewing of the group structure of the data. Any specific group may be expanded by pressing the corresponding '+' button.

Clear

If the grid is grouped, all grouping is undone, and the grid returns to its normal state.

Find

When checked, the Find Panel is shown above the grid. The Find Panel allows filtering to only show grid rows that contain the entered text.

If the text contains a space, and you want that specific text string to be found, place double quotes around the text. Otherwise, the search results will be all rows that contain any of the text words.

Group By

When checked, the Group By Panel is shown above the grid. The Group By Panel initially has text that says 'Drag a column header here to group by that column'. One or more column headers may be dragged into the Group By Panel to group the grid to group by those columns. A column header may be dragged back on the grid header row to remove that column from grouping.

Column Filters

When checked, a green Column Filters row appears immediately below the column headers. Text can be entered in any of the columns of the Column Filters row. This filters the grid to only display rows where that column contains the entered text.

Navigate

When checked, a row appears at the bottom of the grid, that shows the number of rows in the grid, and the index of the selected row. Also shown are small buttons that change the selected row to be the first, previous page, previous row, next row, previous page, or last row in the grid.

Displays Customize Grid - Find Panel - Help

Header Font Size

Changes the font size of the header row.

Group Row Font Size

Changes the font size of the group rows.

Close

Closes this dialog box.