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 axGrid1_Changed(object sender, AxEXGRIDLib._IGridEvents_ChangedEvent e)
{
	System.Diagnostics.Debug.Print( axGrid1.Items.get_CellValue(e.item,e.colIndex).ToString() );
}
//this.axGrid1.Changed += new AxEXGRIDLib._IGridEvents_ChangedEventHandler(this.axGrid1_Changed);

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Edit") as EXGRIDLib.Column).Editor.EditType = EXGRIDLib.EditTypeEnum.EditType;
axGrid1.Items.AddItem("Item 1");
axGrid1.Items.AddItem("Item 2");
axGrid1.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 axGrid1_AnchorClick(object sender, AxEXGRIDLib._IGridEvents_AnchorClickEvent e)
{
	object i = axGrid1.FormatABC("int(value)",e.anchorID,null,null);
	EXGRIDLib.Items var_Items = axGrid1.Items;
		i = var_Items[i];
		bool exp = var_Items.get_ExpandItem(i);
		var_Items.set_ExpandItem(i,false);
}
//this.axGrid1.AnchorClick += new AxEXGRIDLib._IGridEvents_AnchorClickEventHandler(this.axGrid1_AnchorClick);

axGrid1.BeginUpdate();
axGrid1.set_HTMLPicture("expand","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiIYOhFLB0KZvMx0O5hORlABQM" +
	"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyxgjsRzEKv1TqtXrNbrtfsIAwgASAH" +
	"AGShQwGQzGABUGEzudAqgyWdSmWw2Fw+sABSHI4AGH1XAGAxGAwywlI6eRqjGi1YuaJJEIJUHBPYqSJYKQAwCBDKbBPbncBibrUKQjGLFQo+TBFfR5GaUAR/KbGICyRx" +
	"siCOQClgdJxGoMpkGycpdDqUZ0EoJQJHYVoWCSCA4kEbRlHKRwJiYcYCH0PBNB2JwYCaCRsGcE8LDyfZKg+U59EsAZMlQCgJkcEA9CsywkiKJwiFcIQwEEgI=");
axGrid1.set_HTMLPicture("collapse","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYU7YQBCooJSAiIYOhFLB0KZvMx0O5hORlABQM" +
	"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzyO13dGEAGYzWcqlWrFarlesA3AGc" +
	"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWISpVLiXT5MrxiJyJJEIJUHBPYqSXYOQAgBgAB6jJwufxxX7YYhdYhFCSsSwSC4uMLoQajNJ" +
	"AG8QgZAgSIqGMCwRBkAJDicGwuiMeoHGeaRFlAU5qDwQQ6A+CYnlgPQeisGJfl4AJYhsRISjQYwJHIcpmmALAtlMEpkE4YBREmEpPBAARdicSw8AES5fi+fI5g+PpcAA" +
	"UJKgyCYknaZRrssJIiicIhXCEMBBICA==");
axGrid1.set_HTMLPicture("empty","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYE7YABNTWRIJiIYOhFLB0KZvMx0O5hORlABQM" +
	"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyy/O13dGEAGYzWcqlWrFarlesA3AGc" +
	"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWYSvDpndpkQ9xhRTJJEIJUHBPdqSGIKYAwBgDUpCfytH57FqoVaTKQTGS0DJ6cDBDzOGwIfA" +
	"NHMIxJDmf5CFIAxwA4Q5HEQVJlEWRxnBkMANjsPoqBSEAElkfZ5CMFJMHCC52BALBGjkDpHCuXIAB2bQdEGaQgFIbbLCSIonCIVwhDAQSAg==");
axGrid1.HeaderVisible = false;
axGrid1.HasLines = EXGRIDLib.HierarchyLineEnum.exNoLine;
axGrid1.HasButtons = EXGRIDLib.ExpandButtonEnum.exNoButtons;
axGrid1.Indent = 12;
axGrid1.DefaultItemHeight = 24;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exHLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
axGrid1.GridLineColor = Color.FromArgb(204,204,204);
axGrid1.ShowFocusRect = false;
axGrid1.ExpandOnDblClick = false;
axGrid1.ExpandOnKeys = false;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Item") as EXGRIDLib.Column);
		var_Column.set_Def(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";
		EXGRIDLib.Editor var_Editor = var_Column.Editor;
			var_Editor.EditType = EXGRIDLib.EditTypeEnum.EditType;
			var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exEditorAdjustPos,"32 4 -4 -4");
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.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 axGrid1_AnchorClick(object sender, AxEXGRIDLib._IGridEvents_AnchorClickEvent e)
{
	object i = axGrid1.FormatABC("int(value)",e.anchorID,null,null);
	EXGRIDLib.Items var_Items = axGrid1.Items;
		i = var_Items[i];
		bool exp = var_Items.get_ExpandItem(i);
		var_Items.set_ExpandItem(i,false);
}
//this.axGrid1.AnchorClick += new AxEXGRIDLib._IGridEvents_AnchorClickEventHandler(this.axGrid1_AnchorClick);

