500:
How can I filter items for dates before a specified date

extree1.BeginUpdate();
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Dates") as exontrol.EXTREELib.Column);
	var_Column.SortType = exontrol.EXTREELib.SortTypeEnum.SortDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.DisplayFilterDate = true;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exNoItems;
	var_Column.Filter = "to 12/27/2010";
	var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exDate;
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("12/27/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/28/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/29/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/30/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/31/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
extree1.ApplyFilter();
extree1.EndUpdate();

499:
Is it possible to filter dates

extree1.BeginUpdate();
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Dates") as exontrol.EXTREELib.Column);
	var_Column.SortType = exontrol.EXTREELib.SortTypeEnum.SortDate;
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.DisplayFilterDate = true;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("12/27/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/28/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/29/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/30/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("12/31/2010",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
extree1.EndUpdate();

498:
Is it possible to change the Exclude field name to something different, in the drop down filter window

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarExclude,"Leaving out");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowExclude | exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

497:
How can I display the Exclude field in the drop down filter window

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowExclude | exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

496:
Is it possible to show and ensure the focused item from the control, in the drop down filter window

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowFocusItem | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.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.set_SelectItem(var_Items.InsertItem(h,null,"Child 2"),true);
	var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();

495:
Is it possible to show only blanks items with no listed items from the control

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowBlanks | exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

494:
How can I include the blanks items in the drop down filter window

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowBlanks | exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

493:
How can I select multiple items in the drop down filter window, using check-boxes

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exShowCheckBox;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

492:
Is it possible to allow a single item being selected in the drop down filter window

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = false;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exSingleSel;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

491:
How can I display no (All) item in the drop down filter window

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarAll,"");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

490:
Is it possible to display no items in the drop down filter window, so only the pattern is visible

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Items") as exontrol.EXTREELib.Column);
	var_Column.DisplayFilterButton = true;
	var_Column.DisplayFilterPattern = true;
	var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exNoItems;
exontrol.EXTREELib.Items var_Items = extree1.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");
extree1.EndUpdate();

489:
How do I hide the selection

extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
extree1.SelForeColor = extree1.ForeColor;
extree1.SelBackColor = extree1.BackColor;
extree1.ShowFocusRect = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	exontrol.EXTREELib.Column var_Column = (var_Columns.Add("Format") as exontrol.EXTREELib.Column);
		var_Column.FormatColumn = "type(value) in (0,1) ? 'null' : ( dbl(value)<0 ? '<fgcolor=FF0000>'+ (value format '2|.|3|,|1' ) : (dbl(value)>0 ? '<fgcolor=00" +
"00FF>+'+(value format '2|.|3|,' ): '0.00') )";
		var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(10);
	var_Items.AddItem(-8);
extree1.EndUpdate();

488:
How do I access the cells, or how do I get the values in the columns
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("C1");
	var_Columns.Add("C2");
	var_Columns.Add("C3");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Item 1");
	var_Items.set_CellCaption(h,1,"SubItem 1.1");
	var_Items.set_CellCaption(h,2,"SubItem 1.2");
	System.Diagnostics.Debug.Print( var_Items.get_CellCaption(h,0).ToString() );

487:
Is it possible to load child items when clicking the +/- button

// BeforeExpandItem event - Fired before an item is about to be expanded (collapsed).
private void extree1_BeforeExpandItem(object sender,int   Item,ref object   Cancel)
{
	exontrol.EXTREELib.Items var_Items = extree1.Items;
		var_Items.InsertItem(Item,null,"new");
		var_Items.set_ItemHasChildren(var_Items.InsertItem(Item,null,"new"),true);
		var_Items.InsertItem(Item,null,"new");
}
//this.extree1.BeforeExpandItem += new exontrol.EXTREELib.exg2antt.BeforeExpandItemEventHandler(this.extree1_BeforeExpandItem);

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.set_ItemHasChildren(var_Items.AddItem("aka"),true);
	var_Items.AddItem("next item");

486:
How can I change the check-boxes appearance

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Default") as exontrol.EXTREELib.Column);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
exontrol.EXTREELib.Items var_Items = extree1.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);
exontrol.EXTREELib.Appearance var_Appearance = extree1.VisualAppearance;
	var_Appearance.Add(1,"XP:Button 3 12");
	var_Appearance.Add(2,"XP:Button 3 11");
	var_Appearance.Add(3,"XP:Button 3 10");
extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Unchecked,16777216);
extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Checked,33554432);
extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.PartialChecked,50331648);

485:
How can I initiate the OLE Drag and Drop support

// OLEStartDrag event is not supported. Use the DragEnter,DragLeave,DragOver, DragDrop ... events.
extree1.OLEDropMode = exontrol.EXTREELib.exOLEDropModeEnum.exOLEDropManual;
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.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);

484:
How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)

extree1.BeginUpdate();
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1","K1");
	var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat1 = extree1.ConditionalFormats.Add("1","K2");
	var_ConditionalFormat1.BackColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat1.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x2;
extree1.MarkSearchColumn = false;
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Column 1");
	var_Columns.Add("Column 2");
	var_Columns.Add("Column 3");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(null);
	var_Items.AddItem(null);
	var_Items.AddItem(null);
extree1.EndUpdate();

483:
Is it possible to display empty strings for 0 values

(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).FormatColumn = "dbl(value) ? currency(dbl(value)) : ``";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(1.23);
	var_Items.AddItem(2.34);
	var_Items.AddItem(0);
	var_Items.AddItem(10000.99);

482:
Is it possible to display empty strings for 0 values

extree1.Columns.Add("Number");
(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).ComputedField = "%0 ? currency(%0) : ``";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(1.23);
	var_Items.AddItem(2.34);
	var_Items.AddItem(0);
	var_Items.AddItem(10000.99);

481:
How can I get the list of items as they are displayed
extree1.BeginUpdate();
extree1.BackColorAlternate = Color.FromArgb(240,240,240);
extree1.Columns.Add("Names");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("Mantel");
	var_Items.AddItem("Mechanik");
	var_Items.AddItem("Motor");
	var_Items.AddItem("Murks");
	var_Items.AddItem("Märchen");
	var_Items.AddItem("Möhren");
	var_Items.AddItem("Mühle");
extree1.Columns[0].SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending;
extree1.EndUpdate();
System.Diagnostics.Debug.Print( extree1.GetItems(1).ToString() );

480:
Is posible to reduce the size of the picture to be shown in the column's caption

extree1.BeginUpdate();
extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
extree1.HeaderHeight = 48;
(extree1.Columns.Add("DefaultSize") as exontrol.EXTREELib.Column).HTMLCaption = "Default-Size <img>pic1</img> Picture";
(extree1.Columns.Add("CustomSize") as exontrol.EXTREELib.Column).HTMLCaption = "Custom-Size <img>pic1:16</img> Picture";
extree1.EndUpdate();

479:
How can I change the color, font, bold etc for the items/cells in the same column or for the entire column

extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null);
	var_ConditionalFormat.Bold = true;
	var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
extree1.Columns.Add("C1");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column);
	var_Column.HeaderBold = true;
	var_Column.HTMLCaption = "<fgcolor=FF0000>C2";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.set_CellCaption(var_Items.AddItem(10),1,11);
	var_Items.set_CellCaption(var_Items.AddItem(12),1,13);
extree1.EndUpdate();

478:
The item is not getting selected when clicking the cell's checkbox. What should I do

// CellStateChanged event - Fired after cell's state has been changed.
private void extree1_CellStateChanged(object sender,int   Item,int   ColIndex)
{
	extree1.Items.set_SelectItem(Item,true);
}
//this.extree1.CellStateChanged += new exontrol.EXTREELib.exg2antt.CellStateChangedEventHandler(this.extree1_CellStateChanged);

(extree1.Columns.Add("Check") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(0);
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);

477:
Is it possible to limit the height of the item while resizing

// AddItem event - Occurs after a new Item has been inserted to Items collection.
private void extree1_AddItem(object sender,int   Item)
{
	extree1.Items.set_ItemMinHeight(Item,18);
	extree1.Items.set_ItemMaxHeight(Item,72);
}
//this.extree1.AddItem += new exontrol.EXTREELib.exg2antt.AddItemEventHandler(this.extree1_AddItem);

extree1.BeginUpdate();
extree1.ItemsAllowSizing = exontrol.EXTREELib.ItemsAllowSizingEnum.exResizeItem;
extree1.ScrollBySingleLine = false;
extree1.BackColorAlternate = Color.FromArgb(240,240,240);
extree1.Columns.Add("Names");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("Mantel");
	var_Items.AddItem("Mechanik");
	var_Items.AddItem("Motor");
	var_Items.AddItem("Murks");
	var_Items.AddItem("Märchen");
	var_Items.AddItem("Möhren");
	var_Items.AddItem("Mühle");
