1122:
How can I define a column of button type

// ButtonClick event - Occurs when user clicks on the cell's button.
private void axGrid1_ButtonClick(object sender, AxEXGRIDLib._IGridEvents_ButtonClickEvent e)
{
	EXGRIDLib.Items var_Items = axGrid1.Items;
		System.Diagnostics.Debug.Print( var_Items.get_CellValue(e.item,e.colIndex).ToString() );
}
//this.axGrid1.ButtonClick += new AxEXGRIDLib._IGridEvents_ButtonClickEventHandler(this.axGrid1_ButtonClick);

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Button") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasButton,true);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellButtonAutoWidth,false);
	var_Column.FormatColumn = "``";
	var_Column.AllowSizing = false;
	var_Column.Width = 48;
(axGrid1.Columns.Add("Second") as EXGRIDLib.Column).FormatColumn = "` Item ` + 1 index ``";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Button 1");
	var_Items.AddItem("Button 2");
	var_Items.AddItem("Button 3 ");
axGrid1.EndUpdate();

1121:
Is it possible to configure different colour/icon when there is a active filter

// FilterChange event - Occurs when filter was changed.
private void axGrid1_FilterChange(object sender, EventArgs e)
{
	axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,axGrid1.FormatABC("value = 0 ? 0x1000001 : 0x10000FF ",axGrid1.Columns[0].FilterType,null,null));
}
//this.axGrid1.FilterChange += new EventHandler(this.axGrid1_FilterChange);

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.RenderType = -16777216;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQ" +
"gmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYTh" +
"dr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA");
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines;
axGrid1.ShowFocusRect = false;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x1000001);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,-1);
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.BackColorHeader = Color.FromArgb(255,255,255);
axGrid1.HeaderVisible = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.AllowSort = false;
	var_Column.AllowDragging = false;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.Filter = "Item B";
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1120:
How can I display the type of the value the column display

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Values") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "value + ` <off 4><fgcolor=808080>type(` + type(%0) + `)`";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem(null);
	var_Items.AddItem(-1);
	var_Items.AddItem("string");
	var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(2);
	var_Items.AddItem(true);
	var_Items.AddItem(12.34);
axGrid1.EndUpdate();

1119:
I want to create a conditional format for a column, verifying that the value of the cell is numeric, how can I do

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.Columns.Add("Values");
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("type(%0) in (2,3,4,5,18,19,20,21)",null);
	var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
	var_ConditionalFormat.Bold = true;
axGrid1.ConditionalFormats.Add("type(%0) = 11",null).ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0));
axGrid1.ConditionalFormats.Add("type(%0) = 7",null).ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255));
axGrid1.ConditionalFormats.Add("type(%0) in (0,1)",null).BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240));
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem(null);
	var_Items.AddItem(-1);
	var_Items.AddItem("string");
	var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(2);
	var_Items.AddItem(true);
	var_Items.AddItem(12.34);
axGrid1.EndUpdate();

1118:
How can I assign a computed value on a different column based on other columns

// Change event - Occurs when the user changes the cell's content.
private void axGrid1_Change(object sender, AxEXGRIDLib._IGridEvents_ChangeEvent e)
{
	axGrid1.FreezeEvents(true);
	EXGRIDLib.Items var_Items = axGrid1.Items;
		var_Items.set_CellValue(e.item,1,axGrid1.FormatABC("int(255*sin(value/2))",e.newValue,null,null));
		var_Items.set_CellValue(e.item,2,axGrid1.FormatABC("int(255*cos(value/2))",e.newValue,null,null));
	axGrid1.FreezeEvents(false);
}
//this.axGrid1.Change += new AxEXGRIDLib._IGridEvents_ChangeEventHandler(this.axGrid1_Change);

axGrid1.BeginUpdate();
axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Value") as EXGRIDLib.Column);
	var_Column.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	var_Column.Width = 64;
	var_Column.AllowSizing = false;
(axGrid1.Columns.Add("Assign A") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,16448250);
(axGrid1.Columns.Add("Assign B") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,16448250);
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Computed") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,16448250);
	var_Column.ComputedField = "%1 + %2";
	var_Column.FormatColumn = "value format ``";
	var_Column.Alignment = EXGRIDLib.AlignmentEnum.RightAlignment;
	var_Column.HeaderAlignment = var_Column.Alignment;
axGrid1.ConditionalFormats.Add("%3 >= 0",null).Bold = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem(1989);
	var_Items.AddItem(2001);
	var_Items.AddItem(2017);
	var_Items.AddItem(2018);
	var_Items.AddItem(2019);
axGrid1.EndUpdate();

1117:
How can I get computed a value on a different column

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Year") as EXGRIDLib.Column);
	var_Column.Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	var_Column.Width = 64;
	var_Column.AllowSizing = false;
(axGrid1.Columns.Add("Easter") as EXGRIDLib.Column).FormatColumn = "date(dateS('3/1/' + %0)  + ((1:=(((255 - 11 * (%0 mod 19)) - 21) mod 30) + 21) + (=:1 > 48 ? -1 : 0) + 6 - ((%0 + int(%0 / 4)) " +
"+ =:1 + (=:1 > 48 ? -1 : 0) + 1) mod 7))";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem(1989);
	var_Items.AddItem(2001);
	var_Items.AddItem(2017);
	var_Items.AddItem(2018);
	var_Items.AddItem(2019);
axGrid1.EndUpdate();

1116:
How can I prevent applying ConditionalFormats on a specified cell, for instance I am displaying a Total field, and I will like to have formatted in a different way (method 2)

// 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.BeginUpdate();
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("(%0 >= 0)",null);
	var_ConditionalFormat.Expression = "(0=type(%CD0)) and (%0 >= 0)";
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
	System.Diagnostics.Debug.Print( "ConditionalFormat.Valid" );
	System.Diagnostics.Debug.Print( var_ConditionalFormat.Valid.ToString() );
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Numbers") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.Numeric = EXGRIDLib.NumericEnum.exInteger;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	var_Column.SortType = EXGRIDLib.SortTypeEnum.SortNumeric;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem(100);
	var_Items.AddItem(-25);
	var_Items.AddItem(31);
	var_Items.AddItem(-48);
EXGRIDLib.Items var_Items1 = axGrid1.Items;
	int h = var_Items1.AddItem("sum(all,dir,dbl(%0))");
	var_Items1.set_SelectableItem(h,false);
	var_Items1.set_SortableItem(h,false);
	var_Items1.set_ItemBackColor(h,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
	var_Items1.set_CellData(h,0,"total");
	var_Items1.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exTotalField | EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items1.set_FormatCell(h,0,"'Total: <b><fgcolor=0000FF>'+(value format ``)");
axGrid1.EndUpdate();

1115:
How can I prevent applying ConditionalFormats on a specified cell, for instance I am displaying a Total field, and I will like to have formatted in a different way (method 1)

// 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.BeginUpdate();
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%0 >= 0",null);
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
	var_ConditionalFormat.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Numbers") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.Numeric = EXGRIDLib.NumericEnum.exInteger;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.SpinType;
	var_Column.SortType = EXGRIDLib.SortTypeEnum.SortNumeric;
(axGrid1.Columns.Add("Total") as EXGRIDLib.Column).Visible = false;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exBottom,1);
	int h = var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_ItemDivider(h,1);
	var_Items.set_ItemDividerLine(h,EXGRIDLib.DividerLineEnum.EmptyLine);
	var_Items.set_ItemBackColor(h,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
	var_Items.set_CellValue(h,1,"sum(all,dir,dbl(%0))");
	var_Items.set_CellValueFormat(h,1,EXGRIDLib.ValueFormatEnum.exTotalField | EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellHAlignment(h,1,EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(h,1,"'Total: <b><fgcolor=0000FF>'+(value format ``)");
EXGRIDLib.Items var_Items1 = axGrid1.Items;
	var_Items1.AddItem(100);
	var_Items1.AddItem(-25);
	var_Items1.AddItem(31);
	var_Items1.AddItem(-48);
axGrid1.EndUpdate();

1114:
ADODB Requery sample

// ButtonClick event - Occurs when user clicks on the cell's button.
private void axGrid1_ButtonClick(object sender, AxEXGRIDLib._IGridEvents_ButtonClickEvent e)
{
	// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
	ADODB.Command cmd = new ADODB.Command();
		cmd.ActiveConnection = ((axGrid1.DataSource as ADODB.Recordset).ActiveConnection as ADODB.Connection);
		cmd.CommandText = "INSERT INTO Orders (EmployeeID) VALUES(12345)";
		cmd.CommandType = ADODB.CommandTypeEnum.adCmdText;
		cmd.Execute(null,null,0);
	(axGrid1.DataSource as ADODB.Recordset).Requery(0);
}
//this.axGrid1.ButtonClick += new AxEXGRIDLib._IGridEvents_ButtonClickEventHandler(this.axGrid1_ButtonClick);

// Error event - Fired when an internal error occurs.
private void axGrid1_Error(object sender, AxEXGRIDLib._IGridEvents_ErrorEvent e)
{
	System.Diagnostics.Debug.Print( e.description.ToString() );
}
//this.axGrid1.Error += new AxEXGRIDLib._IGridEvents_ErrorEventHandler(this.axGrid1_Error);

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ColumnAutoResize = false;
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Select * From Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access2007\\sample.accdb",ADODB.CursorTypeEnum.adOpenKeyset,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.ConditionalFormats.Add("%1=12345",null).BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240));
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_ItemDivider(h,0);
	var_Items.set_CellHasButton(h,0,true);
	var_Items.set_CellValue(h,0,"Requery (add a new record, using ADODB.Command)");
	var_Items.set_CellHAlignment(h,0,EXGRIDLib.AlignmentEnum.CenterAlignment);
axGrid1.EndUpdate();

1113:
I am using DetectAddNew property, but no new items is added when AddNew is performed

// ButtonClick event - Occurs when user clicks on the cell's button.
private void axGrid1_ButtonClick(object sender, AxEXGRIDLib._IGridEvents_ButtonClickEvent e)
{
	// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
	ADODB.Recordset var_Recordset = (axGrid1.DataSource as ADODB.Recordset);
		var_Recordset.AddNew("EmployeeID",123);
		var_Recordset.Update(null,null);
}
//this.axGrid1.ButtonClick += new AxEXGRIDLib._IGridEvents_ButtonClickEventHandler(this.axGrid1_ButtonClick);

// Error event - Fired when an internal error occurs.
private void axGrid1_Error(object sender, AxEXGRIDLib._IGridEvents_ErrorEvent e)
{
	System.Diagnostics.Debug.Print( e.description.ToString() );
}
//this.axGrid1.Error += new AxEXGRIDLib._IGridEvents_ErrorEventHandler(this.axGrid1_Error);

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.ColumnAutoResize = false;
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Open("Orders","Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access2007\\sample.accdb",ADODB.CursorTypeEnum.adOpenKeyset,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
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_ItemDivider(h,0);
	var_Items.set_CellHasButton(h,0,true);
	var_Items.set_CellValue(h,0,"AddNew");
	var_Items.set_CellHAlignment(h,0,EXGRIDLib.AlignmentEnum.CenterAlignment);
axGrid1.DetectAddNew = true;
axGrid1.DetectDelete = true;
axGrid1.EndUpdate();

1112:
I am skinning the control's header-bar, but the background of the header-bar is shown on each item in the filter-bar drop down panel. What can I do

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABFgDg6AADACAxRDgMQBQKAAzQFAYcBqGqGAAGQZxYgmFgAQhFcZQSKUOQTDKMIziYBYfgkMIgSbJUgDGAkRRdDSOYDmGQYDiCIoRShOMIjH" +
"LUXxtDaIZwhEAoJb+RgAUY/cTzaAEUwHHiTKInaCQGhsCYJUJAdRURQ9EwvCIZBpEWwLChENQwWLCNj2TScBwjCyqbale45ViqdoDU8lORLUi+M4zSBPcZVTRtGShPDB" +
"KTjMKKYgkG4lVpRNa0PC1GTzQ6mazkKQLRADDIDVbAeL3LiMBy9LyLLItQALByua5mWhbcZyBCOPgBTrRb5zO58FjuTK7YLjMB7NrUNYtFaUMy2OpOCADIaecTNcaWLx" +
"PF2MY1HWYxVj2Jw3DuRJonKYBgggSRAlIYw6B0ThGFgPAkFUDAhBMfZRiGNAkFECZnm4YQdneJwqnsSQrGAAhWAIJBJBIQgFCQIBiEIAglgqYo0i4V4MEgRI9gSToYFS" +
"b4Fk6Y4+BmBZhFOJgTC8TBogQAArgqco4muCZOkOMJtgmYpIjYKg7GKE4uCUK4AAKKg2DwI4DiCZw5k6KJ2D6D4OHiag4DwIxiiQAArAqMosnEPBPAOIhOg+DozjIJ4P" +
"GSY4iEwPAkhKLhHUUSQsnKFCnkYU9MjORhcCsAAIACLQ8iaSJ6FKC5jJoaobA8KYoACCRKnmMJzhuDpZnSboMCKGJ4nMPIPDmYAACwKIDk6CoLCeU40m6I5oliMoKDya" +
"ICokLIpgoThviOKJoGYf4KmUKhMjMLJLCAAojCyaYoiYGoGmqM46CkOwPEoKonAACxKlSdItmiWBeBeDgrioNo3D0KxSlAAAtgsUpYnUPRPEoco8hCa+T40SxbBRj5tE" +
"sHJ1i6JhbGYS4ug8awelQLZAAKZI5C4DxrhYQ9ehmUppWiA48nAPRuFKYpiAAC47laZQ9iuKZSgOPotkuFI7C6C4gACPJAm8eQOhOQZoikDp3kCS5AACPoEk8fBGnqQg" +
"pDOSppD2TxjlyPZD6CfwekQTx5lKP5ImseZTCAL5MAMAAAkoTADmMLpIjISp+HSS4PgyMAADBzAHDSIoPCOUpWjObIKE8NJOHKIwPEaTprBsHpdjWLB9AieQ+DQYwQAA" +
"MR1EOZxWi+bx7HcWQ8msfRYnnDhQACRwxgwc5rGaMZPE0ZxqjWNZtgyRwAAyTZEnuXJzEyAx2kQcxNkye5cEy3cYAcANrGAIH4OAhx3gNGGPAfgIR8jBA4McBMARViHH" +
"4HQOYmxuCpF2MsecEQVBvGQCcIQvA6i2CAAIARAQ=");
	var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzQFAYcBqGqGAAGQZxYgmFgAQhFcZQSKUOQTDKMIziYBYJhEMwwDhEIwjHCEEhsGIbJAGQBJCjWGodQLOEgzN" +
"C0IxNFCQILhEZJADKII8TTOU5UPRESwTE4cKBmKhQCo2NpKR7VUTxCKQahLLivoCjBT8EzHMqtIzrCA6MpaP4pQjKcqwHJ8YyHEi0ZrjazKaj6T5AXDUcaWbbNVx3PK3" +
"aioOpLZrqOZZYzYFoABTuJzPMSyIhxXD8cweaZvSpLExVYK9BY3PbKMgxC77QgTIpDaQMNS6PjtF43PAALLFUaNYzoOKzABMHATBIXAYJCwIIR5G7ID4BbQcCQAHL9DB" +
"aEEIAEEISgGhMGZQmocgymmIRQkIEQ2BcGgbEIRQci8XaMBqTRVgSAZHG+S5pnOep+D6f4vjec5zn0fpfmgBgAH6TRoBYBoAh+eAmAiAgPFgNArgOQpIESdoEmCOAOAq" +
"BYfFGAgaEaBgYHYFYFmIB5UiGCJUgKCgmgeYoHk4BgCmKRQiCwApgHgYgyH8B54lQU4NkMeJlBoDgjkiXBTg0R54iYIR+koeQVBoKpkgkChKhEJBkF4SFEjkDgJhFQoe" +
"EmDJlBeehUhWJQJGIXoICWOQ6FeFIlhkfhlDsSJpiQVoamaSY2G6G5nAmRhpCOH5pkwVYdmeCZmHqHpnkmdhzhmaAIFiax8AABAEICA==");
(axGrid1.GetOcx() as EXGRIDLib.Grid).BackColorHeader = 0x1000000;
axGrid1.ForeColorHeader = Color.FromArgb(128,128,128);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x2000000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exSelBackColorFilter,0x1ff8000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exSelForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,-1);
axGrid1.HeaderHeight = 24;
axGrid1.BackColorLevelHeader = axGrid1.BackColor;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exHeaderPaddingLeft,2);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exHeaderPaddingRight,2);
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("A");
	var_Items.AddItem("B");
	var_Items.AddItem("C");
	var_Items.AddItem("D");
