Mashup Builder > Widgets > Advanced Grids > Column Configuration from the Context Menu
Column Configuration from the Context Menu
If the data source for your grid is tied to a Data Shape, certain column parameters are configurable from the context menu.
Accessing Parameters on the Context Menu
1. In the Mashup Builder:
Place the pointer on the menu drop down arrow in the top left corner of the grid, or
2. Select Configure Grid Columns. A Configure Widget dialog box opens.
3. Configure column properties in the following areas of the dialog box:
Left pane: Reorder the columns by dragging them to different locations in the list. When a column is selected, the tabs on the right display property settings specific to the selected column. You can also define which columns are seen by the end user of the grid:
Show — Defines whether a specific grid column initially appears or is hidden from view. End users can hide and unhide the column display in runtime by right-clicking the column header and using the context menu. To toggle this property on and off for all listed columns, click Hide All and Show All at the top of the panel. This property corresponds to the Hidden property when writing a configuration service.
Exclude — Defines whether a specific grid column is seen by the end user. When selected, the end user does not see the column and does not have control over its appearance. However, you can still use data in the excluded column for state formatting. This property corresponds to the inLayout property when writing a configuration service.
Column Format tab: Use this tab to edit the name and description of a specific column and to control the following column formatting options:
Auto-Width – Column width automatically adjusts to fit the content of the selected column.
Width – Set column width to a fixed pixel size or to a percentage. At runtime, after any fixed-width columns are sized, percentage-width columns divide up the remaining space according to the assigned percentages.
If the total of all the percentage column widths exceeds 100%, each percentage column width is recalculated based on the specified percentage relative to the total. For example, if three columns are each assigned a percentage width of 50%, the calculation for each column width becomes: 50/150 = 33%.
Use percentage widths to automatically resize the grid responsively when the browser size changes.
* 
To set individual column widths, clear the Auto-Width box.
Cell Alignment / Header Alignment – Individually set alignment of text in column cells and in the column header.
Cell Editing Options – In a column cell values are editable in run time. Click Editable for a specific column to enable run time editing. This option requires that the IsEditable grid parameter is also set. Currently cell editing is only available for Boolean fields, so you can ignore other options below the Editable.
* 
When configuring the order of columns in a tree grid, you can not configure an editable column as the first column.
See section Cell Editing in Advanced Grids for more information.
Column Renderer & State Formatting tab: Use this tab to control how data is rendered in a column and to configure fixed or state formatting. The tab is divided into two sections:
In the top portion select a type of column Renderer and a corresponding Format. For more information about column renderers and their available formats, see Column Renderers and Formats.
In the bottom portion select Fixed Style or State-based Formatting. The State formatting set on this tab is cell-based and overrides any row-based formatting set in the Mashup Builder or through a configuration service.
Was this helpful?