extree1.Columns[0].SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending;
extree1.EndUpdate();

476:
Is it possible to copy the hierarchy of the control using the GetItems method

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Def");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
extree1.PutItems(extree1.GetItems(-1),null);

475:
How can I show the child items with no identation

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesOutside;
extree1.Indent = 12;
extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exThinLine;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");

474:
Is there other ways of showing the hierarchy lines (exGroupLinesAtRoot)

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);

473:
Is there other ways of showing the hierarchy lines (exGroupLinesOutside)

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesOutside;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");

472:
Is there other ways of showing the hierarchy lines (exGroupLinesInsideLeaf)

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesInsideLeaf;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);

471:
Is there other ways of showing the hierarchy lines (exGroupLinesInside)

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesInside;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);

470:
Is there other ways of showing the hierarchy lines (exGroupLines)

extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLines;
extree1.Indent = 12;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(var_Items.InsertItem(h,null,"Child 2"),null,"SubChild 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);

469:
Does your control supports multiple lines tooltip

extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
extree1.ToolTipDelay = 1;
(extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "<br><font Tahoma;10>This</font> is a <b>multi-lines</b> tooltip assigned to a column. The tooltip supports built-in HTML tags, " +
"icons and pictures.<br><br><br><img>pic1</img> picture ... <br><br>";

468:
How can I prevent highlighting the column from the cursor - point

extree1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZLhEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJ" +
"gEgI=");
extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exCursorHoverColumn,0x1000000);
(extree1.Columns.Add("S") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("Level 1") as exontrol.EXTREELib.Column).LevelKey = 1;
(extree1.Columns.Add("Level 2") as exontrol.EXTREELib.Column).LevelKey = 1;
(extree1.Columns.Add("Level 3") as exontrol.EXTREELib.Column).LevelKey = 1;
(extree1.Columns.Add("E1") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("E2") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("E3") as exontrol.EXTREELib.Column).Width = 32;
(extree1.Columns.Add("E4") as exontrol.EXTREELib.Column).Width = 32;

467:
Is there any option to show the tooltip programmatically

// MouseMove event - Occurs when the user moves the mouse.
private void extree1_MouseMoveEvent(object sender,short   Button,short   Shift,int   X,int   Y)
{
	extree1.ShowToolTip(extree1.get_ItemFromPoint(-1,-1,c,hit).ToString(),"","8","8",null);
}
//this.extree1.MouseMoveEvent += new exontrol.EXTREELib.exg2antt.MouseMoveEventHandler(this.extree1_MouseMoveEvent);

extree1.BeginUpdate();
extree1.Columns.Add("Def");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
extree1.EndUpdate();

466:
Is it possible to prevent changing the rows/items colors by selection

extree1.SelBackMode = exontrol.EXTREELib.BackModeEnum.exTransparent;
(extree1.Columns.Add("HTML") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>.");
	var_Items.set_SelectItem(var_Items.AddItem("<font ;6>This</font> <b>is</b> another <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></font>."),true);

465:
Is it possible to specify the cell's value but still want to display some formatted text instead the value

extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
extree1.Columns.Add("Value");
extree1.Columns.Add("FormatCell");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem(1);
	var_Items.set_CellCaption(h,1,12);
	var_Items.set_FormatCell(h,1,"currency(value)");
	h = var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaptionFormat(h,1,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
	var_Items.set_FormatCell(h,1,"longdate(value) replace '2001' with '<b>2001</b>'");
extree1.EndUpdate();

464:
How can I simulate displaying groups

extree1.BeginUpdate();
extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exNoLine;
extree1.ScrollBySingleLine = true;
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Name");
	var_Columns.Add("A");
	var_Columns.Add("B");
	var_Columns.Add("C");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Group 1");
	var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXTREELib.DividerAlignmentEnum.DividerBoth);
	var_Items.set_ItemHeight(h,24);
	var_Items.set_SortableItem(h,false);
	int h1 = var_Items.InsertItem(h,null,"Child 1");
	var_Items.set_CellCaption(h1,1,1);
	var_Items.set_CellCaption(h1,2,2);
	var_Items.set_CellCaption(h1,3,3);
	h1 = var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_CellCaption(h1,1,4);
	var_Items.set_CellCaption(h1,2,5);
	var_Items.set_CellCaption(h1,3,6);
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("Group 2");
	var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment);
	var_Items.set_ItemDivider(h,0);
	var_Items.set_ItemDividerLineAlignment(h,exontrol.EXTREELib.DividerAlignmentEnum.DividerBoth);
	var_Items.set_ItemHeight(h,24);
	var_Items.set_SortableItem(h,false);
	h1 = var_Items.InsertItem(h,null,"Child 1");
	var_Items.set_CellCaption(h1,1,1);
	var_Items.set_CellCaption(h1,2,2);
	var_Items.set_CellCaption(h1,3,3);
	h1 = var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_CellCaption(h1,1,4);
	var_Items.set_CellCaption(h1,2,5);
	var_Items.set_CellCaption(h1,3,6);
	var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();

