Type | Description | |||
String | A string expression that defines the format to display the cell, including HTML formatting, if the cell supports it. |
The CellValue property of the cell is being shown as:
In other words, all cells applies the format of the FormatColumn property, excepts the cells with the FormatCell property being set. If the cell belongs to a column with the FireFormatColumn property on True, the Value parameter of the FormatColumn event shows the newly caption for the cell to be shown.
For instance:
The value keyword in the FormatColumn property indicates the value being formatted.
The expression supports cell's identifiers as follows:
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 Grid1 .Columns.Add("Currency").FormatColumn = "currency(dbl(value))" With .Items .AddItem "1.23" .AddItem "2.34" .AddItem "0" .AddItem 5 .AddItem "10000.99" End With End WithThe following VB.NET sample shows how can I display the column using currency:
With AxGrid1 .Columns.Add("Currency").FormatColumn = "currency(dbl(value))" With .Items .AddItem "1.23" .AddItem "2.34" .AddItem "0" .AddItem 5 .AddItem "10000.99" End With End WithThe 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 'EXG2ANTTLib' for the library: 'ExGrid 1.0 Control Library' #import "C:\\Windows\\System32\\ExGrid.dll" using namespace EXG2ANTTLib; */ EXG2ANTTLib::IGridPtr spGrid1 = GetDlgItem(IDC_G2ANTT1)->GetControlUnknown(); ((EXG2ANTTLib::IColumnPtr)(spGrid1->GetColumns()->Add(L"Currency")))->PutFormatColumn(L"currency(dbl(value))"); EXG2ANTTLib::IItemsPtr var_Items = spGrid1->GetItems(); var_Items->AddItem("1.23"); var_Items->AddItem("2.34"); var_Items->AddItem("0"); var_Items->AddItem(long(5)); var_Items->AddItem("10000.99");The following C# sample shows how can I display the column using currency:
(axGrid1.Columns.Add("Currency") as EXG2ANTTLib.Column).FormatColumn = "currency(dbl(value))"; EXG2ANTTLib.Items var_Items = axGrid1.Items; var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); var_Items.AddItem("0"); var_Items.AddItem(5); var_Items.AddItem("10000.99");The following VFP sample shows how can I display the column using currency:
with thisform.Grid1 .Columns.Add("Currency").FormatColumn = "currency(dbl(value))" with .Items .AddItem("1.23") .AddItem("2.34") .AddItem("0") .AddItem(5) .AddItem("10000.99") endwith endwith