The grid manager | Ytria Documentation

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:

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

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:

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.