463:
How can I collapse all items

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_ExpandItem(0,false);
extree1.EndUpdate();

462:
How can I expand all items

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root 1");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	h = var_Items.AddItem("Root 2");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.set_ExpandItem(0,true);
extree1.EndUpdate();

461:
Can I use PNG images to display pictures in the control

extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\card.png");
extree1.HeaderHeight = 48;
(extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column).HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture";

460:
Is it possible to move an item from a parent to another

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("A");
	var_Items.AddItem("B");
	var_Items.InsertItem(var_Items.AddItem("C"),"","D");
	var_Items.SetParent(var_Items.get_FindItem("D",0,null),var_Items.get_FindItem("A",0,null));
extree1.EndUpdate();

459:
How can I change the identation for an item

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("A");
	var_Items.AddItem("B");
	var_Items.InsertItem(var_Items.AddItem("C"),"","D");
	var_Items.SetParent(var_Items.get_FindItem("D",0,null),0);
extree1.EndUpdate();

458:
How can I filter programatically using more columns

extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Car");
	var_Columns.Add("Equipment");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag");
	var_Items.set_CellCaption(var_Items.AddItem("Toyota"),1,"Air Bag,Air condition");
	var_Items.set_CellCaption(var_Items.AddItem("Ford"),1,"Air condition");
	var_Items.set_CellCaption(var_Items.AddItem("Nissan"),1,"Air Bag,ABS,ESP");
	var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"Air Bag, ABS,ESP");
	var_Items.set_CellCaption(var_Items.AddItem("Mazda"),1,"ABS,ESP");
exontrol.EXTREELib.Column var_Column = extree1.Columns["Car"];
	var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exFilter;
	var_Column.Filter = "Mazda";
exontrol.EXTREELib.Column var_Column1 = extree1.Columns["Equipment"];
	var_Column1.FilterType = exontrol.EXTREELib.FilterTypeEnum.exPattern;
	var_Column1.Filter = "*ABS*|*ESP*";
extree1.ApplyFilter();
extree1.EndUpdate();

457:
Is it possible to colour a particular column, I mean the cell's foreground color

extree1.BeginUpdate();
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null);
	var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Column 1");
	var_Columns.Add("Column 2");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
	var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
	var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
extree1.EndUpdate();

456:
Is it possible to colour a particular column for specified values

extree1.BeginUpdate();
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("int(%1) in (3,4,5)",null);
	var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0);
	var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1;
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Column 1");
	var_Columns.Add("Column 2");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
	var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
	var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
extree1.EndUpdate();

455:
Is it possible to colour a particular column

extree1.BeginUpdate();
extree1.MarkSearchColumn = false;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellBackColor,255);
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.set_CellCaption(var_Items.AddItem(0),1,1);
	var_Items.set_CellCaption(var_Items.AddItem(2),1,3);
	var_Items.set_CellCaption(var_Items.AddItem(4),1,5);
extree1.EndUpdate();

454:
How do i get all the children items that are under a certain parent Item handle
extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("P");
exontrol.EXTREELib.Items var_Items = extree1.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);
exontrol.EXTREELib.Items var_Items1 = extree1.Items;
	int hChild = var_Items1.get_ItemChild(var_Items1.FirstVisibleItem);
	System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(hChild,0).ToString() );
	System.Diagnostics.Debug.Print( var_Items1.get_CellCaption(var_Items1.get_NextSiblingItem(hChild),0).ToString() );
