constants DefColumnEnum
The Def property retrieves or sets a value that indicates the default value of given properties for all cells in the same column.

NameValueDescription
exCellHasCheckBox0 Assigns check boxes to all cells in the column, if it is True. Similar with the CellHasCheckBox property. By default, the exCellHasCheckBox property is False (0).

(Boolean expression)

exCellHasRadioButton1 Assigns radio buttons to all cells in the column, if it is True. Similar with the CellHasRadioButton property. By default, the exCellHasRadioButton property is False (0).

(Boolean expression)

exCellHasButton2 Specifies that all cells in the column are buttons, if it is True. Similar with the CellHasButton property. By default, the exCellHasButton property is False (0).

(Boolean expression)

exCellButtonAutoWidth3 Similar with the CellButtonAutoWidth property. By default, the exCellButtonAutoWidth property is False (0). The exCellButtonAutoWidth has effect only if the exCellHasButton option is True.

(Boolean expression)

exCellBackColor4 Specifies the background color for all cells in the column. Use the CellBackColor property to assign a background color for a specific cell. The property has effect only if the property is different than zero (default value).

(Color expression)

exCellForeColor5 Specifies the foreground color for all cells in the column. Use the CellForeColor property to assign a foreground color for a specific cell. The property has effect only if the property is different than zero (default value). 

( Color expression )

exCellVAlignment6 Specifies the column's vertical alignment. By default, the Def(exCellVAlignment) property is exMiddle. Use the CellVAlignment property to specify the vertical alignment for a particular cell. By default, the exCellVAlignment property is MiddleAlignment (1).

(VAlignmentEnum expression)

exHeaderBackColor7 Specifies the column's header background color. Use this option to change the background color for a column in the header area. The exHeaderBackColor option supports skinning, so the last 7 bits in the high significant byte of the color to indicates the identifier of the skin being used. Use the Add method to add new skins to the control. The property has effect only if the property is different than zero (default value).

(Color expression)

exHeaderForeColor8 Specifies the column's header background color. The property has effect only if the property is different than zero (default value).

(Color expression)

exCellSingleLine16 Specifies that all cells in the column displays its content into single or multiple lines. Similar with the CellSingleLine property. If using the CellSingleLine / Def(exCellSingleLine) property, we recommend to set the ScrollBySingleLine property on True so all items can be scrolled.

( CellSingleLineEnum type, previously Boolean expression )

exCellValueFormat17 The exCellValueFormat indicates that format to display all cells in the column such as text or HTML text. The CellValueFormat property specifies whether a particular cells displays text or HTML text. By default, the exCellValueFormat property is exText (0).

(ValueFormatEnum expression)

exCellValueToItemBarProperty18 Specifies the ItemBarPropertyEnum property of the bars being shown in the column. By default, the exCellValueToItemBarProperty is -1, so the cells are no associated with any bar. The exCellValueToItemBarProperty has effect only if the AllowCellValueToItemBar property is True.  For instance, you can use the exCellValueToItemBarProperty and exCellValueToItemBarKey options to display the start and ending date of any bar in the item, in the entire column. The values in the cells are automatically changed once the bar is resized or moved and reverse, if the cell's value is changed the bar is moved or resized. The CellValueToItemBar method associates the cell's value with a property of the bar in the item. By default, the exCellValueToItemBarProperty is -1, which indicates that the column is not affiliated with any property of the bar.

(ItemBarPropertyEnum expression or -1)

exCellValueToItemBarKey19 Indicates the key of the bars whose property is shown in the column. The exCellValueToItemBarKey has effect only if the AllowCellValueToItemBar property is True. The exCellValueToItemBarProperty option indicates the property being displayed in the column, while the exCellValueToItemBarKey indicates the key of the bar in the item. The Key parameter of the AddBar indicates the key of the bar being added. For instance, you can use the exCellValueToItemBarProperty and exCellValueToItemBarKey options to display the start and ending date of any bar in the item, in the entire column. The values in the cells are automatically changed once the bar is resized or moved and reverse, if the cell's value is changed the bar is moved or resized. The CellValueToItemBar method associates the cell's value with a property of the bar in the item. 

(Variant expression)

exTotalColumn20 Specifies a formula that defines the total fields applied to all unformatted and non-leaf cells within the column. This option is effective when displaying hierarchical data, allowing aggregate functions like sum or count to be shown for parent items. Essentially, the exTotalColumn option applies a consistent formula to all unformatted and non-leaf cells within the column. A cell is considered unformatted if its FormatCell property is empty. The ItemHasChildren property indicates whether an item has one or more child items. The formula should be of aggregate(list,direction,formula) format as defined in exTotalField of ValueFormatEnum type. The CellValueFormat property on exTotalField specifies that a particular cell displays an aggregate function.