axGrid1.EndUpdate();

1111:
How can I change the font for entire column (method 3)

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	EXGRIDLib.Items var_Items = axGrid1.Items;
		var_Items.set_CellFont(e.item,1,(axGrid1.Columns[1].Data as stdole.IFontDisp));
		var_Items.set_CellBold(e.item,1,true);
		var_Items.set_CellForeColor(e.item,1,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)));
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.Columns.Add("C1");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("C2") as EXGRIDLib.Column);
	var_Column.HTMLCaption = "<b><font Tahoma;14>C2";
	stdole.IFontDisp f = new stdole.StdFont() as stdole.IFontDisp;
		f.Name = "Tahoma";
		f.Size = 11;
	var_Column.Data = (f as stdole.IFontDisp);
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(10),1,11);
	var_Items.set_CellValue(var_Items.AddItem(12),1,13);
axGrid1.EndUpdate();

1110:
How can I change the font for entire column (method 2)

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	EXGRIDLib.Items var_Items = axGrid1.Items;
		stdole.IFontDisp f = new stdole.StdFont() as stdole.IFontDisp;
			f.Name = "Tahoma";
			f.Size = 11;
		var_Items.set_CellFont(e.item,1,(f as stdole.IFontDisp));
		var_Items.set_CellBold(e.item,1,true);
		var_Items.set_CellForeColor(e.item,1,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)));
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.Columns.Add("C1");
(axGrid1.Columns.Add("C2") as EXGRIDLib.Column).HTMLCaption = "<b><font Tahoma;14>C2";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(10),1,11);
	var_Items.set_CellValue(var_Items.AddItem(12),1,13);
axGrid1.EndUpdate();

1109:
How can I change the font for entire column (method 1)

axGrid1.BeginUpdate();
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("1",null);
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0));
	stdole.IFontDisp f = new stdole.StdFont() as stdole.IFontDisp;
		f.Name = "Tahoma";
		f.Size = 11;
	var_ConditionalFormat.Font = (f as stdole.IFontDisp);
	var_ConditionalFormat.ApplyTo = (EXGRIDLib.FormatApplyToEnum)0x1;
axGrid1.HeaderHeight = 24;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.Columns.Add("C1");
(axGrid1.Columns.Add("C2") as EXGRIDLib.Column).HTMLCaption = "<b><font Tahoma;14>C2";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(10),1,11);
	var_Items.set_CellValue(var_Items.AddItem(12),1,13);
axGrid1.EndUpdate();

1108:
I am using ExComboBox as an user editor, how can I display a different column

// UserEditorClose event - Fired the user editor is about to be opened.
private void axGrid1_UserEditorClose(object sender, AxEXGRIDLib._IGridEvents_UserEditorCloseEvent e)
{
	// Items.CellValue(Item,ColIndex) = Object.Select("OrderID")
}
//this.axGrid1.UserEditorClose += new AxEXGRIDLib._IGridEvents_UserEditorCloseEventHandler(this.axGrid1_UserEditorClose);

// UserEditorOleEvent event - Occurs when an user editor fires an event.
private void axGrid1_UserEditorOleEvent(object sender, AxEXGRIDLib._IGridEvents_UserEditorOleEventEvent e)
{
	System.Diagnostics.Debug.Print( e.ev.ToString() );
}
//this.axGrid1.UserEditorOleEvent += new AxEXGRIDLib._IGridEvents_UserEditorOleEventEventHandler(this.axGrid1_UserEditorOleEvent);

// UserEditorOpen event - Occurs when an user editor is about to be opened.
private void axGrid1_UserEditorOpen(object sender, AxEXGRIDLib._IGridEvents_UserEditorOpenEvent e)
{
	// Object.Select("OrderID") = Me.Items.CellValue(Item,ColIndex)
}
//this.axGrid1.UserEditorOpen += new AxEXGRIDLib._IGridEvents_UserEditorOpenEventHandler(this.axGrid1_UserEditorOpen);

axGrid1.BeginUpdate();
axGrid1.SortOnClick = EXGRIDLib.SortOnClickEnum.exNoSort;
EXGRIDLib.Editor var_Editor = (axGrid1.Columns.Add("Exontrol.ComboBox") as EXGRIDLib.Column).Editor;
	var_Editor.EditType = EXGRIDLib.EditTypeEnum.UserEditorType;
	var_Editor.UserEditor("Exontrol.ComboBox","");
	// Add 'ExComboBox 1.0 Control Library(ExComboBox.dll)' reference to your project.
	EXCOMBOBOXLib.ComboBox var_ComboBox = (var_Editor.UserEditorObject as EXCOMBOBOXLib.ComboBox);
		var_ComboBox.BeginUpdate();
		var_ComboBox.Style = EXCOMBOBOXLib.StyleEnum.DropDownList;
		var_ComboBox.ColumnAutoResize = false;
		// 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.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPLE.MDB",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
		var_ComboBox.DataSource = (rs as ADODB.Recordset);
		var_ComboBox.Alignment = EXCOMBOBOXLib.AlignmentEnum.LeftAlignment;
		var_ComboBox.IntegralHeight = true;
		var_ComboBox.MinHeightList = 128;
		var_ComboBox.MinWidthList = 648;
		var_ComboBox.HeaderHeight = 36;
		var_ComboBox.AllowSizeGrip = true;
		var_ComboBox.SingleEdit = true;
		var_ComboBox.LabelColumnIndex = 7;
		var_ComboBox.SearchColumnIndex = 0;
		EXCOMBOBOXLib.Column var_Column = var_ComboBox.Columns[0];
			var_Column.HeaderBold = true;
			var_Column.HTMLCaption = "OrderID<br><fgcolor=808080>(search)";
		EXCOMBOBOXLib.Column var_Column1 = var_ComboBox.Columns[7];
			var_Column1.HeaderBold = true;
			var_Column1.HTMLCaption = "ShipName<br><fgcolor=808080>(display)";
			var_Column1.Width = 128;
		var_ComboBox.UseTabKey = false;
		var_ComboBox.EndUpdate();
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.TreeColumnIndex = -1;
axGrid1.DefaultItemHeight = 21;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("shows always the drop-down editor");
	var_Items.set_CellHAlignment(h,0,EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_SelectableItem(h,false);
	var_Items.set_EnableItem(h,false);
	var_Items.set_CellEditorVisible(var_Items.AddItem(10248),0,EXGRIDLib.EditorVisibleEnum.exEditorVisible);
	var_Items.set_CellEditorVisible(var_Items.AddItem(10249),0,EXGRIDLib.EditorVisibleEnum.exEditorVisible);
	var_Items.set_CellEditorVisible(var_Items.AddItem(10250),0,EXGRIDLib.EditorVisibleEnum.exEditorVisible);
	h = var_Items.AddItem("shows the drop-down editor when user clicks it");
	var_Items.set_CellHAlignment(h,0,EXGRIDLib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_SelectableItem(h,false);
	var_Items.set_EnableItem(h,false);
	var_Items.AddItem(10248);
	var_Items.AddItem(10249);
	var_Items.AddItem(10250);
axGrid1.EndUpdate();

1107:
The ItemHeight property is not working (method 2)

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
axGrid1.ScrollBySingleLine = true;
(axGrid1.Columns.Add("Column") as EXGRIDLib.Column).Width = 128;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellSingleLine(var_Items.AddItem("This is a bit of text that should break the line"),0,EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap);
	int h = var_Items.AddItem("");
	var_Items.set_ItemDivider(h,0);
	var_Items.set_SelectableItem(h,false);
	var_Items.set_ItemDividerLineAlignment(h,EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_ItemHeight(h,3);
	var_Items.set_CellSingleLine(var_Items.AddItem("This is a bit of text that should break the line"),0,EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap);
axGrid1.EndUpdate();

1106:
The ItemHeight property is not working (method 1)

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
axGrid1.ScrollBySingleLine = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Column") as EXGRIDLib.Column);
	var_Column.Width = 128;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,0);
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("This is a bit of text that should break the line");
	int h = var_Items.AddItem("");
	var_Items.set_ItemDivider(h,0);
	var_Items.set_SelectableItem(h,false);
	var_Items.set_ItemDividerLineAlignment(h,EXGRIDLib.DividerAlignmentEnum.DividerCenter);
	var_Items.set_ItemMinHeight(h,3);
	var_Items.set_ItemMaxHeight(h,3);
	var_Items.AddItem("This is a bit of text that should break the line");
axGrid1.EndUpdate();

1105:
How do I add a total field locked at the bottom of the control

// AddGroupItem event - Occurs after a new Group Item has been inserted to Items collection.
private void axGrid1_AddGroupItem(object sender, AxEXGRIDLib._IGridEvents_AddGroupItemEvent e)
{
	EXGRIDLib.Items var_Items = axGrid1.Items;
		var_Items.set_ItemDividerLine(e.item,EXGRIDLib.DividerLineEnum.EmptyLine);
		var_Items.set_FormatCell(e.item,var_Items.get_GroupItem(e.item),"value + ` Min: <b>` + %13 + `</b> Max: <b>` + %14 + `</b> Sum: <b>` + %15 + `</b>, of Freight column`");
		var_Items.set_CellValue(e.item,"Min","min(current,all,dbl(%6))");
		var_Items.set_CellValueFormat(e.item,"Min",EXGRIDLib.ValueFormatEnum.exTotalField);
		var_Items.set_CellValue(e.item,"Max","max(current,all,dbl(%6))");
		var_Items.set_CellValueFormat(e.item,"Max",EXGRIDLib.ValueFormatEnum.exTotalField);
		var_Items.set_CellValue(e.item,"Sum","sum(current,all,dbl(%6))");
		var_Items.set_CellValueFormat(e.item,"Sum",EXGRIDLib.ValueFormatEnum.exTotalField);
		var_Items.set_ItemBackColor(e.item,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
}
//this.axGrid1.AddGroupItem += new AxEXGRIDLib._IGridEvents_AddGroupItemEventHandler(this.axGrid1_AddGroupItem);

// 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.BeginUpdate();
axGrid1.HasLines = EXGRIDLib.HierarchyLineEnum.exNoLine;
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exColumnsFloatBar,"Show/Hide");
axGrid1.ColumnsFloatBarSortOrder = EXGRIDLib.SortOrderEnum.SortAscending;
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
axGrid1.ColumnAutoResize = false;
axGrid1.BackColorSortBar = Color.FromArgb(240,240,240);
// 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.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPLE.MDB",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.SingleSort = false;
axGrid1.SortBarVisible = true;
axGrid1.AllowGroupBy = true;
axGrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Min") as EXGRIDLib.Column);
		var_Column.Visible = false;
		var_Column.AllowDragging = false;
	var_Column = (var_Columns.Add("Max") as EXGRIDLib.Column);
		var_Column.Visible = false;
		var_Column.Visible = false;
		var_Column.AllowDragging = false;
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Sum") as EXGRIDLib.Column);
		var_Column1.Visible = false;
		var_Column1.Visible = false;
		var_Column1.AllowDragging = false;
EXGRIDLib.Column var_Column2 = axGrid1.Columns["Freight"];
	var_Column2.FormatColumn = "currency(value)";
	var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,12895487);
	var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exHeaderBackColor,var_Column2.get_Def(EXGRIDLib.DefColumnEnum.exCellBackColor));
	var_Column2.HeaderBold = true;
	var_Column2.AllowGroupBy = false;
	var_Column2.Alignment = EXGRIDLib.AlignmentEnum.RightAlignment;
axGrid1.ScrollBySingleLine = false;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exBottom,2);
	int hL = var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_ItemDivider(hL,0);
	var_Items.set_ItemHeight(hL,3);
	var_Items.set_ItemDividerLineAlignment(hL,EXGRIDLib.DividerAlignmentEnum.DividerTop);
	var_Items.set_ItemDividerLine(hL,EXGRIDLib.DividerLineEnum.DoubleLine);
	hL = var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exBottom,1);
	var_Items.set_CellValue(hL,6,"sum(all,rec,dbl(%6))");
	var_Items.set_CellValueFormat(hL,6,EXGRIDLib.ValueFormatEnum.exTotalField);
	var_Items.set_ItemHeight(hL,24);
	var_Items.set_ItemBold(hL,true);
axGrid1.Columns["EmployeeID"].SortOrder = true;
axGrid1.EndUpdate();

1104:
How can I add a total field, when I use grouping

// AddGroupItem event - Occurs after a new Group Item has been inserted to Items collection.
private void axGrid1_AddGroupItem(object sender, AxEXGRIDLib._IGridEvents_AddGroupItemEvent e)
{
	EXGRIDLib.Items var_Items = axGrid1.Items;
		var_Items.set_ItemDividerLine(e.item,EXGRIDLib.DividerLineEnum.EmptyLine);
		var_Items.set_FormatCell(e.item,var_Items.get_GroupItem(e.item),"value + ` Min: <b>` + %13 + `</b> Max: <b>` + %14 + `</b> Sum: <b>` + %15 + `</b>, of Freight column`");
		var_Items.set_CellValue(e.item,"Min","min(current,all,dbl(%6))");
		var_Items.set_CellValueFormat(e.item,"Min",EXGRIDLib.ValueFormatEnum.exTotalField);
		var_Items.set_CellValue(e.item,"Max","max(current,all,dbl(%6))");
		var_Items.set_CellValueFormat(e.item,"Max",EXGRIDLib.ValueFormatEnum.exTotalField);
		var_Items.set_CellValue(e.item,"Sum","sum(current,all,dbl(%6))");
		var_Items.set_CellValueFormat(e.item,"Sum",EXGRIDLib.ValueFormatEnum.exTotalField);
		var_Items.set_ItemBackColor(e.item,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
}
//this.axGrid1.AddGroupItem += new AxEXGRIDLib._IGridEvents_AddGroupItemEventHandler(this.axGrid1_AddGroupItem);

// 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.BeginUpdate();
axGrid1.HasLines = EXGRIDLib.HierarchyLineEnum.exNoLine;
axGrid1.ColumnAutoResize = false;
axGrid1.BackColorSortBar = Color.FromArgb(240,240,240);
// 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.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPLE.MDB",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.SingleSort = false;
axGrid1.SortBarVisible = true;
axGrid1.AllowGroupBy = true;
axGrid1.Columns[1].SortOrder = true;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	(var_Columns.Add("Min") as EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("Max") as EXGRIDLib.Column).Visible = false;
	(var_Columns.Add("Sum") as EXGRIDLib.Column).Visible = false;
EXGRIDLib.Column var_Column = axGrid1.Columns["Freight"];
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,12895487);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exHeaderBackColor,var_Column.get_Def(EXGRIDLib.DefColumnEnum.exCellBackColor));
	var_Column.HeaderBold = true;
	var_Column.AllowGroupBy = false;
