Ytria logo DOCUMENTATION
⚠ This page requires javascript enabled in browser
Global Features / The flexYgrid

 

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.

Grid Manager toolbar button

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

Grid manager toggling the sidebar button

Grid manager toggling the sidebar-expanded

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

See the following for information about the Grid Manager's various sections:

Grid Manager Toolbar and Context Menu Options

flexYgrid Column Display

Column Type/Status Indicator

Grid Manager Columns




Grid Manager Toolbar and Context Menu Options

The Grid Manager Toolbar


Grid Manager toolbar

The toolbar options function as follows:

Detach Grid Manager windowSets the Grid Manager as a floating window.
Dock Grid Manager windowLocks the Grid Manager to its flexYgrid.
Categorized Column ConfigurationSelected default mode. Column names are categorized by family.
Sorted Column ConfigurationMode in which columns can be sorted manually in a flat layout.
Live Column ConfigurationMode in which columns can be moved manually.
Resize selected columns according to visible dataResizes 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 setResizes 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 headerResizes 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 setResizes 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 defaultResizes 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


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.

Column Settings dialog

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.

Categorized Column Configuration

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

Sorted Column Configuration

      • 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:
Live Column Configuration step 1

Step 2:
Live Column Configuration 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.

Hidden columns
      • 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.

Dynamic columns

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.
Cell color formatting in Grid Manager



Grid Manager Columns


The columns in the Grid Manager function as follows:

Column TitleDisplays all possible columns (visible and hidden) by name for the associated flexYgrid.

This column is frozen in the Grid Manager.
Data SourceOnly 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 PositionIndicates 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 CategoryIndicates the Column Category name of the flexYgrid column.

Corresponds to the grouped category where the column is placed within the Categorized Column Configuration.
Column TypeDisplays the type of data found in the flexYgrid column.
Sort RankVisible 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 ModeDisplays 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 LevelVisible 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 ModeDisplays and sets the sort to apply to the flexYgrid grouped column: Ascending or Descending.

Remains blank if no sort is selected.
Filters AppliedDisplays the filter currently applied to the column.
Cell FormatSets the flexYgrid column Cell Format.

When a format is applied then a '*' is displayed.
Group FormatSets the flexYgrid column Group Format.

When a format is applied a '*' is displayed.
Group TotalsDefines 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 SizeEnter the number of characters to be displayed within the column.
Column IDIndicates the column's identification which is set upon initialization of the grid.

It serves as a reference for the Automation.