For instance:

  • count(current,dir,1) counts the number of child items ( not implies recursively child items ).
  • count(current,all,1) counts the number of all child items ( implies recursively child items ).
  • count(current,rec,1) counts the number of leaf items ( implies recursively leaf items ).
  • count(current,rec,1) counts the number of leaf items ( a leaf item is an item with no child items ).
  • sum(parent,dir,%1=0?0:1) counts the not-zero values in the second column (%1)
  • sum(parent,dir,%1 + %2) indicates the sum of all cells in the second (%1) and third (%2) column that are directly descendent from the parent item. 
  • sum(all,rec,%1 + %2) sums all leaf cells in the second (%1) and third (%2) columns.

( String expression )

exFilterPatternTemplate21 Specifies the template for the column's filter when the Filter property or the 'Filter For' field is populated. This property customizes the filter pattern for the column when the FilterType property is set to exPattern. It supports the <%filter%> keyword, which replaces the original filter input. For example, setting Def(exFilterPatternTemplate) to "*<%filter%>*" filters for all items containing the specified sequence, while setting it to "Item*<%filter%>" filters for all items starting with 'Item' and ending with the typed characters. If the Column.Def(exFilterPatternTemplate) property is empty, the filter is applied as it is (no effect).

( String expression )

exCellFormatLevel32 Specifies the format layout for the cells. The CellFormatLevel property indicates the format layout for a specified cell. Use the FormatLevel property to specify the layout of the column in the control's header bar. 

(CRD string expression)

exCellDrawPartsOrder34 Specifies the order of the drawing parts for the entire column. By default, this option is "check,icon,icons,picture,caption", which means that the cell displays its parts in the following order: check box/ radio buttons ( CellHasCheckBox/CellRadioButton ), single icon ( CellImage ), multiple icons ( CellImages ), custom size picture ( CellPicture ), and the cell's caption. Use the exCellDrawPartsOrder option to specify a new order for the drawing parts in the cells of the column. The RightToLeft property automatically flips the order of the columns. By default, the exCellDrawPartsOrder property is "check,icon,icons,picture,caption".

(String expression)

exCellPaddingLeft48 The padding defines the space between the element border and the element content. Gets or sets the left padding (space) of the cells within the column. This option applies a padding to all cells in the column. Use the exHeaderPaddingLeft option to apply the padding to the column's caption in the control's header. The padding does not affect the element's background color. By default, the exCellPaddingLeft property is 0.

(Long expression)

exCellPaddingRight49 Gets or sets the right padding (space) of the cells within the column. This option applies a padding to all cells in the column. Use the exHeaderPaddingRight option to apply the padding to the column's caption in the control's header. The padding does not affect the element's background color. By default, the exCellPaddingRight property is 0.

(Long expression)

exCellPaddingTop50 Gets or sets the top padding (space) of the cells within the column. This option applies a padding to all cells in the column. Use the exHeaderPaddingTop option to apply the padding to the column's caption in the control's header. The padding does not affect the element's background color. By default, the exCellPaddingTop property is 0.

(Long expression)

exCellPaddingBottom51 Gets or sets the bottom padding (space) of the cells within the column. This option applies a padding to all cells in the column. Use the exHeaderPaddingBottom option to apply the padding to the column's caption in the control's header. The padding does not affect the element's background color. By default, the exCellPaddingBottom property is 0.

(Long expression)

exHeaderPaddingLeft52 Gets or sets the left padding (space) of the column's header. This option applies the padding to the column's caption in the control's header. Use the exCellPaddingLeft option to apply the padding to all cells in the column. The padding does not affect the element's background color. By default, the exHeaderPaddingLeft property is 0.

(Long expression)

exHeaderPaddingRight53 Gets or sets the right padding (space) of the column's header. This option applies the padding to the column's caption in the control's header. Use the exCellPaddingRight option to apply the padding to all cells in the column. The padding does not affect the element's background color. By default, the exHeaderPaddingRight property is 0.

(Long expression)

exHeaderPaddingTop54 Gets or sets the top padding (space) of the column's header. This option applies the padding to the column's caption in the control's header. Use the exCellPaddingTop option to apply the padding to all cells in the column. The padding does not affect the element's background color. By default, the exHeaderPaddingTop property is 0.

(Long expression)

exHeaderPaddingBottom55 Gets or sets the bottom padding (space) of the column's header. This option applies the padding to the column's caption in the control's header. Use the exCellPaddingBottom option to apply the padding to all cells in the column. The padding does not affect the element's background color. By default, the exHeaderPaddingBottom property is 0.

(Long expression)

exColumnResizeContiguously64 Gets or sets a value that indicates whether the control's content is updated while the user is resizing the column.

(Boolean expression)