|
1261
|
Mask for Floating-Point Numbers (Emglish Style: . as Decimal, , as Grouping Separator)
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.SelForeColor = exgrid1.ForeColor;
exgrid1.SelBackColor = exgrid1.BackColor;
exgrid1.ShowFocusRect = false;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Float(English-style)") as exontrol.EXGRIDLib.Column);
var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
var_Column.FormatColumn = "value format `3`";
var_Column.HeaderAlignment = exontrol.EXGRIDLib.AlignmentEnum.RightAlignment;
var_Column.Alignment = exontrol.EXGRIDLib.AlignmentEnum.RightAlignment;
exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
var_Editor.Mask = "!999,999,990.000;;;float,right,negative,grouping=\\,,decimal=.";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem(192278.12);
var_Items.AddItem(2829.7);
var_Items.AddItem(7391.55);
var_Items.AddItem(50812.23);
var_Items.AddItem(913.04);
var_Items.AddItem(127500.88);
var_Items.AddItem(62.19);
var_Items.AddItem(1);
exgrid1.EndUpdate();
|
|
1260
|
Mask for Floating-Point Numbers (German Style: , as Decimal, . as Grouping Separator)
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.SelForeColor = exgrid1.ForeColor;
exgrid1.SelBackColor = exgrid1.BackColor;
exgrid1.ShowFocusRect = false;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Float(German-style)") as exontrol.EXGRIDLib.Column);
var_Column.SortType = exontrol.EXGRIDLib.SortTypeEnum.SortNumeric;
var_Column.FormatColumn = "value format `3`";
var_Column.HeaderAlignment = exontrol.EXGRIDLib.AlignmentEnum.RightAlignment;
var_Column.Alignment = exontrol.EXGRIDLib.AlignmentEnum.RightAlignment;
exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.MaskType;
var_Editor.Mask = "!999.999.990,000;;;float,right,grouping=.,decimal=\\,";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem(192278.12);
var_Items.AddItem(2829.7);
var_Items.AddItem(7391.55);
var_Items.AddItem(50812.23);
var_Items.AddItem(913.04);
var_Items.AddItem(127500.88);
var_Items.AddItem(62.19);
var_Items.AddItem(1);
exgrid1.EndUpdate();
|
|
1259
|
Locks the first visible column on the left and the last visible column on the right
exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
exgrid1.BackColorLock = Color.FromArgb(192,192,192);
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.mdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.CountLockedColumns = 17;
exgrid1.EndUpdate();
|
|
1258
|
Lock the column on the right
exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
exgrid1.BackColorLock = Color.FromArgb(192,192,192);
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.mdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.CountLockedColumns = 16;
exgrid1.EndUpdate();
|
|
1257
|
Lock the column on the left
exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
exgrid1.BackColorLock = Color.FromArgb(192,192,192);
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.mdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.CountLockedColumns = 1;
exgrid1.EndUpdate();
|
|
1256
|
Update the item's lock state - pinning it to the top, bottom, or making it scrollable
exgrid1.BeginUpdate();
exgrid1.Columns.Add("Column");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("un-locked item");
var_Items.set_LockItem(var_Items.AddItem("top-locked item"),exontrol.EXGRIDLib.LockItemEnum.exLockTop);
var_Items.set_LockItem(var_Items.AddItem("bottom-locked item"),exontrol.EXGRIDLib.LockItemEnum.exLockBottom);
exgrid1.EndUpdate();
|
|
1255
|
The Change event is called before changing the value. Is there any event such as Changed that is called after updating the cell's value
// Changed event - Occurs after the user has changed the content of a cell.
private void exgrid1_Changed(object sender, int Item, int ColIndex)
{
System.Diagnostics.Debug.Print( exgrid1.Items.get_CellValue(Item,ColIndex).ToString() );
}
//this.exgrid1.Changed += new exontrol.EXGRIDLib.exg2antt.ChangedEventHandler(this.exgrid1_Changed);
exgrid1.BeginUpdate();
(exgrid1.Columns.Add("Edit") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
exgrid1.Items.AddItem("Item 1");
exgrid1.Items.AddItem("Item 2");
exgrid1.EndUpdate();
|
|
1254
|
How can I reposition the +/- (expand/collapse) icon to show as "number, icon, text" (sample 2)
// AnchorClick event - Occurs when an anchor element is clicked.
private void exgrid1_AnchorClick(object sender, string AnchorID, string Options)
{
object i = exgrid1.FormatABC("int(value)",AnchorID,null,null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
i = var_Items[i];
bool exp = var_Items.get_ExpandItem(i);
var_Items.set_ExpandItem(i,false);
}
//this.exgrid1.AnchorClick += new exontrol.EXGRIDLib.exg2antt.AnchorClickEventHandler(this.exgrid1_AnchorClick);
exgrid1.BeginUpdate();
exgrid1.set_HTMLPicture("expand","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiIYOhFLB0KZvMx0O5hORlABQM" +
"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyxgjsRzEKv1TqtXrNbrtfsIAwgASAH" +
"AGShQwGQzGABUGEzudAqgyWdSmWw2Fw+sABSHI4AGH1XAGAxGAwywlI6eRqjGi1YuaJJEIJUHBPYqSJYKQAwCBDKbBPbncBibrUKQjGLFQo+TBFfR5GaUAR/KbGICyRx" +
"siCOQClgdJxGoMpkGycpdDqUZ0EoJQJHYVoWCSCA4kEbRlHKRwJiYcYCH0PBNB2JwYCaCRsGcE8LDyfZKg+U59EsAZMlQCgJkcEA9CsywkiKJwiFcIQwEEgI=");
exgrid1.set_HTMLPicture("collapse","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYU7YQBCooJSAiIYOhFLB0KZvMx0O5hORlABQM" +
"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzyO13dGEAGYzWcqlWrFarlesA3AGc" +
"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWISpVLiXT5MrxiJyJJEIJUHBPYqSXYOQAgBgAB6jJwufxxX7YYhdYhFCSsSwSC4uMLoQajNJ" +
"AG8QgZAgSIqGMCwRBkAJDicGwuiMeoHGeaRFlAU5qDwQQ6A+CYnlgPQeisGJfl4AJYhsRISjQYwJHIcpmmALAtlMEpkE4YBREmEpPBAARdicSw8AES5fi+fI5g+PpcAA" +
"UJKgyCYknaZRrssJIiicIhXCEMBBICA==");
exgrid1.set_HTMLPicture("empty","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYE7YABNTWRIJiIYOhFLB0KZvMx0O5hORlABQM" +
"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyy/O13dGEAGYzWcqlWrFarlesA3AGc" +
"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWYSvDpndpkQ9xhRTJJEIJUHBPdqSGIKYAwBgDUpCfytH57FqoVaTKQTGS0DJ6cDBDzOGwIfA" +
"NHMIxJDmf5CFIAxwA4Q5HEQVJlEWRxnBkMANjsPoqBSEAElkfZ5CMFJMHCC52BALBGjkDpHCuXIAB2bQdEGaQgFIbbLCSIonCIVwhDAQSAg==");
exgrid1.HeaderVisible = false;
exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exNoLine;
exgrid1.HasButtons = exontrol.EXGRIDLib.ExpandButtonEnum.exNoButtons;
exgrid1.Indent = 12;
exgrid1.DefaultItemHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exHLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.GridLineColor = Color.FromArgb(204,204,204);
exgrid1.ShowFocusRect = false;
exgrid1.ExpandOnDblClick = false;
exgrid1.ExpandOnKeys = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Item") as exontrol.EXGRIDLib.Column);
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
var_Column.FormatColumn = "(len(parent(1 index ``)) ? (`<b><fgcolor gray>` + (1 pos ``) + `. ` + `</fgcolor></b>` + (%CC0 ? (`<a ` + (0 index ``) + `>`) :" +
" ``) + `<img>` + (%CC0 ? (not %CX0 ? `expand` : `collapse`) : `empty`) + `:16</img>` + (%CC0 ? (`</a>`) : ``)) : ``) + ` ` + val" +
"ue";
exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exEditorAdjustPos,"32 4 -4 -4");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int hRoot = var_Items.AddItem("ACME Corporation");
var_Items.set_SelectableItem(hRoot,false);
var_Items.set_ExpandItem(hRoot,true);
int h = var_Items.InsertItem(hRoot,null,"Management");
var_Items.InsertItem(h,null,"CEO - Alice Brown");
var_Items.InsertItem(h,null,"COO - James Lee");
h = var_Items.InsertItem(hRoot,null,"HR Department");
var_Items.InsertItem(h,null,"Recruiter - Jane Smith");
var_Items.InsertItem(h,null,"HR Assistant - Bob Green");
var_Items.set_ExpandItem(h,true);
h = var_Items.InsertItem(h,null,"Engineering");
var_Items.InsertItem(h,null,"Software Team");
h = var_Items.InsertItem(h,null,"Lead Developer - Mark H.");
var_Items.InsertItem(h,null,"Frontend Dev - Emily R.");
var_Items.InsertItem(h,null,"Backend Dev - Tom W.");
var_Items.InsertItem(hRoot,null,"QA Team");
exgrid1.EndUpdate();
|
|
1253
|
How can I reposition the +/- (expand/collapse) icon to show as "number, icon, text" (sample 1)
// AnchorClick event - Occurs when an anchor element is clicked.
private void exgrid1_AnchorClick(object sender, string AnchorID, string Options)
{
object i = exgrid1.FormatABC("int(value)",AnchorID,null,null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
i = var_Items[i];
bool exp = var_Items.get_ExpandItem(i);
var_Items.set_ExpandItem(i,false);
}
//this.exgrid1.AnchorClick += new exontrol.EXGRIDLib.exg2antt.AnchorClickEventHandler(this.exgrid1_AnchorClick);
exgrid1.BeginUpdate();
exgrid1.set_HTMLPicture("expand","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiIYOhFLB0KZvMx0O5hORlABQM" +
"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyxgjsRzEKv1TqtXrNbrtfsIAwgASAH" +
"AGShQwGQzGABUGEzudAqgyWdSmWw2Fw+sABSHI4AGH1XAGAxGAwywlI6eRqjGi1YuaJJEIJUHBPYqSJYKQAwCBDKbBPbncBibrUKQjGLFQo+TBFfR5GaUAR/KbGICyRx" +
"siCOQClgdJxGoMpkGycpdDqUZ0EoJQJHYVoWCSCA4kEbRlHKRwJiYcYCH0PBNB2JwYCaCRsGcE8LDyfZKg+U59EsAZMlQCgJkcEA9CsywkiKJwiFcIQwEEgI=");
exgrid1.set_HTMLPicture("collapse","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYU7YQBCooJSAiIYOhFLB0KZvMx0O5hORlABQM" +
"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzyO13dGEAGYzWcqlWrFarlesA3AGc" +
"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWISpVLiXT5MrxiJyJJEIJUHBPYqSXYOQAgBgAB6jJwufxxX7YYhdYhFCSsSwSC4uMLoQajNJ" +
"AG8QgZAgSIqGMCwRBkAJDicGwuiMeoHGeaRFlAU5qDwQQ6A+CYnlgPQeisGJfl4AJYhsRISjQYwJHIcpmmALAtlMEpkE4YBREmEpPBAARdicSw8AES5fi+fI5g+PpcAA" +
"UJKgyCYknaZRrssJIiicIhXCEMBBICA==");
exgrid1.HeaderVisible = false;
exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exNoLine;
exgrid1.HasButtons = exontrol.EXGRIDLib.ExpandButtonEnum.exNoButtons;
exgrid1.Indent = 12;
exgrid1.DefaultItemHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exHLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.GridLineColor = Color.FromArgb(204,204,204);
exgrid1.ShowFocusRect = false;
exgrid1.ExpandOnDblClick = false;
exgrid1.ExpandOnKeys = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Item") as exontrol.EXGRIDLib.Column);
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
var_Column.FormatColumn = "(len(parent(1 index ``)) ? (`<b><fgcolor gray>` + (1 pos ``) + `. ` + `</fgcolor></b>` + `<a ` + (0 index ``) + `><img>` + (%CC" +
"0 ? (not %CX0 ? `expand` : `collapse`) : ``) + `:16</img></a>`) : ``) + ` ` + value";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int hRoot = var_Items.AddItem("ACME Corporation");
var_Items.set_SelectableItem(hRoot,false);
var_Items.set_ExpandItem(hRoot,true);
int h = var_Items.InsertItem(hRoot,null,"Management");
var_Items.InsertItem(h,null,"CEO - Alice Brown");
var_Items.InsertItem(h,null,"COO - James Lee");
h = var_Items.InsertItem(hRoot,null,"HR Department");
var_Items.InsertItem(h,null,"Recruiter - Jane Smith");
var_Items.InsertItem(h,null,"HR Assistant - Bob Green");
var_Items.set_ExpandItem(h,true);
h = var_Items.InsertItem(h,null,"Engineering");
var_Items.InsertItem(h,null,"Software Team");
h = var_Items.InsertItem(h,null,"Lead Developer - Mark H.");
var_Items.InsertItem(h,null,"Frontend Dev - Emily R.");
var_Items.InsertItem(h,null,"Backend Dev - Tom W.");
var_Items.InsertItem(hRoot,null,"QA Team");
exgrid1.EndUpdate();
|
|
1252
|
Expandable bullet list
// AnchorClick event - Occurs when an anchor element is clicked.
private void exgrid1_AnchorClick(object sender, string AnchorID, string Options)
{
object i = exgrid1.FormatABC("int(value)",AnchorID,null,null);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
i = var_Items[i];
bool exp = var_Items.get_ExpandItem(i);
var_Items.set_ExpandItem(i,false);
}
//this.exgrid1.AnchorClick += new exontrol.EXGRIDLib.exg2antt.AnchorClickEventHandler(this.exgrid1_AnchorClick);
exgrid1.BeginUpdate();
exgrid1.set_HTMLPicture("expand","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYM7YIBXCRNbtiIYOhFLB0KZvMx0O5hORlABQM" +
"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzZO13dGEAGYzWcqlWrFarlesA3AGc" +
"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWNa6awbST7DBTiLyJJEIJUHBPUqSGJuYYwCAES5pBiQfyEX4QKAFH6QSihJQ/GZlET1FhIcg" +
"GnUdoVHMmxajSIghlMKhsGiAAFggQ5dmKcRHEUEhbFAFQBgacABmAAJgAAcAJkAZgNjUcwDFecYcD8QoIDsGJjD6aYaGyHI7mqLRfgGfBcg+TYggkEhakQThtFsEpAE2" +
"Xh7goSIJiSHp6haKgPGOXx3j+c5hiKLpri6JAPHWYJREuFJkBCYxcFeYS7ikJQzG0ZIVGKMBYGsVwXDWVQHjqfpjAoYpyE4Z5vH2YoHDkZwzkkUxHC8pwCgifIHBCdk4" +
"GMLQVmcXJVhicxWi4IIUiKSQ1A8cBUj+eBEGCFQlFSIophiPRkFAWBLFALhwm+HhKjARpmgSGwNn4AIUCcZZUFEKoVmwywkiKJwiFcIQwEEgI");
exgrid1.set_HTMLPicture("collapse","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYM7YIBXCRNbtiIYOhFLB0KZvMx0O5hORlABQM" +
"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzZO13dGEAGYzWcqlWrFarlesA3AGc" +
"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWNa6awbST7DBTiLZJJEIJUHBPdpSGKOAQxCAzGhIBKfbAvUBsSIPbiVMhLTxJPK3banJB0N5" +
"sA8VQRlmCRKjSCRaAIOgCiORISiWaI0DYLJPBYJBxB+LAqAMBRgAsIABjAAhYAOEB5kKDQ5kGZoaCaL5vH2KoEDCbpbDaWRrE8SopE+AA/DcMoZkgAgkhKERDlcdYEHA" +
"JRzg4IpyCAKRyl6HZLGONwMEMb5clwWB3n2CZki6FoWC4cwQCbGYukKwhiAwOp3HIEJFGCNBGDyLArE8R56n4RUnlOShHGcXJdgcKQlCOSRdEcLw8DmAoInyexvFeMRG" +
"G0DARmsbRZmsfRxleFZeHoD4eEKKRxGmPANgAC5xDAWpYHMW4uCGywkiKJwiFcIQwEEgI");
exgrid1.HeaderVisible = false;
exgrid1.HasLines = exontrol.EXGRIDLib.HierarchyLineEnum.exNoLine;
exgrid1.HasButtons = exontrol.EXGRIDLib.ExpandButtonEnum.exNoButtons;
exgrid1.Indent = 12;
exgrid1.DefaultItemHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exHLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.GridLineColor = Color.FromArgb(204,204,204);
exgrid1.ShowFocusRect = false;
exgrid1.ExpandOnDblClick = false;
exgrid1.ExpandOnKeys = false;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Item") as exontrol.EXGRIDLib.Column);
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
var_Column.FormatColumn = "(len(parent(1 index ``)) ? (`<b><fgcolor gray>` + (1 pos ``) + `. ` + `</fgcolor></b>` + `<a ` + (0 index ``) + `><img>` + (%CC" +
"0 ? (not %CX0 ? `expand` : `collapse`) : `collapse`) + `:16</img></a>`) : ``) + ` ` + value";
exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.EditType;
var_Editor.set_Option(exontrol.EXGRIDLib.EditorOptionEnum.exEditorAdjustPos,"32D 4D -4D -4D");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int hRoot = var_Items.AddItem("ACME Corporation");
var_Items.set_SelectableItem(hRoot,false);
var_Items.set_ExpandItem(hRoot,true);
int h = var_Items.InsertItem(hRoot,null,"Management");
var_Items.InsertItem(h,null,"CEO - Alice Brown");
var_Items.InsertItem(h,null,"COO - James Lee");
h = var_Items.InsertItem(hRoot,null,"HR Department");
var_Items.InsertItem(h,null,"Recruiter - Jane Smith");
var_Items.InsertItem(h,null,"HR Assistant - Bob Green");
var_Items.set_ExpandItem(h,true);
h = var_Items.InsertItem(h,null,"Engineering");
var_Items.InsertItem(h,null,"Software Team");
h = var_Items.InsertItem(h,null,"Lead Developer - Mark H.");
var_Items.InsertItem(h,null,"Frontend Dev - Emily R.");
var_Items.InsertItem(h,null,"Backend Dev - Tom W.");
var_Items.InsertItem(hRoot,null,"QA Team");
exgrid1.EndUpdate();
|
|
1251
|
Does grouping support multi-column sorting
exgrid1.BeginUpdate();
exgrid1.SingleSort = false;
exgrid1.HeaderVisible = false;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.AllowGroupBy = true;
exgrid1.Columns.Add("Prefix");
exgrid1.Columns.Add("Region");
exgrid1.Columns.Add("City");
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Sort") as exontrol.EXGRIDLib.Column);
var_Column.ComputedField = "%1 + %2";
var_Column.Visible = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int h = var_Items.AddItem("+33");
var_Items.set_CellValue(h,1,"Corsica");
var_Items.set_CellValue(h,2,"Bastia ");
h = var_Items.AddItem("+33");
var_Items.set_CellValue(h,1,"Occitanie");
var_Items.set_CellValue(h,2,"Toulouse ");
h = var_Items.AddItem("+33");
var_Items.set_CellValue(h,1,"Corsica");
var_Items.set_CellValue(h,2,"Ajaccio");
h = var_Items.AddItem("+33");
var_Items.set_CellValue(h,1,"Occitanie");
var_Items.set_CellValue(h,2,"Carcassonne ");
exgrid1.Layout = "multiplesort=\"C0:2\";singlesort=\"C3:1\";";
exgrid1.EndUpdate();
|
|
1250
|
How can I vertically scroll the control
exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
// Add 'Microsoft Office 15.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project.
exgrid1.DataSource = (new DAO.PrivDBEngine().OpenDatabase("C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.accdb",null,null,null).OpenRecordset("Orders",null,null,null) as DAO.Recordset2);
exgrid1.Layout = "Collapse=\"\";VScroll=10";
exgrid1.EndUpdate();
|
|
1249
|
Export the items as a two-dimensional array
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.PutItems(exgrid1.Export("array","all"),null);
exgrid1.EndUpdate();
|
|
1248
|
Export only expanded items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(expanded)").ToString() );
|
|
1247
|
Export only selectable, sortable leaf items that are neither locked nor dividers
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(leaf,sortable,selectable,!divider,!locked)").ToString() );
|
|
1246
|
Export only non-divider items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(!divider)").ToString() );
|
|
1245
|
Export only selectable items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(selectable)").ToString() );
|
|
1244
|
Export only sortable, but not locked items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(sortable,!locked)").ToString() );
|
|
1243
|
Export only checked items on specified column
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(checked[0])").ToString() );
|
|
1242
|
Export only filtered, not locked or divider items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(visible,!locked,!divider)").ToString() );
|
|
1241
|
Export only selected items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(selected)").ToString() );
|
|
1240
|
Export only locked items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","only(locked)").ToString() );
|
|
1239
|
Export the leaf items of the control, excluding parent or grouped items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","leaf").ToString() );
|
|
1238
|
Export all checked and visible items (the first column in the columns list specifies the index of the column used to query the checkbox state)
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","chk").ToString() );
|
|
1237
|
Export the selected-items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","sel").ToString() );
|
|
1236
|
Export the visible items, excluding child items of collapsed elements, non-visible items (such as those with a height of 0), and items that do not match the current filter
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","vis").ToString() );
|
|
1235
|
Export all items, including the hidden or collapsed items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.ScrollBySingleLine = true;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
var_Column1.FormatColumn = "currency(value)";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exTop,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exTop,0);
var_Items.set_CellValue(h,0,"All");
var_Items.set_CellValue(h,1,"sum(all,rec,%1)");
var_Items.set_CellValueFormat(h,1,exontrol.EXGRIDLib.ValueFormatEnum.exTotalField);
int r = var_Items.AddItem("Root 1");
int g1 = var_Items.InsertItem(r,null,"Group A");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 1"),1,1);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 2"),1,2);
var_Items.set_CellState(var_Items[3],0,1);
int g2 = var_Items.InsertItem(r,null,"Group B");
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 3"),1,3);
var_Items.set_CellValue(var_Items.InsertItem(g2,null,"Item 4"),1,4);
var_Items.set_ExpandItem(g1,true);
var_Items.set_ExpandItem(r,true);
h = var_Items.AddItem("divider");
var_Items.set_ItemDivider(h,0);
var_Items.set_SelectableItem(h,false);
var_Items.set_SortableItem(h,false);
var_Items.set_ItemHeight(h,1);
r = var_Items.AddItem("Root 2");
g1 = var_Items.InsertItem(r,null,"Group C");
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 5"),1,5);
var_Items.set_CellValue(var_Items.InsertItem(g1,null,"Item 6"),1,6);
var_Items.set_SelectItem(var_Items[2],true);
exgrid1.EndUpdate();
System.Diagnostics.Debug.Print( exgrid1.Export("","all").ToString() );
|
|
1234
|
Bolds only the expanded items
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.ConditionalFormats.Add("%CX0",null).Bold = true;
exgrid1.Columns.Add("Description");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(var_Items.InsertItem(h,null,"Child 2"),null,"Sub-Child 2");
var_Items.set_CellState(var_Items.InsertItem(h,null,"Child 3"),0,1);
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
exgrid1.EndUpdate();
|
|
1233
|
Displays the root item's index and value/caption using expressions
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragPositionAny;
exgrid1.AllowCopyPaste = exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowPaste | exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowCut | exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowCopy;
exgrid1.SingleSel = false;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.GridLineColor = Color.FromArgb(208,208,208);
exgrid1.ConditionalFormats.Add("%CC0 and %CX0",null).Bold = true;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = exgrid1.ConditionalFormats.Add("1",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x2;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Description") as exontrol.EXGRIDLib.Column);
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.PartialCheck = true;
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("Index") as exontrol.EXGRIDLib.Column);
var_Column1.FormatColumn = "1 index ``";
var_Column1.Position = 0;
var_Column1.Width = 16;
exontrol.EXGRIDLib.Column var_Column2 = (exgrid1.Columns.Add("Root-Index") as exontrol.EXGRIDLib.Column);
var_Column2.FormatColumn = "root(1 index ``)";
var_Column2.Position = 1;
var_Column2.Width = 32;
var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
exontrol.EXGRIDLib.Column var_Column3 = (exgrid1.Columns.Add("Root-Value") as exontrol.EXGRIDLib.Column);
var_Column3.FormatColumn = "root(%0)";
var_Column3.Position = 2;
var_Column3.Width = 32;
var_Column3.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(var_Items.InsertItem(h,null,"Child 2"),null,"Sub-Child 2");
var_Items.set_CellState(var_Items.InsertItem(h,null,"Child 3"),0,1);
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();
|
|
1232
|
Displays the parent item's index and caption/value using expressions
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.AutoDrag = exontrol.EXGRIDLib.AutoDragEnum.exAutoDragPositionAny;
exgrid1.AllowCopyPaste = exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowPaste | exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowCut | exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowCopy;
exgrid1.SingleSel = false;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
exgrid1.GridLineColor = Color.FromArgb(208,208,208);
exgrid1.ConditionalFormats.Add("%CC0 and %CX0",null).Bold = true;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = exgrid1.ConditionalFormats.Add("1",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x2;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Description") as exontrol.EXGRIDLib.Column);
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
var_Column.PartialCheck = true;
exontrol.EXGRIDLib.Column var_Column1 = (exgrid1.Columns.Add("Index") as exontrol.EXGRIDLib.Column);
var_Column1.FormatColumn = "1 index `I`";
var_Column1.Position = 0;
var_Column1.Width = 16;
exontrol.EXGRIDLib.Column var_Column2 = (exgrid1.Columns.Add("Parent-Index") as exontrol.EXGRIDLib.Column);
var_Column2.FormatColumn = "parent(1 index `I`)";
var_Column2.Position = 1;
var_Column2.Width = 32;
var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
exontrol.EXGRIDLib.Column var_Column3 = (exgrid1.Columns.Add("Parent-Value") as exontrol.EXGRIDLib.Column);
var_Column3.FormatColumn = "parent(%0)";
var_Column3.Position = 2;
var_Column3.Width = 32;
var_Column3.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(var_Items.InsertItem(h,null,"Child 2"),null,"Sub-Child 2");
var_Items.set_CellState(var_Items.InsertItem(h,null,"Child 3"),0,1);
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.InsertItem(h,null,"Child 3");
var_Items.set_ExpandItem(h,true);
exgrid1.EndUpdate();
|
|
1231
|
Copying and Pasting the Selection Programmatically
exgrid1.BeginUpdate();
exgrid1.Columns.Add("Tasks");
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.SingleSel = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Tasks");
var_Items.set_SelectItem(var_Items.AddItem("Task 1"),true);
var_Items.set_SelectItem(var_Items.AddItem("Task 2"),true);
exgrid1.IndentSelection(false);
exgrid1.CopySelection();
exgrid1.Items.UnselectAll();
exgrid1.Paste(null);
exgrid1.EndUpdate();
|
|
1230
|
Enable Copy, Cut and Paste Clipboard operations
exgrid1.BeginUpdate();
exgrid1.Columns.Add("Tasks");
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.AllowCopyPaste = exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowPaste | exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowCut | exontrol.EXGRIDLib.AllowCopyPasteEnum.exAllowCopy;
exgrid1.SingleSel = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Tasks");
var_Items.set_SelectItem(var_Items.AddItem("Task 1"),true);
var_Items.set_SelectItem(var_Items.AddItem("Task 2"),true);
exgrid1.IndentSelection(false);
exgrid1.EndUpdate();
|
|
1229
|
Adjusts the hierarchy of selected items by changing their parent
exgrid1.BeginUpdate();
exgrid1.Columns.Add("Tasks");
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exgrid1.SingleSel = false;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Tasks");
var_Items.set_SelectItem(var_Items.AddItem("Task A"),true);
var_Items.set_SelectItem(var_Items.AddItem("Task B"),true);
exgrid1.IndentSelection(false);
exgrid1.EndUpdate();
|
|
1228
|
Specify the size of the Columns panel
exgrid1.BeginUpdate();
exgrid1.HeaderHeight = 24;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("City");
(var_Columns.Add("Start") as exontrol.EXGRIDLib.Column).Visible = false;
(var_Columns.Add("End") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.ColumnsFloatBarRect = ",,96";
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
exgrid1.EndUpdate();
|
|
1227
|
Show a vertical line between pivot and Columns panel (EBN color)
exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABRsIQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFICQTIcBhaGIZRiAKCRTDmHwyRCNIwCLD8QxtDqBY4gOZZX" +
"hal4cJTgMaBYi+Pw3DZHcbvBRkewzHQAKgnSjoDhEMg1CTVVYTDKdOSzDyEX7sIAACpOIZQVJVEY1VT8cyxIyEZimSypWqiYJ0Ty6cQwTAIgI");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,0x1000000);
exgrid1.HeaderHeight = 24;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("City");
(var_Columns.Add("Start") as exontrol.EXGRIDLib.Column).Visible = false;
(var_Columns.Add("End") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
exgrid1.EndUpdate();
|
|
1226
|
Change the background of the Columns panel (EBN color)
exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzT" +
"J0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSN" +
"AgqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPp" +
"TlWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+" +
"BZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJl" +
"EkVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd" +
"4kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLB" +
"qOIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,0x1000000);
exgrid1.HeaderHeight = 24;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("City");
(var_Columns.Add("Start") as exontrol.EXGRIDLib.Column).Visible = false;
(var_Columns.Add("End") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
exgrid1.EndUpdate();
|
|
1225
|
Change the background of the Columns panel (solid color)
exgrid1.BeginUpdate();
exgrid1.HeaderHeight = 24;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("City");
(var_Columns.Add("Start") as exontrol.EXGRIDLib.Column).Visible = false;
(var_Columns.Add("End") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
exgrid1.set_Background(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,Color.FromArgb(240,240,240));
exgrid1.EndUpdate();
|
|
1224
|
Change the visual appearance of the Columns panel
exgrid1.BeginUpdate();
exgrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzT" +
"J0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSN" +
"AgqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPp" +
"TlWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+" +
"BZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJl" +
"EkVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd" +
"4kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLB" +
"qOIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA");
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatAppearance,0x1000000);
exgrid1.set_Background(exontrol.EXGRIDLib.BackgroundPartEnum.exColumnsFloatCaptionBackColor,Color.FromArgb(246,246,246));
exgrid1.BackColorHeader32 = 0x1000000;
exgrid1.HeaderHeight = 24;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("City");
(var_Columns.Add("Start") as exontrol.EXGRIDLib.Column).Visible = false;
(var_Columns.Add("End") as exontrol.EXGRIDLib.Column).Visible = false;
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exColumnsFloatBar,"Show/Hide");
exgrid1.ColumnsFloatBarVisible = exontrol.EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
exgrid1.EndUpdate();
|
|
1223
|
Defines the symbol used to indicate repeated captions, providing a clear visual cue for identical entries (ditto mark)
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
(exgrid1.Columns.Add("Country") as exontrol.EXGRIDLib.Column).ShowIdem = "<fgcolor gray>〃";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Spain");
var_Items.AddItem("Spain");
var_Items.AddItem("Spain");
var_Items.AddItem("Spain");
var_Items.AddItem("Germany");
var_Items.AddItem("Germany");
var_Items.AddItem("Germany");
var_Items.AddItem("Germany");
exgrid1.EndUpdate();
|
|
1222
|
Defines the symbol used to indicate repeated captions, providing a clear visual cue for identical entries (space)
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exRowLines;
(exgrid1.Columns.Add("Country") as exontrol.EXGRIDLib.Column).ShowIdem = " ";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Spain");
var_Items.AddItem("Spain");
var_Items.AddItem("Spain");
var_Items.AddItem("Spain");
var_Items.AddItem("Germany");
var_Items.AddItem("Germany");
var_Items.AddItem("Germany");
var_Items.AddItem("Germany");
exgrid1.EndUpdate();
|
|
1221
|
Displays a glitch funnel for drop-down filter buttons (empty or active)
exgrid1.BeginUpdate();
exontrol.EXGRIDLib.Appearance var_Appearance = exgrid1.VisualAppearance;
var_Appearance.RenderType = 0xffffffff;
var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABa8IQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFMbxCKQahLEiTIhGUYJHgmK4tRiAUgxVDkBxrECZYqjcBZO" +
"iwLQ2TxDM7DNKUCBnIoABhGOaYDh+IQNQjUFKwTRFGRxK4EIRKAyTDLQdRyGSMMbjdQpBCbMiMRqhESKRq2UwYRYCFS1NalaztO6BUAvK67YrWez/YBfF+SfwGeqDYRe" +
"WAPfgWERnQrGMLxbD8KwZAKTRjkGJ4XhuB41TbQMqufL9ByXHKSSDpGjaXjeO5VVjYNAvS69UzXNq3bhtQAOXCMEwCgI=");
var_Appearance.Add(2,"CP:1 -2 0 0 0");
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesGeometric;
exgrid1.ShowFocusRect = false;
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x2000000);
exgrid1.set_Background32(exontrol.EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarActive,0x2000001);
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.BackColorHeader = Color.FromArgb(255,255,255);
exgrid1.HeaderHeight = 24;
exgrid1.HeaderVisible = true;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("1st col") as exontrol.EXGRIDLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = false;
var_Column.Filter = "Item B";
var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exFilter;
exgrid1.Columns.Add("2nd col");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Item A");
var_Items.AddItem("Item B");
var_Items.AddItem("Item C");
exgrid1.ApplyFilter();
exgrid1.EndUpdate();
|
|
1220
|
How can I store any extra data associated with a cell
// ButtonClick event - Occurs when user clicks on the cell's button.
private void exgrid1_ButtonClick(object sender, int Item, int ColIndex, object Key)
{
System.Diagnostics.Debug.Print( exgrid1.Items.get_CellData(Item,ColIndex).ToString() );
}
//this.exgrid1.ButtonClick += new exontrol.EXGRIDLib.exg2antt.ButtonClickEventHandler(this.exgrid1_ButtonClick);
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exontrol.EXGRIDLib.Editor var_Editor = (exgrid1.Columns.Add("Def") as exontrol.EXGRIDLib.Column).Editor;
var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.ButtonType;
var_Editor.Locked = true;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_CellData(var_Items.AddItem("Cell 1"),0,"your extra data for cell 1");
var_Items.set_CellData(var_Items.AddItem("Cell 2"),0,"your extra data for cell 2");
exgrid1.EndUpdate();
|
|
1219
|
How can I replace or add an icon at runtime
exgrid1.BeginUpdate();
exgrid1.ReplaceIcon("gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+O" +
"kYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==",null);
exgrid1.ReplaceIcon("C:\\images\\favicon.ico",0);
(exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column).set_Def(exontrol.EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
exgrid1.Items.AddItem("Item <img>1</img>");
exgrid1.EndUpdate();
|
|
1218
|
How can I save the changes, such as column's width, order
// Click event - Occurs when the user presses and then releases the left mouse button over the grid control.
private void exgrid1_Click(object sender)
{
exgrid1.Layout = "Select=\"0\";SingleSort=\"C0:2\";Columns=1";
}
//this.exgrid1.Click += new exontrol.EXGRIDLib.exg2antt.ClickEventHandler(this.exgrid1_Click);
exgrid1.BeginUpdate();
exgrid1.Columns.Add("Column");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Item 1");
var_Items.AddItem("Item 2");
var_Items.AddItem("Item 3");
exgrid1.EndUpdate();
|
|
1217
|
How can I add totals to groups without having to go through the AddGroupItem grid function
exgrid1.FreezeEvents(true);
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.ConditionalFormats var_ConditionalFormats = exgrid1.ConditionalFormats;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CT1",null);
var_ConditionalFormat.ForeColor = Color.FromArgb(128,128,128);
var_ConditionalFormat.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x1;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%CT2",null);
var_ConditionalFormat1.ForeColor = Color.FromArgb(128,128,128);
var_ConditionalFormat1.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x2;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat2 = var_ConditionalFormats.Add("%CT3",null);
var_ConditionalFormat2.ForeColor = Color.FromArgb(128,128,128);
var_ConditionalFormat2.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x3;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("Description");
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as exontrol.EXGRIDLib.Column);
var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column2.ComputedField = "%1 * %2";
var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int r = var_Items.AddItem("Root");
int g1 = var_Items.InsertItem(r,null,"Group 1");
int h = var_Items.InsertItem(g1,null,"Item 1");
var_Items.set_CellValue(h,1,1);
var_Items.set_CellValue(h,2,10);
h = var_Items.InsertItem(g1,null,"Item 2");
var_Items.set_CellValue(h,1,2);
var_Items.set_CellValue(h,2,11);
int g2 = var_Items.InsertItem(r,null,"Group 2");
h = var_Items.InsertItem(g2,null,"Item 1");
var_Items.set_CellValue(h,1,3);
var_Items.set_CellValue(h,2,12);
h = var_Items.InsertItem(g2,null,"Item 2");
var_Items.set_CellValue(h,1,4);
var_Items.set_CellValue(h,2,13);
var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();
exgrid1.FreezeEvents(false);
|
|
1216
|
How can I configure the filters in the text columns to search by content
exgrid1.BeginUpdate();
exgrid1.FilterBarPromptVisible = exontrol.EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.None2;
exgrid1.FilterBarPromptType = exontrol.EXGRIDLib.FilterPromptEnum.exFilterPromptContainsAll;
exgrid1.Columns.Add("Names");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Mantel");
var_Items.AddItem("Mechanik");
var_Items.AddItem("Motor");
var_Items.AddItem("Murks");
var_Items.AddItem("Märchen");
var_Items.AddItem("Möhren");
var_Items.AddItem("Mühle");
var_Items.AddItem("Sérigraphie");
exgrid1.FilterBarPromptPattern = "a";
exgrid1.EndUpdate();
|
|
1215
|
How can I display the control's captions in Spanish
exgrid1.BeginUpdate();
exgrid1.FilterBarPromptVisible = exontrol.EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.None2;
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exFilterBarAll,"(todo) ");
exgrid1.set_Description(exontrol.EXGRIDLib.DescriptionTypeEnum.exFilterBarFilterForCaption,"filtrar por...");
exgrid1.FilterBarPrompt = "<i><fgcolor=808080>iniciar filtro...</fgcolor></i>";
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Names") as exontrol.EXGRIDLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exPattern;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Mantel");
var_Items.AddItem("Mechanik");
var_Items.AddItem("Motor");
var_Items.AddItem("Murks");
var_Items.AddItem("Märchen");
var_Items.AddItem("Möhren");
var_Items.AddItem("Mühle");
var_Items.AddItem("Sérigraphie");
exgrid1.EndUpdate();
|
|
1214
|
How can I zoom in the control
exgrid1.BeginUpdate();
string s1 = 16;
object s2 = exgrid1.FormatABC("2 * value",s1,null,null);
exgrid1.ImageSize = s2;
exgrid1.DefaultItemHeight = s2;
exgrid1.HeaderHeight = s2;
exgrid1.SortBarHeight = s2;
exgrid1.Indent = s2;
exgrid1.Font.Size = s1;
exgrid1.FilterBarFont.Size = s1;
exgrid1.ToolTipFont.Size = s1;
exgrid1.FilterBarPromptVisible = exontrol.EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.None2;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Names") as exontrol.EXGRIDLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exPattern;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.AddItem("Mantel");
var_Items.AddItem("Mechanik");
var_Items.AddItem("Motor");
var_Items.AddItem("Murks");
var_Items.AddItem("Märchen");
var_Items.AddItem("Möhren");
var_Items.AddItem("Mühle");
var_Items.AddItem("Sérigraphie");
exgrid1.EndUpdate();
|
|
1213
|
Can I set a filter that automatically adds a * before and after the word, so the user can just search for 'cat' and it becomes '*cat*' automatically
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("Items") as exontrol.EXGRIDLib.Column);
var_Column.DisplayFilterButton = true;
var_Column.DisplayFilterPattern = true;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exFilterPatternTemplate,"*<%filter%>*");
var_Column.FilterType = exontrol.EXGRIDLib.FilterTypeEnum.exPattern;
var_Column.Filter = "1";
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int h = var_Items.AddItem("Root 1");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("Root 2");
var_Items.InsertItem(h,null,"Child 1");
var_Items.InsertItem(h,null,"Child 2");
exgrid1.ApplyFilter();
exgrid1.EndUpdate();
|
|
1212
|
The fine dotted lines in the control appear much thicker than the standard ones we've been using. How can we fix this
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesGeometric;
exgrid1.ColumnAutoResize = false;
exgrid1.Columns.Add("Column 1");
exgrid1.Columns.Add("Column 2");
exgrid1.Columns.Add("Column 3");
exgrid1.Columns.Add("Column 4");
exgrid1.EndUpdate();
|
|
1211
|
Load data as a tree using a parent-id relationship
exgrid1.BeginUpdate();
exgrid1.ColumnAutoResize = false;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
rs.Open("Select * FROM Employees WHERE 1=0","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.mdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.DataSource = (rs as ADODB.Recordset);
exgrid1.Columns[0].Width = 128;
rs = new ADODB.Recordset();
rs.Open("Employees","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access\\misc.mdb",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0);
exgrid1.PutItems(rs.GetRows(0,null,null),";0;17");
exgrid1.Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();
|
|
1210
|
Is there a way to change the contents of the drop down editor based on a value in another column
// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void exgrid1_AddItem(object sender, int Item)
{
exgrid1.Items.set_CellEditorVisible(Item,0,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorVisible);
exgrid1.Items.set_CellEditorVisible(Item,1,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorVisible);
}
//this.exgrid1.AddItem += new exontrol.EXGRIDLib.exg2antt.AddItemEventHandler(this.exgrid1_AddItem);
// EditOpen event - Occurs when the edit operation starts.
private void exgrid1_EditOpen(object sender)
{
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
object v = var_Items.get_CellValue(var_Items.FocusItem,0);
string c = var_Items.get_CellCaption(var_Items.FocusItem,0);
exontrol.EXGRIDLib.Editor var_Editor = exgrid1.Columns[1].Editor;
var_Editor.ClearItems();
var_Editor.AddItem(v,c.ToString(),null);
}
//this.exgrid1.EditOpen += new exontrol.EXGRIDLib.exg2antt.EditOpenEventHandler(this.exgrid1_EditOpen);
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.GridLineStyle = exontrol.EXGRIDLib.GridLinesStyleEnum.exGridLinesGeometric;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("DropDownList") as exontrol.EXGRIDLib.Column);
exontrol.EXGRIDLib.Editor var_Editor = var_Column.Editor;
var_Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
var_Editor.AddItem(1,"First",null);
var_Editor.AddItem(2,"Second",null);
var_Editor.AddItem(3,"Third",null);
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exAllLines;
(exgrid1.Columns.Add("DropDownList-Related") as exontrol.EXGRIDLib.Column).Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.DropDownListType;
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
var_Items.set_CellValue(var_Items.AddItem(1),1,-1);
var_Items.set_CellValue(var_Items.AddItem(2),1,-1);
var_Items.set_CellValue(var_Items.AddItem(3),1,-1);
var_Items.set_LockedItemCount(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,1);
int h = var_Items.get_LockedItem(exontrol.EXGRIDLib.VAlignmentEnum.exBottom,0);
var_Items.set_ItemDivider(h,0);
var_Items.set_ItemDividerLineAlignment(h,exontrol.EXGRIDLib.DividerAlignmentEnum.DividerTop);
var_Items.set_CellEditorVisible(h,0,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorHidden);
var_Items.set_CellSingleLine(h,0,exontrol.EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap);
var_Items.set_CellValueFormat(h,0,exontrol.EXGRIDLib.ValueFormatEnum.exHTML);
var_Items.set_CellValue(h,0,"The drop down editor in the second column is filled during the <b>EditOpen event</b>, and the values are based on the selection" +
" on the first column.");
exgrid1.EndUpdate();
|
|
1209
|
Highlight the editable fields
// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender, int Item, int ColIndex, ref object NewValue)
{
exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);
exgrid1.FreezeEvents(true);
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.ConditionalFormats var_ConditionalFormats = exgrid1.ConditionalFormats;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CE1",null);
var_ConditionalFormat.Bold = true;
var_ConditionalFormat.BackColor = Color.FromArgb(245,245,245);
var_ConditionalFormat.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x1;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%CE2",null);
var_ConditionalFormat1.Bold = true;
var_ConditionalFormat1.BackColor = Color.FromArgb(245,245,245);
var_ConditionalFormat1.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x2;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat2 = var_ConditionalFormats.Add("%CE3",null);
var_ConditionalFormat2.Bold = true;
var_ConditionalFormat2.BackColor = Color.FromArgb(245,245,245);
var_ConditionalFormat2.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x3;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("Description");
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as exontrol.EXGRIDLib.Column);
var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column2.ComputedField = "%1 * %2";
var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int r = var_Items.AddItem("Root");
int g1 = var_Items.InsertItem(r,null,"Group 1");
int h = var_Items.InsertItem(g1,null,"Item 1");
var_Items.set_CellValue(h,1,1);
var_Items.set_CellValue(h,2,10);
h = var_Items.InsertItem(g1,null,"Item 2");
var_Items.set_CellValue(h,1,2);
var_Items.set_CellValue(h,2,11);
int g2 = var_Items.InsertItem(r,null,"Group 2");
h = var_Items.InsertItem(g2,null,"Item 1");
var_Items.set_CellValue(h,1,3);
var_Items.set_CellValue(h,2,12);
h = var_Items.InsertItem(g2,null,"Item 2");
var_Items.set_CellValue(h,1,4);
var_Items.set_CellValue(h,2,13);
var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();
exgrid1.FreezeEvents(false);
|
|
1208
|
Highlight the total fields
// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender, int Item, int ColIndex, ref object NewValue)
{
exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);
exgrid1.FreezeEvents(true);
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.ConditionalFormats var_ConditionalFormats = exgrid1.ConditionalFormats;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CT1",null);
var_ConditionalFormat.ForeColor = Color.FromArgb(128,128,128);
var_ConditionalFormat.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x1;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%CT2",null);
var_ConditionalFormat1.ForeColor = Color.FromArgb(128,128,128);
var_ConditionalFormat1.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x2;
exontrol.EXGRIDLib.ConditionalFormat var_ConditionalFormat2 = var_ConditionalFormats.Add("%CT3",null);
var_ConditionalFormat2.ForeColor = Color.FromArgb(128,128,128);
var_ConditionalFormat2.ApplyTo = (exontrol.EXGRIDLib.FormatApplyToEnum)0x3;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("Description");
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as exontrol.EXGRIDLib.Column);
var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column2.ComputedField = "%1 * %2";
var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int r = var_Items.AddItem("Root");
int g1 = var_Items.InsertItem(r,null,"Group 1");
int h = var_Items.InsertItem(g1,null,"Item 1");
var_Items.set_CellValue(h,1,1);
var_Items.set_CellValue(h,2,10);
h = var_Items.InsertItem(g1,null,"Item 2");
var_Items.set_CellValue(h,1,2);
var_Items.set_CellValue(h,2,11);
int g2 = var_Items.InsertItem(r,null,"Group 2");
h = var_Items.InsertItem(g2,null,"Item 1");
var_Items.set_CellValue(h,1,3);
var_Items.set_CellValue(h,2,12);
h = var_Items.InsertItem(g2,null,"Item 2");
var_Items.set_CellValue(h,1,4);
var_Items.set_CellValue(h,2,13);
var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();
exgrid1.FreezeEvents(false);
|
|
1207
|
Highlight the leaf items
exgrid1.BeginUpdate();
exgrid1.ConditionalFormats.Add("%CC0=0",null).ForeColor = Color.FromArgb(128,128,128);
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
(var_Columns.Add("Item") as exontrol.EXGRIDLib.Column).Width = 16;
var_Columns.Add("Desc");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int hR = var_Items.AddItem("Root");
var_Items.set_CellValue(hR,1,"The root directory /");
var_Items.set_ExpandItem(hR,true);
int h = var_Items.InsertItem(hR,null,"Home");
var_Items.set_CellValue(h,1,"The home directory with user directories Alice and Bob");
var_Items.InsertItem(h,null,"Alice");
var_Items.InsertItem(h,null,"Bob");
var_Items.set_ExpandItem(h,true);
h = var_Items.InsertItem(hR,null,"Etc");
var_Items.set_CellValue(h,1,"The etc directory with one configuration file");
h = var_Items.InsertItem(h,null,"nginx.conf");
var_Items.set_CellValue(var_Items.InsertItem(hR,null,"Var"),1,"The var directory");
exgrid1.EndUpdate();
|
|
1206
|
Highlight the parent items
exgrid1.BeginUpdate();
exgrid1.ConditionalFormats.Add("%CC0",null).ForeColor = Color.FromArgb(255,0,0);
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
(var_Columns.Add("Item") as exontrol.EXGRIDLib.Column).Width = 16;
var_Columns.Add("Desc");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int hR = var_Items.AddItem("Root");
var_Items.set_CellValue(hR,1,"The root directory /");
var_Items.set_ExpandItem(hR,true);
int h = var_Items.InsertItem(hR,null,"Home");
var_Items.set_CellValue(h,1,"The home directory with user directories Alice and Bob");
var_Items.InsertItem(h,null,"Alice");
var_Items.InsertItem(h,null,"Bob");
var_Items.set_ExpandItem(h,true);
h = var_Items.InsertItem(hR,null,"Etc");
var_Items.set_CellValue(h,1,"The etc directory with one configuration file");
h = var_Items.InsertItem(h,null,"nginx.conf");
var_Items.set_CellValue(var_Items.InsertItem(hR,null,"Var"),1,"The var directory");
exgrid1.EndUpdate();
|
|
1205
|
Highlight the item being expanded or collapsed
exgrid1.BeginUpdate();
exgrid1.ConditionalFormats.Add("%CX0",null).Bold = true;
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
(var_Columns.Add("Item") as exontrol.EXGRIDLib.Column).Width = 16;
var_Columns.Add("Desc");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int hR = var_Items.AddItem("Root");
var_Items.set_CellValue(hR,1,"The root directory /");
var_Items.set_ExpandItem(hR,true);
int h = var_Items.InsertItem(hR,null,"Home");
var_Items.set_CellValue(h,1,"The home directory with user directories Alice and Bob");
var_Items.InsertItem(h,null,"Alice");
var_Items.InsertItem(h,null,"Bob");
var_Items.set_ExpandItem(h,true);
h = var_Items.InsertItem(hR,null,"Etc");
var_Items.set_CellValue(h,1,"The etc directory with one configuration file");
h = var_Items.InsertItem(h,null,"nginx.conf");
var_Items.set_CellValue(var_Items.InsertItem(hR,null,"Var"),1,"The var directory");
exgrid1.EndUpdate();
|
|
1204
|
I am using exTotalColumn. Is there an option to exclude specific cells to display the total
// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender, int Item, int ColIndex, ref object NewValue)
{
exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);
exgrid1.FreezeEvents(true);
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("Description");
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as exontrol.EXGRIDLib.Column);
var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column2.ComputedField = "%1 * %2";
var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int r = var_Items.AddItem("Root");
int g1 = var_Items.InsertItem(r,null,"Group 1");
var_Items.set_FormatCell(g1,2,"`<average missing>`");
var_Items.set_CellEditorVisible(g1,2,exontrol.EXGRIDLib.EditorVisibleEnum.exEditorHidden);
var_Items.set_CellBold(g1,2,true);
var_Items.set_CellForeColor(g1,2,Color.FromArgb(255,0,0));
int h = var_Items.InsertItem(g1,null,"Item 1");
var_Items.set_CellValue(h,1,1);
var_Items.set_CellValue(h,2,10);
h = var_Items.InsertItem(g1,null,"Item 2");
var_Items.set_CellValue(h,1,2);
var_Items.set_CellValue(h,2,11);
int g2 = var_Items.InsertItem(r,null,"Group 2");
h = var_Items.InsertItem(g2,null,"Item 1");
var_Items.set_CellValue(h,1,3);
var_Items.set_CellValue(h,2,12);
h = var_Items.InsertItem(g2,null,"Item 2");
var_Items.set_CellValue(h,1,4);
var_Items.set_CellValue(h,2,13);
var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();
exgrid1.FreezeEvents(false);
|
|
1203
|
How can I add a total column
// Change event - Occurs when the user changes the cell's content.
private void exgrid1_Change(object sender, int Item, int ColIndex, ref object NewValue)
{
exgrid1.Refresh();
}
//this.exgrid1.Change += new exontrol.EXGRIDLib.exg2antt.ChangeEventHandler(this.exgrid1_Change);
exgrid1.FreezeEvents(true);
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.HeaderHeight = 24;
exgrid1.LinesAtRoot = exontrol.EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXGRIDLib.Columns var_Columns = exgrid1.Columns;
var_Columns.Add("Description");
exontrol.EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as exontrol.EXGRIDLib.Column);
var_Column.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
var_Column.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
exontrol.EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as exontrol.EXGRIDLib.Column);
var_Column1.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
var_Column1.Editor.EditType = exontrol.EXGRIDLib.EditTypeEnum.SpinType;
exontrol.EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as exontrol.EXGRIDLib.Column);
var_Column2.ComputedField = "%1 * %2";
var_Column2.set_Def(exontrol.EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
exontrol.EXGRIDLib.Items var_Items = exgrid1.Items;
int r = var_Items.AddItem("Root");
int g1 = var_Items.InsertItem(r,null,"Group 1");
int h = var_Items.InsertItem(g1,null,"Item 1");
var_Items.set_CellValue(h,1,1);
var_Items.set_CellValue(h,2,10);
h = var_Items.InsertItem(g1,null,"Item 2");
var_Items.set_CellValue(h,1,2);
var_Items.set_CellValue(h,2,11);
int g2 = var_Items.InsertItem(r,null,"Group 2");
h = var_Items.InsertItem(g2,null,"Item 1");
var_Items.set_CellValue(h,1,3);
var_Items.set_CellValue(h,2,12);
h = var_Items.InsertItem(g2,null,"Item 2");
var_Items.set_CellValue(h,1,4);
var_Items.set_CellValue(h,2,13);
var_Items.set_ExpandItem(0,true);
exgrid1.EndUpdate();
exgrid1.FreezeEvents(false);
|
|
1202
|
Is it possible to disable sizing(size) the column
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
exontrol.EXGRIDLib.Column var_Column = (exgrid1.Columns.Add("32px") as exontrol.EXGRIDLib.Column);
var_Column.Width = 32;
var_Column.AllowSizing = false;
exgrid1.Columns.Add("Rest");
exgrid1.ColumnAutoResize = true;
exgrid1.EndUpdate();
|
|
1201
|
How can I add two columns of 25% and the third of 50%
exgrid1.BeginUpdate();
exgrid1.HeaderAppearance = exontrol.EXGRIDLib.AppearanceEnum.Etched;
exgrid1.DrawGridLines = exontrol.EXGRIDLib.GridLinesEnum.exVLines;
(exgrid1.Columns.Add("25%") as exontrol.EXGRIDLib.Column).Width = 25;
(exgrid1.Columns.Add("25%") as exontrol.EXGRIDLib.Column).Width = 25;
(exgrid1.Columns.Add("50%") as exontrol.EXGRIDLib.Column).Width = 50;
exgrid1.ColumnAutoResize = true;
exgrid1.EndUpdate();
|