Zero or more of the following options may be specified to further define column options. Syntax is:
~option = value~
Example
COLDEF = COLDEF + "10~15~Title~S~Color=3,7~Scale=200~~"
Note that both options and values are case sensitive. Additional examples may be found in the Advanced Syntax Example.
Option |
Description |
Defines a column whose contents are filled automatically starting with the specified base number, and incrementing by 1 for each data row in the tree. | |
Caption |
Used with XTF2_POPUP to specify the caption of the popup window housing the XTREE. |
Use to associate shared lists (combo boxes) with individual cells rather than entire columns. | |
CellListX |
List substitution style (aka INFLD ||L) combo lists. See ListX and CellListX. |
Define Exitcode values for left and right click on the column. Applies to all columns if the ClickExit clause is associated with column 0, otherwise applies only to the specific column. A right-click value in ClickExit takes precedence over PopupMenu. Format: ClickExit=<left exitcode>,<right exitcode>. See also XTR.KBDSTR. | |
CollapseExit |
Triggers an exitcode when a branch is collapsed; see ExpandExit. |
Color |
A pair of digits, comma separated, representing the desired foreground and background text color for the column, from the A-Shell palette. Use only if you want the column to have a different color scheme from the others. E.g.: Color=1,2. (Foreground color one, background color two). Also see RGBbg, RGBfg. |
Determines how many rows are considered when optimizing the column widths. | |
CtlName |
You can assign a name to an XTREE control by adding the coldef clause CtlName=name to any column (where name is the name you want to assign). |
Defines an alternate currency symbol to replace the $ in a mask (e.g. Mask=$###,###.##). | |
Data |
Use to define the contents of a Constant Data Column. |
DefaultFont |
Sets the default font for the entire tree. The syntax is the same as for Font. |
DefaultScale |
A font scaling percentage (100=normal), e.g. DefaultScale=120. Works similarly to Scale, except that it affects all subsequent columns, not just the current column. Furthermore, if specified with a pseudo-column, it affects all the rows, eliminating the need to define a special font column with coldef code "f". This makes it much easier to apply a scale factor to an entire tree. Note also that the DefaultScale value is taken into consideration when XTREE determines the row height for fixed-height rows. HdrScale=0 and DefaultScale=0 are interpreted as requesting the default Windows desktop font size. |
DragDropExit |
DragDropExit=###, where ### is the negative exitcode to be generated when an item (or items) from the source tree is/are dropped on to the destination tree. For example, DragDropExit=150 will generate exitcode -150. See XTF2_DRAGDROP2 |
DragDrop Protect |
DragDropProtect=### allows ### rows at the top (or -### rows at the bottom) to be protected from drag/drop operations. Note that because sorting would confuse the issue, DragDropProtect=### will automatically set HdrLines=### (if ### positive and HdrLines not already set), and TotalLines=### (if ### negative and TotalLines not already set). Also supported is the syntax DragDropProtect=##,##, which will protect rows at the top of the screen (first number) and the bottom (second number); use positive values for each. |
DropExit |
DropExit=### may be used to force XTREE to exit with the specified exit code (###) at the completion of a Drag/Drop operation. Note that the exitcode will be -###—i.e. DropExit=88 will return exitcode -88 on a drag/drop. This is the same syntax as SelChgExit=###. |
Dspmin |
Similar to Dspwid except sets the minimum display width. (Unless the column is locked with the cformat L option, the user can resize the column, subject to this minimum.) E.g. Dspmin=5. The dspmin option is overridden by the hidden column (H) option. |
Sets the initial display width of the column, e.g. Dspwid=10. | |
EnterGoto=# specifies the column # to jump to when the Enter key is hit. | |
Defines a set of characters that will force an exit from the tree. | |
Triggers an exitcode when a branch is expanded. | |
ExportFspec |
ExportFspec=<filespec> will set the name of an exported CSV or XLSX file. If name is not specified, system will use the TreeID for the export file name. If option is not specified, the filename will revert to the previous default—XTREE-<jobnam> for the CSV2XL export and ASHGRID for the CSV export. |
Sets various options related to the export-to-CSV function. | |
FastMax |
FastMax=# sets the number of characters for an editable text or combo field which can be entered before it automatically advances to the next field. Supercedes InfDef=F, which no longer does anything. This clause is compatible with cell validation. Change In A-Shell 1377 of March 2014: FastMax=1 now causes the cell to exit after clicking on a new selection in the dropdown list, or after using the up/down arrow keys to change the selection and then hitting ENTER. |
FileListX |
In conjunction with LookupX, automatically fills in a target cell based on the contents of a source cell, using an external lookup table. |
Overrides the default Auto-Filter type. Choices are CB, Range, Pattern, None. | |
Causes XTREE to handle the specified column in a more "INMEMO-friendly" manner. | |
Fold |
Fold = <Upper or Lower>. For editable cells, this flag causes contents to be automatically folded. The folding applies during editing of cell but does not change the underlying data. See Cformat ^. Also see Coldef Default. |
A font face name and/or font attribute code, separated by a comma. See Coldef Default. | |
Provides a way to configure the behavior of the Windows Time and Date Picker control associated with an editable date and/or time column. | |
Set page footer. | |
FooterFont |
Define footer font. Uses same syntax as HdrFont. |
FooterScale |
Define scale for footer text. Uses same syntax as HdrScale. |
FooterClickExit |
Define exitcode(s) for clicking on footer. Same syntax as ClickExit. |
Sets options related to the Date/Time Picker control associated with an editable date/time column. | |
Group |
Associate a radio button cell with a Radio Button Group. |
When specified, clicking on this column header causes an exit with the specified exitcode. | |
HdrDspMin |
Set minimum display width for row headers in grid column units. (HdrDspMin=5) See XTR.SHOWROWHDR. |
HdrDspWid |
Set display width for row headers in grid column units. (HdrDspWid=15) See XTR.SHOWROWHDR. |
Same format and concept as Font, but applies to the header row. | |
HdrLines |
This is analogous to the TotalLines option, but allows you to specify a number of lines at the top of the tree that are to be treated as fixed headers and thus not included in sorting. |
HdrScale |
This is to Scale as HdrFont is to Font, e.g. HdrScale=125. HdrScale=0 and DefaultScale=0 are interpreted as requesting the default Windows desktop font size. |
Associate column with a numeric ID. | |
Required with cformat I to allocate space for the image storage | |
Specifies the default image that will be displayed if and when the specified image is not found. | |