For instance:
- the "currency(value)" displays the column using the current format for the currency ie, 1000 gets displayed as $1,000.00
- the "longdate(date(value))" converts the value to a date and gets the long format to display the date in the column, ie #1/1/2001# displays instead Monday, January 01, 2001
- the "'<b>' + ((0:=proper(value)) left 1) + '</b>' + (=:0 mid 2)" converts the name to proper, so the first letter is capitalized, bolds the first character, and let unchanged the rest, ie a "mihai filimon" gets displayed "Mihai Filimon".
- the "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)" displays the cells that contains not empty daya, the value in currency format, with a different font and color for values less than 10, and bolded for those that are greater than 10, as can see in the following screen shot in the column (A+B+C):
The value keyword in the FormatColumn/FormatCell property indicates the value to be formatted.
The expression supports cell's identifiers as follows:
- %0, %1, %2, ... specifies the value of the cell in the column with the index 0, 1 2, ... The Caption property specifies the cell's value. For instance, "%0 format ``" formats the value on the cell with the index 0, using current regional setting, while "int(%1)" converts the value of the column with the index 1, to integer.
Other known operators for auto-numbering are:
- number index 'format', indicates the index of the item. The first
added item has the index 0, the second added item has the index 1, and so
on. The index of the item remains the same even if the order of the items
is changed by sorting. For instance, 1 index '' gets the index of the item
starting from 1 while 100 index '' gets the index of the item starting
from 100. The number indicates the starting index, while the format is a
set of characters to be used for specifying the index. If the format is
missing, the index of the item is formatted as numbers. For instance: 1
index 'A-Z' gets the index as A, B, C... Z, BA, BB, ... BZ, CA, ... . The
1 index 'abc' gives the index as: a,b,c,ba,bb,bc,ca,cb,cc,.... You can use
other number formatting function to format the returned value. For
instance "1 index '' format '0||2|:'" gets the numbers grouped
by 2 digits and separated by : character.
In the following screen shot the FormatColumn("Col 1") = "1 index ''"
In the following screen shot the FormatColumn("Col 1") = "1 index 'A-Z'"
- number apos 'format' indicates the absolute position of the item.
The first displayed item has the absolute position 0 ( scrolling position
on top ), the next visible item is 1, and so on. The number
indicates the starting position, while the format is a set of characters
to be used for specifying the position. For instance, 1 apos '' gets the
absolute position of the item starting from 1, while 100 apos '' gets the
position of the item starting from 100. If the format is missing, the
absolute position of the item is formatted as numbers.
In the following screen shot the FormatColumn("Col 1") = "1 apos ''"
In the following screen shot the FormatColumn("Col 1") = "1 apos 'A-Z'"
- number pos 'format' indicates the relative position of the item.
The relative position is the position of the visible child item in the
parent children collection. The number indicates the starting position,
while the format is a set of characters to be used for specifying the
position. For instance, 1 pos '' gets the relative position of the item
starting from 1, while 100 pos '' gets the relative position of the item
starting from 100. If the format is missing, the relative position of the
item is formatted as numbers. The difference between pos and opos can
be seen while filtering the items in the control. For instance, if no
filter is applied to the control, the pos and opos gets the same result.
Instead, if the filter is applied, the opos gets the position of the item
in the list of unfiltered items, while the pos gets the position of the
item in the filtered list.
In the following screen shot the FormatColumn("Col 2") = "'<b>' + 1 pos '' + '</b> ' + value"
In the following screen shot the FormatColumn("Col 2") = "'<b>' + 1 pos 'A-Z' + '</b> ' + value"
- number opos 'format' indicates the relative old position of the item. The relative old position is the position of the child item in the parent children collection. The number indicates the starting position, while the format is a set of characters to be used for specifying the position.For instance, 1 pos '' gets the relative position of the item starting from 1, while 100 pos '' gets the relative position of the item starting from 100. If the format is missing, the relative position of the item is formatted as numbers. The difference between pos and opos can be seen while filtering the items in the control. For instance, if no filter is applied to the control, the pos and opos gets the same result. Instead, if the filter is applied, the opos gets the position of the item in the list of unfiltered items, while the pos gets the position of the item in the filtered list.
- number rpos 'format' indicates the relative recursive position of
the item. The recursive position indicates the position of the parent
items too. The relative position is the position of the visible child item
in the parent children collection. The number indicates the starting
position, while the format is of the following type "delimiter|format|format|...".
If the format is missing, the delimiter is . character, and the positions
are formatted as numbers. The format is applied consecutively to each
parent item, from root to item itself.
In the following screen shot the FormatColumn("Col 1") = "1 rpos ''"
In the following screen shot the FormatColumn("Col 1") = "1 rpos ':|A-Z'"
In the following screen shot the FormatColumn("Col 1") = "1 rpos '.|A-Z|'"
In the following screen shot the FormatColumn("Col 1") = "1 apos ''" and FormatColumn("Col 2") = "'<b><font Tahoma;10>' + 1 rpos '.|A-Z|' + '</font></b> ' + value"
-
number rindex 'format', number rapos 'format' and number ropos 'format' are working similar with number rpos 'format', excepts that they gives the index, absolute position, or the old child position.
This property/method supports predefined constants and operators/functions as described here.
The following VB sample shows how can I display the column using currency:With List1
.Columns.Add("Currency").FormatColumn = "currency(dbl(value))"
With .Items
.Add "1.23"
.Add "2.34"
.Add "0"
.Add 5
.Add "10000.99"
End With
End With
The following VB.NET sample shows how can I display the column
using currency:
With AxList1
.Columns.Add("Currency").FormatColumn = "currency(dbl(value))"
With .Items
.Add "1.23"
.Add "2.34"
.Add "0"
.Add 5
.Add "10000.99"
End With
End With
The following C++ sample shows how can I display the column
using currency:
/*
Copy and paste the following directives to your header file as
it defines the namespace 'EXLISTLib' for the library: 'ExList 1.0 Control Library'
#import "C:\\Windows\\System32\\ExList.dll"
using namespace EXLISTLib;
*/
EXLISTLib::IListPtr spList1 = GetDlgItem(IDC_LIST1)->GetControlUnknown();
((EXLISTLib::IColumnPtr)(spList1->GetColumns()->Add(L"Currency")))->PutFormatColumn(L"currency(dbl(value))");
EXLISTLib::IItemsPtr var_Items = spList1->GetItems();
var_Items->Add("1.23");
var_Items->Add("2.34");
var_Items->Add("0");
var_Items->Add(long(5));
var_Items->Add("10000.99");
The following C# sample shows how can I display the column using
currency:
(axList1.Columns.Add("Currency") as EXLISTLib.Column).FormatColumn = "currency(dbl(value))";
EXLISTLib.Items var_Items = axList1.Items;
var_Items.Add("1.23");
var_Items.Add("2.34");
var_Items.Add("0");
var_Items.Add(5);
var_Items.Add("10000.99");
The following VFP sample shows how can I display the column
using currency:
with thisform.List1
.Columns.Add("Currency").FormatColumn = "currency(dbl(value))"
with .Items
.Add("1.23")
.Add("2.34")
.Add("0")
.Add(5)
.Add("10000.99")
endwith
endwith