Currently, the Exontrol's built-in HTML format supports the following HTML tags:
For instance, the following HTML caption
- <b>…</b> displays the text in bold.
- <i>…</i> displays the text in italics.
- <u>…</u> underlines the 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 event when the user clicks an
anchor element. Use the FormatAnchor property to specify the visual
effect for anchor elements. For instance, if the user clicks the anchor <a1>anchor</a>,
the control fires the AnchorClick event, where the AnchorID parameter is 1,
and the Options parameter is empty. Also, if the user clicks the anchor <a
1;yourextradata>anchor</a>, the AnchorID parameter of the
AnchorClick event is 1, and the Options parameter is "yourextradata".
You can use the <a> anchor elements to insert hyperlinks to cells,
bars or links.
- <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> displays text with a
specified foreground color. The RR, GG or BB
should be hexa values and indicates red, green and blue values.
- <bgcolor=RRGGBB>…</bgcolor> displays text with a
specified background color.
The RR, GG or BB should be hexa values and indicates red, green and blue
- <br> a forced line-break
- <solidline> The next line shows a solid-line on top/bottom
side. If has no effect for a single line caption.
- <dotline> The next line shows a dot-line on top/bottom side.
If has no effect for a single line caption.
- <upline> The next line shows a solid/dot-line on top side. If
has no effect for a single line caption.
- <r> Right aligns the text
- <c> Centers the text
- <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, in UNICODE configuration. 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>
<font Segoe Print>This is a bit of text with a <b>different</b> font</font>
<upline><dotline>left 1<r><b>right</b> 2
<img>1</img><c><a><s>center <img>pic1:64</img> picture</s><r></a><img>2</img>
left 3 <c>center<r><b>right</b> 4
generates the following screen shot:
Also, newer HTML format supports decorative text like
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)
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:
Shortly, by setting to a different value to any of these properties, makes
the item to be ignored by the aggregate functions.
- 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
- 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
- sum(all,rec,%1 + %2) sums all leaf cells in the second (%1) and third (%2)