axGrid1.ScrollBySingleLine = false;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exBottom,1);
	int hL = var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exBottom,0);
	var_Items.set_ItemDivider(hL,0);
	var_Items.set_ItemHeight(hL,24);
	var_Items.set_ItemDividerLineAlignment(hL,EXGRIDLib.DividerAlignmentEnum.DividerTop);
	var_Items.set_ItemDividerLine(hL,EXGRIDLib.DividerLineEnum.DoubleLine);
	var_Items.set_CellValue(hL,0,"sum(all,rec,dbl(%6))");
	var_Items.set_CellValueFormat(hL,0,EXGRIDLib.ValueFormatEnum.exTotalField | EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellHAlignment(hL,0,EXGRIDLib.AlignmentEnum.RightAlignment);
	var_Items.set_FormatCell(hL,0,"'Freight: <bgcolor=FFC4C4> '+(value format ``) + ` `");
axGrid1.EndUpdate();

1103:
How do I use the ColumnsFloatBarVisible on exColumnsFloatBarVisibleIncludeCheckColumns

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
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.ColumnsFloatBarSortOrder = EXGRIDLib.SortOrderEnum.SortAscending;
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeCheckColumns;
axGrid1.EndUpdate();

1102:
How do I use the ColumnsFloatBarVisible on exColumnsFloatBarVisibleIncludeHiddenColumn

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
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");
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeHiddenColumns;
axGrid1.ColumnsFloatBarSortOrder = EXGRIDLib.SortOrderEnum.SortAscending;
axGrid1.EndUpdate();

1101:
How do I use the ColumnsFloatBarVisible on exColumnsFloatBarVisibleIncludeGroupByColumns

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("City");
	var_Columns.Add("Start");
	var_Columns.Add("End");
axGrid1.AllowGroupBy = true;
axGrid1.SortBarVisible = true;
axGrid1.SortBarCaption = "Drag a <b>column</b> header here to group by that column.";
axGrid1.BackColorSortBar = Color.FromArgb(250,250,250);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exColumnsFloatBar,"Group-By");
axGrid1.ColumnsFloatBarVisible = EXGRIDLib.ColumnsFloatBarVisibleEnum.exColumnsFloatBarVisibleIncludeGroupByColumns;
axGrid1.ColumnsFloatBarSortOrder = EXGRIDLib.SortOrderEnum.SortAscending;
axGrid1.Columns["City"].SortOrder = EXGRIDLib.SortOrderEnum.SortAscending;
axGrid1.EndUpdate();

1100:
How can I advance to the next line, once the user presses the ENTER key

// KeyDown event - Occurs when the user presses a key while an object has the focus.
private void axGrid1_KeyDownEvent(object sender, AxEXGRIDLib._IGridEvents_KeyDownEvent e)
{
	System.Diagnostics.Debug.Print( "KeyCode Before:" );
	System.Diagnostics.Debug.Print( e.keyCode.ToString() );
	e.keyCode = axGrid1.FormatABC("value = 13 ? 40 : value",e.keyCode,null,null);
	System.Diagnostics.Debug.Print( "KeyCode After:" );
	System.Diagnostics.Debug.Print( e.keyCode.ToString() );
}
//this.axGrid1.KeyDownEvent += new AxEXGRIDLib._IGridEvents_KeyDownEventHandler(this.axGrid1_KeyDownEvent);

axGrid1.BeginUpdate();
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Editor var_Editor = (var_Columns.Add("A") as EXGRIDLib.Column).Editor;
		var_Editor.Appearance = EXGRIDLib.InplaceAppearanceEnum.EtchedApp;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.EditType;
	EXGRIDLib.Editor var_Editor1 = (var_Columns.Add("B") as EXGRIDLib.Column).Editor;
		var_Editor1.Appearance = EXGRIDLib.InplaceAppearanceEnum.EtchedApp;
		var_Editor1.EditType = EXGRIDLib.EditTypeEnum.EditType;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h0 = var_Items.AddItem("Item A.1");
	var_Items.set_CellValue(h0,1,"Item B.1");
	h0 = var_Items.AddItem("Item A.2");
	var_Items.set_CellValue(h0,1,"Item B.2");
axGrid1.EndUpdate();

1099:
I am using AddNew to add new records, but I can not see them into the control

// ButtonClick event - Occurs when user clicks on the cell's button.
private void axGrid1_ButtonClick(object sender, AxEXGRIDLib._IGridEvents_ButtonClickEvent e)
{
	// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
	ADODB.Recordset var_Recordset = (axGrid1.DataSource as ADODB.Recordset);
		var_Recordset.AddNew(null,null);
		var_Recordset.Fields["A"].Value = "new A";
		var_Recordset.Fields["B"].Value = "new B";
		var_Recordset.Update(null,null);
}
//this.axGrid1.ButtonClick += new AxEXGRIDLib._IGridEvents_ButtonClickEventHandler(this.axGrid1_ButtonClick);

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Fields.Append("A",ADODB.DataTypeEnum.adBSTR,0,null,null);
	rs.Fields.Append("B",ADODB.DataTypeEnum.adBSTR,0,null,null);
	rs.Open(null,null,null,null,0);
	rs.AddNew(null,null);
	rs.Fields["A"].Value = "Item A.1";
	rs.Fields["B"].Value = "Item B.1";
	rs.Update(null,null);
	rs.AddNew(null,null);
	rs.Fields["A"].Value = "Item A.2";
	rs.Fields["B"].Value = "Item B.2";
	rs.Update(null,null);
axGrid1.DataSource = (rs as ADODB.Recordset);
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_ItemDivider(h,0);
	var_Items.set_CellHasButton(h,0,true);
	var_Items.set_CellValue(h,0,"AddNew");
	var_Items.set_CellHAlignment(h,0,EXGRIDLib.AlignmentEnum.CenterAlignment);
axGrid1.DetectAddNew = true;
axGrid1.DetectDelete = true;
axGrid1.EndUpdate();

1098:
How can I create a new ADO recordset

axGrid1.BeginUpdate();
// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
ADODB.Recordset rs = new ADODB.Recordset();
	rs.Fields.Append("A",ADODB.DataTypeEnum.adBSTR,0,null,null);
	rs.Fields.Append("B",ADODB.DataTypeEnum.adBSTR,0,null,null);
	rs.Open(null,null,null,null,0);
	rs.AddNew(null,null);
	rs.Fields["A"].Value = "Item A.1";
	rs.Fields["B"].Value = "Item B.1";
	rs.Update(null,null);
	rs.AddNew(null,null);
	rs.Fields["A"].Value = "Item A.2";
	rs.Fields["B"].Value = "Item B.2";
	rs.Update(null,null);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.EndUpdate();

1097:
Do do I get the DAO version I have installed

// Add 'Microsoft DAO 2.5/3.51 Compatibility Library(dao2535.tlb)' reference to your project.
System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version );
// Add 'Microsoft DAO 3.6 Object Library(dao360.dll)' reference to your project.
System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version );
// Add 'Microsoft Office 12.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project.
System.Diagnostics.Debug.Print( new DAO.PrivDBEngine().Version );

1096:
How do I get a list of interfaces the object implemenets

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// Add 'Microsoft Office 12.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project.
DAO.PrivDBEngine var_PrivDBEngine = new DAO.PrivDBEngine();
	DAO.Recordset2 rs = (var_PrivDBEngine.OpenDatabase("C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access2007\\sample.accdb",null,null,null).OpenRecordset("Orders",null,null,null) as DAO.Recordset2);
// Add 'ExPropertiesList 1.0 Control Library(ExPropertiesList.dll)' reference to your project.
System.Diagnostics.Debug.Print( new EXPROPERTIESLISTLib.PropertiesList().get_Interfaces(rs) );
axGrid1.DataSource = (rs as DAO.Recordset2);
axGrid1.EndUpdate();

1095:
Do do I get the ADO version I have installed

// Add 'Microsoft ActiveX Data Objects 6.1 Library(msado15.dll)' reference to your project.
System.Diagnostics.Debug.Print( "ADO Version:" );
System.Diagnostics.Debug.Print( new ADODB.Connection().Version );

1094:
DAO, ACCDB, 120

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// Add 'Microsoft Office 12.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project.
DAO.PrivDBEngine var_PrivDBEngine = new DAO.PrivDBEngine();
	DAO.Recordset2 rs = (var_PrivDBEngine.OpenDatabase("C:\\Program Files\\Exontrol\\ExGrid\\Sample\\Access2007\\sample.accdb",null,null,null).OpenRecordset("Orders",null,null,null) as DAO.Recordset2);
axGrid1.DataSource = (rs as DAO.Recordset2);
axGrid1.EndUpdate();

1093:
DAO, MDB, 120

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// Add 'Microsoft Office 12.0 Access database engine Object Library(ACEDAO.DLL)' reference to your project.
DAO.PrivDBEngine var_PrivDBEngine = new DAO.PrivDBEngine();
	DAO.Recordset2 rs = (var_PrivDBEngine.OpenDatabase("C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPLE.MDB",null,null,null).OpenRecordset("Orders",null,null,null) as DAO.Recordset2);
axGrid1.DataSource = (rs as DAO.Recordset2);
axGrid1.EndUpdate();

1092:
DAO, MDB

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// Add 'Microsoft DAO 3.6 Object Library(dao360.dll)' reference to your project.
DAO.PrivDBEngine var_PrivDBEngine = new DAO.PrivDBEngine();
	DAO.Recordset rs = var_PrivDBEngine.OpenDatabase("C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPLE.MDB",null,null,null).OpenRecordset("Orders",null,null,null);
axGrid1.DataSource = (rs as DAO.Recordset);
axGrid1.EndUpdate();

1091:
ADODB, ACCDB, x64

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// 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\\Access2007\\sample.accdb",ADODB.CursorTypeEnum.adOpenKeyset,ADODB.LockTypeEnum.adLockReadOnly,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.EndUpdate();

1090:
ADOR, ACCDB

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// 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\\Access2007\\sample.accdb",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.EndUpdate();

1089:
ADODB, MDB

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// 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.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPLE.MDB",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.EndUpdate();

1088:
ADOR, MDB

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = false;
// 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.Jet.OLEDB.4.0;Data Source=C:\\Program Files\\Exontrol\\ExGrid\\Sample\\SAMPLE.MDB",ADODB.CursorTypeEnum.adOpenStatic,ADODB.LockTypeEnum.adLockOptimistic,0);
axGrid1.DataSource = (rs as ADODB.Recordset);
axGrid1.EndUpdate();

1087:
How can I display the row on multiple lines (excrd)

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellFormatLevel,"[b=0]60;1[b=15]:60,((20;\"<fgcolor=808080>Dateigröße\"[b=1][a=2]:120,2[b=15])/(20;\"<fgcolor=808080>Erstellt am\"[a=2]:120,3[b=" +
"15])/(20;\"<fgcolor=808080>Zuletzt bearbeitet\"[b=4][a=2]:120,4[b=15]))");
	var_Column.AllowSort = false;
(axGrid1.Columns.Add(1.ToString()) as EXGRIDLib.Column).Visible = false;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add(2.ToString()) as EXGRIDLib.Column);
	var_Column1.Visible = false;
	var_Column1.Editor.EditType = EXGRIDLib.EditTypeEnum.EditType;
	var_Column1.FormatColumn = "1 index `A-Z`";
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add(3.ToString()) as EXGRIDLib.Column);
	var_Column2.Visible = false;
	var_Column2.Editor.EditType = EXGRIDLib.EditTypeEnum.EditType;
	var_Column2.FormatColumn = "1 index ``";
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add(4.ToString()) as EXGRIDLib.Column);
	var_Column3.Visible = false;
	var_Column3.Editor.EditType = EXGRIDLib.EditTypeEnum.EditType;
	var_Column3.FormatColumn = "date(``)";
axGrid1.DefaultItemHeight = 48;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.GridLineStyle = EXGRIDLib.GridLinesStyleEnum.exGridLinesSolid;
axGrid1.set_ViewModeOption(EXGRIDLib.ViewModeEnum.exTableView,EXGRIDLib.ViewModeOptionEnum.exBorderWidth,1);
axGrid1.set_ViewModeOption(EXGRIDLib.ViewModeEnum.exTableView,EXGRIDLib.ViewModeOptionEnum.exBorderHeight,1);
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem(""),1,"One");
	var_Items.set_CellValue(var_Items.AddItem(""),1,"Two");
	var_Items.set_CellValue(var_Items.AddItem(""),1,"Three");
axGrid1.EndUpdate();

1086:
Type of wraps the cell's caption support (Sample 2)

axGrid1.BeginUpdate();
axGrid1.HeaderSingleLine = false;
axGrid1.HeaderHeight = 36;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.ColumnAutoResize = false;
axGrid1.ScrollBySingleLine = true;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Single-Line (exCaptionSingleLine)") as EXGRIDLib.Column);
		var_Column.Width = 96;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,-1);
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Word-Wrap (exCaptionWordWrap)") as EXGRIDLib.Column);
		var_Column1.Width = 96;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,0);
		var_Column1.FormatColumn = "%0";
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Break-Wrap (exCaptionBreakWrap)") as EXGRIDLib.Column);
		var_Column2.Width = 96;
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,1);
		var_Column2.FormatColumn = "%0";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
	var_Items.AddItem("This is the <b>first</b> line.\\r\\nThis is the <b>second</b> line.\\r\\nThis is the <b>third</b> line.");
axGrid1.EndUpdate();

1085:
Type of wraps the cell's caption support (Sample 1)

axGrid1.BeginUpdate();
axGrid1.HeaderSingleLine = false;
axGrid1.HeaderHeight = 36;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.ColumnAutoResize = false;
axGrid1.ScrollBySingleLine = true;
(axGrid1.Columns.Add("Default") as EXGRIDLib.Column).Width = 128;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
	h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
	var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML);
	h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
	var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap);
	h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
	var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionWordWrap);
	h = var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
	var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionBreakWrap);
	h = var_Items.AddItem("This is the <b>first</b> line.<br>This is the <b>second</b> line.<br>This is the <b>third</b> line.");
	var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML);
	var_Items.set_CellSingleLine(h,0,EXGRIDLib.CellSingleLineEnum.exCaptionBreakWrap);
axGrid1.EndUpdate();

1084:
Can I break the cell's caption using the line break <br> or \r\n (Sample 2)

axGrid1.BeginUpdate();
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.ColumnAutoResize = false;
axGrid1.ScrollBySingleLine = true;
(axGrid1.Columns.Add("Default") as EXGRIDLib.Column).Width = 128;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellSingleLine(var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line."),0,EXGRIDLib.CellSingleLineEnum.exCaptionBreakWrap);
	var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
axGrid1.EndUpdate();

1083:
Can I break the cell's caption using the line break <br> or \r\n (Sample 1)

axGrid1.BeginUpdate();
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exRowLines;
axGrid1.ColumnAutoResize = false;
axGrid1.ScrollBySingleLine = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column);
	var_Column.Width = 128;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,1);
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
	var_Items.AddItem("This is the first line.\\r\\nThis is the second line.\\r\\nThis is the third line.");
axGrid1.EndUpdate();

1082:
How can I change the visual appearance/color of the Filter For ... field

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.BackColorHeader = Color.FromArgb(1,0,0);
axGrid1.ForeColorHeader = Color.FromArgb(255,255,255);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter,axGrid1.BackColorHeader);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exForeColorFilter,axGrid1.ForeColorHeader);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,-1);
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Bump;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Items") as EXGRIDLib.Column);
	var_Column.FilterOnType = true;
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exNoItems;
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.EndUpdate();

1081:
How can I display the cell's caption without spaces on both sides

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "((trim(value) replace `   ` with ` `) replace `  ` with ` `) replace ` ` with `<bgcolor=FF0000> </bgcolor>`";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.AddItem("Item A");
	var_Items.AddItem("    Item B");
	var_Items.AddItem("        Item   C    ");
axGrid1.EndUpdate();

1080:
How can I highlight the spaces within the column (sample 2)

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "`'` + ( value replace ` ` with `_` ) + `'`";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.AddItem("Item A");
	var_Items.AddItem("    Item B");
	var_Items.AddItem("        Item   C    ");
axGrid1.EndUpdate();

1079:
How can I highlight the spaces within the column (sample 1)

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "len(value) = 0 ? `<bgcolor=FF0000> </bgcolor>` : ( value replace ` ` with `<bgcolor=FF0000> </bgcolor>` )";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.AddItem("Item A");
	var_Items.AddItem("    Item B");
	var_Items.AddItem("        Item   C    ");
