The grid manager

You can oversee the grid layout and data display preferences through a grid-specific console called the Grid Manager.
Show/hide the Grid Manager by clicking the corresponding toolbar button.

It can also be toggled using the grid side bar button, or by using Ctrl + J.

Once visible, you can resize the Grid Manager by dragging the window border between the Grid Manager and the grid itself.

TIP	You can also detach Grid Manager into a separate window by clicking the icon in its upper left corner.

Using the Grid Manager

Scroll down or click each section below for more details:

Grid Manager Toolbar and Context Menu Options

The Grid Manager Toolbar

The toolbar options function as follows:

	Detach Grid Manager window	Sets the Grid Manager as a floating window.
	Dock Grid Manager window	Locks the Grid Manager to its flexYgrid.
	Categorized Column Configuration	Selected default mode. Column names are categorized by family.
	Sorted Column Configuration	Mode in which columns can be sorted manually in a flat layout.
	Live Column Configuration	Mode in which columns can be moved manually.
	Resize selected columns according to visible data	Resizes the column on the visible grid data as it is displayed. In the grid, single columns can be resized by double-clicking the column separator to the right of the column.
	Resize selected columns based on full data set	Resizes only on the full grid data set. This does not include the column header. In the grid, single columns can be resized by holding Shift and double-clicking the column separator to the right of the column.
	Resize selected columns according to header	Resizes only on the column header. This does not include the full grid data set. In the grid, single columns can be resized by holding Ctrl and double-clicking the column separator to the right of the column.
	Resize according to header and full data set	Resizes on the column header and on the full grid data set. In the grid, single columns can be resized by holding Ctrl + Shift and double-clicking the column separator to the right of the column.
	Resize selected columns to default	Resizes using the Ytria default sizing.
	Select Column In Grid (Ctrl + Enter or double click with the mouse)	Moves to the selected column in the grid.

The Grid Manager context menu

This menu contains a slightly different option selection as the toolbar:

Resize to Header Title: This option resizes the selected columns based only on their headers. This does not include the full data set within the columns.
Resize to Visible Data: This option resizes the selected columns based on the visible grid data as displayed currently seen on the screen. This does not affect the column header, and will not consider the full data set of the selected columns.
Toggle all selected and editable checkboxes in column 'Grid Manager column name' (Space): This option will affect the Grid Manager column that the mouse cursor is hovered over when you click. It will toggle all selected entries' checkboxes between on and off.
Check all selected and editable checkboxes in column 'Grid Manager column name' (Ctrl + Space): This option will affect the Grid Manager column that the mouse cursor is hovered over when you click. It will set all selected entries' checkboxes to Checked.
Un-check all selected and editable checkboxes in column 'Grid Manager column name' (Shift + Space): This option will affect the Grid Manager column that the mouse cursor is hovered over when you click. It will set all selected entries' checkboxes to Unchecked.
Select Column in Grid (Ctrl + Enter): This moves the column focus in the grid to the column that is selected in the Grid Manager list. If multiple columns are selected, the focus will be moved to the column name that was selected last.
'Edit Selected Column Settings…' (Ctrl + Shift + F): This will open the 'Column Settings' dialog. For more information see this page.

NOTE	If you activate this option with more than one Grid Manager entry selected, all selected columns will be active in the 'Column Settings' dialog. The different columns and their current settings will be shown in a grid for easier management.

flexYgrid Column Display

The Grid Manager has three inner flexYgrid column display modes available:

Categorized Column Configuration
: This is the default configuration. The columns are grouped by category and listed in the order they appear in the grid.

Sorted Column Configuration
: Columns are listed alphabetically. This does not affect column position in the grid.

Live Column Configuration
: Columns are listed per their position in the grid. This configuration lets you manually organize column positions by dragging column names to the desired position.

Step 1:

Step 2:

TIP	Editing columns (shortcuts): Navigate the Grid Manager using ↑ / ↓ / ← / → and use the Space Bar to modify the editable cell at the intersection of the focused row and column.

Column Type/Status Indicators

The type of column, as well as the visibility status, is indicated through color coding:

Hidden columns: Hidden columns—columns whose Is Visible? option are unchecked—are not displayed in the grid and are represented with red cells.

Dynamic columns: Dynamic columns are represented with green cells.

These are columns whose values will only appear if you use specific types of commands. Examples of dynamic columns are Annotation Columns and the Note Counter columns in databaseEZ.

NOTE	You can also apply Cell Formatting preferences and column filters to columns via the Grid Manager. If a cell color format is applied to a given flexYgrid column, that column's Grid Manager entry will be displayed in the same color.

Grid Manager Columns

The columns in the Grid Manager function as follows:

Column Title	Displays all possible columns (visible and hidden) by name for the associated flexYgrid. This column is frozen in the Grid Manager.
Data Source	Only available in the databaseEZ Main Grid. Indicates if the data is available when loaded with Edit > Load Complete Database information (Ctrl + L), from the summarized information or both.
Is Visible?	If checked, the column is visible in the grid. If unchecked, the column is hidden in the grid. In Categorized Column Configuration mode it is possible to make visible all columns for an entire category simply by checking this box for the category name.
Grid Position	Indicates the column's position within the flexYgrid. Count starts at 1. Columns with the column 'Is Visible?' unchecked are not part of the count.
Is Auto Resize?	If checked, resizes the flexYgrid column to its best fit. The column title and the row data will both adapt based on the length of whatever is currently visible within the column. Some flexYgrid windows apply an auto resize by default on its last column (like the Dashboad in consoleEZ). In this case the Auto Resize column will be grayed out.
Column Category	Indicates the Column Category name of the flexYgrid column. Corresponds to the grouped category where the column is placed within the Categorized Column Configuration.
Column Type	Displays the type of data found in the flexYgrid column.
Sort Rank	Visible when a sort is applied to a column. Indicates the sorting position of the column within the flexYgrid. The sort can be disabled and, in case of multiple sortings, the position can be changed directly from within the Grid Manager using this column.
Sort Mode	Displays and sets the sort to apply to the column within the flexYgrid: Ascending or Descending. Is blank if no sort is to be applied.
Group Level	Visible when a sort is applied to a grouped column. Indicates the sorting position of the grouped column in the flexYgrid. The sort can be disabled and, in case of multiple sortings, the position can be changed directly from within the Grid Manager using this column.
Group Sort Mode	Displays and sets the sort to apply to the flexYgrid grouped column: Ascending or Descending. Remains blank if no sort is selected.
Filters Applied	Displays the filter currently applied to the column.
Cell Format	Sets the flexYgrid column Cell Format. When a format is applied then a '*' is displayed.
Group Format	Sets the flexYgrid column Group Format. When a format is applied a '*' is displayed.
Group Totals	Defines the calculation method of grouped column content : Sum, Average, Minimum, Maximum, Count, Count but Exclude Empty Cells. The Sort all groupings by summary command will use this feature. More information is on this page.
Column Size	Enter the number of characters to be displayed within the column.
Column ID	Indicates the column's identification which is set upon initialization of the grid. It serves as a reference for the Automation.