axGrid1.BeginUpdate();
axGrid1.set_HTMLPicture("expand","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYc7YYBY5vVBkiIYOhFLB0KZvMx0O5hORlABQM" +
	"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyxgjsRzEKv1TqtXrNbrtfsIAwgASAH" +
	"AGShQwGQzGABUGEzudAqgyWdSmWw2Fw+sABSHI4AGH1XAGAxGAwywlI6eRqjGi1YuaJJEIJUHBPYqSJYKQAwCBDKbBPbncBibrUKQjGLFQo+TBFfR5GaUAR/KbGICyRx" +
	"siCOQClgdJxGoMpkGycpdDqUZ0EoJQJHYVoWCSCA4kEbRlHKRwJiYcYCH0PBNB2JwYCaCRsGcE8LDyfZKg+U59EsAZMlQCgJkcEA9CsywkiKJwiFcIQwEEgI=");
axGrid1.set_HTMLPicture("collapse","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYU7YQBCooJSAiIYOhFLB0KZvMx0O5hORlABQM" +
	"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzyO13dGEAGYzWcqlWrFarlesA3AGc" +
	"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWISpVLiXT5MrxiJyJJEIJUHBPYqSXYOQAgBgAB6jJwufxxX7YYhdYhFCSsSwSC4uMLoQajNJ" +
	"AG8QgZAgSIqGMCwRBkAJDicGwuiMeoHGeaRFlAU5qDwQQ6A+CYnlgPQeisGJfl4AJYhsRISjQYwJHIcpmmALAtlMEpkE4YBREmEpPBAARdicSw8AES5fi+fI5g+PpcAA" +
	"UJKgyCYknaZRrssJIiicIhXCEMBBICA==");
