Column
Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.
Contents
Description
Shown below in a standalone Form. Click the image to see in a Custom Section in a Lianja Page.
A Grid is a container object that displays data in rows and columns, and is similar in appearance to a Browse window. A grid is also a container object that contains column objects. A column can contain a Header object and controls. Because a grid and its columns, headers, and controls each have their own set of properties, you have complete control over each element of the grid.
Properties
This class supports the Common Properties plus the following:
Property | Access (R/RW) | Value | Description |
---|---|---|---|
AlternatingRowColors | RW | Boolean | Whether this column should display alternating background cell colors |
BackColor | RW | Numeric or Character | Background color |
BadgeExpression | RW | Character | Expression to return text to display inside a badge |
Button | RW | Boolean | Whether column is displayed as a button. From v5.0. |
ButtonCaption | RW | Character | Caption text if column is displayed as a button. From v5.0. |
Caption | RW | Character | Header caption text |
Celleditor | RW | Character | VarChar CellEditor type. Text, Html, Stringlist. From 5.3. |
ChoiceList | RW | Character | List of choices for data input |
Cssstyle | RW | Character | CSS for the cell |
CssHeaderStyle | RW | Character | CSS for the column header |
CustomDisplay | RW | Character | The name of a procedure/function that will return the display text for the cell. From v5.0. |
CustomEditor | RW | Character | The name of a procedure/function that will return a custom editor for the cell. This may be a container with multiple controls. From v5.0. |
DataControlSource | RW | Character | Source of data to which the grid column is bound. This may be a table.column or an expression for a calculated value. |
DatamappingGet | RW | Character | Expression to evaluate for custom data mapping when reading data |
DatamappingSet | RW | Character | Expression to evaluate for custom data mapping when writing data |
Default | RW | Character | Default value when adding new row |
CellDynamicForeColor | RW | Character | Dynamic Foreground color expression |
CellDynamicBackColor | RW | Character | Dynamic Background color expression |
FixedColumnWidth | RW | Numeric | The fixed width of the column in pixels |
ForeColor | RW | Numeric or Character | Foreground color |
Header1 | R | Object | Return an object reference to the column's Header object |
Hyperlink | RW | Boolean | Whether column is displayed as a hyperlink. From v5.3. |
InputMask | RW | Character | Input mask for data entry |
Padding | RW | Numeric | Cell padding in pixels |
RatingMaxValue | RW | Numeric | Maximum rating value for rating cells. |
Readonly | RW | Boolean | Whether column is read only |
Recalculate | RW | Boolean | Whether all calculated columns (DataControlSource expressions) should be recalculated and re-displayed when this column is edited. |
SparklineExpression | RW | Character | Expression to display a sparklne graph. This should return a comma separated list of values. |
SparkLineDynamicBackColor | RW | Character | A color for a sparkline graph |
Stringlist | RW | Character | A comma separated list or a SQL SELECT. From v5.3. |
TextAlignment | RW | Character | left, right or center |
Total | RW | Boolean | Whether column should be totaled. From v5.3. |
Totalexpression | RW | Character | The expression to total the column on. |
Totalformat | RW | Character | The mask for the total value displayed. |
Validation | RW | Character | Validation condition to evaluate for update |
ValidationMessage | RW | Character | Message to display when Validation returns False |
VisibleWhenEditing | RW | Boolean | Whether column is visible when split grid editing. |
Width | RW | Numeric | Width in pixels |
Methods
This class supports the Common Methods plus the following:
Method | Args | Description |
---|
Events
This class supports the Common Events plus the following:
Event | Args | Description |
---|