axGrid1.EndUpdate();

1078:
How can I change the visual aspect of the drop down filter-calendar

axGrid1.BeginUpdate();
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exForeColorFilter,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exDateScrollRange,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,255,255)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exDateHeader,axGrid1.get_Background(EXGRIDLib.BackgroundPartEnum.exBackColorFilter));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exDateScrollThumb,(uint)ColorTranslator.ToWin32(Color.FromArgb(128,128,128)));
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Date") as EXGRIDLib.Column);
	var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterDate = true;
	var_Column.DisplayFilterPattern = false;
axGrid1.EndUpdate();

1077:
How can I hide the filter bar description

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column.Filter = "B";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("A");
	var_Items.AddItem("B");
	var_Items.AddItem("C");
axGrid1.ApplyFilter();
axGrid1.FilterBarHeight = 0;
axGrid1.EndUpdate();

1076:
Export Data in HTML format

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.BackColorAlternate = Color.FromArgb(240,240,240);
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.FilterBarPromptType = EXGRIDLib.FilterPromptEnum.exFilterPromptContainsAny;
EXGRIDLib.ConditionalFormats var_ConditionalFormats = axGrid1.ConditionalFormats;
	var_ConditionalFormats.Add("%0 like `*parent*`","parent").BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(192,192,192));
	EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%0 like `*child*`","child");
		var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128));
		var_ConditionalFormat.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%0 like `*B*`","b");
		var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255));
		var_ConditionalFormat1.Bold = true;
		var_ConditionalFormat1.Italic = true;
		var_ConditionalFormat1.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Value") as EXGRIDLib.Column);
		var_Column.Width = 128;
		var_Column.HTMLCaption = "<b>VA</b><r>sko";
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("APos") as EXGRIDLib.Column);
		var_Column1.FormatColumn = "0 apos ``";
		var_Column1.AllowSort = false;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor));
		var_Column1.Position = 0;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("RPos") as EXGRIDLib.Column);
		var_Column2.FormatColumn = "0 rpos ``";
		var_Column2.AllowSort = false;
		var_Column2.Position = 1;
	EXGRIDLib.Column var_Column3 = (var_Columns.Add("Index") as EXGRIDLib.Column);
		var_Column3.FormatColumn = "0 index ``";
		var_Column3.DisplayFilterButton = true;
		var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowCheckBox;
		var_Column3.Position = 2;
	EXGRIDLib.Column var_Column4 = (var_Columns.Add("Data 1") as EXGRIDLib.Column);
		var_Column4.FormatColumn = "0 index `A-Z`";
		var_Column4.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column5 = (var_Columns.Add("Data 2") as EXGRIDLib.Column);
		var_Column5.FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`";
		var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,false);
		var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellHasRadioButton,true);
	EXGRIDLib.Column var_Column6 = (var_Columns.Add("Data 3") as EXGRIDLib.Column);
		var_Column6.FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`";
		var_Column6.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("ParentA");
	var_Items.InsertItem(h,null,"Child A");
	var_Items.InsertItem(h,null,"Child B");
	var_Items.set_CellState(h,4,1);
	var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child C"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0)));
	var_Items.set_ExpandItem(h,true);
	var_Items.AddItem("Item A");
	h = var_Items.AddItem("ParentB");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child 3"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0)));
	var_Items.set_CellState(h,5,1);
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
	var_Items.AddItem("Item D");
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();
string sFile = "c:/temp/export.html";
axGrid1.Export(sFile,"vis");
// Add 'Microsoft Internet Controls(ieframe.dll)' reference to your project.
SHDocVw.ShellBrowserWindow var_ShellBrowserWindow = new SHDocVw.ShellBrowserWindow();
	var_ShellBrowserWindow.Navigate2(sFile,null,null,null,null);

1075:
Export Data in CSV format

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.BackColorAlternate = Color.FromArgb(240,240,240);
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "(( ( value replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.FilterBarPromptType = EXGRIDLib.FilterPromptEnum.exFilterPromptContainsAny;
EXGRIDLib.ConditionalFormats var_ConditionalFormats = axGrid1.ConditionalFormats;
	var_ConditionalFormats.Add("%0 like `*parent*`","parent").BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(192,192,192));
	EXGRIDLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%0 like `*child*`","child");
		var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128));
		var_ConditionalFormat.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns;
	EXGRIDLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%0 like `*B*`","b");
		var_ConditionalFormat1.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,255));
		var_ConditionalFormat1.Bold = true;
		var_ConditionalFormat1.Italic = true;
		var_ConditionalFormat1.ApplyTo = EXGRIDLib.FormatApplyToEnum.exFormatToColumns;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Value") as EXGRIDLib.Column);
		var_Column.Width = 128;
		var_Column.HTMLCaption = "<b>VA</b><r>sko";
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("APos") as EXGRIDLib.Column);
		var_Column1.FormatColumn = "0 apos ``";
		var_Column1.AllowSort = false;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellBackColor,15790320);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor));
		var_Column1.Position = 0;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("RPos") as EXGRIDLib.Column);
		var_Column2.FormatColumn = "0 rpos ``";
		var_Column2.AllowSort = false;
		var_Column2.Position = 1;
	EXGRIDLib.Column var_Column3 = (var_Columns.Add("Index") as EXGRIDLib.Column);
		var_Column3.FormatColumn = "0 index ``";
		var_Column3.DisplayFilterButton = true;
		var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowCheckBox;
		var_Column3.Position = 2;
	EXGRIDLib.Column var_Column4 = (var_Columns.Add("Data 1") as EXGRIDLib.Column);
		var_Column4.FormatColumn = "0 index `A-Z`";
		var_Column4.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	EXGRIDLib.Column var_Column5 = (var_Columns.Add("Data 2") as EXGRIDLib.Column);
		var_Column5.FormatColumn = "0 index `AB` replace `A` with `<off -4>A</off>`";
		var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellSingleLine,false);
		var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
		var_Column5.set_Def(EXGRIDLib.DefColumnEnum.exCellHasRadioButton,true);
	EXGRIDLib.Column var_Column6 = (var_Columns.Add("Data 3") as EXGRIDLib.Column);
		var_Column6.FormatColumn = "0 index `CDC` replace `D` with `<b>D</b>`";
		var_Column6.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("ParentA");
	var_Items.InsertItem(h,null,"Child A");
	var_Items.InsertItem(h,null,"Child B");
	var_Items.set_CellState(h,4,1);
	var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child C"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0)));
	var_Items.set_ExpandItem(h,true);
	var_Items.AddItem("Item A");
	h = var_Items.AddItem("ParentB");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_CellBackColor(var_Items.InsertItem(h,null,"Child 3"),5,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,255,0)));
	var_Items.set_CellState(h,5,1);
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
	var_Items.AddItem("Item D");
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("","vis").ToString() );

1074:
Is it possible to check multiple-items at once

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object bHasParent = axGrid1.FormatABC("value != 0",axGrid1.Items.get_ItemParent(e.item),null,null);
	EXGRIDLib.Items var_Items = axGrid1.Items;
		var_Items.set_CellHasCheckBox(e.item,0,false);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "value + (%CS0 = 1 ? `<r><fgcolor=808080>(checked)` : ``)";
axGrid1.HeaderVisible = true;
axGrid1.SingleSel = false;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	hChild = var_Items.InsertItem(h,null,"Task 2");
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_ExpandItem(h,true);
	var_Items.set_LockedItemCount(EXGRIDLib.VAlignmentEnum.exTop,1);
	var_Items.set_CellValue(var_Items.get_LockedItem(EXGRIDLib.VAlignmentEnum.exTop,0),0,"<c>Select multiple items and press the <b>SPACE</b> key");
axGrid1.EndUpdate();

1073:
How can I get the icon from the cell when using the Items.CellImages property (icon index)

// MouseMove event - Occurs when the user moves the mouse.
private void axGrid1_MouseMoveEvent(object sender, AxEXGRIDLib._IGridEvents_MouseMoveEvent e)
{
	int i = axGrid1.get_ItemFromPoint(-1,-1,c,hit);
	System.Diagnostics.Debug.Print( axGrid1.FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? ( ( (value bitand 0xFFFF0000) bitshift 16 ) array B split `,` )  : `no image`",hit,axGrid1.Items.get_CellImages(i,c),null).ToString() );
}
//this.axGrid1.MouseMoveEvent += new AxEXGRIDLib._IGridEvents_MouseMoveEventHandler(this.axGrid1_MouseMoveEvent);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
axGrid1.Columns.Add("Default");
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellImages(var_Items.AddItem("Item 1"),0,"3,2,1");
	var_Items.set_CellImages(var_Items.AddItem("Item 2"),0,"2,3");
	var_Items.set_CellImages(var_Items.AddItem("Item 3"),0,"2,");
axGrid1.EndUpdate();

1072:
How can I get the icon from the cell when using the Items.CellImages property (icon position within the cell)

// MouseMove event - Occurs when the user moves the mouse.
private void axGrid1_MouseMoveEvent(object sender, AxEXGRIDLib._IGridEvents_MouseMoveEvent e)
{
	int i = axGrid1.get_ItemFromPoint(-1,-1,c,hit);
	System.Diagnostics.Debug.Print( axGrid1.FormatABC("( 0x44 = ( value bitand 0x44 ) ) ? 1 + ( (value bitand 0xFFFF0000) bitshift 16 ) : `no image`",hit,null,null).ToString() );
}
//this.axGrid1.MouseMoveEvent += new AxEXGRIDLib._IGridEvents_MouseMoveEventHandler(this.axGrid1_MouseMoveEvent);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
axGrid1.Columns.Add("Default");
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellImages(var_Items.AddItem("Item 1"),0,"3,2,1");
	var_Items.set_CellImages(var_Items.AddItem("Item 2"),0,"2,3");
	var_Items.set_CellImages(var_Items.AddItem("Item 3"),0,"2");
axGrid1.EndUpdate();

1071:
Is it possible to change the visual appearance of the position signs when user changes the column's position by drag and drop

axGrid1.BeginUpdate();
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("Column 1");
	var_Columns.Add("Column 2");
	var_Columns.Add("Column 3");
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABZEGACAADACAxRDgMQBQKAAzAJBIYhiG4cYCgMYxXDOCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADKMA4SOKIZhrE4bBhGaQRUgyI43RhHUBzV" +
"IUcQvE6TZRHCQYHgkNIhDJIM7TPLkeSVJaTIRoKhJUogApQThTMgVRDEThkGoSa6soSoYTDBKybLrSLKagOT5YUDKUqSdKEZRpEq1YztWbaQoCUoqVRRVIWfbNd4JJa4" +
"aDhWpYdpeeY5R7bWLgBYVVABL7LLRsSxpHxPF6RXxaeI3GKsaS8G6ic6nPQMHj7I4NS5pUa6Rh2VYNSa8AAtETRYznOw4bTMXAjNIea5bAYIIR5HIoDzVbQcCQAHL9DB" +
"eEMIQEEISgGhMGZQmocgymoYRRCIEQ0G2HYBnEIBig4V4zCQGINnmagCECY43medZ6H2Pw/g+X5fnueh/h+R5+AKABfkMWgGgGYA4AICoCGCE5WA4CphACMgSD2IRIDI" +
"BICmEd5YGCBpRjGBgegWIYIgWdgoGIRQsiKCZiAiJZ0gGQI4jUS4LECOAiBmDJflGfg2BSY4Al4OhGkOCJ2DgFJjGGfgqgiH5Ch4RhGkqOQmEOEpkFkHQYhJRYyESAok" +
"GKHhIhKIxJEmf4VGUeRGFmF5iBkchPhYJQ5GoYIZg6Ug6GoFYmkmNhuhulRGHKGoImefh0BUZ4JmYeoemeSZ2H6HQmgoBgXDqXwUAQgI=");
	var_Appearance.Add(2,"CP:1 0 -36 0 0");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exColumnsPositionSign,0x2000000);
axGrid1.EndUpdate();

1070:
How can I add a title column

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 22;
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.Etched;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exAllLines;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("Col 1");
	(var_Columns.Add("Col 2") as EXGRIDLib.Column).FormatColumn = "1 pos ``";
	(var_Columns.Add("Col 3") as EXGRIDLib.Column).FormatColumn = "1 pos `A-`";
	(var_Columns.Add("Col 4") as EXGRIDLib.Column).FormatColumn = "1 pos `A-Z`";
	EXGRIDLib.Column var_Column = (var_Columns.Add("Title") as EXGRIDLib.Column);
		var_Column.ExpandColumns = "0,1,2,3";
		var_Column.DisplayExpandButton = false;
		var_Column.AllowSort = false;
		var_Column.AllowDragging = false;
		var_Column.Position = 0;
		var_Column.HeaderAlignment = EXGRIDLib.AlignmentEnum.CenterAlignment;
axGrid1.ColumnAutoResize = false;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
	var_Items.AddItem("Item 4");
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( axGrid1.Export("",null).ToString() );

1069:
FilterBarCaption ALLUI Keyword ( sample 3, result, leaf )

// AddGroupItem event - Occurs after a new Group Item has been inserted to Items collection.
private void axGrid1_AddGroupItem(object sender, AxEXGRIDLib._IGridEvents_AddGroupItemEvent e)
{
	EXGRIDLib.Items var_Items = axGrid1.Items;
		var_Items.set_ItemBackColor(e.item,(uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240)));
		object val = var_Items.get_CellValue(e.item,var_Items.get_GroupItem(e.item));
		var_Items.set_CellState(e.item,var_Items.get_GroupItem(e.item),axGrid1.FormatABC("A = `Checked` ? 1 : 0",val,null,null));
}
//this.axGrid1.AddGroupItem += new AxEXGRIDLib._IGridEvents_AddGroupItemEventHandler(this.axGrid1_AddGroupItem);

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null);
	axGrid1.Items.set_CellImage(e.item,3,i);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column2.DisplayFilterButton = true;
	var_Column2.DisplayFilterPattern = false;
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column);
	var_Column3.DisplayFilterButton = true;
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage;
	var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column4.AllowSizing = false;
	var_Column4.AllowSort = false;
	var_Column4.Width = 32;
	var_Column4.FormatColumn = "1 rpos ``";
	var_Column4.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellValue(h,1,"Sub-Item B");
	var_Items.set_CellState(h,2,1);
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + leafitemcount + ` result(s)` ) : (`<r><fgcolor=808080>`+ leafitemcount + `" +
" item(s)`) )))";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.AllowGroupBy = true;
axGrid1.SortBarVisible = true;
EXGRIDLib.Column var_Column5 = axGrid1.Columns[2];
	var_Column5.FormatColumn = "%CS2 ? `Checked` : `Unchecked`";
	var_Column5.SortOrder = EXGRIDLib.SortOrderEnum.SortAscending;
axGrid1.EndUpdate();

1068:
A black portion is shown while I am using the BackColorAlternate with EBN colors. What can I do

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = true;
axGrid1.DefaultItemHeight = 20;
axGrid1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAAEhIDhAxHAxg0HG0Mg4xGI3HMOig3GcJiYAf8jAEhhUnAAyhEqg8hk0oAsIjgAiAwmYxGA4mYzGwwkI0i0ooUnB0IBMIl1Dg8zmYyGolptPkI1m" +
"Y1GAll9KoUslNIrVCqNQldShFUstXAVfrVcrlZtVhuFnsUHq1zoczoQGhFBkNpg6zbDykUkhsPHE2h85nc9n8xtVDtlex9Msd2p1YstVq9ux8HyMtzuFz1PsNTzQlv2h" +
"hWfkuqpeVuN0q+nvEooN5veSAGpkb/ACcZrvhU3w83nM/poxGuchGpoVBvWgg+8knA4WimnFxI45Er5XOlHMg/Q3XU33W4ew9Wyu11mchDagcO7zus8VDoNBBEIKBpMY" +
"6DqOQyokhA/IQIQmwMk4bIQFDcoO6LWgwhQkNcABwEyAB5GwWbet6cRQg3DENQ5D8QxADZvEkAB8nabsURGeBpFM3pwE2AEZRpDx/neZpOR3Dz9oO/r/wCMoZNTBQAQR" +
"JSEwYg8HPGhEIoNCaEwq10gQ2WcRt7LcRxRFpuxUAEURQ3sczBEMgTTG8gN7HpOSEAEiQBAQZpmQ0DibPUFwbKcHwkhQoQtNQNzNEMbABOKDy/DMYQzHLeoPL0OTJSUd" +
"0pHcxTewk5zrIygIRPslz4lEngBKIAQivgASs/kLSBTlO00f8t0vGcgUbDlDRjXLCUNRERRvRgAHW2oAICA==");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Position") as EXGRIDLib.Column);
	var_Column1.FormatColumn = "1 rindex ``";
	var_Column1.Visible = false;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%C1 mod 2",null);
	var_ConditionalFormat.BackColor = 0x1000000;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
	var_Items.AddItem("Item 4");