axGrid1.HeaderVisible = false;
axGrid1.HasLines = EXGRIDLib.HierarchyLineEnum.exNoLine;
axGrid1.HasButtons = EXGRIDLib.ExpandButtonEnum.exNoButtons;
axGrid1.Indent = 12;
axGrid1.DefaultItemHeight = 24;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exHLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
axGrid1.GridLineColor = Color.FromArgb(204,204,204);
axGrid1.ShowFocusRect = false;
axGrid1.ExpandOnDblClick = false;
axGrid1.ExpandOnKeys = false;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Item") as EXGRIDLib.Column);
		var_Column.set_Def(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";
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1252
Expandable bullet list

// AnchorClick event - Occurs when an anchor element is clicked.
private void axGrid1_AnchorClick(object sender, AxEXGRIDLib._IGridEvents_AnchorClickEvent e)
{
	object i = axGrid1.FormatABC("int(value)",e.anchorID,null,null);
	EXGRIDLib.Items var_Items = axGrid1.Items;
		i = var_Items[i];
		bool exp = var_Items.get_ExpandItem(i);
		var_Items.set_ExpandItem(i,false);
}
//this.axGrid1.AnchorClick += new AxEXGRIDLib._IGridEvents_AnchorClickEventHandler(this.axGrid1_AnchorClick);

axGrid1.BeginUpdate();
axGrid1.set_HTMLPicture("expand","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYM7YIBXCRNbtiIYOhFLB0KZvMx0O5hORlABQM" +
	"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzZO13dGEAGYzWcqlWrFarlesA3AGc" +
	"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWNa6awbST7DBTiLyJJEIJUHBPUqSGJuYYwCAES5pBiQfyEX4QKAFH6QSihJQ/GZlET1FhIcg" +
	"GnUdoVHMmxajSIghlMKhsGiAAFggQ5dmKcRHEUEhbFAFQBgacABmAAJgAAcAJkAZgNjUcwDFecYcD8QoIDsGJjD6aYaGyHI7mqLRfgGfBcg+TYggkEhakQThtFsEpAE2" +
	"Xh7goSIJiSHp6haKgPGOXx3j+c5hiKLpri6JAPHWYJREuFJkBCYxcFeYS7ikJQzG0ZIVGKMBYGsVwXDWVQHjqfpjAoYpyE4Z5vH2YoHDkZwzkkUxHC8pwCgifIHBCdk4" +
	"GMLQVmcXJVhicxWi4IIUiKSQ1A8cBUj+eBEGCFQlFSIophiPRkFAWBLFALhwm+HhKjARpmgSGwNn4AIUCcZZUFEKoVmwywkiKJwiFcIQwEEgI");
axGrid1.set_HTMLPicture("collapse","gCJKBOI4NBQaBQAhQNJJIIhShQACERCAIA0RD7zf5hiIBOZSI5CACuZwcdMRAhnIJNIMKWKPBb8MIFiIJOBILJzhQOYM7YIBXCRNbtiIYOhFLB0KZvMx0O5hORlABQM" +
	"JpNx0FxOIpUEA1FwxFw3RbWe45iK2MpYJJmJJJFQABERmgaAM0AMRJURDd1AF3hUQhQoAIDvsRAURGIBw8ThRaiJpQ4EwsKNURyzZO13dGEAGYzWcqlWrFarlesA3AGc" +
	"SAHAGShQwGQzGABUGEv2TAAFUGS26Uy2GwuH1wAKQ5HAAw+s4YwGIwGGWNa6awbST7DBTiLZJJEIJUHBPdpSGKOAQxCAzGhIBKfbAvUBsSIPbiVMhLTxJPK3banJB0N5" +
	"sA8VQRlmCRKjSCRaAIOgCiORISiWaI0DYLJPBYJBxB+LAqAMBRgAsIABjAAhYAOEB5kKDQ5kGZoaCaL5vH2KoEDCbpbDaWRrE8SopE+AA/DcMoZkgAgkhKERDlcdYEHA" +
	"JRzg4IpyCAKRyl6HZLGONwMEMb5clwWB3n2CZki6FoWC4cwQCbGYukKwhiAwOp3HIEJFGCNBGDyLArE8R56n4RUnlOShHGcXJdgcKQlCOSRdEcLw8DmAoInyexvFeMRG" +
	"G0DARmsbRZmsfRxleFZeHoD4eEKKRxGmPANgAC5xDAWpYHMW4uCGywkiKJwiFcIQwEEgI");
axGrid1.HeaderVisible = false;
axGrid1.HasLines = EXGRIDLib.HierarchyLineEnum.exNoLine;
axGrid1.HasButtons = EXGRIDLib.ExpandButtonEnum.exNoButtons;
axGrid1.Indent = 12;
axGrid1.DefaultItemHeight = 24;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exHLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
axGrid1.GridLineColor = Color.FromArgb(204,204,204);
axGrid1.ShowFocusRect = false;
axGrid1.ExpandOnDblClick = false;
axGrid1.ExpandOnKeys = false;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Item") as EXGRIDLib.Column);
		var_Column.set_Def(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";
		EXGRIDLib.Editor var_Editor = var_Column.Editor;
			var_Editor.EditType = EXGRIDLib.EditTypeEnum.EditType;
			var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exEditorAdjustPos,"32D 4D -4D -4D");
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1251
Does grouping support multi-column sorting

axGrid1.BeginUpdate();
axGrid1.SingleSort = false;
axGrid1.HeaderVisible = false;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
axGrid1.AllowGroupBy = true;
axGrid1.Columns.Add("Prefix");
axGrid1.Columns.Add("Region");
axGrid1.Columns.Add("City");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Sort") as EXGRIDLib.Column);
	var_Column.ComputedField = "%1 + %2";
	var_Column.Visible = false;
EXGRIDLib.Items var_Items = axGrid1.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 ");
axGrid1.Layout = "multiplesort=\"C0:2\";singlesort=\"C3:1\";";
axGrid1.EndUpdate();
1250
How can I vertically scroll the control
axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// Add 'Microsoft Office 15.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project.
axGrid1.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);
axGrid1.Layout = "Collapse=\"\";VScroll=10";
axGrid1.EndUpdate();
1249
Export the items as a two-dimensional array

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.PutItems(axGrid1.Export("array","all"),null);
axGrid1.EndUpdate();
1248
Export only expanded items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(expanded)").ToString() );
1247
Export only selectable, sortable leaf items that are neither locked nor dividers

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(leaf,sortable,selectable,!divider,!locked)").ToString() );
1246
Export only non-divider items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(!divider)").ToString() );
1245
Export only selectable items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(selectable)").ToString() );
1244
Export only sortable, but not locked items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(sortable,!locked)").ToString() );
1243
Export only checked items on specified column

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(checked[0])").ToString() );
1242
Export only filtered, not locked or divider items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(visible,!locked,!divider)").ToString() );
1241
Export only selected items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(selected)").ToString() );
1240
Export only locked items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","only(locked)").ToString() );
1239
Export the leaf items of the control, excluding parent or grouped items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.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)

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","chk").ToString() );
1237
Export the selected-items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.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

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","vis").ToString() );
1235
Export all items, including the hidden or collapsed items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ScrollBySingleLine = true;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesOutside;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Desc") as EXGRIDLib.Column);
		var_Column.Width = 32;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
		var_Column1.FormatColumn = "currency(value)";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	int h = var_Items.get_LockedItem(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,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);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","all").ToString() );