extree1.EndUpdate();

453:
How can I get the caption of focused item
// SelectionChanged event - Fired after a new item has been selected.
private void extree1_SelectionChanged(object sender)
{
	exontrol.EXTREELib.Items var_Items = extree1.Items;
		System.Diagnostics.Debug.Print( "Handle" );
		System.Diagnostics.Debug.Print( var_Items.FocusItem.ToString() );
		System.Diagnostics.Debug.Print( "Caption" );
		System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.FocusItem,0).ToString() );
}
//this.extree1.SelectionChanged += new exontrol.EXTREELib.exg2antt.SelectionChangedEventHandler(this.extree1_SelectionChanged);

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("R1");
	var_Items.InsertItem(h,null,"Cell 1.1");
	var_Items.InsertItem(h,null,"Cell 1.2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("R2");
	var_Items.InsertItem(h,null,"Cell 2.1");
	var_Items.InsertItem(h,null,"Cell 2.2");
	var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();

452:
How can I get the caption of selected item
// SelectionChanged event - Fired after a new item has been selected.
private void extree1_SelectionChanged(object sender)
{
	exontrol.EXTREELib.Items var_Items = extree1.Items;
		System.Diagnostics.Debug.Print( "Handle" );
		System.Diagnostics.Debug.Print( var_Items.get_SelectedItem(0).ToString() );
		System.Diagnostics.Debug.Print( "Caption" );
		System.Diagnostics.Debug.Print( var_Items.get_CellCaption(var_Items.get_SelectedItem(0),0).ToString() );
}
//this.extree1.SelectionChanged += new exontrol.EXTREELib.exg2antt.SelectionChangedEventHandler(this.extree1_SelectionChanged);

extree1.BeginUpdate();
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
extree1.Columns.Add("Items");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("R1");
	var_Items.InsertItem(h,null,"Cell 1.1");
	var_Items.InsertItem(h,null,"Cell 1.2");
	var_Items.set_ExpandItem(h,true);
	h = var_Items.AddItem("R2");
	var_Items.InsertItem(h,null,"Cell 2.1");
	var_Items.InsertItem(h,null,"Cell 2.2");
	var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();

451:
Can I display the cell's check box after the text

exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,check");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 1"),0,true);
	var_Items.set_CellHasCheckBox(var_Items.AddItem("Caption 2"),0,true);

450:
Can I change the order of the parts in the cell, as checkbox after the text, and so on

extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Text");
	var_Items.set_CellImage(h,0,1);
	var_Items.set_CellHasCheckBox(h,0,true);

449:
Can I have an image displayed after the text. Can I get that effect without using HTML content

extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellDrawPartsOrder,"caption,icon,check,icons,picture");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Text");
	var_Items.set_CellImage(h,0,1);

448:
Does your control support RightToLeft property for RTL languages or right to left

extree1.BeginUpdate();
extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("P1") as exontrol.EXTREELib.Column);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true);
	var_Column.PartialCheck = true;
exontrol.EXTREELib.Items var_Items = extree1.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);
extree1.RightToLeft = true;
extree1.EndUpdate();

447:
Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right

extree1.BeginUpdate();
extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("C1");
	var_Columns.Add("C2");
	var_Columns.Add("C3");
	var_Columns.Add("C4");
	var_Columns.Add("C5");
	var_Columns.Add("C6");
	var_Columns.Add("C7");
	var_Columns.Add("C8");
extree1.RightToLeft = true;
extree1.EndUpdate();

446:
How can I use the CASE statement (CASE usage)

extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("CASE - statment") as exontrol.EXTREELib.Column);
	var_Column.ComputedField = "%0 case (default:'not found';1:%0;2:2*%0;3:3*%0;4:4*%0;5:5*%0;7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen';14:'Fourt" +
"heen')";
	var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(0);
	var_Items.AddItem(1);
	var_Items.AddItem(2);
extree1.EndUpdate();

445:
How can I use the CASE statement (CASE usage)

extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("CASE - statment") as exontrol.EXTREELib.Column);
	var_Column.ComputedField = "%0 case (default:'not found';1:'One';2:'Two';3:'Three';4:'Four';5:'Five';7:'Seven';8:'Eight';9:'Nine';11:'Eleven';13:'Thirtheen" +