axGrid1.EndUpdate();

1067:
How can I specify alternate background colors for each root item, similar with BackColorAlternate

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Default") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Position") as EXGRIDLib.Column);
	var_Column1.FormatColumn = "( ( 1:=( ( 0:=(1 rpos '') ) lfind `.`) ) < 0 ? =:0 : (=:0 left =:1) )";
	var_Column1.Visible = false;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%C1 mod 2",null);
	var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(240,240,240));
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");
	h = var_Items.AddItem("Root 3");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
axGrid1.EndUpdate();

1066:
Is it possible to change the caption from a column without to remove the column and add it with the new caption
(axGrid1.Columns.Add("ColumnName") as EXGRIDLib.Column).Caption = "NewName";
(axGrid1.Columns.Add("ColumnName") as EXGRIDLib.Column).HTMLCaption = "<b>New</b>Name";

1065:
FilterBarCaption ALL Keyword ( sample 2, result )

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null);
	axGrid1.Items.set_CellImage(e.item,3,i);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column2.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column2.DisplayFilterButton = true;
	var_Column2.DisplayFilterPattern = false;
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column);
	var_Column3.DisplayFilterButton = true;
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage;
	var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column4.AllowSizing = false;
	var_Column4.AllowSort = false;
	var_Column4.Width = 32;
	var_Column4.FormatColumn = "1 apos ``";
	var_Column4.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellValue(h,1,"Sub-Item B");
	var_Items.set_CellState(h,2,1);
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "(( ( all replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace `[" +
"<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matchi" +
"temcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount" +
" + ` item(s)`) )))";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column5 = axGrid1.Columns[0];
	var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column5.Filter = "Item A|Item B";
axGrid1.Columns[2].Filter = 1.ToString();
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1064:
FilterBarCaption ALL Keyword ( sample 1 )

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null);
	axGrid1.Items.set_CellImage(e.item,3,i);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column2.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column2.DisplayFilterButton = true;
	var_Column2.DisplayFilterPattern = false;
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column);
	var_Column3.DisplayFilterButton = true;
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage;
	var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column4.AllowSizing = false;
	var_Column4.AllowSort = false;
	var_Column4.Width = 32;
	var_Column4.FormatColumn = "1 apos ``";
	var_Column4.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellValue(h,1,"Sub-Item B");
	var_Items.set_CellState(h,2,1);
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "all";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column5 = axGrid1.Columns[0];
	var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column5.Filter = "Item A|Item B";
axGrid1.Columns[2].Filter = 1.ToString();
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1063:
FilterBarCaption ALLUI Keyword ( sample 2, result )

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null);
	axGrid1.Items.set_CellImage(e.item,3,i);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column2.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column2.DisplayFilterButton = true;
	var_Column2.DisplayFilterPattern = false;
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column);
	var_Column3.DisplayFilterButton = true;
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage;
	var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column4.AllowSizing = false;
	var_Column4.AllowSort = false;
	var_Column4.Width = 32;
	var_Column4.FormatColumn = "1 apos ``";
	var_Column4.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellValue(h,1,"Sub-Item B");
	var_Items.set_CellState(h,2,1);
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "(( ( allui replace `[<b>` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `</b>]` with ` </b></bgcolor></fgcolor>` replace " +
"`[<s>` with `<bgcolor=C0C0C0><fgcolor=FFFFFF> ` replace `</s>]` with ` </fgcolor></bgcolor>` )  + `<r><fgcolor=808080>` + ( matc" +
"hitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcou" +
"nt + ` item(s)`) )))";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column5 = axGrid1.Columns[0];
	var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column5.Filter = "Item A|Item B";
axGrid1.Columns[2].Filter = 1.ToString();
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1062:
FilterBarCaption ALLUI Keyword ( sample 1 )

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null);
	axGrid1.Items.set_CellImage(e.item,3,i);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column2.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column2.DisplayFilterButton = true;
	var_Column2.DisplayFilterPattern = false;
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column);
	var_Column3.DisplayFilterButton = true;
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage;
	var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column4.AllowSizing = false;
	var_Column4.AllowSort = false;
	var_Column4.Width = 32;
	var_Column4.FormatColumn = "1 apos ``";
	var_Column4.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellValue(h,1,"Sub-Item B");
	var_Items.set_CellState(h,2,1);
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "allui";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column5 = axGrid1.Columns[0];
	var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column5.Filter = "Item A|Item B";
axGrid1.Columns[2].Filter = 1.ToString();
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1061:
FilterBarCaption AVAILABLE Keyword ( sample 2, result )

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null);
	axGrid1.Items.set_CellImage(e.item,3,i);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column2.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column2.DisplayFilterButton = true;
	var_Column2.DisplayFilterPattern = false;
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column);
	var_Column3.DisplayFilterButton = true;
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage;
	var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column4.AllowSizing = false;
	var_Column4.AllowSort = false;
	var_Column4.Width = 32;
	var_Column4.FormatColumn = "1 apos ``";
	var_Column4.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellValue(h,1,"Sub-Item B");
	var_Items.set_CellState(h,2,1);
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "(( ( value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` ) + ` ` + ( ava" +
"ilable replace `[` with `<bgcolor=C0C0C0><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>` replace `<s>` with `" +
"` replace `</s>` with `` ) + `<fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount" +
" + 1) + ` result(s)` ) : (`<r><fgcolor=808080>`+ itemcount + ` item(s)`) )))";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column5 = axGrid1.Columns[0];
	var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column5.Filter = "Item A|Item B";
axGrid1.Columns[2].Filter = 1.ToString();
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1060:
FilterBarCaption AVAILABLE Keyword ( sample 1 )

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void axGrid1_AddItem(object sender, AxEXGRIDLib._IGridEvents_AddItemEvent e)
{
	object i = axGrid1.FormatABC("value + 1",axGrid1.Items.get_ItemToIndex(e.item),null,null);
	axGrid1.Items.set_CellImage(e.item,3,i);
}
//this.axGrid1.AddItem += new AxEXGRIDLib._IGridEvents_AddItemEventHandler(this.axGrid1_AddItem);

axGrid1.BeginUpdate();
axGrid1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column2.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column2.DisplayFilterButton = true;
	var_Column2.DisplayFilterPattern = false;
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column3 = (axGrid1.Columns.Add("Image") as EXGRIDLib.Column);
	var_Column3.DisplayFilterButton = true;
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exImage;
	var_Column3.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox;
EXGRIDLib.Column var_Column4 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column4.AllowSizing = false;
	var_Column4.AllowSort = false;
	var_Column4.Width = 32;
	var_Column4.FormatColumn = "1 apos ``";
	var_Column4.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellValue(h,1,"Sub-Item B");
	var_Items.set_CellState(h,2,1);
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080> ` + value + ` </fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "value + ` ` + available";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column5 = axGrid1.Columns[0];
	var_Column5.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column5.Filter = "Item A|Item B";
axGrid1.Columns[2].Filter = 1.ToString();
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1059:
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 3, results )

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column2.AllowSizing = false;
	var_Column2.AllowSort = false;
	var_Column2.Width = 32;
	var_Column2.FormatColumn = "1 apos ``";
	var_Column2.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	var_Items.set_CellValue(var_Items.AddItem("Item B"),1,"Sub-Item B");
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "(`<b>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `` : `` ) + `<r>` + abs(matchitemcount + 1) +" +
" ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )) replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replac" +
"e `]` with ` </b></bgcolor></fgcolor>`";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle;
EXGRIDLib.Column var_Column3 = axGrid1.Columns[0];
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column3.Filter = "Item A|Item B";
EXGRIDLib.Column var_Column4 = axGrid1.Columns[1];
	var_Column4.FilterType = EXGRIDLib.FilterTypeEnum.exPattern;
	var_Column4.Filter = "*B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1058:
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 2 )

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column2.AllowSizing = false;
	var_Column2.AllowSort = false;
	var_Column2.Width = 32;
	var_Column2.FormatColumn = "1 apos ``";
	var_Column2.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	var_Items.set_CellValue(var_Items.AddItem("Item B"),1,"Sub-Item B");
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "value replace `[` with `<bgcolor=000000><fgcolor=FFFFFF><b> ` replace `]` with ` </b></bgcolor></fgcolor>`";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle;
EXGRIDLib.Column var_Column3 = axGrid1.Columns[0];
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column3.Filter = "Item A|Item B";
EXGRIDLib.Column var_Column4 = axGrid1.Columns[1];
	var_Column4.FilterType = EXGRIDLib.FilterTypeEnum.exPattern;
	var_Column4.Filter = "*B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1057:
Is it possible to somehow highlight the column's name different than its filter value in the control's filter bar ( sample 1 )

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Col-1") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Col-2") as EXGRIDLib.Column);
	var_Column1.DisplayFilterButton = true;
	var_Column1.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column2.AllowSizing = false;
	var_Column2.AllowSort = false;
	var_Column2.Width = 32;
	var_Column2.FormatColumn = "1 apos ``";
	var_Column2.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellValue(var_Items.AddItem("Item A"),1,"Sub-Item A");
	var_Items.set_CellValue(var_Items.AddItem("Item B"),1,"Sub-Item B");
	var_Items.set_CellValue(var_Items.AddItem("Item C"),1,"Sub-Item C");
axGrid1.set_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd,axGrid1.FormatABC("`<fgcolor=808080>` + value + `</fgcolor>`",axGrid1.get_Description(EXGRIDLib.DescriptionTypeEnum.exFilterBarAnd),null,null).ToString());
axGrid1.FilterBarCaption = "value replace `[` with `<fgcolor=808080>[` replace `]` with `]</fgcolor>`";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle;
EXGRIDLib.Column var_Column3 = axGrid1.Columns[0];
	var_Column3.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column3.Filter = "Item A|Item B";
EXGRIDLib.Column var_Column4 = axGrid1.Columns[1];
	var_Column4.FilterType = EXGRIDLib.FilterTypeEnum.exPattern;
	var_Column4.Filter = "*B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1056:
Is it possible to automatically displays the control's filter label to the right

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Item") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column1.AllowSizing = false;
	var_Column1.AllowSort = false;
	var_Column1.Width = 32;
	var_Column1.FormatColumn = "1 apos ``";
	var_Column1.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarCaption = "`<r>` + value";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight | EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle;
EXGRIDLib.Column var_Column2 = axGrid1.Columns[0];
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column2.Filter = "Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1055:
How can I get the number of results/items being shown in the control's filter bar (sample 4)

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Item") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.FilterList = EXGRIDLib.FilterListEnum.exShowExclude | EXGRIDLib.FilterListEnum.exShowFocusItem | EXGRIDLib.FilterListEnum.exShowCheckBox | EXGRIDLib.FilterListEnum.exSortItemsAsc;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column1.AllowSizing = false;
	var_Column1.AllowSort = false;
	var_Column1.Width = 32;
	var_Column1.FormatColumn = "1 apos ``";
	var_Column1.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.FilterBarPrompt = axGrid1.FormatABC("`<b>` + value",axGrid1.FilterBarPrompt,null,null).ToString();
axGrid1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " +
"+ 1) + ` result(s)` ) : (`<fgcolor=808080>`+ itemcount + ` item(s)`) )";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight | EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.EndUpdate();

1054:
How can I get the number of results being shown in the control's filter bar (sample 3)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? ( ( len(value) ? `<br>` : `` ) + `<r>` + abs(matchitemcount " +
"+ 1) + ` result(s)` ) : ``)";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item A|Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1053:
How can I get the number of results being shown in the control's filter bar (sample 2, compact)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.FilterBarCaption = "`<b><r>` + value + `</b><fgcolor=808080>` + ( matchitemcount < 0 ? `<off -4> ` + abs(matchitemcount + 1) + ` result(s)` : ``)";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item A|Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1052:
How can I get the number of results being shown in the control's filter bar (sample 1)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.FilterBarCaption = "`<b>` + value + `</b><r><fgcolor=808080>` + ( matchitemcount < 0 ? abs(matchitemcount + 1) + ` result(s)` : ``)";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item A|Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1051:
FilterBarCaption Predefined Keywords

