This is an XML property that is used to override specific columns in the grid.
The property should contain a root node value of Columns and should contain a child node value of Column for each column in the grid you wish to modify.
A Boolean value that controls whether grouping can occur on the column.
Default: True
A Boolean value that controls whether the cells can contain multiple lines of data.
Default: False
A Boolean value that controls whether sorting is allowed on the column.
Default: True
A Boolean value that controls whether the column can be sizing.
Default: True
The string value of the text to be displayed in the column header.
The filename of the image that should be displayed in the cells of the column.
The css style used to control the style of the cells under the column.
The string name of the column to override.
The type of column to set.
Options: Custom(html), Hyperlink, Image, ImageAndText, Text
Default: Text
The value of the format string used to format the column values.
To have dates or times returned in a different format, use the following parameters.
|
d |
The day of the month. Single-digit days will not have a leading zero. |
|
dd |
The day of the month. Single-digit days will have a leading zero. |
|
ddd |
The abbreviated name of the day of the week, as defined in AbbreviatedDayNames. |
|
dddd |
The full name of the day of the week, as defined in DayNames. |
|
M |
The numeric month. Single-digit months will not have a leading zero. |
|
MM |
The numeric month. Single-digit months will have a leading zero. |
|
MMM |
The abbreviated name of the month, as defined in AbbreviatedMonthNames. |
|
MMMM |
The full name of the month, as defined in MonthNames. |
|
y |
The year without the century. If the year without the century is less than 10, the year is displayed with no leading zero. |
|
yy |
The year without the century. If the year without the century is less than 10, the year is displayed with a leading zero. |
|
yyyy |
The year in four digits, including the century. |
|
gg |
The period or era. This pattern is ignored if the date to be formatted does not have an associated period or era string. |
|
h |
The hour in a 12-hour clock. Single-digit hours will not have a leading zero. |
|
hh |
The hour in a 12-hour clock. Single-digit hours will have a leading zero. |
|
H |
The hour in a 24-hour clock. Single-digit hours will not have a leading zero. |
|
HH |
The hour in a 24-hour clock. Single-digit hours will have a leading zero. |
|
m |
The minute. Single-digit minutes will not have a leading zero. |
|
mm |
The minute. Single-digit minutes will have a leading zero. |
|
s |
The second. Single-digit seconds will not have a leading zero. |
|
ss |
The second. Single-digit seconds will have a leading zero. |
|
f |
The fraction of a second in single-digit precision. The remaining digits are truncated. |
|
ff |
The fraction of a second in double-digit precision. The remaining digits are truncated. |
|
fff |
The fraction of a second in three-digit precision. The remaining digits are truncated. |
|
ffff |
The fraction of a second in four-digit precision. The remaining digits are truncated. |
|
fffff |
The fraction of a second in five-digit precision. The remaining digits are truncated. |
|
ffffff |
The fraction of a second in six-digit precision. The remaining digits are truncated. |
|
fffffff |
The fraction of a second in seven-digit precision. The remaining digits are truncated. |
|
t |
The first character in the AM/PM designator defined in AMDesignator or PMDesignator, if any. |
|
tt |
The AM/PM designator defined in AMDesignator or PMDesignator, if any. |
|
z |
The time zone offset ("+" or "-" followed by the hour only). Single-digit hours will not have a leading zero. For example, Pacific Standard Time is "-8". |
|
zz |
The time zone offset ("+" or "-" followed by the hour only). Single-digit hours will have a leading zero. For example, Pacific Standard Time is "-08". |
|
zzz |
The full time zone offset ("+" or "-" followed by the hour and minutes). Single-digit hours and minutes will have leading zeros. For example, Pacific Standard Time is "-08:00". |
|
: |
The default time separator defined in TimeSeparator. |
|
/ |
The default date separator defined in DateSeparator. |
A numeric value that represents the position order of the columns.
Example:
<Columns>
<Column>
<ColumnMember>Description</ColumnMember>
<Caption>Task Description</Caption>
<ColumnType>Custom</ColumnType>
</Column>
<Column>
<ColumnMember>ObjSiteURL</ColumnMember>
<ColumnType>Hyperlink</ColumnType>
</Column>
</Columns>
When configured as a Parent-Child Grid, this is the Table Name (e.g., Table 1, Data, etc.) within the XML that identifies the table where the column being modified is locatedS.
A Boolean value used to hide or show the column.
Default: True
An integer that is used to control the width of the column. This can be expressed with a percentage symbol.