"';14:'Fourtheen')";
	var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(0);
	var_Items.AddItem(1);
	var_Items.AddItem(2);
extree1.EndUpdate();

444:
I have seen the IN function but it returns -1 or 0. How can I display the value being found ( SWITCH usage )

extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("SWITCH - statment") as exontrol.EXTREELib.Column);
	var_Column.ComputedField = "%0 switch ('not found', 1,2,3,4,5,7,8,9,11,13,14)";
	var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(0);
	var_Items.AddItem(1);
	var_Items.AddItem(2);
extree1.EndUpdate();

443:
I have a large collection of constant values and using or operator is a time consuming (IN usage). Is there any way to increase the speed to check if a value maches the collection

extree1.BeginUpdate();
(extree1.Columns.Add("Value") as exontrol.EXTREELib.Column).Width = 24;
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("IN - statment") as exontrol.EXTREELib.Column);
	var_Column.ComputedField = "%0 in (1,2,3,4,5,7,8,9,11,13,14) ? 'found' : ''";
	var_Column.ToolTip = var_Column.ComputedField;
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(0);
	var_Items.AddItem(1);
	var_Items.AddItem(2);
extree1.EndUpdate();

442:
Is is possible to use HTML tags to display in the filter caption

extree1.BeginUpdate();
extree1.FilterBarPromptVisible = true;
extree1.FilterBarCaption = "This is a bit of text being displayed in the filter bar.";
extree1.Columns.Add("");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("Item 1");
	var_Items.AddItem("Item 2");
	var_Items.AddItem("Item 3");
extree1.EndUpdate();

441:
How can I find the number of items after filtering
extree1.BeginUpdate();
extree1.Columns.Add("");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("");
	var_Items.set_CellCaption(h,0,var_Items.VisibleItemCount);
extree1.EndUpdate();

440:
How can I change the filter caption

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
extree1.FilterBarPromptPattern = "london robert";
extree1.FilterBarCaption = "<r>Found: ... ";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

439:
While using the filter prompt is it is possible to use wild characters

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptPattern;
extree1.FilterBarPromptPattern = "lon* seat*";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

438:
How can I list all items that contains any of specified words, not necessary at the beggining

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "london davolio";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

437:
How can I list all items that contains any of specified words, not strings

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "london nancy";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

436:
How can I list all items that contains all specified words, not strings

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptWords | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
extree1.FilterBarPromptPattern = "london robert";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

435:
I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptCaseSensitive | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "Anne";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

434:
Is it possible to list only items that ends with any of specified strings

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptEndWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "Fuller";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

433:
Is it possible to list only items that ends with any of specified strings

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptEndWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "Fuller";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

432:
Is it possible to list only items that starts with any of specified strings

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "An M";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

431:
Is it possible to list only items that starts with specified string

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWith;
extree1.FilterBarPromptColumns = "0";
extree1.FilterBarPromptPattern = "A";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

430:
How can I specify that the list should include any of the seqeunces in the pattern

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny;
extree1.FilterBarPromptPattern = "london seattle";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

429:
How can I specify that all sequences in the filter pattern must be included in the list

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptType = exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll;
extree1.FilterBarPromptPattern = "london manager";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

428:
How do I change at runtime the filter prompt

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptPattern = "london manager";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

427:
How do I specify to filter only a single column when using the filter prompt

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPromptColumns = "2,3";
extree1.FilterBarPromptPattern = "london";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

426:
How do I change the prompt or the caption being displayed in the filter bar

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
extree1.FilterBarPrompt = "changed";
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
extree1.EndUpdate();

425:
How do I enable the filter prompt feature