// AfterExpandItem event - Fired after an item is expanded (collapsed).
private void axGrid1_AfterExpandItem(object sender, AxEXGRIDLib._IGridEvents_AfterExpandItemEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.AfterExpandItem += new AxEXGRIDLib._IGridEvents_AfterExpandItemEventHandler(this.axGrid1_AfterExpandItem);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.CheckValueType;
		var_Editor.set_Option(EXGRIDLib.EditorOptionEnum.exCheckValue2,1);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterType = EXGRIDLib.FilterTypeEnum.exCheck;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column1.AllowSizing = false;
	var_Column1.AllowSort = false;
	var_Column1.Width = 32;
	var_Column1.FormatColumn = "1 apos ``";
	var_Column1.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	int h = var_Items.AddItem("Item B");
	var_Items.set_CellState(var_Items.InsertItem(h,null,"Sub-Item B1"),1,1);
	var_Items.InsertItem(h,null,"Sub-Item B2");
	var_Items.set_ExpandItem(h,true);
	var_Items.AddItem("Item C");
axGrid1.FilterInclude = EXGRIDLib.FilterIncludeEnum.exItemsWithChilds;
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.FilterBarCaption = "`<fgcolor=0000FF><i>value/current</i></fgcolor>: <fgcolor=808080>` + value + `</fgcolor>` + `<br><fgcolor=0000FF><i>available</" +
"i></fgcolor>: ` + available + `<br><fgcolor=0000FF><i>allui</i></fgcolor>: ` + allui + `<br><fgcolor=0000FF><i>all</i></fgcolor>" +
": ` + all + `<br><fgcolor=0000FF><i>itemcount</i></fgcolor>: <fgcolor=808080>` + itemcount + `</fgcolor>`+ `<br><fgcolor=0000FF>" +
"<i>visibleitemcount</i></fgcolor>: <fgcolor=808080>` + visibleitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>matchitemcount</" +
"i></fgcolor>: <fgcolor=808080>` + matchitemcount + `</fgcolor>`+ `<br><fgcolor=0000FF><i>promptpattern</i></fgcolor>: <fgcolor=8" +
"08080>` + promptpattern + `</fgcolor>`+ `<br><fgcolor=0000FF><i>leafitemcount</i></fgcolor>: <fgcolor=808080>` + leafitemcount +" +
" `</fgcolor>`";
axGrid1.FilterBarPromptPattern = "B";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCaptionVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column2 = axGrid1.Columns[0];
	var_Column2.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column2.Filter = "Item A|Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1050:
I am using filter prompt feature, and also column's filter, just wondering if possible to compact displaying the filter bar so it won't show on multiple lines

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarFont = (axGrid1.Font as stdole.IFontDisp);
axGrid1.FilterBarCaption = "`<r><i><fgcolor=808080><upline><solidline><sha ;;0>` + value";
axGrid1.FilterBarPromptPattern = "B";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item A|Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1049:
Just wondering if it is possible to show the filter bar's close button on the right ( sample 2 )

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseOnRight | EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.FilterBarPrompt = axGrid1.FormatABC("`<r>` + value",axGrid1.FilterBarPrompt,null,null).ToString();
axGrid1.EndUpdate();

1048:
Just wondering if it is possible to show the filter bar's close button on the right ( sample 1 )

axGrid1.BeginUpdate();
axGrid1.RightToLeft = true;
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.EndUpdate();

1047:
How can I change the visual appearance of the filter bar's close button (EBN)

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABHQDg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLOg7IJ" +
"jyI4/SJAYCydKAWhxIaZKJHCZoEDaTAADCNVAQp6MEIJVbVEI0e79OgBLp/Z7kECIJJAaRjHQdJxGLA8EhtCQhCZteK6SgMKJYXhWQYRXI1JwvMBrWrdQjiOYELQtMKm" +
"SZNLYGG4dR5SVJbcYhSYsRRFMoyDIOXYDLKsdYqSpXIThObEGgaPqJYjsUjCMKnR7HVIURrBPC9TBPE69ZgmC6ucKPX51ShKFaBWDZcwFAS+UBuYCAILiEAQGZ1XT8OR" +
"OicbgJgSTJRlCaZeDsHY7QGR4xkSYp3CaExZAQMgalQYAwjCAAfBANxcA2TgKAUOpDCGFhKg0RpXCwCwDHQHQHEyAIkCkOhbFOGA8A8DohBgRg9AccZcn8EpEjMLI2C2" +
"DYxAgQgvAIUIVkoAAPBQDJlECTZ3CCYwDACQwUA8A5MCAWAWDiQi4l8aQOEgLJuBgBgDmYFAzEoIoIl0WALgKYJbBABADAAHgHg8VAMmqCQQDMXABAATYwTmNwBDATJX" +
"AiAgjHmNQ5lgQ5QEQEQMmcWg/GwD5ylyNw2gMcJcjsBgBgOQQDDhRpVAMMwnDBFw1B0Ax8D0DxOmmJJIGQTY5hGMAwkwM4CAYLZAmAOJnAqAojiIGg6iieYkmeAYOHaK" +
"JDCyCwjH6AoggsQpQliAJLhgaJ0CESBTnyDwjk+cg4g4P5IHIHJ+BWRRzlYWAxiOUxihsY4KjKLJRGqC44FCegkkkM58iAKAPnIWIWD8SRSFSfQnkmewUhYP4GiGKJ7G" +
"0TIbCSUoggqUo0lAQ4LnEcBcD8Coiiif4nE+eAAn2HpOkcFJqi4T5SkyMw/kqQown8IBIBOdA+A+DJrBqVxXEqYo4lCApLhGHBnD8S4ymyfxmg+cwQkQP5egOUZIWoEA" +
"kjIeIPBMBJBD+TBjBifwvkuc58hQJQPmFrYykkchclSApKjGOBuD+TRDFCfw3mmIxNi8FxFlOXhVC4aYDFyPgvg2YBcBcLZGCGCJ0DSLRzGSWQ/lmY5+mEP5gmMDBZRS" +
"MRsFsOxMhMJJ/DsTpTnwaQaE+N5ojuNhdEYNI5C4TZJO1GRDmCaxnA2Yx4n8IpIjOTBQBQC5TgyYw7gUYRYikC0BYRwsDQBoB8eA6Q2hsE0BUXgywZtYCyHMKwnxSAhA" +
"QHkIQhRrBaDsCwA4ERiB2EWAIYIXhhiVEgAEUYwwYjyASLge4FhHgRDkM8OQih0jWPkGgBBAQ");
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exFooterFilterBarButton,0x1000000);
axGrid1.EndUpdate();

1046:
How can I change the visual appearance of the filter bar's close button (solid)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exFooterFilterBarButton,(uint)ColorTranslator.ToWin32(Color.FromArgb(255,0,0)));
axGrid1.EndUpdate();

1045:
Is it possible to prevent definitely showing the filter bar's close button

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exFooterFilterBarButton,-1);
axGrid1.EndUpdate();

1044:
Is it possible to show the close button only if there is a filter applied

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarShowCloseIfRequired | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.EndUpdate();

1043:
The control's filter bar is not closed once I click the close button (toggle)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
	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_CellValue(h,0,"<c><fgcolor=808080>Press the CTRL + F to turn on/off the control's filter bar. ALT + Up/Down moves the focus.");
	var_Items.set_CellValueFormat(h,0,EXGRIDLib.ValueFormatEnum.exHTML);
axGrid1.FilterBarCaption = "`<r><fgcolor=808080>` + value";
axGrid1.FilterBarPromptPattern = "B";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarToggle | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1042:
How can I display the control's filter on a single line

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarCaption = "len(value) ? `filter for: <fgcolor 808080>` + value  : `<fgcolor 808080>no filter`";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item A|Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1041:
How can I display the control's filter on a single line (prompt-combined)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarCaption = "`<r>` + value";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarCompact | EXGRIDLib.FilterBarVisibleEnum.exFilterBarSingleLine | EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item A|Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1040:
How can I get the number of results after a filter is applied

// 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.ClearFilter();
}
//this.axGrid1.ClickEvent += new EventHandler(this.axGrid1_ClickEvent);

// FilterChange event - Occurs when filter was changed.
private void axGrid1_FilterChange(object sender, EventArgs e)
{
	System.Diagnostics.Debug.Print( "Items.MatchItemCount" );
	System.Diagnostics.Debug.Print( axGrid1.Items.MatchItemCount.ToString() );
	System.Diagnostics.Debug.Print( axGrid1.FormatABC("value < 0 ? `filter applied: ` + abs(value + 1) + ` result(s)` : `no filter`",axGrid1.Items.MatchItemCount,null,null).ToString() );
}
//this.axGrid1.FilterChange += new EventHandler(this.axGrid1_FilterChange);

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.FilterBarPromptPattern = "Item";
axGrid1.EndUpdate();

1039:
How can I programmatically clear the control's filter
// 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.ClearFilter();
}
//this.axGrid1.ClickEvent += new EventHandler(this.axGrid1_ClickEvent);

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.FilterBarPromptPattern = "B";
axGrid1.EndUpdate();

1038:
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptPattern = "B";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible | EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1037:
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarPromptVisible;
axGrid1.FilterBarPromptPattern = "B";
axGrid1.EndUpdate();

1036:
Is it possible to prevent closing the control's filter bar, so it is always shown

axGrid1.BeginUpdate();
(axGrid1.Columns.Add("Item") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Pos") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowSort = false;
	var_Column.Width = 32;
	var_Column.FormatColumn = "1 apos ``";
	var_Column.Position = 0;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item A");
	var_Items.AddItem("Item B");
	var_Items.AddItem("Item C");
axGrid1.FilterBarCaption = "len(value) = 0 ? `<fgcolor=808080>no filter` : value";
axGrid1.FilterBarPromptVisible = EXGRIDLib.FilterBarVisibleEnum.exFilterBarVisible;
EXGRIDLib.Column var_Column1 = axGrid1.Columns[0];
	var_Column1.FilterType = EXGRIDLib.FilterTypeEnum.exFilter;
	var_Column1.Filter = "Item B";
axGrid1.ApplyFilter();
axGrid1.EndUpdate();

1035:
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 4)

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.VisualDesign = "gBFLBWIgBAEHhEJAEGg6VAkHeLpgwChAOhULB8XAUUg8MAAREEHGMcgRCJ0ei8dhABDEcQAAYAQGKIYBkAKBQAGaAoDDMOQwQwAAxjGKEEwsACEIrjKCRShyCYZRhGc" +
"TSBCIZBqEqSZLiEZRQiiCYsS5GQBRWAkEwiBiEQTjea5CgOIAFS7LIqjRQEBxhIaZYIGaiQADENo9TxIMZAfBIHShK6NJABCCSQKkYx0HScRijDIEFwGIQmbKiej4DCi" +
"CQQW7OYYRVCNMQSfa8HivJyrcamfp/YBgOBYHb1eLVPR5LwfPCGUw1P6PLxkORZHimK4tSLHV7xVpMIwZFafIQhCCoHomS5NU7UNR0TQUFx9FaGX7rDDsGwLAJ6XRgF4" +
"bg2VpnHePpenAN4bH2GwHFmApSjEGBLnWOpRGOTBZHOegrE6BxPiWVJqCweQrn0LgJAWJBjwgaw1gKO5HmWch5h+fovF+G5bmich4BgfZkB8dynRUVYqiUR5rnmex/F6" +
"N4tn2AJfnebZ3DEXw3HWXgzAyIwgicKJKBKEIhCeCgiHyHYFEmSAFmqBghFIdgSCeIJygYDAyAgJx6AoIINAMOJNCgCZCGoGoLmMCI+CwJoihMNglCCIhzFCUg0EmMhg" +
"hWDBkAiQg9CUY4jEYN4Jk2IxklYJoJHIUg+CSZJSESFwkkkGI+FOFIJEIRhPhMCRJCSVoRrSBhiDgTZjHYT4PEkYhwhgJYm0SaIaiaSYuE+GQNlmCIBGCJxjhiZQ5AkM" +
"hAg6ExJCkPhPguaAiFYUAlAkKZ0g6HoOEmWR/GHcA4m0OwIlIJIHCRgQshGJhpjoaocieaZiC6GAimkUgehIOwnGYGYIGkah6jaE4rg6SpCjKK5rEOMYlGIGIihKOggl" +
"oFoqj6L5aGaBo6CkGIkAQjiPpCAAaJILCTJQlKPACDaXJgmSaJsnCdJ4nygKEoijKQpSmKcqCpKoqysK0rivLAsSyLMtC1LYty4Lkui7LwvS+L8wDBMIwzEMUxjHMgyT" +
"KMszDNM4zzQNE0jTNQ1TWNc2DZNo2zcN03jfOA4TiOM5DlOY5zoOk6jrOw7TuO88DxPI8z0PU9j3Pg+T6Ps/D9P4/0AQFAkDQRBUGQdCEJQpC0MQ1DkPRBEUSRNFEVBh" +
"FkXRhGQ9D6Dxfh+W5gGGd4QH2XQjCmDpFFaKoVB+D5Xmed5+H8YAHnIAh9EwV5Fl0d4MkMKJICmSgygSJAoEmMUCIPgnDCCIOQFYCxJjwFoCcA4kxoF+AIJkAgExegDE" +
"gEYQInAzCUAIOEGgfxiiRDYF1Q4EQ2BSCaEQYwbAiKREMpRSymFNDIAkAxT6oVRgSA2qdVKq1WqvVirMZQUhSCnBUMoIgoQRgnGSIQUgkg1hIHYAkAYMROAmHiLsE4xx" +
"SCxBwEwCQ0wmDdBsE0GYXBtg2CSPMFIuwYiQBYBQeAcwOCnBCCZgw0g0glBONAQgqQThCGgPQGoBQfiRGmOEZIPAXjsBoPAO4HRThhA0EQSA5BAgaCKJIGg3QdhOCmNU" +
"BoQAijTCIF0FwQxpCHDIPAYYMQGgtCmFcaQtRAjZCyFYSojQ2B2BoKwIYFApBXEIBsIQ1QsAWAWEwaA1xCgjAoIAQBAQ=";
axGrid1.Columns.Add("Column");
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");
axGrid1.EndUpdate();

1034:
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 3)

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(3,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" +
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" +
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" +
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" +
"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" +
"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" +
"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=");
	var_Appearance.Add(1,"CP:3 -2 -2 2 2");
	var_Appearance.Add(4,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" +
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" +
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" +
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" +
"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" +
"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" +
"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=");
	var_Appearance.Add(2,"CP:4 -2 -2 2 2");
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesAtRoot;
axGrid1.HasButtons = EXGRIDLib.ExpandButtonEnum.exCustom;
axGrid1.set_HasButtonsCustom(false,16777216);
axGrid1.set_HasButtonsCustom(true,33554432);
axGrid1.Columns.Add("Column");
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");
axGrid1.EndUpdate();

1033:
How can I change the visual appearance of the +/- buttons, open/close glyphs as current visual theme (method 2)

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(1,"XP:TREEVIEW 2 1");
	var_Appearance.Add(2,"XP:TREEVIEW 2 2");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphOpen,0x1000000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphClose,0x2000000);
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.Columns.Add("Column");
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");
axGrid1.EndUpdate();

1032:
How can I find if the control is running in DPI mode
System.Diagnostics.Debug.Print( axGrid1.FormatABC("dpi = 1 ? `normal/stretch mode` : `dpi mode`",null,null,null).ToString() );

1031:
How can I change the visual appearance of the +/- buttons (method 1)

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABDwCg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" +
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" +
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" +
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJegef4zluaJ3nqPJeCYH4BAeX5TDLBpVGqKRRnwf4flefZtHsX54BYAR/F+EwVnUd5eAMMJKDIChygyIQpAoEh4iIJ5Jlg" +
"XIcgCXpIGoFwnGEQh6BEKBgmMIICHgIJCAiUAzgyUoAhwJohkiRgygwYpiGoKwzGIcgKCkNQNCMRIbCYCRYk4QoMiOchWDwNBjhiJJaDYTRiGiFwlCQAhOE8JBJHITIR" +
"gwZRZFCFCZBkOIUhKTRpCWAwgGYQ4El4NxlBifIWCcCYCFoaoMGaKYyG6GxlBmGJdhkCAWBIeA5g4U4QhMJAImkPIShRVxGgQJRlCIUISh+SJpnCZIeBgFgiHgO4OlOM" +
"INCISByECDQikkGhuh2JwpmqBogCKaYiC6FwhmkQ4yHgYgYiaHopiuaRakCbIsisSpGjYOwaHYKYMCkK5CA2IxrCwCwFigaJrkLTI6lcdANAEgIA=");
	var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABEICg6AADACAxRDgMQBQKAAzAJBIYhiG4cYCgMZhXDOCYXABCEYRXBIZQ7BKNIxjSJ5BhIAAyDSJMjSRJUEhqGCWYDleYYYAKHIMQLJQKQS" +
"BcQR9EaBZBAWTpQC0OJDTJRI4TNAgbSYAAYRqoCb6loTKypaxjCQQIgkUBpGKdBynEYsDwSGyJCCJWyIbpKAwoVbcs4AYhuJpaQi+d5PFbjVT8dLAMBwLA8EwXAJ+Opf" +
"DxXU7eFKpR5fchXTI8UxXFqXZhkeQrfh7KYVRBKdBQRBEFQPJqnahqOpaXo2RoLUJKcQwHTmHYNQTALyuTALZrWeZ3XrgN74LbtZzVQauYRpbCMEr6bpoWLnFi6Ho1U4" +
"llWah1jqSweFqfxPgQQRphi+Yak0YIuqUfJeg8X4rluaZ3niGB+AQHx/EyShjjEVYqiUR5rnmex/GAB5+AIf4gEeXJFHyXZ3gCTAygyAociMKBKEKBIeCiCZyHYFAnCE" +
"eBkh+BghFgRIegOCgYCySAgh4CAkgINAMmMNIgCcCYjn4LoLmMCJGDKC5ijIagoDMYhCAoJg1A0IxEhsJgJFiThChCY5yFYPA0GOGIYloNhNGIaIXCUJACE4TwkEkchO" +
"FSFYlFkXhUCUCQZEYTglCSMxaEkYJIBmFJhDeDZZEYPwlgmQhghaGqVDoa4bGaeY6FGGZNlmFIBGEJ4jhiZQ5AkMhAg6E5JCkRoGCUSQ6B6CYiSCBIOh+DhJmmARiWQO" +
"JtDsCJSCSBwkXSLIRicaZ6HqIIomoIguhwIpphIHoWDsJ4mCGChpmqOpGheLIOkqUo2iya4DjGJxihiQoSj4IJaDaMpCjCWoGg6PgpBiQ4tHcQJQBAgI=");
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphOpen,0x1000000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exTreeGlyphClose,0x2000000);
axGrid1.Columns.Add("Column");
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");
axGrid1.EndUpdate();