1234
Bolds only the expanded items

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.ConditionalFormats.Add("%CX0",null).Bold = true;
axGrid1.Columns.Add("Description");
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1233
Displays the root item's index and value/caption using expressions

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.AutoDrag = EXGRIDLib.AutoDragEnum.exAutoDragPositionAny;
axGrid1.AllowCopyPaste = EXGRIDLib.AllowCopyPasteEnum.exAllowPaste | EXGRIDLib.AllowCopyPasteEnum.exAllowCut | EXGRIDLib.AllowCopyPasteEnum.exAllowCopy;
axGrid1.SingleSel = false;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
axGrid1.GridLineColor = Color.FromArgb(208,208,208);
axGrid1.ConditionalFormats.Add("%CC0 and %CX0",null).Bold = true;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("1",null);
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x2;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Description") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Index") as EXGRIDLib.Column);
	var_Column1.FormatColumn = "1 index ``";
	var_Column1.Position = 0;
	var_Column1.Width = 16;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Root-Index") as EXGRIDLib.Column);
	var_Column2.FormatColumn = "root(1 index ``)";
	var_Column2.Position = 1;
	var_Column2.Width = 32;
	var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Root-Value") as EXGRIDLib.Column);
	var_Column3.FormatColumn = "root(%0)";
	var_Column3.Position = 2;
	var_Column3.Width = 32;
	var_Column3.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.EndUpdate();
1232
Displays the parent item's index and caption/value using expressions

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.AutoDrag = EXGRIDLib.AutoDragEnum.exAutoDragPositionAny;
axGrid1.AllowCopyPaste = EXGRIDLib.AllowCopyPasteEnum.exAllowPaste | EXGRIDLib.AllowCopyPasteEnum.exAllowCut | EXGRIDLib.AllowCopyPasteEnum.exAllowCopy;
axGrid1.SingleSel = false;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
axGrid1.GridLineColor = Color.FromArgb(208,208,208);
axGrid1.ConditionalFormats.Add("%CC0 and %CX0",null).Bold = true;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("1",null);
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x2;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Description") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Index") as EXGRIDLib.Column);
	var_Column1.FormatColumn = "1 index `I`";
	var_Column1.Position = 0;
	var_Column1.Width = 16;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Parent-Index") as EXGRIDLib.Column);
	var_Column2.FormatColumn = "parent(1 index `I`)";
	var_Column2.Position = 1;
	var_Column2.Width = 32;
	var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Parent-Value") as EXGRIDLib.Column);
	var_Column3.FormatColumn = "parent(%0)";
	var_Column3.Position = 2;
	var_Column3.Width = 32;
	var_Column3.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.EndUpdate();
1231
Copying and Pasting the Selection Programmatically
axGrid1.BeginUpdate();
axGrid1.Columns.Add("Tasks");
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.SingleSel = false;
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.IndentSelection(false);
axGrid1.CopySelection();
axGrid1.Items.UnselectAll();
axGrid1.Paste(null);
axGrid1.EndUpdate();
1230
Enable Copy, Cut and Paste Clipboard operations
axGrid1.BeginUpdate();
axGrid1.Columns.Add("Tasks");
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.AllowCopyPaste = EXGRIDLib.AllowCopyPasteEnum.exAllowPaste | EXGRIDLib.AllowCopyPasteEnum.exAllowCut | EXGRIDLib.AllowCopyPasteEnum.exAllowCopy;
axGrid1.SingleSel = false;
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.IndentSelection(false);
axGrid1.EndUpdate();
1229
Adjusts the hierarchy of selected items by changing their parent

axGrid1.BeginUpdate();
axGrid1.Columns.Add("Tasks");
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.SingleSel = false;
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.IndentSelection(false);
axGrid1.EndUpdate();
1228
Specify the size of the Columns panel

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("City");
	(var_Columns.Add("Start") as EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("End") as EXGRIDLib.Column).Visible = false;
