Type | Description | |||
String | A string expression that defines the format to display the cell, including HTML formatting, if the cell supports it. |
For instance:
The value keyword in the FormatColumn property indicates the value to be 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 Gantt1 .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 AxGantt1 .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 'EXGANTTLib' for the library: 'ExGantt 1.0 Control Library' #import "C:\\Windows\\System32\\ExGantt.dll" using namespace EXGANTTLib; */ EXGANTTLib::IGanttPtr spGantt1 = GetDlgItem(IDC_GANTT1)->GetControlUnknown(); ((EXGANTTLib::IColumnPtr)(spGantt1->GetColumns()->Add(L"Currency")))->PutFormatColumn(L"currency(dbl(value))"); EXGANTTLib::IItemsPtr var_Items = spGantt1->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:
(axGantt1.Columns.Add("Currency") as EXGANTTLib.Column).FormatColumn = "currency(dbl(value))"; EXGANTTLib.Items var_Items = axGantt1.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.Gantt1 .Columns.Add("Currency").FormatColumn = "currency(dbl(value))" with .Items .AddItem("1.23") .AddItem("2.34") .AddItem("0") .AddItem(5) .AddItem("10000.99") endwith endwith