ValueFormatEnum Constants (ExCascadeTree)

The formula on the CellValue property ( if the CellValueFormat property indicates the exComputedField or exTotalField ) may include the formatting operators as follows:

The expression supports cell's identifiers as follows:

%0, %1, %2, ...{any} specifies the value of the cell in the column with the index 0, 1 2, ... The CellCaption property defines the cell's value. For example, "%0 format ``" formats the value in the cell at index 0 using the current regional settings, while "int(%1)" converts the value in the cell at index 1 to an integer.
%C0, %C1, %C2, ...{string} specifies the caption of the cell, or the string the cell displays in the column with the index 0, 1 2, ... The CellCaption property gets the cell's formatted caption. The cell's displayed string may differ from its actual value. For example, if a cell displays HTML content, %0 returns the HTML format including the tags, while %C0 returns the cell's content as a plain string without HTML tags. For instance, "upper(%C1)" converts the caption of the cell at index 1 to uppercase, while "%C0 left 2" returns the leftmost two characters of the caption in the cell at index 0.
%CD0, %CD1, %CD2, ...{any} specifies the cell's extra data in the column with the index 0, 1 2, ... The CellData property associates any extra/user data to a cell. For example, "%CD0 = your user data" specifies all cells in the column with index 0 whose CellData property is equal to your user data.
%CS0, %CS1, %CS2, ...{number} specifies the cell's state in the column with the index 0, 1 2, ... The CellState property defines the state of a cell, indicating whether it is checked or unchecked. For example, "%CS0" identifies all checked items in the column with index 0, while "not %CS1" identifies all unchecked items in the column with index 1.
%CC0, %CC1, %CC2, ... {number} retrieve the number of child items (this keyword consistently returns identical results for all cells since it pertains to the item that hosts each cell). The ChildCount property returns the number of child items. For example, "%CC0" identifies all parent items, while "%CC0 = 0" identifies all leaf items.
%CX0, %CX1, %CX2, ... {boolean} returns true if the item hosting the cell is expanded, or false if it is collapsed (this keyword consistently returns identical results for all cells since it pertains to the item that hosts each cell). The ExpandItem property specifically indicates whether the item is expanded or collapsed. For example, "%CX0" refers to all expanded items, while "not %CX0" identifies all collapsed items

This property/method supports predefined constants and operators/functions as described here.

Usage examples:

"1", the cell displays 1
"%0 + %1", the cell displays the sum between cells in the first and second columns.
"%0 + %1 - %2", the cell displays the sum between cells in the first and second columns minus the third column.
"(%0 + %1)*0.19", the cell displays the sum between cells in the first and second columns multiplied with 0.19.
"(%0 + %1 + %2)/3", the cell displays the arithmetic average for the first three columns.
"%0 + %1 < %2 + %3", displays 1 if the sum between cells in the first two columns is less than the sum of third and forth columns.
"proper(%0)'" formats the cells by capitalizing first letter in each word
"currency(%1)'" displays the second column as currency using the format in the control panel for money
"len(%0) ? currency(dbl(%0)) : ''" displays the currency only for not empty/blank cells.
"int(date(%1)-date(%2)) + 'D ' + round(24*(date(%1)-date(%2) - floor(date(%1)-date(%2)))) + 'H''" displays interval between two dates in days and hours, as xD yH
"2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : '') + =:3 + ' hour(s)' : '' )" displays the interval between two dates, as x day(s) [and y hour(s)], where the x indicates the number of days, and y the number of hours. The hour part is missing, if 0 hours is displayed, or nothing is displayed if dates are identical.