axGrid1.ColumnsFloatBarRect = ",,96";
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
axGrid1.EndUpdate();
1227
Show a vertical line between pivot and Columns panel (EBN color)

axGrid1.BeginUpdate();
axGrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABRsIQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFICQTIcBhaGIZRiAKCRTDmHwyRCNIwCLD8QxtDqBY4gOZZX" +
	"hal4cJTgMaBYi+Pw3DZHcbvBRkewzHQAKgnSjoDhEMg1CTVVYTDKdOSzDyEX7sIAACpOIZQVJVEY1VT8cyxIyEZimSypWqiYJ0Ty6cQwTAIgI");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,0x1000000);
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("City");
	(var_Columns.Add("Start") as EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("End") as EXGRIDLib.Column).Visible = false;
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
axGrid1.EndUpdate();
1226
Change the background of the Columns panel (EBN color)

axGrid1.BeginUpdate();
axGrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzT" +
	"J0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSN" +
	"AgqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPp" +
	"TlWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+" +
	"BZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJl" +
	"EkVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd" +
	"4kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLB" +
	"qOIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,0x1000000);
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("City");
	(var_Columns.Add("Start") as EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("End") as EXGRIDLib.Column).Visible = false;
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
axGrid1.EndUpdate();
1225
Change the background of the Columns panel (solid color)

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("City");
	(var_Columns.Add("Start") as EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("End") as EXGRIDLib.Column).Visible = false;
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleAsChild | EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exColumnsFloatBackColor,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
axGrid1.EndUpdate();
1224
Change the visual appearance of the Columns panel

axGrid1.BeginUpdate();
axGrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhABNoCg6AADACAxRDAMgBQKAAzQFAYahqGKGAAGOD4JhUAIIRZGMIjFDcEwxC6NIpAWLoJDCH4mSTHYxgJIMWwzDiBZgkCA4fiGEYnThCIxzT" +
	"J0aw1CKbYRAKCUKoUAJFsSnQAJIgOO4lULPMIhDDQKQTIKBahoehqIhaEQyDSJNb2DCIahhMSEbKtCooDhGFZUWzLVxTJJNawHJqJJDuOTpSjKH4+RjWFKUXR9b4BJSN" +
	"AgqeCQTiSWZEVxRUS0XbGCyZLSQY7uAAMKgOVoDYzdGLwHTtOwrMa1QAsDSbKqWZ5uRpHcQ5aAGN5DPbMbqwOaqLznAaLQLtG4RTikVRPTDYaj437+OaHGyNbI6HTNPp" +
	"TlWDJWjYXI8l8C4fg6GYAAEEISgGJJGHQOocgyIwYnqKhYAAIQTH2MYRjQJBRAmZptmEAYIjGU5dk8UgOFgBJUgCTQIBYBoBmCCAmAqApghgDJUDmYQFCCZoEk2OBUm+" +
	"BZPCgZgagaYZIHYHoHmGWBcm8NwiEiFJVgmYgji4Kg6GKSI2C6C5jAiRgygwIojiycINkyeJmAYPJjkiTg+g+ZAIkCdIQkyWQWDuDxkBkJhKguZAzlIRQzGQc5ODWFJl" +
	"EkVhWhWZYJFYTYTmUE4yF6F5mAmBhihiZhJhYX4WmQaAUnWGpOlmNhuhuZwJkYcocmcSY4naHZlkmKhrDuJ5JnYfofmgCgGgKIJnlmXJ2h4TQKBosRokoNoOiOaQKDSd" +
	"4kmiChMncPBpgoZoaiaaZKHaHonmmE5iiKJRpDicomimaoKiaKoqmqSoeiIPgogqPotiyaxKlYPA+GuCqbBMa5KnaPovmwCwGj6LgP24RIhiyCwmkqMpsksNpKD6LQLB" +
	"qOIzi0SxWlaHZtAOahPssM5Wi+IYtlsXpijKbZ5lyTo5mAE4UlqOpjHOQpEjubyanKPJvEuNgVj2TY1CCao+k2G52AyP5wAwBp9DYZZ1CCaxsAABAEICA");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exColumnsFloatAppearance,0x1000000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exColumnsFloatCaptionBackColor,(uint)ColorTranslator.ToWin32(Color.FromArgb(246,246,246)));