1030:
I am using single selection, the question is if possible to select an item only when the user releases the mouse, as currently it selects the item as soon as the user clicks it
// SelectionChanged event - Fired after a new item has been selected.
private void axGrid1_SelectionChanged(object sender, EventArgs e)
{
	System.Diagnostics.Debug.Print( "SelectionChanged" );
}
//this.axGrid1.SelectionChanged += new EventHandler(this.axGrid1_SelectionChanged);

axGrid1.BeginUpdate();
axGrid1.FreezeEvents(true);
axGrid1.SingleSel = true;
axGrid1.SelectOnRelease = true;
(axGrid1.Columns.Add("Column") as EXGRIDLib.Column).FormatColumn = "1 apos `A-Z`";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.set_SelectItem(var_Items.AddItem(""),true);
	var_Items.AddItem("");
axGrid1.FreezeEvents(false);
axGrid1.EndUpdate();

1029:
Is it possible to select nothing
// SelectionChanged event - Fired after a new item has been selected.
private void axGrid1_SelectionChanged(object sender, EventArgs e)
{
	System.Diagnostics.Debug.Print( "SelectionChanged" );
}
//this.axGrid1.SelectionChanged += new EventHandler(this.axGrid1_SelectionChanged);

axGrid1.BeginUpdate();
axGrid1.FreezeEvents(true);
axGrid1.AllowSelectNothing = true;
(axGrid1.Columns.Add("Column") as EXGRIDLib.Column).FormatColumn = "1 apos `A-Z`";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.set_SelectItem(var_Items.AddItem(""),true);
	var_Items.AddItem("");
axGrid1.FreezeEvents(false);
axGrid1.EndUpdate();

1028:
How can I specify the color for control's selection when it loses the focus

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("") as EXGRIDLib.Column);
	var_Column.AllowSizing = false;
	var_Column.AllowDragging = false;
	var_Column.AllowSort = false;
	var_Column.Width = 24;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasButton,true);
(axGrid1.Columns.Add("Column") as EXGRIDLib.Column).FormatColumn = "1 apos `A-Z`";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.set_SelectItem(var_Items.AddItem(""),true);
	var_Items.AddItem("");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exSelBackColorHide,(uint)ColorTranslator.ToWin32(Color.FromArgb(196,196,196)));
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exSelForeColorHide,(uint)ColorTranslator.ToWin32(Color.FromArgb(0,0,1)));
axGrid1.EndUpdate();

1027:
How can I change the background color for checked items (EBN color, frame)

// CellStateChanged event - Fired after cell's state has been changed.
private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent;
axGrid1.DefaultItemHeight = 22;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABUkIQAAYAQGKIcBiAKBQAGYBIJDEMQ3DjAUBjMK4ZwTC4AIQjCK4JDKHYJRpHEZgLBMJAAGIZYhhUYRUiYMkiJBGGDIDiGGI2SJAcbTVIEc" +
"x9EyUJSgSTJOjCMokTTIU4TTLYASbJafJJhWSaAiyMouDIOMg1BDNIw/Hika6jOgKUisNJXRzWIBTbDlOQ3JqnbCjOQRSrQBoNDAMAiiaKlbwJPK9RoieQXfwUAJrXJc" +
"FqXFSLVxNBKAQEBA=");
	var_Appearance.Add(1,"CP:2 1 1 -1 -1");
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null);
	var_ConditionalFormat.BackColor = 0x1000000;
axGrid1.HeaderVisible = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	var_Items.set_SelectItem(hChild,true);
	hChild = var_Items.InsertItem(h,null,"Task 2");
	var_Items.set_CellState(hChild,null,1);
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_CellState(hChild,null,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1026:
How can I change the caption of the checked items (sample 2)

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "%CS0 = 1 ? `<bgcolor=000000><fgcolor=FFFFFF> ` + value + ` </fgcolor></bgcolor>` : value";
axGrid1.HeaderVisible = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	var_Items.set_SelectItem(hChild,true);
	hChild = var_Items.InsertItem(h,null,"Task 2");
	var_Items.set_CellState(hChild,null,1);
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_CellState(hChild,null,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1025:
How can I change the caption of the checked items (sample 1)

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellValueFormat,1);
	var_Column.FormatColumn = "value + (%CS0 = 1 ? `<r><fgcolor=808080>(checked)` : ``)";
axGrid1.HeaderVisible = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	var_Items.set_SelectItem(hChild,true);
	hChild = var_Items.InsertItem(h,null,"Task 2");
	var_Items.set_CellState(hChild,null,1);
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_CellState(hChild,null,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1024:
How can I change the font for the checked items

// CellStateChanged event - Fired after cell's state has been changed.
private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.DefaultItemHeight = 22;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null);
	stdole.IFontDisp f = new stdole.StdFont() as stdole.IFontDisp;
		f.Name = axGrid1.Font.Name;
		f.Size = 12;
	var_ConditionalFormat.Font = (f as stdole.IFontDisp);
axGrid1.HeaderVisible = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	var_Items.set_SelectItem(hChild,true);
	hChild = var_Items.InsertItem(h,null,"Task 2");
	var_Items.set_CellState(hChild,null,1);
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_CellState(hChild,null,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1023:
How can I bold the checked items

// CellStateChanged event - Fired after cell's state has been changed.
private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null);
	var_ConditionalFormat.Bold = true;
axGrid1.HeaderVisible = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	var_Items.set_SelectItem(hChild,true);
	hChild = var_Items.InsertItem(h,null,"Task 2");
	var_Items.set_CellState(hChild,null,1);
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_CellState(hChild,null,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1022:
How can I change the foreground color for checked items

// CellStateChanged event - Fired after cell's state has been changed.
private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null);
	var_ConditionalFormat.ForeColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128));
axGrid1.HeaderVisible = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	var_Items.set_SelectItem(hChild,true);
	hChild = var_Items.InsertItem(h,null,"Task 2");
	var_Items.set_CellState(hChild,null,1);
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_CellState(hChild,null,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1021:
How can I change the background color for checked items (solid color)

// CellStateChanged event - Fired after cell's state has been changed.
private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e)
{
	axGrid1.Refresh();
}
//this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Tasks") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0 = 1",null);
	var_ConditionalFormat.BackColor = (uint)ColorTranslator.ToWin32(Color.FromArgb(255,128,128));
axGrid1.HeaderVisible = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Project");
	int hChild = var_Items.InsertItem(h,null,"Task 1");
	var_Items.set_SelectItem(hChild,true);
	hChild = var_Items.InsertItem(h,null,"Task 2");
	var_Items.set_CellState(hChild,null,1);
	hChild = var_Items.InsertItem(h,null,"Task 3");
	var_Items.set_CellState(hChild,null,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1020:
How can I export the cell's state as well

axGrid1.BeginUpdate();
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	(var_Columns.Add("C1") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	(var_Columns.Add("C2") as EXGRIDLib.Column).FormatColumn = "1 index `A-Z`";
	(var_Columns.Add("C3") as EXGRIDLib.Column).FormatColumn = "100 index ``";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.set_CellState(var_Items.AddItem("Item 2"),null,1);
	var_Items.set_CellState(var_Items.AddItem("Item 3"),null,1);
axGrid1.EndUpdate();
System.Diagnostics.Debug.Print( "Export CSV Items including Check-State:" );
axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Check") as EXGRIDLib.Column);
	var_Column.Position = 0;
	var_Column.FormatColumn = "%CS0";
System.Diagnostics.Debug.Print( axGrid1.Export("",null).ToString() );
axGrid1.Columns.Remove("Check");
axGrid1.EndUpdate();

1019:
Is it possible to customize the editor selection colour of the built in text editor, from standard blue to black

axGrid1.BeginUpdate();
axGrid1.SelBackColor = Color.FromArgb(0,0,0);
axGrid1.SelForeColor = Color.FromArgb(255,255,255);
EXGRIDLib.Editor var_Editor = (axGrid1.Columns.Add("Edit") as EXGRIDLib.Column).Editor;
	var_Editor.EditType = EXGRIDLib.EditTypeEnum.MaskType;
	var_Editor.Mask = ";;;rich";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.AddItem("Just a text");
	var_Items.AddItem("");
axGrid1.EndUpdate();

1018:
Is it possible to customize the editor selection colour of the built in dropdown editor, from standard blue to black

axGrid1.BeginUpdate();
axGrid1.SelBackColor = Color.FromArgb(0,0,0);
axGrid1.SelForeColor = Color.FromArgb(255,255,255);
EXGRIDLib.Editor var_Editor = (axGrid1.Columns.Add("DropDown") as EXGRIDLib.Column).Editor;
	var_Editor.AddItem(1,"This is just the first item",null);
	var_Editor.AddItem(2,"This is just the second item",null);
	var_Editor.AddItem(3,"This is just the third item",null);
	var_Editor.EditType = EXGRIDLib.EditTypeEnum.DropDownType;
	var_Editor.Mask = ";;;rich";
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("");
	var_Items.AddItem("Just a text");
	var_Items.AddItem("");
axGrid1.EndUpdate();

1017:
The BeforeExpandItem event is fired when clicking the drop down filter button. What we can do to prevent that
// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
private void axGrid1_BeforeExpandItem(object sender, AxEXGRIDLib._IGridEvents_BeforeExpandItemEvent e)
{
	System.Diagnostics.Debug.Print( "BeforeExpandItem" );
	System.Diagnostics.Debug.Print( e.item.ToString() );
	System.Diagnostics.Debug.Print( "ColumnFromPoint" );
	System.Diagnostics.Debug.Print( axGrid1.get_ColumnFromPoint(-1,-1).ToString() );
	System.Diagnostics.Debug.Print( "ColumnFromPoint return -1, if the user clicks the +/- glitch, else it returns the index of the column where the click occurs." );
	axGrid1.Items.InsertItem(e.item,null,"new child");
}
//this.axGrid1.BeforeExpandItem += new AxEXGRIDLib._IGridEvents_BeforeExpandItemEventHandler(this.axGrid1_BeforeExpandItem);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	(var_Columns.Add("Items") as EXGRIDLib.Column).DisplayFilterButton = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_ItemHasChildren(var_Items.InsertItem(null,null,"Group 1"),true);
	var_Items.set_ItemHasChildren(var_Items.InsertItem(null,null,"Group 2"),true);
axGrid1.EndUpdate();

1016:
How do I change the drop down filter icon/button (black)

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQ" +
"gmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYTh" +
"dr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x1000000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,-1);
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.None2;
axGrid1.BackColorHeader = Color.FromArgb(0,0,0);
axGrid1.ForeColorHeader = Color.FromArgb(255,255,255);
axGrid1.HeaderVisible = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.AllowSort = false;
	var_Column.AllowDragging = false;
axGrid1.EndUpdate();

1015:
How do I change the drop down filter icon/button (white)

axGrid1.BeginUpdate();
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN" +
"J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" +
"NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" +
"hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" +
"bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" +
"BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI=");
	var_Appearance.Add(1,"CP:2 -4 -4 2 4");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exHeaderFilterBarButton,0x1000000);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exCursorHoverColumn,axGrid1.BackColor);
axGrid1.HeaderAppearance = EXGRIDLib.AppearanceEnum.None2;
axGrid1.HeaderHeight = 24;
axGrid1.BackColorHeader = Color.FromArgb(255,255,255);
axGrid1.HeaderVisible = true;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Filter") as EXGRIDLib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.AllowSort = false;
	var_Column.AllowDragging = false;
axGrid1.EndUpdate();

1014:
How can I draw a solid frame around the the focusing item

axGrid1.BeginUpdate();
axGrid1.SingleSel = false;
axGrid1.DefaultItemHeight = 20;
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.RenderType = -1;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABOkGACAADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBKUQSDqEYyjGLIXAWCYSAAMIwDKAUEwpFAZBhgeDYMiSNoYDJCM4wH" +
"IURRJFCUJSGWQpTgSIgyT5HFIxXKoASbJabZLhWS6EpWOotTbIQQRYCkEyfKKfZyGURZQqOKA1DBZErWTJESRFJqLazgO4LAhyQYrVgAErzVKVCRNOqbJzADApdpGQJT" +
"ULDNTQHRFIyhOSnIRrWbMAhid6JUZiVT4dBOIYhSYANAqCwLFqrDJmWrpV5WZjlZ47V6BdAyXJsIrmFJEXaOGhyDDlGybSDZYryfZhUziUw4XjbWwZDqPF6DKTTdSGLR" +
"EE8WZVlURZvDaep3C+AY8kAYRgGCCBJECUhjDoHROEYWgoAGTQ1CEEx9lGMY0CQUYSnuZQDBGBYFlOH5+H+igGAKAJgEgFgGgGVgDn4CoCmCSA2A6A5hAgDgQgSYRIE4" +
"EoFGGCBiBeBhhkgPgbgcYgICoH4IGGWIOCSBhiGiHgVgoYooFoAoLGIWI+DCCgjCiTgrgII4ImYOoOmOSJ2AYOpWlQDQBICA=");
axGrid1.ShowFocusRect = true;
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exShowFocusRect,0x1000000);
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("P1") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1013:
The frame around the focusing item is not very clear. Can I show it larger or more cleared (sample 2)

axGrid1.BeginUpdate();
axGrid1.SingleSel = false;
axGrid1.DefaultItemHeight = 20;
axGrid1.ShowFocusRect = true;
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.RenderType = -1;
	var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABPEGACAADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBKUQSDqEYyjGLIXAWCYSAAMIwDKAUEwpFAZBhgeCRUgyJI3RgMUIzV" +
"AcRRFEiUJQlIZZCjOAw0SIMU7xZRcNxsACnaZnCR4NiuRYiUhOcqzRIQIQ4CiEahqOgJbDUJYwWZKAyjBY8XTZFCSJCpeJ6egOc5jRxQUp1WAEXx3GSsJKvCZ5cADBY+" +
"VLQNS0JBtMSTKSLaiuWoIJqCPaDRheWKQJh1NSnLqEcjyYANDxDCZlWzAYxWTZ2Uz7N7PbB0HY4DyPGKZYrfESVRbQcZNS6nNigPI9XhfGq6VjRe63ZaOaYpWrnOJqTR" +
"WjOKYujWdZ2BGO5lkuBAAkmcQkDmDBEAwEQJCgGhMGcQ4pkiSxGAAOYmkQIhvkYNg2gSCgyj+LI4GIMIwF2XQoAYAoAmASAWAaAZgggJgKFiT54DYDoDmECBGBKBJgGg" +
"TgWgWYRoFYGIGmGOBqByB5hCgegggiYJYgoJIICIaIeByChiigYgsgsYYYBYMIKCMKJOCuDRjGiOgLg6Y5InYPoPmQCAkmsXAQDQBCAg=");
	var_Appearance.Add(3,"CP:2 -3 0 3 0");
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exShowFocusRect,0x3010101);
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("P1") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1012:
The frame around the focusing item is not very clear. Can I show it larger or more cleared (sample 1)

