Basic Column Properties
Below you will find a list of the basic Column Properties.
Name
The name of the column in the data set. Use the name for addressing the column in formulas. The name must be unique within the column set. Setting Columns can provide a localized caption based on the Name property if the value is registed in pbSimLangText and there is no Caption or Caption Expression providing an override Caption value.
Store Column Binding
Specifies the id of the Data Store column that the grid column is bound to.
Default Value
Specifies a default value to assign to the cell when a new row is added to the grid.
Order By
Specifies if the Worksheet data set should be ordered by the values of the column when loaded from the server.
Priority must be greater than 0 to order the data set by the column. Priority also specifies the index of the column in the order by clause.
Sort Descending specifies if the values of the column should be sorted in descending order instead of ascending.
Trim whitespace on save
Specifies whether to remove leading and trailing whicespace characters from text column values when data is saved to the database. Dropdown or Ranked Input columns will only be trimmed if this property is set to True. Standard text input columns will be trimmed unless the value is explicitly set to False.
Context Menu Actions
Specifies Custom Context Menu Actions for the column.
Is Action Link Column
Specifies whether the column should be an Action Link Column. The values of Action Link Columns are displayed as hyperlinks, and cannot be edited by the user. When clicked, an event is raised in the Workbook context containing information about the clicked row, action and column.
Format String
Specifies the format string used to display the rendered value of the column.
Width Type
Specifies how the column should be sized.
Width
Specifies the width if Width Type is set to Numeric.
Content Alignment
Specifies the alignment of the cell values of the column.
Is Fixed
Specifies if the column is be fixed / pinned to the left side of the grid.
Conditional Formatting
Specifies styling and formatting rules for the column based on cell values. Due to performance reasons, we recommend specifying cell formatting using Style Formulas, SetRowStyle(…) and SetCellStyle(…), instead of the Conditional Formatting feature.
Summary Function
Specifies which summary function to apply the the column when the Summary Row feature of the data grid is enabled. Available functions are Default, Sum, Min, Max, Count, Average and None. For numeric columns, the default is Sum and for all other columns, the default is None.