(axGrid1.GetOcx() as EXGRIDLib.Grid).BackColorHeader = 0x1000000;
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("City");
	(var_Columns.Add("Start") as EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("End") as EXGRIDLib.Column).Visible = false;
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exColumnsFloatBar,"Show/Hide");
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
axGrid1.EndUpdate();
1223
Defines the symbol used to indicate repeated captions, providing a clear visual cue for identical entries (ditto mark)

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
(axGrid1.Columns.Add("Country") as EXGRIDLib.Column).ShowIdem = "<fgcolor gray>〃";
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1222
Defines the symbol used to indicate repeated captions, providing a clear visual cue for identical entries (space)

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
(axGrid1.Columns.Add("Country") as EXGRIDLib.Column).ShowIdem = " ";
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1221
Displays a glitch funnel for drop-down filter buttons (empty or active)

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.RenderType = -1;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABa8IQAAYAQGKIYBkAKBQAGaAoDDUNQxQwAAxwfBMKgBBCLIxhEYobgmGIXRpFMbxCKQahLEiTIhGUYJHgmK4tRiAUgxVDkBxrECZYqjcBZO" +
	"iwLQ2TxDM7DNKUCBnIoABhGOaYDh+IQNQjUFKwTRFGRxK4EIRKAyTDLQdRyGSMMbjdQpBCbMiMRqhESKRq2UwYRYCFS1NalaztO6BUAvK67YrWez/YBfF+SfwGeqDYRe" +
	"WAPfgWERnQrGMLxbD8KwZAKTRjkGJ4XhuB41TbQMqufL9ByXHKSSDpGjaXjeO5VVjYNAvS69UzXNq3bhtQAOXCMEwCgI=");
	var_Appearance.Add(2,"CP:1 -2 0 0 0");
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesGeometric;
axGrid1.ShowFocusRect = false;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x2000000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarActive,0x2000001);
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.BackColorHeader = Color.FromArgb(255,255,255);
axGrid1.HeaderHeight = 24;
axGrid1.HeaderVisible = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("1st col") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.Filter = "Item B";
	var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
axGrid1.Columns.Add("2nd col");
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.ApplyFilter();
axGrid1.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 axGrid1_ButtonClick(object sender, AxEXGRIDLib._IGridEvents_ButtonClickEvent e)
{
	System.Diagnostics.Debug.Print( axGrid1.Items.get_CellData(e.item,e.colIndex).ToString() );
}
//this.axGrid1.ButtonClick += new AxEXGRIDLib._IGridEvents_ButtonClickEventHandler(this.axGrid1_ButtonClick);

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Editor var_Editor = (axGrid1.Columns.Add("Def") as EXGRIDLib.Column).Editor;
	var_Editor.EditType = EXGRIDLib.EditTypeEnum.ButtonType;
	var_Editor.Locked = true;
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1219
How can I replace or add an icon at runtime

axGrid1.BeginUpdate();
axGrid1.ReplaceIcon("gAAAABgYACEHgUJFEEAAWhUJCEJEEJggEhMCYEXjUbjkJQECj8gj8hAEjkshYEpk8kf8ClsulsvAExmcvf83js5nU7nkCeEcn8boMaocXosCB9Hn09pkzcEuoL/fE+O" +
	"kYB0gB9YhIHrddgVcr9aktZADAD8+P8CgIA==",null);
axGrid1.ReplaceIcon("C:\\images\\favicon.ico",0);
(axGrid1.Columns.Add("Items") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
axGrid1.Items.AddItem("Item <img>1</img>");
axGrid1.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 axGrid1_ClickEvent(object sender, EventArgs e)
{
	axGrid1.Layout = "Select=\"0\";SingleSort=\"C0:2\";Columns=1";
}
//this.axGrid1.ClickEvent += new EventHandler(this.axGrid1_ClickEvent);

axGrid1.BeginUpdate();
axGrid1.Columns.Add("Column");
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
axGrid1.EndUpdate();
1217
How can I add totals to groups without having to go through the AddGroupItem grid function

axGrid1.FreezeEvents(true);
axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.ConditionalFormats var_ConditionalFormats = axGrid1.ConditionalFormats;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CT1",null);
		var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128));
		var_ConditionalFormat.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x1;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%CT2",null);
		var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128));
		var_ConditionalFormat1.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x2;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat2 = var_ConditionalFormats.Add("%CT3",null);
		var_ConditionalFormat2.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128));
		var_ConditionalFormat2.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x3;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("Description");
	EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as EXGRIDLib.Column);
		var_Column.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
		var_Column1.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column2.ComputedField = "%1 * %2";
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.EndUpdate();
axGrid1.FreezeEvents(false);
1216
How can I configure the filters in the text columns to search by content