axGrid1.BeginUpdate();
axGrid1.SingleSel = false;
axGrid1.ShowFocusRect = true;
EXGRIDLib.Appearance var_Appearance = axGrid1.VisualAppearance;
	var_Appearance.Add(1,"gBFLBCJwBAEHhEJAAEhABHoDg6AADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBIZQ7BKNIxjSJwFiCCQwSDKEjyCKcGRHF6MI6gOYpCgOIYjRJNIASV" +
"AceAAGaUZrjSgobjmOYhAJCLqhYIgASXJqLaBlOCaAieSc+QhjQJIJoeCZXU5TFg1BTsOhqEqcRiseaRVDCaIJWzbdYWLDdNQHHKYLjnWorbpSJZ5XjNEySDQkMS9PrE" +
"J7vST8FBCdAABLJUB2BR9RwxRafKpnWwJDpmCaOQLXEB5DK1PyVMTKYrtGy7GrIAJxWxbV4UHh+QABOzIMAvHKJMwvHYcUZne5XVLeF41HbONogPaJZyIAK2cLROq6Xo" +
"7GEcJZEcLASB4DwvgWUZlE6AQQhKAYkkYdA6hyDIwHgSoqFwQgmnsYxjGgSIiBOTpSEiAwRgOJI7j4JAHA6U5wm0MpPlOBIjD8TZiGYCICiCGAuA6AxhAgMgSgOYQ4DY" +
"Bg/g6cw1n+ABOmMMJ9DmCwjnScw4RsVJngkYh4hoKIKmKKI2CmC5ikiQgqgiT5jhyMw8g4QwIn0OIKEiCJhD8DwTGyfA7k0WQOEWEQkGkJhIhKZB5DYSoTiSCQEn4PQO" +
"COXJcCeIJjliaIQk0aRyF4O5llmAhfhgZhJg4ZoYiaAxYn4PZOhOZJaCUZYTiYQw1mcOZUm+HQnHmWh4h6Z4pnYeYfk0eYsmqG4nAgNJ2DqD5DkCWoiGiOgqgyI5omoR" +
"oNiSaQKFKEojCaM4ugSFhOjkAJcieKgDkaH4oioGoOiaKRqgqEoqDddwyhuAxPgOMJ8DyDZqk6NYtCsapmjiLprHqdo6i+K5K1oPhOlqPgKD4DpjnII4yiOewuk6MxtA" +
"sMpSjObQ7EaT4wk6ewYn0PgPAiCJkjeLgDk6X44i4G4OmaORuguEpqDkLAzkaWg+E8GIUmaPIvEOVpzj2Lxbl6eo+G+S5in4OYPmOaJyjuTwjnYWpBg6DAjAqQZwkwJw" +
"NkKcJsEcEJCDBEpaD6Dw8BiapGjGSgfB2RpxmyBwgkicZ8haBw/g+M5TBcPQPlOXJskscp8jsMJMnMLJXDGTZzEyYw2kwMoDlcFw9i2M4/EGUJPg0CxFlENBtCcSJSnQ" +
"fQ0m+SgPHsaJ7lALZLG6XZVHWDRfFqVY1k0ZxdladYTnifJUGaeAWAeMnSGcGWgBObJ3lWbwdjKW5cHcTZPHaLkN4GxXDlFqFsA4uRbBOGAFAEIzAsDEFOBkfYqR4D6A" +
"OBEYo8QuBvAmMceInBDgcD0JwOIqQyJ1DMAwG4IANDnHSMoK4QhOgMBGNEIQvQWAdGenETIswGiddsAAQAgCAgA==");
	var_Appearance.Add(2,"gBFLBCJwBAEHhEJAAEhABeEGACAADACAxRDgMQBQKAAzAJBIYhkGYYYCgMZRUDGCYXABCEYRXBIZQ7BKNIxjSJwFgmEgADDFIBQSLAYROGSDJBGODJDjWGIeQLOEhQH" +
"IMRxPE6UYLhWYpBDKPYcUbGc7yBBMVwGf59XzACoKSheQIVSDQkw6Fo6NYhAxHALyNRkBy8f60KjtGpodDUJYvW5JYyjBZ8EznOqbJBkeJ7BgOe5NQjaD72VgdWQJFSW" +
"JajWYYJDOJY2ZAAE5TVINEwxJbDaylChIdxaF6WAzZEBhBYoATPNLBMrhWqKDw2XaQWBCOgwHYeR5LU7BdRwbIrRq2eAAXbcVyXfDddZlBK+QA0SK9lRVTKvJZmKgBWw" +
"1COSxmAAGw4kcNx1iKFBiCAfQsG8lJemucg7nsXpUHOOxrm+DI3jOH4XAOBx2nscw0j2HhPG4L5uGEVIECQCBCEUAYkGMHQHFGSBlGaAxkEgQgTGCVBsDYQhCgQJZrHK" +
"UggGEShkFGNgIlsNpPnMHJHD+TADAIJIJiIWIeCqChikiIgmgiD5zHyXxgiACJKCuC4jHiZgtg6I4IlkCQwkwOIonMPJjEkFhGhGZBpA4KoMBCGJuEiE5lAkGg7hMY4J" +
"EYVoUCUNAOE6FZl0KWQACWOR2GKF5mBmChchkJRZhoXYaCKKYqGuDglEmNhuhWZpIiYc4dCcCRqGmHZlgm2YxAwSQKESHwkFkKgpiAIAIH4PIimOOg2DiChoiQJRRD+T" +
"ZDHCfwyAyCgyg+JpiioYJ/DgDgIlECQ6lwRAEICA=");
	var_Appearance.Add(3,"CP:2 -2 0 2 0");
(axGrid1.GetOcx() as EXGRIDLib.Grid).SelBackColor = 0x1000000;
axGrid1.SelForeColor = Color.FromArgb(0,0,0);
axGrid1.set_Background(EXGRIDLib.BackgroundPartEnum.exShowFocusRect,0x3ff0000);
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exLinesAtRoot;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("P1") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1011:
I have a column right-aligned. How can I display its check box aligned to the right, as it appears to the left of the cell's caption

axGrid1.BeginUpdate();
axGrid1.ColumnAutoResize = true;
axGrid1.DrawGridLines = EXGRIDLib.GridLinesEnum.exVLines;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	EXGRIDLib.Column var_Column = (var_Columns.Add("Left") as EXGRIDLib.Column);
		var_Column.AllowSizing = false;
		var_Column.Width = 96;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column.FormatColumn = "0 pos `A-Z`";
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Center") as EXGRIDLib.Column);
		var_Column1.HeaderAlignment = EXGRIDLib.AlignmentEnum.CenterAlignment;
		var_Column1.Alignment = var_Column1.HeaderAlignment;
		var_Column1.AllowSizing = false;
		var_Column1.Width = 96;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column1.FormatColumn = "0 pos `A-Z`";
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Right") as EXGRIDLib.Column);
		var_Column2.HeaderAlignment = EXGRIDLib.AlignmentEnum.RightAlignment;
		var_Column2.Alignment = var_Column2.HeaderAlignment;
		var_Column2.AllowSizing = false;
		var_Column2.Width = 96;
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column2.FormatColumn = "0 pos `A-Z`";
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture");
	var_Columns.Add("");
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1);
	var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1);
	var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1);
axGrid1.EndUpdate();

1010:
Can I display the column's multiple-lines caption vertically oriented (method 2)

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 48;
axGrid1.ColumnAutoResize = true;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("And others ...");
	EXGRIDLib.Column var_Column = (var_Columns.Add("") as EXGRIDLib.Column);
		var_Column.HTMLCaption = "First Column";
		var_Column.HeaderVertical = true;
		var_Column.Width = 36;
		var_Column.AllowSizing = false;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8);
		var_Column.Position = 0;
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("") as EXGRIDLib.Column);
		var_Column1.HTMLCaption = "<c><b>Second Column";
		var_Column1.HeaderVertical = true;
		var_Column1.Width = 36;
		var_Column1.AllowSizing = false;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8);
		var_Column1.Position = 1;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("") as EXGRIDLib.Column);
		var_Column2.HTMLCaption = "<r>Third Column";
		var_Column2.HeaderVertical = true;
		var_Column2.Width = 36;
		var_Column2.AllowSizing = false;
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8);
		var_Column2.Position = 2;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1);
	var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1);
	var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1);
axGrid1.EndUpdate();

1009:
Can I display the column's multiple-lines caption vertically oriented (method 1)

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 48;
axGrid1.HeaderSingleLine = false;
axGrid1.ColumnAutoResize = true;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("And others ...");
	EXGRIDLib.Column var_Column = (var_Columns.Add("First Column") as EXGRIDLib.Column);
		var_Column.HeaderVertical = true;
		var_Column.Width = 36;
		var_Column.AllowSizing = false;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8);
		var_Column.Position = 0;
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Second Column") as EXGRIDLib.Column);
		var_Column1.HeaderBold = true;
		var_Column1.HeaderVertical = true;
		var_Column1.Width = 36;
		var_Column1.AllowSizing = false;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8);
		var_Column1.Position = 1;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Third Column") as EXGRIDLib.Column);
		var_Column2.HeaderVertical = true;
		var_Column2.Width = 36;
		var_Column2.AllowSizing = false;
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellPaddingLeft,8);
		var_Column2.Position = 2;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1);
	var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1);
	var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1);
axGrid1.EndUpdate();

1008:
Can I display the column's caption vertically oriented (method 2)

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 48;
axGrid1.ColumnAutoResize = true;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("And others ...");
	EXGRIDLib.Column var_Column = (var_Columns.Add("") as EXGRIDLib.Column);
		var_Column.HTMLCaption = "First";
		var_Column.HeaderVertical = true;
		var_Column.Width = 20;
		var_Column.AllowSizing = false;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column.Position = 0;
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("") as EXGRIDLib.Column);
		var_Column1.HTMLCaption = "<c><b>Second";
		var_Column1.HeaderVertical = true;
		var_Column1.Width = 20;
		var_Column1.AllowSizing = false;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column1.Position = 1;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("") as EXGRIDLib.Column);
		var_Column2.HTMLCaption = "<r>Third";
		var_Column2.HeaderVertical = true;
		var_Column2.Width = 20;
		var_Column2.AllowSizing = false;
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column2.Position = 2;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1);
	var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1);
	var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1);
axGrid1.EndUpdate();

1007:
Can I display the column's caption vertically oriented (method 1)

axGrid1.BeginUpdate();
axGrid1.HeaderHeight = 48;
axGrid1.ColumnAutoResize = true;
EXGRIDLib.Columns var_Columns = axGrid1.Columns;
	var_Columns.Add("And others ...");
	EXGRIDLib.Column var_Column = (var_Columns.Add("First") as EXGRIDLib.Column);
		var_Column.HeaderVertical = true;
		var_Column.Width = 20;
		var_Column.AllowSizing = false;
		var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column.Position = 0;
	EXGRIDLib.Column var_Column1 = (var_Columns.Add("Second") as EXGRIDLib.Column);
		var_Column1.HeaderBold = true;
		var_Column1.HeaderVertical = true;
		var_Column1.Width = 20;
		var_Column1.AllowSizing = false;
		var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column1.Position = 1;
	EXGRIDLib.Column var_Column2 = (var_Columns.Add("Third") as EXGRIDLib.Column);
		var_Column2.HeaderVertical = true;
		var_Column2.Width = 20;
		var_Column2.AllowSizing = false;
		var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
		var_Column2.Position = 2;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellState(var_Items.AddItem("Item 1"),3,1);
	var_Items.set_CellState(var_Items.AddItem("Item 2"),2,1);
	var_Items.set_CellState(var_Items.AddItem("Item 3"),1,1);
axGrid1.EndUpdate();

1006:
How do I automatically bold items being checked

// CellStateChanged event - Fired after cell's state has been changed.
private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e)
{
}
//this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged);

axGrid1.BeginUpdate();
axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent;
EXGRIDLib.ConditionalFormat var_ConditionalFormat = axGrid1.ConditionalFormats.Add("%CS0","check");
	var_ConditionalFormat.Bold = true;
(axGrid1.Columns.Add("Items") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
(axGrid1.Columns.Add(axGrid1.ConditionalFormats["check"].Expression) as EXGRIDLib.Column).FormatColumn = axGrid1.ConditionalFormats["check"].Expression;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Item 1");
	var_Items.set_CellState(var_Items.AddItem("Item 2"),0,1);
	var_Items.AddItem("Item 3");
axGrid1.EndUpdate();

1005:
How can I use the CellState with ConditionalFormat/ComputedField/FormatColumn

// CellStateChanged event - Fired after cell's state has been changed.
private void axGrid1_CellStateChanged(object sender, AxEXGRIDLib._IGridEvents_CellStateChangedEvent e)
{
}
//this.axGrid1.CellStateChanged += new AxEXGRIDLib._IGridEvents_CellStateChangedEventHandler(this.axGrid1_CellStateChanged);

axGrid1.BeginUpdate();
axGrid1.LinesAtRoot = EXGRIDLib.LinesAtRootEnum.exGroupLinesInsideLeaf;
axGrid1.SelBackMode = EXGRIDLib.BackModeEnum.exTransparent;
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Items") as EXGRIDLib.Column);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column);
	var_Column1.FormatColumn = "%CS0";
	var_Column1.Caption = var_Column1.FormatColumn;
	var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504);
	var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor));
EXGRIDLib.Items var_Items = axGrid1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Item 1");
	var_Items.set_CellState(var_Items.InsertItem(h,null,"Item 2"),0,1);
	var_Items.set_CellState(var_Items.InsertItem(h,null,"Item 3"),0,1);
	var_Items.set_ExpandItem(h,true);
axGrid1.EndUpdate();

1004:
How can I use the CellData with ConditionalFormat/ComputedField/FormatColumn

axGrid1.BeginUpdate();
axGrid1.Columns.Add("Items");
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column);
	var_Column.FormatColumn = "%CD0";
	var_Column.Caption = var_Column.FormatColumn;
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504);
	var_Column.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor));
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.set_CellData(var_Items.AddItem("Item 1"),0,1234);
	var_Items.set_CellData(var_Items.AddItem("Item 2"),0,"this is just an user data");
	var_Items.set_CellData(var_Items.AddItem("Item 3"),0,Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
axGrid1.EndUpdate();

1003:
How can I use the CellValue/CellCaption with ConditionalFormat/ComputedField/FormatColumn

axGrid1.BeginUpdate();
EXGRIDLib.Column var_Column = (axGrid1.Columns.Add("Items") as EXGRIDLib.Column);
	EXGRIDLib.Editor var_Editor = var_Column.Editor;
		var_Editor.EditType = EXGRIDLib.EditTypeEnum.DropDownListType;
		var_Editor.AddItem(1,"Item 1",null);
		var_Editor.AddItem(2,"Item 2",null);
		var_Editor.AddItem(3,"Item 3",null);
EXGRIDLib.Column var_Column1 = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column);
	var_Column1.FormatColumn = "%0";
	var_Column1.Caption = var_Column1.FormatColumn;
	var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504);
	var_Column1.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column1.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor));
	var_Column1.AllowSizing = false;
EXGRIDLib.Column var_Column2 = (axGrid1.Columns.Add("Format") as EXGRIDLib.Column);
	var_Column2.FormatColumn = "%C0";
	var_Column2.Caption = var_Column2.FormatColumn;
	var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exCellForeColor,8421504);
	var_Column2.set_Def(EXGRIDLib.DefColumnEnum.exHeaderForeColor,var_Column2.get_Def(EXGRIDLib.DefColumnEnum.exCellForeColor));
	var_Column2.AllowSizing = false;
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem(1);
	var_Items.set_CellValue(var_Items.AddItem(0),0,2);
	var_Items.AddItem(2);
axGrid1.EndUpdate();

1002:
Can I display the radio-button with a solid color

axGrid1.BeginUpdate();
axGrid1.set_RadioImage(false,32699122);
axGrid1.set_RadioImage(true,16777216);
(axGrid1.Columns.Add("Check") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasRadioButton,true);
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Radio 1");
	var_Items.set_CellState(var_Items.AddItem("Radio 2"),0,1);
	var_Items.AddItem("Radio 1");
axGrid1.EndUpdate();

1001:
Can I display the check-box with a solid color

axGrid1.BeginUpdate();
axGrid1.set_CheckImage(EXGRIDLib.CheckStateEnum.Unchecked,32699122);
axGrid1.set_CheckImage(EXGRIDLib.CheckStateEnum.Checked,16777216);
(axGrid1.Columns.Add("Check") as EXGRIDLib.Column).set_Def(EXGRIDLib.DefColumnEnum.exCellHasCheckBox,true);
EXGRIDLib.Items var_Items = axGrid1.Items;
	var_Items.AddItem("Check 1");
	var_Items.set_CellState(var_Items.AddItem("Check 2"),0,1);
	var_Items.AddItem("Check 3");
axGrid1.EndUpdate();