Layout

The Grid dashboard item allows you to customize its layout in various ways. You can manage the width of grid columns, specify the visibility of column headers, enable cell merging, etc.

To do this, use the Layout and Column Width Mode groups in the Design Ribbon tab.

Grid_Layout_Ribbon

Column Width Modes

The Grid dashboard item allows you to manage column widths using different modes. Use buttons in the Column Width Mode group to manage the column width modes.

Grid_ColumnAutoWidth_Ribbon

The following modes are available.

AutoFit to Contents

The grid adjusts columns to the minimum width required to completely display their content automatically. If the entire content cannot be displayed within the dashboard item, horizontal scrolling is enabled..

AutoFit to Grid

The grid adjusts the width of all columns to fit their content in an optimal way. If you are changing the size of the dashboard item, the width of columns is changed proportionally..

Manual

The grid allows you to adjust column widths manually.

In this mode, you can adjust the width of individual columns in the following ways.

  • Specify the width of the required column by dragging the right edge of the column header.

    Grid_ManualColumnWidth

    In this case, all columns preserve their relative size when the grid width is changed.

  • Specify the column width and fix it by right-clicking the required column header and selecting Fix Width.

    Grid_FixColumnWidth

    You can also specify the fixed column width by selecting Column Width... This invokes the Column Width window that allows you to specify the width of the column in characters.

    Grid_ColumnWidthDialog

  • Fit the column width to its content and fix it by right-clicking the required column header and selecting Fit to Content.

Column Header

Use the Column Headers button to toggle column header visibility.

Grid_Layout_NoLinesAndHeaders

Cell Merging

The Grid allows you to merge neighboring cells with identical values . To do this, use the Merge Cells button.

Grid_Layout_MergeCells

Note

Note that banded rows are not available when cell merging is enabled.

Word Wrapping

The word wrapping feature enables the capability to display cell content on multiple lines if the size of a dashboard item is insufficient to completely display the cell content on a single line.

Grid_WordWrapping

Note

The word wrapping feature is not in effect when the AutoFit to Contents column width mode is enabled.