extree1.BeginUpdate();
extree1.ColumnAutoResize = true;
extree1.ContinueColumnScroll = false;
extree1.MarkSearchColumn = false;
extree1.SearchColumnIndex = 1;
extree1.FilterBarPromptVisible = true;
exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	(var_Columns.Add("Name") as exontrol.EXTREELib.Column).Width = 96;
	(var_Columns.Add("Title") as exontrol.EXTREELib.Column).Width = 96;
	var_Columns.Add("City");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h0 = var_Items.AddItem("Nancy Davolio");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Andrew Fuller");
	var_Items.set_CellCaption(h0,1,"Vice President, Sales");
	var_Items.set_CellCaption(h0,2,"Tacoma");
	var_Items.set_SelectItem(h0,true);
	h0 = var_Items.AddItem("Janet Leverling");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Kirkland");
	h0 = var_Items.AddItem("Margaret Peacock");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"Redmond");
	h0 = var_Items.AddItem("Steven Buchanan");
	var_Items.set_CellCaption(h0,1,"Sales Manager");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Michael Suyama");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Robert King");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
	h0 = var_Items.AddItem("Laura Callahan");
	var_Items.set_CellCaption(h0,1,"Inside Sales Coordinator");
	var_Items.set_CellCaption(h0,2,"Seattle");
	h0 = var_Items.AddItem("Anne Dodsworth");
	var_Items.set_CellCaption(h0,1,"Sales Representative");
	var_Items.set_CellCaption(h0,2,"London");
extree1.EndUpdate();

424:
I have an EBN file how can I apply different colors to it, so no need to create a new one

extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn");
extree1.SelBackColor = extree1.BackColor;
extree1.SelForeColor = extree1.ForeColor;
extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exNoLine;
extree1.Columns.Add("Default");
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	int hC = var_Items.InsertItem(h,null,"Default");
	var_Items.set_ItemBackColor32(hC,0x1000000);
	var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
	hC = var_Items.InsertItem(h,null,"Light Green");
	var_Items.set_ItemBackColor32(hC,0x100ff00);
	var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
	hC = var_Items.InsertItem(h,null,"Dark Green");
	var_Items.set_ItemBackColor32(hC,0x1007f00);
	var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
	hC = var_Items.InsertItem(h,null,"Magenta");
	var_Items.set_ItemBackColor32(hC,0x1ff7fff);
	var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
	hC = var_Items.InsertItem(h,null,"Yellow");
	var_Items.set_ItemBackColor32(hC,0x17fffff);
	var_Items.set_ItemHeight(var_Items.InsertItem(h,null,""),6);
	var_Items.set_ExpandItem(h,true);

423:
How can I change the foreground color for a particular column

exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exHeaderForeColor,8439039);
	var_Columns.Add("Column 3");

422:
How can I change the background color for a particular column

exontrol.EXTREELib.Columns var_Columns = extree1.Columns;
	var_Columns.Add("Column 1");
	(var_Columns.Add("Column 2") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exHeaderBackColor,8439039);
	var_Columns.Add("Column 3");

421:
How can I display the column using currency format and enlarge the font for certain values

exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
	var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("1.23");
	var_Items.AddItem("2.34");
	var_Items.AddItem("9.94");
	var_Items.AddItem("11.94");
	var_Items.AddItem("1000");

420:
How can I highlight only parts of the cells

exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("") as exontrol.EXTREELib.Column);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
	var_Column.FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);

419:
How can I get the number of occurrences of a specified string in the cell

extree1.Columns.Add("");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("occurrences") as exontrol.EXTREELib.Column);
	var_Column.ComputedField = "lower(%0) count 'o'";
	var_Column.FormatColumn = "'contains ' + value + ' of \\'o\\' chars'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1 oooof the root");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"Child 3");
	var_Items.set_ExpandItem(h,true);

418:
How can I display dates in my format

exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Date") as exontrol.EXTREELib.Column);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
	var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0) +')'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/21/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/24/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

417:
How can I display dates in short format

(extree1.Columns.Add("Date") as exontrol.EXTREELib.Column).FormatColumn = "shortdate(value)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

416:
How can I display dates in long format

(extree1.Columns.Add("Date") as exontrol.EXTREELib.Column).FormatColumn = "longdate(value)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/1/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/2/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/3/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/4/2004",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

415:
How can I display only the right part of the cell

extree1.Columns.Add("");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Right") as exontrol.EXTREELib.Column);
	var_Column.ComputedField = "%0 right 2";
	var_Column.FormatColumn = "'\"' + value + '\"'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"SChild 3");
	var_Items.set_ExpandItem(h,true);

414:
How can I display only the left part of the cell

extree1.Columns.Add("");
(extree1.Columns.Add("Left") as exontrol.EXTREELib.Column).ComputedField = "%0 left 2";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem("Root");
	var_Items.InsertItem(h,null,"Child 1");
	var_Items.InsertItem(h,null,"Child 2");
	var_Items.InsertItem(h,null,"SChild 3");
	var_Items.set_ExpandItem(h,true);