axGrid1.BeginUpdate();
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.None2;
axGrid1.FilterBarPromptType = EXGRIDLib.FilterPromptEnum.exFilterPromptContainsAll;
axGrid1.Columns.Add("Names");
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.FilterBarPromptPattern = "a";
axGrid1.EndUpdate();
1215
How can I display the control's captions in Spanish

axGrid1.BeginUpdate();
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.None2;
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAll,"(todo) ");
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarFilterForCaption,"filtrar por...");
axGrid1.FilterBarPrompt = "<i><fgcolor=808080>iniciar filtro...</fgcolor></i>";
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Names") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exPattern;
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1214
How can I zoom in the control

axGrid1.BeginUpdate();
string s1 = 16;
object s2 = axGrid1.FormatABC("2 * value",s1,null,null);
axGrid1.ImageSize = s2;
axGrid1.DefaultItemHeight = s2;
axGrid1.HeaderHeight = s2;
axGrid1.SortBarHeight = s2;
axGrid1.Indent = s2;
axGrid1.Font.Size = s1;
axGrid1.FilterBarFont.Size = s1;
axGrid1.ToolTipFont.Size = s1;
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.None2;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Names") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exPattern;
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.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

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Items") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exFilterPatternTemplate,"*<%filter%>*");
	var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exPattern;
	var_Column.Filter = "1";
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.ApplyFilter();
axGrid1.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

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesGeometric;
axGrid1.ColumnAutoResize = false;
axGrid1.Columns.Add("Column 1");
axGrid1.Columns.Add("Column 2");
axGrid1.Columns.Add("Column 3");
axGrid1.Columns.Add("Column 4");
axGrid1.EndUpdate();
1211
Load data as a tree using a parent-id relationship

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exVLines;
axGrid1.LinesAtRoot = 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",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.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",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.PutItems(rs.GetRows(0,null,null),";0;17");
axGrid1.Items.set_ExpandItem(0,true);
axGrid1.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 axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	axGrid1.Items.set_CellEditorVisible(e.item,0,EXGRIDLib.EditorVisibleEnum.exEditorVisible);
	axGrid1.Items.set_CellEditorVisible(e.item,1,EXGRIDLib.EditorVisibleEnum.exEditorVisible);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

// EditOpen event - Occurs when the edit operation starts.
private void axGrid1_EditOpen(object sender, EventArgs e)
{
	EXGRIDLib.Items var_Items = axGrid1.Items;
		object v = var_Items.get_CellValue(var_Items.FocusItem,0);
		string c = var_Items.get_CellCaption(var_Items.FocusItem,0);
	EXGRIDLib.Editor var_Editor = axGrid1.Columns[1].Editor;
		var_Editor.ClearItems();
		var_Editor.AddItem(v,c.ToString(),null);
}
//this.axGrid1.EditOpen += new EventHandler(this.axGrid1_EditOpen);

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesGeometric;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("DropDownList") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.DropDownListType;
		var_Editor.AddItem(1,"First",null);
		var_Editor.AddItem(2,"Second",null);
		var_Editor.AddItem(3,"Third",null);
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines;
(axGrid1.Columns.Add("DropDownList-Related") as EXGRIDLib.Column).Editor.EditType = EXGRIDLib.EditTypeEnum.DropDownListType;
EXGRIDLib.Items var_Items = axGrid1.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(EXGRIDLib.VAlignmentEnum.exBottom,1);
	int h = var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,EXGRIDLib.DividerAlignmentEnum.DividerTop);
	var_Items.set_CellEditorVisible(h,0,EXGRIDLib.EditorVisibleEnum.exEditorHidden);
	var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap);
	var_Items.set_CellValueFormat(h,0,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.");
axGrid1.EndUpdate();
1209
Highlight the editable fields

// Change event - Occurs when the user changes the cell's content.
private void axGrid1_Change(object sender, AxEXGRIDLib._IGridEvents_ChangeEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.Change += new AxEXGRIDLib._IGridEvents_ChangeEventHandler(this.axGrid1_Change);

axGrid1.FreezeEvents(true);
axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.ConditionalFormats var_ConditionalFormats = axGrid1.ConditionalFormats;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CE1",null);
		var_ConditionalFormat.Bold = true;
		var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(245,245,245));
		var_ConditionalFormat.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x1;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%CE2",null);
		var_ConditionalFormat1.Bold = true;
		var_ConditionalFormat1.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(245,245,245));
		var_ConditionalFormat1.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x2;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat2 = var_ConditionalFormats.Add("%CE3",null);
		var_ConditionalFormat2.Bold = true;
		var_ConditionalFormat2.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(245,245,245));
		var_ConditionalFormat2.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x3;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("Description");
	EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as EXGRIDLib.Column);
		var_Column.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
		var_Column1.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column2.ComputedField = "%1 * %2";
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.EndUpdate();
axGrid1.FreezeEvents(false);
1208
Highlight the total fields

