Column

Note: property, method and event names should be referred to in lowercase in case-sensitive scripting languages.

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