Name	Value	Description
exText	0	Standard text. No HTML tags are displayed
exHTML	1	The control uses built-in HTML tags to display the caption using HTML format. The control supports the following HTML tags: <b> ... </b> displays the text in bold <i> ... </i> displays the text in italics <u> ... </u> underlines the text <s> ... </s> ~~Strike~~-through text <a id;options> ... </a> displays an anchor element that can be clicked. An anchor is a piece of text or some other object (for example an image) which marks the beginning and/or the end of a hypertext link.The <a> element is used to mark that piece of text (or inline image), and to give its hypertextual relationship to other documents. The control fires the AnchorClick(AnchorID, Options) event when the user clicks the anchor element. The FormatAnchor property customizes the visual effect for anchor elements. <font face;size> ... </font> displays portions of text with a different font and/or different size. For instance, the <font Tahoma;12>bit</font> draws the bit text using the Tahoma font, on size 12 pt. If the name of the font is missing, and instead size is present, the current font is used with a different size. For instance, <font ;12>bit</font> displays the bit text using the current font, but with a different size. <fgcolor rrggbb> ... </fgcolor> or <fgcolor=rrggbb> ... </fgcolor> displays text with a specified foreground color. The rr/gg/bb represents the red/green/blue values of the color in hexa values. <bgcolor rrggbb> ... </bgcolor> or <bgcolor=rrggbb> ... </bgcolor> displays text with a specified background color. The rr/gg/bb represents the red/green/blue values of the color in hexa values. <solidline rrggbb> ... </solidline> or <solidline=rrggbb> ... </solidline> draws a solid-line on the bottom side of the current text-line, of specified RGB color. The <solidline> ... </solidline> draws a black solid-line on the bottom side of the current text-line. The rr/gg/bb represents the red/green/blue values of the color in hexa values. <dotline rrggbb> ... </dotline> or <dotline=rrggbb> ... </dotline> draws a dot-line on the bottom side of the current text-line, of specified RGB color. The <dotline> ... </dotline> draws a black dot-line on the bottom side of the current text-line. The rr/gg/bb represents the red/green/blue values of the color in hexa values. <upline> ... </upline> draws the line on the top side of the current text-line (requires <solidline> or <dotline>). <r> right aligns the text <c> centers the text <br> forces a line-break <img>number[:width]</img> inserts an icon inside the text. The number indicates the index of the icon being inserted. Use the Images method to assign a list of icons to your chart. The last 7 bits in the high significant byte of the number expression indicates the identifier of the skin being used to paint the object. Use the Add method to add new skins to the control. If you need to remove the skin appearance from a part of the control you need to reset the last 7 bits in the high significant byte of the color being applied to the part. The width is optional and indicates the width of the icon being inserted. Using the width option you can overwrite multiple icons getting a nice effect. By default, if the width field is missing, the width is 18 pixels. <img>key[:width]</img> inserts a custom size picture into the text being previously loaded using the HTMLPicture property. The Key parameter indicates the key of the picture being displayed. The Width parameter indicates a custom size, if you require to stretch the picture, else the original size of the picture is used. & glyph characters as & ( & ), < ( < ), > ( > ), &qout; ( " ) and &#number; ( the character with specified code ), For instance, the € displays the EUR character. The & ampersand is only recognized as markup when it is followed by a known letter or a #character and a digit. For instance if you want to display <b>bold</b> in HTML caption you can use <b>bold</b> <off offset> ... </off> defines the vertical offset to display the text/element. The offset parameter defines the offset to display the element. This tag is inheritable, so the offset is keep while the associated </off> tag is found. You can use the <off offset> HTML tag in combination with the <font face;size> to define a smaller or a larger font to be displayed. For instance: Text with <font ;7><off 6>subscript displays the text such as: Text with _subscriptThe Text with <font ;7><off -6>superscript displays the text such as: Text with ^subscript <gra rrggbb;mode;blend> ... </gra> defines a gradient text. The text color or <fgcolor> defines the starting gradient color, while the rr/gg/bb represents the red/green/blue values of the ending color, 808080 if missing as gray. The mode is a value between 0 and 4, 1 if missing, and blend could be 0 or 1, 0 if missing. The <font> HTML tag can be used to define the height of the font. Any of the rrggbb, mode or blend field may not be specified. The <gra> with no fields, shows a vertical gradient color from the current text color to gray (808080). For instance the <font ;18><gra FFFFFF;1;1>gradient-center</gra></font> generates the following picture: <out rrggbb;width> ... </out> shows the text with outlined characters, where rr/gg/bb represents the red/green/blue values of the outline color, 808080 if missing as gray, width indicates the size of the outline, 1 if missing. The text color or <fgcolor> defines the color to show the inside text. The <font> HTML tag can be used to define the height of the font. For instance the <font ;31><out 000000><fgcolor=FFFFFF>outlined</fgcolor></out></font> generates the following picture: <sha rrggbb;width;offset> ... </sha> define a text with a shadow, where rr/gg/bb represents the red/green/blue values of the shadow color, 808080 if missing as gray, width indicates the size of shadow, 4 if missing, and offset indicates the offset from the origin to display the text's shadow, 2 if missing. The text color or <fgcolor> defines the color to show the inside text. The <font> HTML tag can be used to define the height of the font. For instance the <font ;31><sha>shadow</sha></font> generates the following picture: or <font ;31><sha* 404040;5;0><fgcolor=FFFFFF>outline anti-aliasing</fgcolor></sha></font>* gets:
exComputedField	2	Indicates a computed field. The CellValue property indicates the formula to compute the field. A computed field can display its content using the values from any other cell in the same item/row. For instance %1 + %2 indicates that the cell displays the addition from the second and third cells in the same item ( cells are 0 based ). For instance, if the cells are of numeric format the result is the sum of two values, while if any of the cell is of string type it performs a concatenation of the specified cells. The ComputedField property indicates the formula to compute all cells in the column. The exComputedField can be combined with exText or exHTML. For instance, the exComputedField + exHTML indicates that the computed field may display HTML tags. The syntax for the CellValue property should be: formula where %n indicates the cell from the n-index. The operation being supported are listed bellow. For instance %1 + %2 indicates the sum of all cells in the second and third column from the current item.
exTotalField	4	Indicates a total/subtotal field. The CellValue property indicates the formula for total field that includes an aggregate function such as: sum, min, max, count, avg. The exTotalField can be combined with exText or exHTML. For instance, the exTotalField + exHTML indicates that the total field may display HTML tags. The syntax for the CellValue property should be: aggregate(list,direction,formula) where: aggregate must be one of the following: sum - calculates the sum of values. min - retrieves the minimum value. max - retrieves the maximum value. count - counts the number of items. avg - calculates the average of values. list must be one of the following: a long expression that specifies the index of the item being referred. a predefined string expression as follows: all - indicates all items, so the formula is being applied to all items. The direction has no effect. current - the current item. parent - the parent item. root - the root item. direction must be one of the following: dir - collects the direct descendents. rec - collects the leaf descendents ( leaf items ). A leaf item is an item with no child items. all - collects all descendents. Currently, the following items are excluded by aggregate functions: not-sortable items. The SortableItem property specifies whether the item can be sorted ( a sortable item can change its position after sorting, while a not-sortable item keeps its position after sorting. not-selectable items. The SelectableItem property specifies whether the user can selects/focus the specified item. divider items. The ItemDivider property specifies whether the item displays a single cell, instead displaying whole cells. In conclusion, aggregate functions counts ONLY items that are: sortable, SortableItem is True, by default. selectable, SelectableItem is True, by default. not divider, ItemDivider is -1, by default. Shortly, by setting to a different value to any of these properties, makes the item to be ignored by the aggregate functions. 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.