// Change event - Occurs when the user changes the cell's content.
private void axGrid1_Change(object sender, AxEXGRIDLib._IGridEvents_ChangeEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.Change += new AxEXGRIDLib._IGridEvents_ChangeEventHandler(this.axGrid1_Change);

axGrid1.FreezeEvents(true);
axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.ConditionalFormats var_ConditionalFormats = axGrid1.ConditionalFormats;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%CT1",null);
		var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128));
		var_ConditionalFormat.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x1;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%CT2",null);
		var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128));
		var_ConditionalFormat1.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x2;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat2 = var_ConditionalFormats.Add("%CT3",null);
		var_ConditionalFormat2.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128));
		var_ConditionalFormat2.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x3;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("Description");
	EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as EXGRIDLib.Column);
		var_Column.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
		var_Column1.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column2.ComputedField = "%1 * %2";
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.EndUpdate();
axGrid1.FreezeEvents(false);
1207
Highlight the leaf items

axGrid1.BeginUpdate();
axGrid1.ConditionalFormats.Add("%CC0=0",null).ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128));
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	(var_Columns.Add("Item") as EXGRIDLib.Column).Width = 16;
	var_Columns.Add("Desc");
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1206
Highlight the parent items

axGrid1.BeginUpdate();
axGrid1.ConditionalFormats.Add("%CC0",null).ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	(var_Columns.Add("Item") as EXGRIDLib.Column).Width = 16;
	var_Columns.Add("Desc");
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.EndUpdate();
1205
Highlight the item being expanded or collapsed

axGrid1.BeginUpdate();
axGrid1.ConditionalFormats.Add("%CX0",null).Bold = true;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	(var_Columns.Add("Item") as EXGRIDLib.Column).Width = 16;
	var_Columns.Add("Desc");
EXGRIDLib.Items var_Items = axGrid1.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");
axGrid1.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 axGrid1_Change(object sender, AxEXGRIDLib._IGridEvents_ChangeEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.Change += new AxEXGRIDLib._IGridEvents_ChangeEventHandler(this.axGrid1_Change);

axGrid1.FreezeEvents(true);
axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("Description");
	EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as EXGRIDLib.Column);
		var_Column.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
		var_Column1.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column2.ComputedField = "%1 * %2";
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
EXGRIDLib.Items var_Items = axGrid1.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,EXGRIDLib.EditorVisibleEnum.exEditorHidden);
	var_Items.set_CellBold(g1,2,true);
	var_Items.set_CellForeColor(g1,2,(uint)ColorTranslator.ToWin32(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);
axGrid1.EndUpdate();
axGrid1.FreezeEvents(false);
1203
How can I add a total column

// Change event - Occurs when the user changes the cell's content.
private void axGrid1_Change(object sender, AxEXGRIDLib._IGridEvents_ChangeEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.Change += new AxEXGRIDLib._IGridEvents_ChangeEventHandler(this.axGrid1_Change);

axGrid1.FreezeEvents(true);
axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.HeaderHeight = 24;
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("Description");
	EXGRIDLib.Column var_Column = (var_Columns.Add("Qty") as EXGRIDLib.Column);
		var_Column.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%1)");
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Price") as EXGRIDLib.Column);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"avg(current,rec,%2)");
		var_Column1.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Amount") as EXGRIDLib.Column);
		var_Column2.ComputedField = "%1 * %2";
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exTotalColumn,"sum(current,rec,%3)");
EXGRIDLib.Items var_Items = axGrid1.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);
axGrid1.EndUpdate();
axGrid1.FreezeEvents(false);
1202
Is it possible to disable sizing(size) the column
axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exVLines;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("32px") as EXGRIDLib.Column);
	var_Column.Width = 32;
	var_Column.AllowSizing = false;
axGrid1.Columns.Add("Rest");
axGrid1.ColumnAutoResize = true;
axGrid1.EndUpdate();
1201
How can I add two columns of 25% and the third of 50%

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exVLines;
(axGrid1.Columns.Add("25%") as EXGRIDLib.Column).Width = 25;
(axGrid1.Columns.Add("25%") as EXGRIDLib.Column).Width = 25;
(axGrid1.Columns.Add("50%") as EXGRIDLib.Column).Width = 50;
axGrid1.ColumnAutoResize = true;
axGrid1.EndUpdate();