413:
How can I display true or false instead 0 and -1

(extree1.Columns.Add("Boolean") as exontrol.EXTREELib.Column).FormatColumn = "value != 0 ? 'true' : 'false'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(true);
	var_Items.AddItem(false);
	var_Items.AddItem(true);
	var_Items.AddItem(0);
	var_Items.AddItem(1);

412:
How can I display icons or images instead numbers

extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq" +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=");
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Icons") as exontrol.EXTREELib.Column);
	var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1);
	var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(1);
	var_Items.AddItem(2);
	var_Items.AddItem(3);

411:
How can I display the column using currency

(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).FormatColumn = "currency(dbl(value))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("1.23");
	var_Items.AddItem("2.34");
	var_Items.AddItem("0");
	var_Items.AddItem(5);
	var_Items.AddItem("10000.99");

410:
How can I display the currency only for not empty cells

extree1.Columns.Add("Number");
(extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).ComputedField = "len(%0) ? currency(dbl(%0)) : ''";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem("1.23");
	var_Items.AddItem("2.34");
	var_Items.AddItem("0");
	var_Items.set_ItemBackColor(var_Items.AddItem(null),Color.FromArgb(255,128,128));
	var_Items.AddItem("10000.99");

409:
Is there a function to display the number of days between two date including the number of hours

(extree1.Columns.Add("Start") as exontrol.EXTREELib.Column).Width = 32;
extree1.Columns.Add("End");
(extree1.Columns.Add("Duration") as exontrol.EXTREELib.Column).ComputedField = "2:=((1:=int(0:= date(%1)-date(%0))) = 0 ? '' : str(=:1) + ' day(s)') + ( 3:=round(24*(=:0-floor(=:0))) ? (len(=:2) ? ' and ' : " +
"'') + =:3 + ' hour(s)' : '' )";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

408:
Is there a function to display the number of days between two date including the number of hours

extree1.Columns.Add("Start");
extree1.Columns.Add("End");
(extree1.Columns.Add("Duration") as exontrol.EXTREELib.Column).ComputedField = "\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%0))))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001 23:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

407:
How can I display the number of days between two dates

extree1.Columns.Add("Start");
extree1.Columns.Add("End");
(extree1.Columns.Add("Duration") as exontrol.EXTREELib.Column).ComputedField = "(date(%1)-date(%0)) + ' days'";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	int h = var_Items.AddItem(Convert.ToDateTime("1/11/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	h = var_Items.AddItem(Convert.ToDateTime("2/22/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	h = var_Items.AddItem(Convert.ToDateTime("3/13/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

406:
How can I get second part of the date

extree1.Columns.Add("Date");
(extree1.Columns.Add("Second") as exontrol.EXTREELib.Column).ComputedField = "sec(date(%0))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:22",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:01",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:59",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

405:
How can I get minute part of the date

extree1.Columns.Add("Date");
(extree1.Columns.Add("Minute") as exontrol.EXTREELib.Column).ComputedField = "min(date(%0))";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:10:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:11:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

404:
How can I check the hour part only so I know it was afternoon

extree1.ConditionalFormats.Add("hour(%0)>=12",null).Bold = true;
extree1.Columns.Add("Date");
(extree1.Columns.Add("Hour") as exontrol.EXTREELib.Column).ComputedField = "hour(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

403:
What about a function to get the day in the week, or days since Sunday

extree1.Columns.Add("Date");
(extree1.Columns.Add("WeekDay") as exontrol.EXTREELib.Column).ComputedField = "weekday(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

402:
Is there any function to get the day of the year or number of days since January 1st

extree1.Columns.Add("Date");
(extree1.Columns.Add("Day since January 1st") as exontrol.EXTREELib.Column).ComputedField = "yearday(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));

401:
How can I display only the day of the date

extree1.Columns.Add("Date");
(extree1.Columns.Add("Day") as exontrol.EXTREELib.Column).ComputedField = "day(%0)";
exontrol.EXTREELib.Items var_Items = extree1.Items;
	var_Items.AddItem(Convert.ToDateTime("1/11/2001 10:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));
	var_Items.AddItem(Convert.ToDateTime("4/14/2004 13:00:00",System.Globalization.CultureInfo.GetCultureInfo("en-US")));