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,0,"Child 1"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"Child 3"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"Child 3"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(var_Items.InsertItem(h,0,"Child 2"),0,"SubChild 2"); var_Items.InsertItem(h,0,"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 toolt" +
"ip supports built-in HTML tags, icons and pictures.<br><br><br><img>pic1</img> picture ... <br><" +
"br>";
extree1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZL" + "hEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJgEgI="); 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();
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></fon" + "t>."); 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")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/1/2001")); 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,0,"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,0,"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,0,"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,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"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,0,"Cell 1.1");
var_Items.InsertItem(h,0,"Cell 1.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,0,"Cell 2.1");
var_Items.InsertItem(h,0,"Cell 2.2");
var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();
// 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,0,"Cell 1.1");
var_Items.InsertItem(h,0,"Cell 1.2");
var_Items.set_ExpandItem(h,true);
h = var_Items.AddItem("R2");
var_Items.InsertItem(h,0,"Cell 2.1");
var_Items.InsertItem(h,0,"Cell 2.2");
var_Items.set_ExpandItem(h,true);
extree1.EndUpdate();
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" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+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" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+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,0,"Child 1"); var_Items.InsertItem(h,0,"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:'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();
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)0x2000 | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWords; 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.exFilterPromptContainsAny | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWords; 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)0x2000 | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAny | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWords; 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)0x2000 | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptContainsAll | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptStartWords; 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.exFilterPromptContainsAny | exontrol.EXTREELib.FilterPromptEnum.exFilterPromptCaseSensitive; 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,0,"Default"); var_Items.set_ItemBackColor32(hC,0x1000000); var_Items.set_ItemHeight(var_Items.InsertItem(h,0,""),6); hC = var_Items.InsertItem(h,0,"Light Green"); var_Items.set_ItemBackColor32(hC,0x100ff00); var_Items.set_ItemHeight(var_Items.InsertItem(h,0,""),6); hC = var_Items.InsertItem(h,0,"Dark Green"); var_Items.set_ItemBackColor32(hC,0x1007f00); var_Items.set_ItemHeight(var_Items.InsertItem(h,0,""),6); hC = var_Items.InsertItem(h,0,"Magenta"); var_Items.set_ItemBackColor32(hC,0x1ff7fff); var_Items.set_ItemHeight(var_Items.InsertItem(h,0,""),6); hC = var_Items.InsertItem(h,0,"Yellow"); var_Items.set_ItemBackColor32(hC,0x17fffff); var_Items.set_ItemHeight(var_Items.InsertItem(h,0,""),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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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,0,"Child 1 oooof the root"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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")); var_Items.AddItem(Convert.ToDateTime("2/22/2002")); var_Items.AddItem(Convert.ToDateTime("3/13/2003")); var_Items.AddItem(Convert.ToDateTime("4/24/2004"));
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")); var_Items.AddItem(Convert.ToDateTime("2/2/2002")); var_Items.AddItem(Convert.ToDateTime("3/3/2003")); var_Items.AddItem(Convert.ToDateTime("4/4/2004"));
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")); var_Items.AddItem(Convert.ToDateTime("2/2/2002")); var_Items.AddItem(Convert.ToDateTime("3/3/2003")); var_Items.AddItem(Convert.ToDateTime("4/4/2004"));
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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"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" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+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(0,0,0)); 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")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001")); h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00 PM")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 1:00:00 PM")); h = var_Items.AddItem(Convert.ToDateTime("3/13/2003")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00 AM"));
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")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001 11:00:00 PM")); h = var_Items.AddItem(Convert.ToDateTime("2/22/2002 12:00:00 PM")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002 1:00:00 PM")); h = var_Items.AddItem(Convert.ToDateTime("3/13/2003")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003 11:00:00 AM"));
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")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("1/14/2001")); h = var_Items.AddItem(Convert.ToDateTime("2/22/2002")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("3/14/2002")); h = var_Items.AddItem(Convert.ToDateTime("3/13/2003")); var_Items.set_CellCaption(h,1,Convert.ToDateTime("4/11/2003"));
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 AM")); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:22 AM")); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:01 PM")); var_Items.AddItem(Convert.ToDateTime("4/14/2004 1:11:59 PM"));
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 AM")); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:01:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:23:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/14/2004 1:11:00 PM"));
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 AM")); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
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 AM")); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
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 AM")); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
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 AM")); var_Items.AddItem(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
400. How can I display only the month of the date
extree1.Columns.Add("Date"); (extree1.Columns.Add("Month") as exontrol.EXTREELib.Column).ComputedField = "month(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
399. How can I get only the year part from a date expression
extree1.Columns.Add("Date"); (extree1.Columns.Add("Year") as exontrol.EXTREELib.Column).ComputedField = "year(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
398. Can I convert the expression to date
extree1.Columns.Add("Number"); (extree1.Columns.Add("Date") as exontrol.EXTREELib.Column).ComputedField = "date(dbl(%0))"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("30000.99"); var_Items.AddItem("3561.23"); var_Items.AddItem("1232.34");
397. Can I convert the expression to a number, double or float
extree1.Columns.Add("Number"); (extree1.Columns.Add("Number + 2") as exontrol.EXTREELib.Column).ComputedField = "dbl(%0)+2"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34");
396. How can I display dates in long format
extree1.Columns.Add("Date"); (extree1.Columns.Add("LongFormat") as exontrol.EXTREELib.Column).ComputedField = "longdate(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
395. How can I display dates in short format
extree1.Columns.Add("Date"); (extree1.Columns.Add("ShortFormat") as exontrol.EXTREELib.Column).ComputedField = "shortdate(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
394. How can I display the time only of a date expression
extree1.Columns.Add("Date"); (extree1.Columns.Add("Time") as exontrol.EXTREELib.Column).ComputedField = "'time is:' + time(date(%0))"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.AddItem(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.AddItem(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
393. Is there any function to display currencies, or money formatted as in the control panel
extree1.Columns.Add("Number"); (extree1.Columns.Add("Currency") as exontrol.EXTREELib.Column).ComputedField = "currency(dbl(%0))"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("1.23"); var_Items.AddItem("2.34"); var_Items.AddItem("10000.99");
392. How can I convert the expression to a string so I can look into the date string expression for month's name
extree1.Columns.Add("Number"); (extree1.Columns.Add("Str") as exontrol.EXTREELib.Column).ComputedField = "str(%0) + ' AA'"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34");
391. Can I display the absolute value or positive part of the number
extree1.Columns.Add("Number"); (extree1.Columns.Add("Abs") as exontrol.EXTREELib.Column).ComputedField = "abs(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34");
390. Is there any function to get largest number with no fraction part that is not greater than the value
extree1.Columns.Add("Number"); (extree1.Columns.Add("Floor") as exontrol.EXTREELib.Column).ComputedField = "floor(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34");
389. Is there any function to round the values base on the .5 value
extree1.Columns.Add("Number"); (extree1.Columns.Add("Round") as exontrol.EXTREELib.Column).ComputedField = "round(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34");
388. How can I get or display the integer part of the cell
extree1.Columns.Add("Number"); (extree1.Columns.Add("Int") as exontrol.EXTREELib.Column).ComputedField = "int(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("-1.98"); var_Items.AddItem("0.99"); var_Items.AddItem("1.23"); var_Items.AddItem("2.34");
387. How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
(extree1.Columns.Add("") as exontrol.EXTREELib.Column).ComputedField = "proper(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("root"); var_Items.InsertItem(h,0,"child child"); var_Items.InsertItem(h,0,"child child"); var_Items.InsertItem(h,0,"child child"); var_Items.set_ExpandItem(h,true);
386. Is there any option to display cells in uppercase
(extree1.Columns.Add("") as exontrol.EXTREELib.Column).ComputedField = "upper(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"Chld 3"); var_Items.set_ExpandItem(h,true);
385. Is there any option to display cells in lowercase
(extree1.Columns.Add("") as exontrol.EXTREELib.Column).ComputedField = "lower(%0)"; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"Chld 3"); var_Items.set_ExpandItem(h,true);
384. How can I mark the cells that has a specified type, ie strings only
extree1.ConditionalFormats.Add("type(%0) = 8",null).ForeColor = Color.FromArgb(255,0,0); extree1.Columns.Add(""); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,2); var_Items.InsertItem(h,0,"Chld 3"); var_Items.set_ExpandItem(h,true);
383. How can I bold the items that contains data or those who displays empty strings
extree1.ConditionalFormats.Add("not len(%1)=0",null).Bold = true; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); int hC = var_Items.InsertItem(h,0,"Child 2"); var_Items.set_CellCaption(hC,1,"1"); var_Items.InsertItem(h,0,"Child 3"); var_Items.set_ExpandItem(h,true);
382. Can I change the background color for items or cells that contains a specified string
extree1.ConditionalFormats.Add("%0 contains 'hi'",null).BackColor = Color.FromArgb(255,0,0); extree1.Columns.Add(""); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"Chld 3"); var_Items.set_ExpandItem(h,true);
381. Is there any option to change the fore color for cells or items that ends with a specified string
extree1.ConditionalFormats.Add("%0 endwith '22'",null).ForeColor = Color.FromArgb(255,0,0); extree1.Columns.Add(""); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 1.22"); var_Items.InsertItem(h,0,"Child 2.22"); var_Items.set_ExpandItem(h,true);
380. How can I highlight the cells or items that starts with a specified string
extree1.ConditionalFormats.Add("%0 startwith 'C'",null).Underline = true; extree1.Columns.Add(""); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.InsertItem(h,0,"SChild 3"); var_Items.set_ExpandItem(h,true);
379. How can I change the background color or the visual appearance using ebn for a particular column
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); 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,16777216); (var_Columns.Add("Column 3") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exHeaderBackColor,16777471); var_Columns.Add("Column 4");
378. 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");
377. How can I display the column's header using multiple lines
extree1.HeaderHeight = 128; extree1.HeaderSingleLine = false; (extree1.Columns.Add("This is just a column that should break the header.") as exontrol.EXTREELib.Column).Width = 32; extree1.Columns.Add("This is just another column that should break the header.");
376. How can include the values in the inner cells in the drop down filter window
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarBlanks,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarNonBlanks,""); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Single Column") as exontrol.EXTREELib.Column); var_Column.HTMLCaption = "Single column with <b>inner cells</b>"; var_Column.ToolTip = "Click the drop down filter button, and the filter list includes the inner cells values too."; var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false; var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exIncludeInnerCells; extree1.ShowFocusRect = false; exontrol.EXTREELib.Items var_Items = extree1.Items; object s = var_Items.get_SplitCell(var_Items.AddItem("S 1.1"),0); var_Items.set_CellCaption(0,s,"S 1.2"); var_Items.set_CellHAlignment(0,s,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_CellBackColor32(0,s,0x1000000); var_Items.set_CellWidth(0,s,84); s = var_Items.get_SplitCell(var_Items.AddItem("S 2.1"),0); var_Items.set_CellCaption(0,s,"S 2.2"); var_Items.set_CellHAlignment(0,s,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_CellWidth(0,s,84); s = var_Items.get_SplitCell(var_Items.AddItem("S 3.1"),0); var_Items.set_CellCaption(0,s,"S 3.2"); var_Items.set_CellHAlignment(0,s,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_CellBackColor32(0,s,0x1000000); var_Items.set_CellWidth(0,s,84);
375. How can I sort the value gets listed in the drop down filter window
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.MarkSearchColumn = false; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarAll,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarBlanks,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarNonBlanks,""); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("P1") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false; var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exSortItemsDesc; exontrol.EXTREELib.Column var_Column1 = (extree1.Columns.Add("P2") as exontrol.EXTREELib.Column); var_Column1.DisplayFilterButton = true; var_Column1.DisplayFilterPattern = false; var_Column1.FilterList = exontrol.EXTREELib.FilterListEnum.exSortItemsAsc; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Z3"); var_Items.set_CellCaption(h,1,"C"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Z1"),1,"B"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Z2"),1,"A"); var_Items.set_ExpandItem(h,true);
374. How can I align the text/caption on the scroll bar
extree1.set_ScrollPartCaption(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLowerBackPart,"left"); extree1.set_ScrollPartCaptionAlignment(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLowerBackPart,exontrol.EXTREELib.AlignmentEnum.LeftAlignment); extree1.set_ScrollPartCaption(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exUpperBackPart,"right"); extree1.set_ScrollPartCaptionAlignment(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exUpperBackPart,exontrol.EXTREELib.AlignmentEnum.RightAlignment); extree1.ColumnAutoResize = false; extree1.Columns.Add(1.ToString()); extree1.Columns.Add(2.ToString()); extree1.Columns.Add(3.ToString()); extree1.Columns.Add(4.ToString()); extree1.Columns.Add(5.ToString()); extree1.Columns.Add(6.ToString());
373. How do I select the next row/item
extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Item 1"); var_Items.AddItem("Item 2"); var_Items.AddItem("Item 3"); var_Items.set_SelectItem(var_Items.get_NextVisibleItem(var_Items.FocusItem),true);
372. How do I enable resizing ( changing the height ) the items at runtime
extree1.ItemsAllowSizing = exontrol.EXTREELib.ItemsAllowSizingEnum.exResizeItem; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exHLines; extree1.ScrollBySingleLine = true; extree1.Columns.Add("Column"); extree1.Items.AddItem("Item 1"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemHeight(var_Items.AddItem("Item 2"),48); extree1.Items.AddItem("Item 3"); extree1.Items.AddItem("Item 4");
371. How do I enable resizing all the items at runtime
extree1.ItemsAllowSizing = exontrol.EXTREELib.ItemsAllowSizingEnum.exResizeAllItems; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exHLines; extree1.Columns.Add("Column"); extree1.Items.AddItem("Item 1"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemHeight(var_Items.AddItem("Item 2"),48); extree1.Items.AddItem("Item 3");
370. How can I remove the filter
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter(); extree1.ClearFilter();
369. How do I change the control's border, using your EBN files
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.Appearance = (exontrol.EXTREELib.AppearanceEnum)0x1000000;
368. Can I change the default border of the tooltip, using your EBN files
extree1.ToolTipDelay = 1; extree1.ToolTipWidth = 364; extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exToolTipAppearance,0x1000000); (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip assigned to a column";
367. Can I change the background color for the tooltip
extree1.ToolTipDelay = 1; extree1.ToolTipWidth = 364; extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exToolTipBackColor,Color.FromArgb(0,0,0)); (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip assigned to a column";
366. Does the tooltip support HTML format
extree1.ToolTipDelay = 1; extree1.ToolTipWidth = 364; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "<font Tahoma;11>T</font>his is an HTML <b>tooltip</b> assigned to a <fgcolor=FF0000>column</fgc" + "olor>";
365. Can I change the forecolor for the tooltip
extree1.ToolTipDelay = 1; extree1.ToolTipWidth = 364; extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exToolTipForeColor,Color.FromArgb(0,0,0)); (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip assigned to a column";
364. Can I change the foreground color for the tooltip
extree1.ToolTipDelay = 1; extree1.ToolTipWidth = 364; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "<fgcolor=FF0000>this is a tooltip assigned to a column</fgcolor>";
363. How can I merge cells
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exAllLines; extree1.MarkSearchColumn = false; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); extree1.Columns.Add("C3"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("this cell merges the first two columns"); var_Items.set_CellMerge(h,0,1); h = var_Items.AddItem(null); var_Items.set_CellCaption(h,1,"this cell merges the last two columns"); var_Items.set_CellMerge(h,1,2); h = var_Items.AddItem("this cell merges the all three columns"); var_Items.set_CellMerge(h,0,1); var_Items.set_CellMerge(h,0,2); h = var_Items.AddItem("this draws a divider item"); var_Items.set_ItemDivider(h,0);
362. How can I merge cells
extree1.MarkSearchColumn = false; extree1.TreeColumnIndex = -1; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false); h = var_Items.AddItem("This is bit of text merges all cells in the item"); var_Items.set_ItemDivider(h,0); var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment);
361. How can I specify the width for a splited cell
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Columns.Add("Single Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Split 1"); object s = var_Items.get_SplitCell(h,0); var_Items.set_CellWidth(0,s,64); var_Items.set_CellCaption(0,s,"Split 2"); object s1 = var_Items.get_SplitCell(0,s); var_Items.set_CellCaption(0,s1,"Split 3"); var_Items.set_CellWidth(0,s1,64);
360. How can I split a cell in three parts
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Columns.Add("Single Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Split 1"); object s = var_Items.get_SplitCell(h,0); var_Items.set_CellCaption(0,s,"Split 2"); object s1 = var_Items.get_SplitCell(0,s); var_Items.set_CellCaption(0,s1,"Split 3");
359. How can I add a button aligned to right
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.Columns.Add("Single Column"); extree1.ShowFocusRect = false; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemDivider(var_Items.AddItem("This is a bit of text being displayed on the entire item"),0); object s = var_Items.get_SplitCell(var_Items.AddItem("Split Cell 1.1"),0); var_Items.set_CellCaption(0,s,"Split Cell <img>1</img>"); var_Items.set_CellCaptionFormat(0,s,exontrol.EXTREELib.CaptionFormatEnum.exHTML); var_Items.set_CellHAlignment(0,s,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_CellHasButton(0,s,true); var_Items.set_CellWidth(0,s,84);
358. How can I split a cell
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.Columns.Add("Single Column"); extree1.ShowFocusRect = false; exontrol.EXTREELib.Items var_Items = extree1.Items; object s = var_Items.get_SplitCell(var_Items.AddItem("Split Cell 1.1"),0); var_Items.set_CellCaption(0,s,"Split Cell <img>1</img>"); var_Items.set_CellCaptionFormat(0,s,exontrol.EXTREELib.CaptionFormatEnum.exHTML); var_Items.set_CellHAlignment(0,s,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_CellBackColor32(0,s,0x1000000); var_Items.set_CellWidth(0,s,84);
357. Can I select an item giving its general position
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.SelectPos = 1;
356. How can I change the color for separator / dividers items
extree1.GridLineColor = Color.FromArgb(255,0,0); extree1.MarkSearchColumn = false; extree1.TreeColumnIndex = -1; extree1.ScrollBySingleLine = false; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false); h = var_Items.AddItem(null); var_Items.set_ItemDivider(h,0); var_Items.set_ItemDividerLine(h,exontrol.EXTREELib.DividerLineEnum.DoubleDotLine); var_Items.set_ItemDividerLineAlignment(h,exontrol.EXTREELib.DividerAlignmentEnum.DividerCenter); var_Items.set_ItemHeight(h,6); var_Items.set_SelectableItem(h,false); h = var_Items.AddItem("Cell 2"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false);
355. How can I add separator - dividers items
extree1.MarkSearchColumn = false; extree1.TreeColumnIndex = -1; extree1.ScrollBySingleLine = false; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false); h = var_Items.AddItem(null); var_Items.set_ItemDivider(h,0); var_Items.set_ItemDividerLine(h,exontrol.EXTREELib.DividerLineEnum.DoubleDotLine); var_Items.set_ItemDividerLineAlignment(h,exontrol.EXTREELib.DividerAlignmentEnum.DividerCenter); var_Items.set_ItemHeight(h,6); var_Items.set_SelectableItem(h,false); h = var_Items.AddItem("Cell 2"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false);
354. Can I change the style of the line being displayed by a divider item
extree1.MarkSearchColumn = false; extree1.TreeColumnIndex = -1; extree1.ScrollBySingleLine = false; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false); h = var_Items.AddItem("This is bit of text that's displayed on the entire item, divider."); var_Items.set_ItemDivider(h,0); var_Items.set_ItemDividerLine(h,exontrol.EXTREELib.DividerLineEnum.DoubleDotLine); var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_ItemHeight(h,24);
353. Can I remove the line being displayed by a divider item
extree1.MarkSearchColumn = false; extree1.TreeColumnIndex = -1; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false); h = var_Items.AddItem("This is bit of text that's displayed on the entire item, divider."); var_Items.set_ItemDivider(h,0); var_Items.set_ItemDividerLine(h,exontrol.EXTREELib.DividerLineEnum.EmptyLine); var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment);
352. How can I display a divider item, merging all cells
extree1.MarkSearchColumn = false; extree1.TreeColumnIndex = -1; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false); h = var_Items.AddItem("This is bit of text that's displayed on the entire item, divider."); var_Items.set_ItemDivider(h,0); var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment);
351. How can I fix or lock items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_LockedItemCount(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,1); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,0),0,"This is a locked item, fixed to the top side of the control."); var_Items.set_ItemBackColor(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,0),Color.FromArgb(0,0,0)); var_Items.set_LockedItemCount(exontrol.EXTREELib.VAlignmentEnum.BottomAlignment,2); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.BottomAlignment,0),0,"This is a locked item, fixed to the top side of the control."); var_Items.set_ItemBackColor(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.BottomAlignment,0),Color.FromArgb(0,0,0)); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.BottomAlignment,1),0,"This is a locked item, fixed to the top side of the control."); var_Items.set_ItemBackColor(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.BottomAlignment,1),Color.FromArgb(0,0,0));
350. How can I fix or lock an item on the bottom side of the control
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_LockedItemCount(exontrol.EXTREELib.VAlignmentEnum.BottomAlignment,1); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.BottomAlignment,0),0,"This is a locked item, fixed to the bottom side of the control."); int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
349. How can I fix or lock an item on the top of the control
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_LockedItemCount(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,1); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,0),0,"This is a locked item, fixed to the top side of the control."); int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
348. Is there any function to limit the height of the items when I display it using multiple lines
extree1.ScrollBySingleLine = true; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" + "e lines."); var_Items.set_CellSingleLine(h,1,false); var_Items.set_ItemMaxHeight(h,48);
347. Why I cannot center my cells in the column
extree1.TreeColumnIndex = -1; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; (extree1.Columns.Add("Default") as exontrol.EXTREELib.Column).Alignment = exontrol.EXTREELib.AlignmentEnum.CenterAlignment; extree1.Items.AddItem("item 1"); extree1.Items.AddItem("item 2"); extree1.Items.AddItem("item 3");
346. How can I align the cell to the left, center or to the right
extree1.TreeColumnIndex = -1; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellHAlignment(var_Items.AddItem("left"),0,exontrol.EXTREELib.AlignmentEnum.LeftAlignment); var_Items.set_CellHAlignment(var_Items.AddItem("center"),0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_CellHAlignment(var_Items.AddItem("right"),0,exontrol.EXTREELib.AlignmentEnum.RightAlignment);
345. How do I apply HTML format to a cell
extree1.TreeColumnIndex = -1; extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.set_HTMLPicture("p1","c:\\exontrol\\images\\zipdisk.gif"); extree1.set_HTMLPicture("p2","c:\\exontrol\\images\\auction.gif"); extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("The following item shows some of the HTML format supported:"); var_Items.set_CellHAlignment(h,0,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); h = var_Items.AddItem("<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>te" + "xt <b>bold</b>, <i>italic</i>, <u>underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<" + "br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolor</fgcolor> or <bgcolor=00FF00>b" + "gcolor</bgcolor> "); var_Items.set_CellCaptionFormat(h,0,exontrol.EXTREELib.CaptionFormatEnum.exHTML); var_Items.set_CellSingleLine(h,0,false);
344. How can I change the font for a cell
extree1.Columns.Add("Default"); extree1.Items.AddItem("std font"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("this <font tahoma;12>is a bit of text with</font> a different font"),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
343. How can I change the font for a cell
extree1.Columns.Add("Default"); extree1.Items.AddItem("default font"); stdole.IFontDisp f = new stdole.StdFont(); f.Name = "Tahoma"; f.Size = 12; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellFont(var_Items.AddItem("new font"),0,(f as stdole.IFontDisp));
342. How can I change the font for entire item
extree1.Columns.Add("Default"); extree1.Items.AddItem("default font"); stdole.IFontDisp f = new stdole.StdFont(); f.Name = "Tahoma"; f.Size = 12; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemFont(var_Items.AddItem("new font"),(f as stdole.IFontDisp));
341. How do I vertically align a cell
extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; (extree1.Columns.Add("MultipleLine") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellSingleLine,false); extree1.Columns.Add("VAlign"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("This is a bit of long text that should break the line"); var_Items.set_CellCaption(h,1,"top"); var_Items.set_CellVAlignment(h,1,exontrol.EXTREELib.VAlignmentEnum.TopAlignment); h = var_Items.AddItem("This is a bit of long text that should break the line"); var_Items.set_CellCaption(h,1,"middle"); var_Items.set_CellVAlignment(h,1,exontrol.EXTREELib.VAlignmentEnum.MiddleAlignment); h = var_Items.AddItem("This is a bit of long text that should break the line"); var_Items.set_CellCaption(h,1,"bottom"); var_Items.set_CellVAlignment(h,1,exontrol.EXTREELib.VAlignmentEnum.BottomAlignment);
340. How can I change the position of an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Item 1"); var_Items.AddItem("Item 2"); var_Items.set_ItemPosition(var_Items.AddItem("Item 3"),0);
339. How do I find an item based on a path
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.set_ItemData(var_Items.InsertItem(h,0,"Child 2"),1234); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items.get_FindPath("Root 1\\Child 1"),true);
338. How do I find an item based on my extra data
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.set_ItemData(var_Items.InsertItem(h,0,"Child 2"),1234); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items.get_FindItemData(1234,null),true);
337. How do I find an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items.get_FindItem("Child 2",0,null),true);
336. How can I insert a hyperlink or an anchor element
extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaptionFormat(var_Items1.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
335. How do I find the index of the item based on its handle
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items[var_Items.get_ItemToIndex(h)],true);
334. How do I find the handle of the item based on its index
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items[1],true);
333. How can I find the cell being clicked in a radio group
extree1.MarkSearchColumn = false; extree1.SelBackColor = Color.FromArgb(255,255,128); extree1.SelForeColor = Color.FromArgb(0,0,0); extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); extree1.Columns.Add("C3"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Radio 1"); var_Items.set_CellHasRadioButton(h,1,true); var_Items.set_CellRadioGroup(h,1,1234); var_Items.set_CellCaption(h,2,"Radio 2"); var_Items.set_CellHasRadioButton(h,2,true); var_Items.set_CellRadioGroup(h,2,1234); var_Items.set_CellState(h,1,1); var_Items.set_CellBold(0,var_Items.get_CellChecked(1234),true);
332. Can I add a +/- ( expand / collapse ) buttons to each item, so I can load the child items later
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemHasChildren(var_Items.AddItem("parent item with no child items"),true); var_Items.AddItem("next item");
331. Can I let the user to resize at runtime the specified item
extree1.ScrollBySingleLine = true; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemAllowSizing(var_Items.AddItem("resizable item"),true); var_Items.AddItem("not resizable item");
330. How can I change the size ( width, height ) of the picture
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.set_CellPicture(h,0,(extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp)); var_Items.set_CellPictureWidth(h,0,24); var_Items.set_CellPictureHeight(h,0,24); var_Items.set_ItemHeight(h,32); h = var_Items.AddItem("Root 2"); var_Items.set_CellPicture(h,0,(extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp)); var_Items.set_ItemHeight(h,48);
329. How can I find the number or the count of selected items
extree1.SingleSel = false; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_SelectItem(var_Items.get_ItemChild(h),true); var_Items.set_SelectItem(var_Items.get_NextSiblingItem(var_Items.get_ItemChild(h)),true); var_Items.AddItem(var_Items.SelectCount);
328. How do I unselect an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_SelectItem(h,false);
327. How do I find the selected item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_SelectItem(h,true); var_Items.set_ItemBold(var_Items.get_SelectedItem(0),true);
326. How do I un select all items
extree1.SingleSel = false; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.UnselectAll();
325. How do I select multiple items
extree1.SingleSel = false; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_SelectItem(var_Items.get_ItemChild(h),true); var_Items.set_SelectItem(var_Items.get_NextSiblingItem(var_Items.get_ItemChild(h)),true);
324. How do I select all items
extree1.SingleSel = false; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.SelectAll();
323. How do I select an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_SelectItem(h,true);
322. Can I display a button with some picture or icon inside
extree1.set_HTMLPicture("p1","c:\\exontrol\\images\\zipdisk.gif");
extree1.Columns.Add("C1");
extree1.Columns.Add("C2");
exontrol.EXTREELib.Items var_Items = extree1.Items;
int h = var_Items.AddItem("Cell 1");
var_Items.set_CellCaption(h,1," Button <img>p1</img> ");
var_Items.set_CellCaptionFormat(h,1,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
var_Items.set_CellHAlignment(h,1,exontrol.EXTREELib.AlignmentEnum.RightAlignment);
var_Items.set_CellHasButton(h,1,true);
var_Items.set_CellButtonAutoWidth(h,1,true);
var_Items.set_ItemHeight(h,48);
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1," Button <img>1</img> "); var_Items.set_CellCaptionFormat(h,1,exontrol.EXTREELib.CaptionFormatEnum.exHTML); var_Items.set_CellHAlignment(h,1,exontrol.EXTREELib.AlignmentEnum.RightAlignment); var_Items.set_CellHasButton(h,1,true); var_Items.set_CellButtonAutoWidth(h,1,true);
320. Can I display a button with some icon inside
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1," <img>1</img> "); var_Items.set_CellCaptionFormat(h,1,exontrol.EXTREELib.CaptionFormatEnum.exHTML); var_Items.set_CellHAlignment(h,1,exontrol.EXTREELib.AlignmentEnum.RightAlignment); var_Items.set_CellHasButton(h,1,true); var_Items.set_CellButtonAutoWidth(h,1,true);
319. How can I assign multiple icon/picture to a cell
extree1.set_HTMLPicture("p1","c:\\exontrol\\images\\zipdisk.gif"); extree1.set_HTMLPicture("p2","c:\\exontrol\\images\\auction.gif"); extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("text <img>p1</img> another picture <img>p2</img> and so on"); var_Items.set_CellCaptionFormat(h,0,exontrol.EXTREELib.CaptionFormatEnum.exHTML); var_Items.set_CellPicture(h,0,(extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\colorize.gif`)") as stdole.IPictureDisp)); var_Items.set_ItemHeight(h,48); var_Items.AddItem("Root 2");
318. How can I assign an icon/picture to a cell
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.set_CellPicture(h,0,(extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp)); var_Items.set_ItemHeight(h,48); var_Items.AddItem("Root 2");
317. How can I assign multiple icons/pictures to a cell
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root <img>1</img> 1, <img>2</img>, ... and so on "); var_Items.set_CellCaptionFormat(h,0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
316. How can I assign multiple icons/pictures to a cell
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.set_CellImages(h,0,"1,2,3");
315. How can I assign an icon/picture to a cell
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.set_CellImage(h,0,1); var_Items.set_CellImage(var_Items.InsertItem(h,0,"Child 1"),0,2); var_Items.set_CellImage(var_Items.InsertItem(h,0,"Child 2"),0,3); var_Items.set_ExpandItem(h,true);
314. How can I get the handle of an item based on the handle of the cell
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items.get_CellItem(var_Items.get_ItemCell(h,0)),true);
313. How can I display a button inside the item or cell
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1," Button 1 "); var_Items.set_CellHAlignment(h,1,exontrol.EXTREELib.AlignmentEnum.RightAlignment); var_Items.set_CellHasButton(h,1,true); var_Items.set_CellButtonAutoWidth(h,1,true); h = var_Items.AddItem("Cell 2"); var_Items.set_CellCaption(h,1," Button 2 "); var_Items.set_CellHAlignment(h,1,exontrol.EXTREELib.AlignmentEnum.CenterAlignment); var_Items.set_CellHasButton(h,1,true);
312. How can I change the state of a radio button
extree1.MarkSearchColumn = false; extree1.SelBackColor = Color.FromArgb(255,255,128); extree1.SelForeColor = Color.FromArgb(0,0,0); extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); extree1.Columns.Add("C3"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Radio 1"); var_Items.set_CellHasRadioButton(h,1,true); var_Items.set_CellRadioGroup(h,1,1234); var_Items.set_CellCaption(h,2,"Radio 2"); var_Items.set_CellHasRadioButton(h,2,true); var_Items.set_CellRadioGroup(h,2,1234); var_Items.set_CellState(h,1,1);
311. How can I assign a radio button to a cell
extree1.MarkSearchColumn = false; extree1.SelBackColor = Color.FromArgb(255,255,128); extree1.SelForeColor = Color.FromArgb(0,0,0); extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); extree1.Columns.Add("C3"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Radio 1"); var_Items.set_CellHasRadioButton(h,1,true); var_Items.set_CellRadioGroup(h,1,1234); var_Items.set_CellCaption(h,2,"Radio 2"); var_Items.set_CellHasRadioButton(h,2,true); var_Items.set_CellRadioGroup(h,2,1234); var_Items.set_CellState(h,1,1);
310. How can I change the state of a checkbox
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Check Box"); var_Items.set_CellHasCheckBox(h,1,true); var_Items.set_CellState(h,1,1);
309. How can I assign a checkbox to a cell
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Check Box"); var_Items.set_CellHasCheckBox(h,1,true);
308. How can I display an item or a cell on multiple lines
extree1.ScrollBySingleLine = true; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines"); var_Items.set_CellSingleLine(h,1,false);
307. How can I assign a tooltip to a cell
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"tooltip"); var_Items.set_CellToolTip(h,1,"This is bit of text that's shown when the user hovers the cell");
306. How can I associate an extra data to a cell
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Cell 2"); var_Items.set_CellData(h,1,"your extra data");
305. How do I enable or disable a cell
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Cell 2"); var_Items.set_CellEnabled(h,1,false);
304. How do I change the cell's foreground color
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Cell 2"); var_Items.set_CellForeColor(h,1,Color.FromArgb(0,0,0));
303. How do I change the visual effect for the cell, using your EBN files
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Cell 2"); var_Items.set_CellBackColor32(h,1,0x1000000);
302. How do I change the cell's background color
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Cell 2"); var_Items.set_CellBackColor(h,1,Color.FromArgb(0,0,0));
301. How do I change the caption or value for a particular cell
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("Cell 1"),1,"Cell 2");
300. How do I get the handle of the cell
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_CellBold(0,var_Items.get_ItemCell(h,0),true);
299. How do I retrieve the focused item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items.FocusItem,true);
298. How do I get the number or count of child items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.AddItem(var_Items.get_ChildCount(h));
297. How do I enumerate the visible items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.set_ItemBold(var_Items.FirstVisibleItem,true); var_Items.set_ItemBold(var_Items.get_NextVisibleItem(var_Items.FirstVisibleItem),true);
296. How do I enumerate the siblings items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.set_ItemBold(var_Items.get_NextSiblingItem(var_Items.FirstVisibleItem),true); var_Items.set_ItemBold(var_Items.get_PrevSiblingItem(var_Items.get_NextSiblingItem(var_Items.FirstVisibleItem)),true);
295. How do I get the parent item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items.get_ItemParent(var_Items.get_ItemChild(h)),true);
294. How do I get the first child item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.set_ItemBold(var_Items.get_ItemChild(h),true);
293. How do I enumerate the root items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ItemBold(var_Items.get_RootItem(0),true); var_Items.set_ItemUnderline(var_Items.get_RootItem(1),true);
292. I have a hierarchy, how can I count the number of root items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.AddItem(var_Items.RootCount);
291. How can I make an item unselectable, or not selectable
extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("unselectable - you can't get selected"); var_Items.set_SelectableItem(h,false); var_Items.AddItem("selectable");
290. How can I hide or show an item
extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("hidden"); var_Items.set_ItemHeight(h,0); var_Items.set_SelectableItem(h,false); var_Items.AddItem("visible");
289. How can I change the height for all items
extree1.DefaultItemHeight = 32; extree1.Columns.Add("Column"); extree1.Items.AddItem("One"); extree1.Items.AddItem("Two");
288. How do I change the height of an item
extree1.ScrollBySingleLine = true; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemHeight(var_Items.AddItem("height"),128); extree1.Items.AddItem("enabled");
287. How do I disable or enable an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_EnableItem(var_Items.AddItem("disabled"),false); extree1.Items.AddItem("enabled");
286. How do I display as strikeout a cell
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellStrikeOut(var_Items.AddItem("strikeout"),0,true);
285. How do I display as strikeout a cell or an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("gets <s>strikeout</s> only a portion of text"),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
284. How do I display as strikeout an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemStrikeOut(var_Items.AddItem("strikeout"),true);
283. How do I underline a cell
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellUnderline(var_Items.AddItem("underline"),0,true);
282. How do I underline a cell or an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("gets <u>underline</u> only a portion of text"),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
281. How do I underline an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemUnderline(var_Items.AddItem("underline"),true);
280. How do I display as italic a cell
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellItalic(var_Items.AddItem("italic"),0,true);
279. How do I display as italic a cell or an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("gets <i>italic</i> only a portion of text"),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
278. How do I display as italic an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemItalic(var_Items.AddItem("italic"),true);
277. How do I bold a cell
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellBold(var_Items.AddItem("bold"),0,true);
276. How do I bold a cell or an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("gets <b>bold</b> only a portion of text"),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
275. How do I bold an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemBold(var_Items.AddItem("bold"),true);
274. How do I change the foreground color for the item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); int hC = var_Items.InsertItem(h,0,"Child 1"); var_Items.set_ItemForeColor(hC,Color.FromArgb(0,0,0)); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
273. How do I change the visual appearance for the item, using your EBN technology
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); int hC = var_Items.InsertItem(h,0,"Child 1"); var_Items.set_ItemBackColor32(hC,0x1000000); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
272. How do I change the background color for the item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); int hC = var_Items.InsertItem(h,0,"Child 1"); var_Items.set_ItemBackColor(hC,Color.FromArgb(0,0,0)); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
271. How do I expand or collapse an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
270. How do I associate an extra data to an item
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemData(var_Items.AddItem("item"),"your extra data");
269. How do I get the number or count of items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); extree1.Items.AddItem(0.ItemCount);
268. How can I specify the width of the ActiveX control, when using the InsertControlItem property
extree1.ScrollBySingleLine = false; extree1.TreeColumnIndex = 1; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exAllLines; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); extree1.Columns.Add("C3"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.InsertControlItem(0,"MSCAL.Calendar",null); var_Items.set_ItemWidth(h,128); var_Items.set_CellCaption(h,0,"This is a bit of text that is shown in the first column"); var_Items.set_CellSingleLine(h,0,false); var_Items.set_CellCaption(h,2,"This is a bit of text that is shown in the third column"); var_Items.set_CellSingleLine(h,2,false);
267. How can I put the ActiveX control in a different column, when using the InsertControlItem property
extree1.ScrollBySingleLine = false; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exAllLines; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); extree1.Columns.Add("C3"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.InsertControlItem(0,"MSCAL.Calendar",null); var_Items.set_CellCaption(h,0,"This is a bit of text that is shown in the first column"); var_Items.set_CellSingleLine(h,0,false); var_Items.set_ItemWidth(h,-32001); var_Items.set_CellCaption(h,2,"This is a bit of text that is shown in the third column"); var_Items.set_CellSingleLine(h,2,false);
266. Is there any function I can use to get the program or the control identifier I've been using when called the InsertControlItem
extree1.Columns.Add("Default"); extree1.ScrollBySingleLine = false; extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.InsertControlItem(0,"MSCAL.Calendar",null); var_Items.InsertItem(h,0,var_Items.get_ItemControlID(h)); var_Items.set_ExpandItem(h,true); h = var_Items.InsertControlItem(0,"MSChart20Lib.MSChart",null); var_Items.set_ItemAppearance(h,exontrol.EXTREELib.AppearanceEnum.Etched); var_Items.InsertItem(h,0,var_Items.get_ItemControlID(h)); var_Items.set_ExpandItem(h,true);
265. How can I change the height of newly created ActiveX control, using the InsertControlItem
extree1.Columns.Add("Default"); extree1.ScrollBySingleLine = false; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemHeight(var_Items.InsertControlItem(0,"MSCAL.Calendar",null),64); var_Items.set_ItemAppearance(var_Items.InsertControlItem(0,"MSChart20Lib.MSChart",null),exontrol.EXTREELib.AppearanceEnum.Etched);
264. How can I change the border for newly created ActiveX control, using the InsertControlItem
extree1.Columns.Add("Default"); extree1.ScrollBySingleLine = false; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemAppearance(var_Items.InsertControlItem(0,"MSCAL.Calendar",null),exontrol.EXTREELib.AppearanceEnum.Sunken); var_Items.set_ItemAppearance(var_Items.InsertControlItem(0,"MSChart20Lib.MSChart",null),exontrol.EXTREELib.AppearanceEnum.Etched);
263. How can I access the properties and methods for an ActiveX control that I've just added using the InsertControlItem
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); // Add 'Microsoft Calendar Control 2007' reference to your project. MSACAL.Calendar var_Calendar = (var_Items.get_ItemObject(var_Items.InsertControlItem(h,"MSCAL.Calendar",null)) as MSACAL.Calendar); var_Calendar.BackColor = Color.FromArgb(255,255,255); var_Calendar.GridCellEffect = 0; var_Calendar.ShowTitle = false; var_Calendar.ShowDateSelectors = false; var_Items.set_ExpandItem(h,true);
262. How can I access the properties and methods for an ActiveX control that I've just added using the InsertControlItem
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); // Add 'Microsoft Calendar Control 2007' reference to your project. MSACAL.Calendar var_Calendar = (var_Items.get_ItemObject(var_Items.InsertControlItem(h,"MSCAL.Calendar",null)) as MSACAL.Calendar); var_Calendar.BackColor = Color.FromArgb(255,255,255); var_Items.set_ExpandItem(h,true);
261. How can I insert an ActiveX control
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertControlItem(h,"MSCAL.Calendar",null); var_Items.set_ExpandItem(h,true);
260. How do I programmatically edit a cell
extree1.AllowEdit = true; extree1.Items.Edit(0.FocusItem,0);
259. How can I change at runtime the parent of the item
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int hP = var_Items.AddItem("Root"); int hC = var_Items.AddItem("Child"); var_Items.SetParent(hC,hP);
258. How can I sort the items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); extree1.Columns["Default"].SortOrder = exontrol.EXTREELib.SortOrderEnum.SortDescending;
257. How do I sort the child items
extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); var_Items.SortChildren(h,0,false);
256. How can I ensure or scroll the control so the item fits the control's client area
extree1.Columns.Add("Default"); int h = extree1.Items.AddItem("item"); extree1.Items.EnsureVisibleItem(h);
255. How can I remove or delete all items
extree1.Columns.Add("Default"); extree1.Items.AddItem("removed item"); extree1.Items.RemoveAllItems();
254. How can I remove or delete an item
extree1.Columns.Add("Default"); int h = extree1.Items.AddItem("removed item"); extree1.Items.RemoveItem(h);
253. How can I add or insert child items
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Cell 1"); var_Items.set_CellCaption(h,1,"Cell 2"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Cell 3"),1,"Cell 4"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Cell 5"),1,"Cell 6"); var_Items.set_ExpandItem(h,true);
252. How can I add or insert a child item
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.Columns.Add("Default"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.InsertItem(var_Items.AddItem("root"),0,"child");
251. How can I add or insert an item
extree1.Columns.Add("C1"); extree1.Columns.Add("C2"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("Cell 1"),1,"Cell 2"); int h = var_Items.AddItem("Cell 3"); var_Items.set_CellCaption(h,1,"Cell 4");
250. How can I add or insert an item
extree1.Columns.Add("Default"); extree1.Items.AddItem("new item");
249. How can I get the columns as they are shown in the control's sortbar
Object var_Object = (extree1.Columns.get_ItemBySortPosition(0) as Object);
248. How can I access the properties of a column
extree1.Columns.Add("A"); extree1.Columns["A"].HeaderBold = true;
247. How can I remove all the columns
extree1.Columns.Clear();
246. How can I remove a column
extree1.Columns.Remove("A");
245. How can I get the number or the count of columns
int var_Count = extree1.Columns.Count;
244. How can I change the font for all cells in the entire column
stdole.IFontDisp f = new stdole.StdFont(); f.Name = "Tahoma"; f.Size = 12; exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Font = (f as stdole.IFontDisp); var_ConditionalFormat.ApplyTo = exontrol.EXTREELib.FormatApplyToEnum.exFormatToColumns; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
243. How can I change the background color for all cells in the column
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null); var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = exontrol.EXTREELib.FormatApplyToEnum.exFormatToColumns; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
242. How can I change the foreground color for all cells in the column
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null); var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = exontrol.EXTREELib.FormatApplyToEnum.exFormatToColumns; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
241. How can I show as strikeout all cells in the column
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null); var_ConditionalFormat.StrikeOut = true; var_ConditionalFormat.ApplyTo = exontrol.EXTREELib.FormatApplyToEnum.exFormatToColumns; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
240. How can I underline all cells in the column
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Underline = true; var_ConditionalFormat.ApplyTo = exontrol.EXTREELib.FormatApplyToEnum.exFormatToColumns; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
239. How can I show in italic all data in the column
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Italic = true; var_ConditionalFormat.ApplyTo = exontrol.EXTREELib.FormatApplyToEnum.exFormatToColumns; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
238. How can I bold the entire column
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.ApplyTo = exontrol.EXTREELib.FormatApplyToEnum.exFormatToColumns; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
237. How can I display a computed column and highlight some values that are negative or less than a value
extree1.Columns.Add("A"); extree1.Columns.Add("B"); (extree1.Columns.Add("(A+B)*1.19") as exontrol.EXTREELib.Column).ComputedField = "(%0 + %1) * 1.19"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem(1),1,2); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem(10),1,20); exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("%2 > 10",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x2;
236. Can I display a computed column so it displays the VAT, or SUM
extree1.Columns.Add("A"); extree1.Columns.Add("B"); (extree1.Columns.Add("(A+B)*1.19") as exontrol.EXTREELib.Column).ComputedField = "(%0 + %1) * 1.19"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem(1),1,2); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem(10),1,20);
235. How can I show a column that adds values in the cells
extree1.Columns.Add("A"); extree1.Columns.Add("B"); (extree1.Columns.Add("A+B") as exontrol.EXTREELib.Column).ComputedField = "%0 + %1"; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem(1),1,2); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem(10),1,20);
234. Is there any function to filter the control's data as I type, so the items being displayed include the typed characters
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Filter") as exontrol.EXTREELib.Column); var_Column.FilterOnType = true; var_Column.DisplayFilterButton = true; var_Column.AutoSearch = exontrol.EXTREELib.AutoSearchEnum.exContains; extree1.Items.AddItem("Canada"); extree1.Items.AddItem("USA");
233. Is there any function to filter the control's data as I type, something like filter on type
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Filter") as exontrol.EXTREELib.Column); var_Column.FilterOnType = true; var_Column.DisplayFilterButton = true; extree1.Items.AddItem("Canada"); extree1.Items.AddItem("USA");
232. How can I programmatically filter a column
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Filter") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exNonBlanks; extree1.Items.AddItem(null); extree1.Items.AddItem("not empty"); extree1.ApplyFilter();
231. How can I show or display the control's filter
(extree1.Columns.Add("Filter") as exontrol.EXTREELib.Column).DisplayFilterButton = true;
230. How can I customize the items being displayed in the drop down filter window
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Custom Filter") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false; var_Column.CustomFilter = "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||" + "Text Documents (*.log,*.txt)||*.txt|*.log"; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exPattern; var_Column.Filter = "*.xls"; extree1.Items.AddItem("excel.xls"); extree1.Items.AddItem("word.doc"); extree1.Items.AddItem("pp.pps"); extree1.Items.AddItem("text.txt"); extree1.ApplyFilter();
229. How can I change the order or the position of the columns in the sort bar
extree1.SortBarVisible = true; extree1.SortBarColumnWidth = 48; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortDescending; extree1.Columns["C2"].SortPosition = 0;
228. How do I arrange my columns on multiple levels
(extree1.Columns.Add("S") as exontrol.EXTREELib.Column).Width = 32; (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("Level 4") as exontrol.EXTREELib.Column).LevelKey = 1; (extree1.Columns.Add("Level 1") as exontrol.EXTREELib.Column).LevelKey = "2"; (extree1.Columns.Add("Level 2") as exontrol.EXTREELib.Column).LevelKey = "2"; (extree1.Columns.Add("Level 3") as exontrol.EXTREELib.Column).LevelKey = "2"; (extree1.Columns.Add("Level 4") as exontrol.EXTREELib.Column).LevelKey = "2"; (extree1.Columns.Add("E") as exontrol.EXTREELib.Column).Width = 32;
227. How do I arrange my columns on multiple lines
extree1.HeaderHeight = 32; (extree1.Columns.Add("") as exontrol.EXTREELib.Column).HTMLCaption = "Line 1<br>Line 2";
226. How can I display all cells using HTML format
(extree1.Columns.Add("HTML") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellCaptionFormat,1); extree1.Items.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></fon" + "t>.");
225. How can I display all cells using multiple lines
(extree1.Columns.Add("MultipleLine") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellSingleLine,false); (extree1.Columns.Add("SingleLine") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellSingleLine,true); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("This is a bit of long text that should break the line"),1,"this is a bit of long text that's displayed on a single line");
224. How do change the vertical alignment for all cells in the column
(extree1.Columns.Add("MultipleLine") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellSingleLine,false); (extree1.Columns.Add("VAlign") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellVAlignment,2); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("This is a bit of long text that should break the line"),1,"bottom"); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem("This is a bit of long text that should break the line"),1,"bottom");
223. How do change the foreground color for all cells in the column
(extree1.Columns.Add("ForeColor") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellForeColor,255); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
222. How do change the background color for all cells in the column
(extree1.Columns.Add("BackColor") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellBackColor,255); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
221. How do I show buttons for all cells in the column
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Button") as exontrol.EXTREELib.Column); var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasButton,true); var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellButtonAutoWidth,true); extree1.Items.AddItem(" Button 1 "); extree1.Items.AddItem(" Button 2 ");
220. How do I show buttons for all cells in the column
(extree1.Columns.Add("Button") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasButton,true); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
219. How do I display radio buttons for all cells in the column
(extree1.Columns.Add("Radio") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasRadioButton,true); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
218. How do I display checkboxes for all cells in the column
(extree1.Columns.Add("Check") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
217. How can I display a tooltip when the cursor hovers the column
(extree1.Columns.Add("tooltip") as exontrol.EXTREELib.Column).ToolTip = "This is a bit of text that is shown when user hovers the column.";
216. Is there any function to assign a key to a column instead using its name or capion
(extree1.Columns.Add("Data") as exontrol.EXTREELib.Column).Key = "DKey"; extree1.Columns["DKey"].Caption = "new caption";
215. Is there any function to assign any extra data to a column
(extree1.Columns.Add("Data") as exontrol.EXTREELib.Column).Data = "your extra data";
214. By default, the column gets sorted descending, when I first click its header. How can I change so the column gets sorted ascending when the user first clicks the column's header
(extree1.Columns.Add("Sort") as exontrol.EXTREELib.Column).DefaultSortOrder = true;
213. How can I specify the maximum width for the column, if I use WidthAutoResize property
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Auto") as exontrol.EXTREELib.Column); var_Column.WidthAutoResize = true; var_Column.MinWidthAutoResize = 32; var_Column.MaxWidthAutoResize = 128; extree1.Items.AddItem(0); extree1.Items.AddItem(1);
212. How can I specify the minimum width for the column, if I use WidthAutoResize property
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Auto") as exontrol.EXTREELib.Column); var_Column.WidthAutoResize = true; var_Column.MinWidthAutoResize = 32; extree1.Items.AddItem(0); extree1.Items.AddItem(1);
211. Is there any option to resize the column based on its data, captions
(extree1.Columns.Add("A") as exontrol.EXTREELib.Column).WidthAutoResize = true; extree1.Items.AddItem(0); extree1.Items.AddItem(1);
210. How can I align the icon in the column's header in the center
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("") as exontrol.EXTREELib.Column); var_Column.HeaderImage = 1; var_Column.HeaderImageAlignment = exontrol.EXTREELib.AlignmentEnum.CenterAlignment;
209. How do I align the icon in the column's header to the right
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column); var_Column.HeaderImage = 1; var_Column.HeaderImageAlignment = exontrol.EXTREELib.AlignmentEnum.RightAlignment;
208. How do I show or hide the sorting icons, but still need sorting
(extree1.Columns.Add("Sorted") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending; extree1.Columns[0].DisplaySortIcon = false;
207. How do I enable or disable the entire column
extree1.Columns.Add("C1"); (extree1.Columns.Add("Disabled") as exontrol.EXTREELib.Column).Enabled = false; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem(0),1,"0.1"); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem(1),1,"1.1");
206. How do I disable drag and drop columns
(extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).AllowDragging = false; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).AllowDragging = false;
205. How do I disable resizing a column at runtime
(extree1.Columns.Add("Unsizable") as exontrol.EXTREELib.Column).AllowSizing = false; extree1.Columns.Add("C2"); extree1.Columns.Add("C3"); extree1.Columns.Add("C4");
204. How can I align the column to the right, and its caption too
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.Alignment = exontrol.EXTREELib.AlignmentEnum.RightAlignment; var_Column.HeaderAlignment = exontrol.EXTREELib.AlignmentEnum.RightAlignment; extree1.Items.AddItem(0); extree1.Items.AddItem(1);
203. How can I align the column to the right
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).Alignment = exontrol.EXTREELib.AlignmentEnum.RightAlignment; extree1.Items.AddItem(0); extree1.Items.AddItem(1);
202. How do I change the column's caption
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).Caption = "new caption";
201. Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions, after the user clicks it
extree1.set_FormatAnchor(false,"<b><u><fgcolor=880000> </fgcolor></u></b>"); extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaptionFormat(var_Items1.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML); extree1.Items.AddItem("next item");
200. Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions
extree1.set_FormatAnchor(true,"<b><u><fgcolor=FF0000> </fgcolor></u></b>"); extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaptionFormat(var_Items1.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
199. Can I change the font for the tooltip
extree1.ToolTipDelay = 1; extree1.ToolTipWidth = 364; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "<br><font Tahoma;14>this</font> is a tooltip assigned to a column<br>";
198. Can I change the font for the tooltip
extree1.ToolTipDelay = 1; stdole.IFontDisp var_StdFont = extree1.ToolTipFont; var_StdFont.Name = "Tahoma"; var_StdFont.Size = 14; extree1.ToolTipWidth = 364; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip assigned to a column";
197. Can I change the order of the buttons in the scroll bar
extree1.set_ScrollOrderParts(exontrol.EXTREELib.ScrollBarEnum.exHScroll,"t,l,r"); extree1.set_ScrollOrderParts(exontrol.EXTREELib.ScrollBarEnum.exVScroll,"t,l,r"); extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
196. The thumb size seems to be very small. Can I make it bigger
extree1.ColumnAutoResize = false; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C3") as exontrol.EXTREELib.Column).Width = 256; extree1.set_ScrollThumbSize(exontrol.EXTREELib.ScrollBarEnum.exHScroll,64);
195. How can I display my text on the scroll bar, using a different font
extree1.set_ScrollPartCaption(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exThumbPart,"This is <s><font Tahoma;12> just </font></s> text"); extree1.ColumnAutoResize = false; extree1.ScrollHeight = 20; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C3") as exontrol.EXTREELib.Column).Width = 256;
194. How can I display my text on the scroll bar, using a different font
extree1.set_ScrollPartCaption(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exThumbPart,"This is just a text"); extree1.get_ScrollFont(exontrol.EXTREELib.ScrollBarEnum.exHScroll).Size = 12; extree1.ColumnAutoResize = false; extree1.ScrollHeight = 20; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C3") as exontrol.EXTREELib.Column).Width = 256;
193. How can I display my text on the scroll bar
extree1.set_ScrollPartCaption(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exThumbPart,"this is just a text"); extree1.ColumnAutoResize = false; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C3") as exontrol.EXTREELib.Column).Width = 256;
192. How do I enlarge or change the size of the control's scrollbars
extree1.ScrollHeight = 18; extree1.ScrollWidth = 18; extree1.ScrollButtonWidth = 18; extree1.ScrollButtonHeight = 18; extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
191. How do I assign a tooltip to a scrollbar
extree1.set_ScrollToolTip(exontrol.EXTREELib.ScrollBarEnum.exHScroll,"This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar"); extree1.ColumnAutoResize = false; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).Width = 256; (extree1.Columns.Add("C3") as exontrol.EXTREELib.Column).Width = 256;
190. How do I assign an icon to the button in the scrollbar
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.set_ScrollPartVisible(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLeftB1Part,true); extree1.set_ScrollPartCaption(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLeftB1Part,"<img>1</img>"); extree1.ScrollHeight = 18; extree1.ScrollButtonWidth = 18; extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableNoHorizontal;
189. I need to add a button in the scroll bar. Is this possible
extree1.set_ScrollPartVisible(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLeftB1Part,true); extree1.set_ScrollPartCaption(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLeftB1Part,"1"); extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableNoHorizontal;
188. Can I display an additional buttons in the scroll bar
extree1.set_ScrollPartVisible(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLeftB1Part,true); extree1.set_ScrollPartVisible(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exLeftB2Part,true); extree1.set_ScrollPartVisible(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exRightB6Part,true); extree1.set_ScrollPartVisible(exontrol.EXTREELib.ScrollBarEnum.exHScroll,exontrol.EXTREELib.ScrollPartEnum.exRightB5Part,true); extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableNoHorizontal;
187. Can I display the picture aligned to the right, while the text aligned to the left
extree1.DefaultItemHeight = 48; extree1.Columns.Add("C1"); exontrol.EXTREELib.Items var_Items = extree1.Items; object s = var_Items.get_SplitCell(var_Items.AddItem("Text"),0); var_Items.set_CellPicture(0,s,(extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp)); var_Items.set_CellHAlignment(0,s,exontrol.EXTREELib.AlignmentEnum.RightAlignment);
186. How can I display a custom size picture to a cell or item
extree1.DefaultItemHeight = 48; extree1.Columns.Add("C1"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellPicture(var_Items.AddItem("Text"),0,(extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp));
185. How can I display a multiple pictures to a cell or item
extree1.DefaultItemHeight = 48; extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif"); extree1.set_HTMLPicture("pic2","c:\\exontrol\\images\\auction.gif"); extree1.Columns.Add("C1"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaptionFormat(var_Items.AddItem("<img>pic1</img> Text <img>pic2</img> another text ..."),0,exontrol.EXTREELib.CaptionFormatEnum.exHTML);
184. How do I change the column's foreground color for numbers between an interval - Range
exontrol.EXTREELib.ConditionalFormat var_ConditionalFormat = extree1.ConditionalFormats.Add("%0 >= 2 and %0 <= 10",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = (exontrol.EXTREELib.FormatApplyToEnum)0x1; extree1.Columns.Add("N1"); extree1.Columns.Add("N2"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem(1),1,2); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem(3),1,3); exontrol.EXTREELib.Items var_Items2 = extree1.Items; var_Items2.set_CellCaption(var_Items2.AddItem(10),1,11); exontrol.EXTREELib.Items var_Items3 = extree1.Items; var_Items3.set_CellCaption(var_Items3.AddItem(13),1,31); extree1.SearchColumnIndex = 1;
183. How do I change the item's foreground color for numbers between an interval - Range
extree1.ConditionalFormats.Add("%0 >= 2 and %0 <= 10",null).ForeColor = Color.FromArgb(255,0,0); extree1.Columns.Add("Numbers"); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(10); extree1.Items.AddItem(20);
182. How do I change the item's background color for numbers less than a value
extree1.ConditionalFormats.Add("%0 < 10",null).BackColor = Color.FromArgb(255,0,0); extree1.Columns.Add("Numbers"); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(10); extree1.Items.AddItem(20);
181. How do I underline the numbers greater than a value
extree1.ConditionalFormats.Add("%0 >= 10",null).Underline = true; extree1.Columns.Add("Numbers"); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(10); extree1.Items.AddItem(20);
180. How do I highlight in italic the numbers greater than a value
extree1.ConditionalFormats.Add("%0 >= 10",null).StrikeOut = true; extree1.Columns.Add("Numbers"); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(10); extree1.Items.AddItem(20);
179. How do I highlight in italic the numbers greater than a value
extree1.ConditionalFormats.Add("%0 >= 10",null).Italic = true; extree1.Columns.Add("Numbers"); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(10); extree1.Items.AddItem(20);
178. How do I highlight in bold the numbers greater than a value
extree1.ConditionalFormats.Add("%0 >= 10",null).Bold = true; extree1.Columns.Add("Numbers"); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(10); extree1.Items.AddItem(20);
177. Can I use your EBN files to change the visual appearance for +/- expand - collapse buttons
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot; extree1.HasButtons = exontrol.EXTREELib.ExpandButtonEnum.exCustom; extree1.set_HasButtonsCustom(false,16777216); extree1.set_HasButtonsCustom(true,33554432); extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child");
176. Can I use your EBN files to change the visual appearance for radio buttons
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.set_RadioImage(false,16777216); extree1.set_RadioImage(true,33554432); (extree1.Columns.Add("Radio") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasRadioButton,true); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Radio 1"); var_Items.set_CellState(var_Items.AddItem("Radio 2"),0,1); var_Items.AddItem("Radio 3");
175. Can I use your EBN files to change the visual appearance for checkbox cells
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Unchecked,16777216); extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Checked,33554432); (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("Check 1"); var_Items.set_CellState(var_Items.AddItem("Check 2"),0,1);
174. How do I change the visual aspect for thumb parts in the scroll bars, using EBN
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.VisualAppearance.Add(3,"c:\\exontrol\\images\\hot.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exHSThumb,0x1000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exHSThumbP,0x2000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exHSThumbH,0x3000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exVSThumb,0x1000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exVSThumbP,0x2000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exVSThumbH,0x3000000); extree1.ColumnAutoResize = false; extree1.ScrollBySingleLine = true; (extree1.Columns.Add("S") as exontrol.EXTREELib.Column).Width = 483; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemHeight(var_Items.AddItem("Item 1"),248); extree1.Items.AddItem("Item 2");
173. How do I change the visual aspect only for the thumb in the scroll bar, using EBN
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.VisualAppearance.Add(3,"c:\\exontrol\\images\\hot.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exHSThumb,0x1000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exHSThumbP,0x2000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exHSThumbH,0x3000000); extree1.ColumnAutoResize = false; (extree1.Columns.Add("S") as exontrol.EXTREELib.Column).Width = 483;
172. I've seen that you can change the visual appearance for the scroll bar. How can I do that
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.VisualAppearance.Add(3,"c:\\exontrol\\images\\hot.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exSBtn,0x1000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exSBtnP,0x2000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exSBtnH,0x3000000); extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exHSBack,Color.FromArgb(0,0,0)); extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exVSBack,Color.FromArgb(0,0,0)); extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exScrollSizeGrip,Color.FromArgb(0,0,0)); (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; extree1.ColumnAutoResize = false; extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
171. Is there any option to highligth the column from the cursor - point
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); 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;
170. How do I change the visual aspect of selected item in the drop down filter window, using your EBN technology
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exSelBackColorFilter,0x1000000); extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exSelForeColorFilter,Color.FromArgb(0,0,0)); (extree1.Columns.Add("Filter") as exontrol.EXTREELib.Column).DisplayFilterButton = true;
169. How do I change the visual aspect of the drop down calendar window, that shows up if I click the drop down filter button, using EBN
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exDateHeader,0x1000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exDateTodayUp,0x1000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exDateTodayDown,0x2000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exDateScrollThumb,0x1000000); extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exDateScrollRange,Color.FromArgb(0,0,0)); extree1.set_Background(exontrol.EXTREELib.BackgroundPartEnum.exDateSeparatorBar,Color.FromArgb(0,0,0)); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exDateSelect,0x1000000); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Date") as exontrol.EXTREELib.Column); var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exDate; var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true;
168. How do I change the visual aspect of the close button in the filter bar, using EBN
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exFooterFilterBarButton,0x1000000); (extree1.Columns.Add("Filter") as exontrol.EXTREELib.Column).FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
167. How do I change the visual aspect of buttons in the cell, using EBN
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exCellButtonUp,0x1000000); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exCellButtonDown,0x2000000); extree1.SelForeColor = Color.FromArgb(0,0,0); extree1.ShowFocusRect = false; (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasButton,true); extree1.Items.AddItem("Button 1"); extree1.Items.AddItem("Button 2"); extree1.Columns.Add("Column 2");
166. How do I change the visual aspect of the drop down filter button, using EBN
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.set_Background32(exontrol.EXTREELib.BackgroundPartEnum.exHeaderFilterBarButton,0x1000000); (extree1.Columns.Add("Filter") as exontrol.EXTREELib.Column).DisplayFilterButton = true;
165. Is there any function to get the control's data in your x-script format / template
extree1.Columns.Add("Column"); extree1.Items.AddItem(0);
164. How do I enable resizing the columns at runtime
extree1.ColumnsAllowSizing = true; extree1.MarkSearchColumn = false; extree1.HeaderVisible = false; extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exVLines; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("Item 1"),1,"Sub Item 1"); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem("Item 2"),1,"Sub Item 2");
163. How can I select the second inner column when spliting the cells
extree1.SelectColumnInner = 1; extree1.FullRowSelect = false; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exAllLines; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(0,var_Items.get_SplitCell(var_Items.AddItem("Split Cell 1.1"),0),"Split Cell 2.1"); var_Items.set_CellCaption(0,var_Items.get_SplitCell(var_Items.AddItem("Split Cell 1.2"),0),"Split Cell 2.2"); var_Items.set_SelectItem(var_Items.FirstVisibleItem,true);
162. How can I sort by multiple columns
extree1.SingleSort = false; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortDescending; (extree1.Columns.Add("C3") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending;
161. How can I add several columns to control's sort bar
extree1.SortBarVisible = true; extree1.SortBarColumnWidth = 48; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortDescending;
160. How can I change the width of the columns being displayed in the sort bar
extree1.SortBarVisible = true; extree1.SortBarColumnWidth = 48; (extree1.Columns.Add("C1") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending; (extree1.Columns.Add("C2") as exontrol.EXTREELib.Column).SortOrder = exontrol.EXTREELib.SortOrderEnum.SortDescending;
159. How can I change the height of the sort bar's
extree1.SortBarVisible = true; extree1.SortBarHeight = 48;
158. How can I change the sort bar's foreground color
extree1.SortBarVisible = true; extree1.ForeColorSortBar = Color.FromArgb(255,0,0);
157. How can I change the visual appearance of the control's sort bar, using EBN files
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); extree1.SortBarVisible = true; extree1.BackColorSortBar32 = 0x1000000; extree1.BackColorSortBarCaption32 = 0x2000000; extree1.Appearance = exontrol.EXTREELib.AppearanceEnum.None2;
156. How can I change the sort bar's background color
extree1.SortBarVisible = true; extree1.BackColorSortBar = Color.FromArgb(255,0,0); extree1.BackColorSortBarCaption = Color.FromArgb(128,0,0);
155. How can I change the default caption being displayed in the control's sort bar
extree1.SortBarVisible = true; extree1.SortBarCaption = "new caption";
154. How can I show the locked / fixed items on the bottom side of the control
extree1.ShowLockedItems = true; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_LockedItemCount(exontrol.EXTREELib.VAlignmentEnum.MiddleAlignment,2); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.MiddleAlignment,0),0,"locked item 1"); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.MiddleAlignment,1),0,"locked item 2"); var_Items.AddItem("un-locked item");
153. How can I show the locked / fixed items
extree1.ShowLockedItems = true; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_LockedItemCount(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,2); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,0),0,"locked item 1"); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,1),0,"locked item 2"); var_Items.AddItem("un-locked item");
152. How can I hide the locked / fixed items
extree1.ShowLockedItems = false; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_LockedItemCount(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,1); var_Items.set_CellCaption(var_Items.get_LockedItem(exontrol.EXTREELib.VAlignmentEnum.TopAlignment,0),0,"locked item"); var_Items.AddItem("un-locked item");
151. How can I show the control's sort bar
extree1.SortBarVisible = true;
extree1.PictureLevelHeader = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\colorize.gif`)") as stdole.IPictureDisp); extree1.PictureDisplayLevelHeader = exontrol.EXTREELib.PictureDisplayEnum.Stretch; (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;
149. How can I display a picture on the control's header, when multiple levels are displayed, so it is not tiled
extree1.PictureLevelHeader = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\colorize.gif`)") as stdole.IPictureDisp); extree1.PictureDisplayLevelHeader = exontrol.EXTREELib.PictureDisplayEnum.MiddleRight; (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("E") as exontrol.EXTREELib.Column).Width = 32;
148. How can I display a picture on the control's header, when multiple levels are displayed
extree1.PictureLevelHeader = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); (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;
147. How can I change the header's background color, when multiple levels are displayed
extree1.BackColorLevelHeader = Color.FromArgb(250,0,0); (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;
146. Can I programmatically scroll the control
extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(3); extree1.PutItems(extree1.GetItems(0),null); extree1.PutItems(extree1.GetItems(0),null); extree1.set_ScrollPos(true,1);
145. How do I disable expanding or collapsing an item when user presses the arrow keys
extree1.ExpandOnKeys = false; extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.Columns.Add("Column 1"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
144. How do I expand automatically the items while user types characters to searching for something ( incremental searching )
extree1.ExpandOnSearch = true; extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.AutoSearch = true; (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).AutoSearch = exontrol.EXTREELib.AutoSearchEnum.exContains; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.InsertItem(var_Items.InsertItem(var_Items.AddItem("text"),0,"some text"),0,"another text"); var_Items.InsertItem(var_Items.InsertItem(var_Items.AddItem("text"),0,"some text"),0,"another text");
143. Can I programmatically scroll the control
extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.Items.AddItem(3); extree1.PutItems(extree1.GetItems(0),null); extree1.PutItems(extree1.GetItems(0),null); extree1.Scroll(exontrol.EXTREELib.ScrollEnum.exScrollDown,null);
142. Do you have some function to load data from a safe array
extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.PutItems(extree1.GetItems(0),null);
141. Do you have some function to retrieve all items to a safe array
extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.PutItems(extree1.GetItems(0),null); extree1.Items.AddItem(1); extree1.PutItems(extree1.GetItems(0),null); extree1.Items.AddItem(2); extree1.PutItems(extree1.GetItems(0),null); extree1.Items.AddItem(3);
140. How can still display the selected items when the control loses the focus
extree1.HideSelection = false; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Item 3"); var_Items.AddItem("Item 1"); var_Items.set_SelectItem(var_Items.AddItem("Item 2"),true);
139. How can I hide a column
(extree1.Columns.Add("Hidden") as exontrol.EXTREELib.Column).Visible = false; extree1.Columns.Add("2"); extree1.Columns.Add("3"); extree1.Columns.Add("4"); extree1.Columns.Add("5");
138. How can I ensure that a column is visible and fits the control's client area
extree1.ColumnAutoResize = false; (extree1.Columns.Add("1") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("2") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("3") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("4") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("5") as exontrol.EXTREELib.Column).Width = 128; extree1.EnsureVisibleColumn("5");
137. I've seen that the width of the tooltip is variable. Can I make it larger
extree1.ToolTipWidth = 328; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip that should be very very very very very very very long";
136. How do I disable showing the tooltip for all control
extree1.ToolTipDelay = 0; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip assigned to a column";
135. How do I let the tooltip being displayed longer
extree1.ToolTipPopDelay = 10000; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip assigned to a column";
134. How do I show the tooltip quicker
extree1.ToolTipDelay = 1; (extree1.Columns.Add("tootip") as exontrol.EXTREELib.Column).ToolTip = "this is a tooltip assigned to a column";
133. How do I change the caption being displayed in the control's filter bar
extree1.FilterBarCaption = "your filter caption"; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
132. How do I disable expanding or collapsing an item when user double clicks it
extree1.ExpandOnDblClick = false; extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.Indent = 13; extree1.Columns.Add("Column 1"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
131. How do I search case sensitive, using your incremental search feature
extree1.AutoSearch = true; extree1.ASCIILower = ""; exontrol.EXTREELib.Columns var_Columns = extree1.Columns; (var_Columns.Add("exStartWith") as exontrol.EXTREELib.Column).AutoSearch = exontrol.EXTREELib.AutoSearchEnum.exStartWith; (var_Columns.Add("exContains") as exontrol.EXTREELib.Column).AutoSearch = exontrol.EXTREELib.AutoSearchEnum.exContains; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("text"),1,"another text"); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem("text"),1,"another text");
130. How do I disable the control
extree1.Enabled = false;
extree1.AutoSearch = true; exontrol.EXTREELib.Columns var_Columns = extree1.Columns; (var_Columns.Add("exStartWith") as exontrol.EXTREELib.Column).AutoSearch = exontrol.EXTREELib.AutoSearchEnum.exStartWith; (var_Columns.Add("exContains") as exontrol.EXTREELib.Column).AutoSearch = exontrol.EXTREELib.AutoSearchEnum.exContains; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("text"),1,"another text"); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_CellCaption(var_Items1.AddItem("text"),1,"another text");
128. How do I call your x-script language
exontrol.EXTREELib.Column var_Column = (extree1.ExecuteTemplate("Columns.Add(`Column`)") as exontrol.EXTREELib.Column); var_Column.HeaderStrikeOut = true; var_Column.HeaderBold = true;
127. How do I call your x-script language
extree1.Template = "Columns.Add(`Column`).HTMLCaption = `<b>C</b>olumn`";
extree1.BackColorAlternate = Color.FromArgb(240,240,240); extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Item 1"); var_Items.AddItem("Item 2"); var_Items.AddItem("Item 3"); var_Items.AddItem("Item 4"); var_Items.AddItem("Item 5");
125. How do I enlarge the drop down filter window
extree1.FilterBarDropDownHeight = "-320"; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterBarDropDownWidth = "-320"; extree1.Items.AddItem("Item 1"); extree1.Items.AddItem("Item 2");
124. How do I filter programatically the control
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exPattern; var_Column.Filter = "Item*"; extree1.Items.AddItem("Item 1"); extree1.Items.AddItem(""); extree1.Items.AddItem("Item 2"); extree1.ApplyFilter();
123. How do I change the font of the control's filterbar
extree1.FilterBarFont.Size = 20; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
122. Can I apply an EBN skin to the control's filter bar so I can change its visual appearance
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.FilterBarBackColor32 = 0x1000000; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
121. How do I change the background color of the control's filterbar
extree1.FilterBarBackColor = Color.FromArgb(240,240,240); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
120. How do I change the foreground color of the control's filterbar
extree1.FilterBarForeColor = Color.FromArgb(255,0,0); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
119. How do I change the height of the control's filterbar
extree1.FilterBarHeight = 32; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
118. How do select only a portion of text when the control starts editing a cell
extree1.AllowEdit = true; extree1.SelStart = 1; extree1.SelLength = 1; extree1.Columns.Add("Column"); extree1.Items.AddItem("Item 1"); extree1.Items.AddItem("Item 2");
117. How do I change the header's foreground color
extree1.ForeColorHeader = Color.FromArgb(255,0,0); extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); extree1.Items.AddItem("Item 1");
116. I have a picture on the control's background, the question is how do I draw selection as semi-transparent
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.SelBackMode = exontrol.EXTREELib.BackModeEnum.exTransparent; extree1.Columns.Add("Column"); extree1.Items.AddItem("Item 1"); extree1.Items.AddItem("Item 2");
115. It seems that the control uses the TAB key, is there any way to avoid that
extree1.UseTabKey = false;
extree1.SelectColumnIndex = 1; extree1.FullRowSelect = false; extree1.SelectColumn = true; extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("Item 1"),1,"SubItem 1");
113. How do I assign a database to your control, using ADO, ADOR or ADODB objects
extree1.ColumnAutoResize = false; extree1.ContinueColumnScroll = false; // Add 'Microsoft ActiveX Data Objects 6.0 Library' 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\\ExTree\\Sample\\VB\\S" + "AMPLE.MDB",exontrol.ADODB.CursorTypeEnum.adOpenStatic,exontrol.ADODB.LockTypeEnum.adLockOptimistic,0); extree1.DataSource = (rs as ADODB.Recordset);
112. How do I change the visual appearance effect for the selected item, using EBN
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.SelBackColor32 = 0x1000000; extree1.SelForeColor = Color.FromArgb(0,0,0); extree1.ShowFocusRect = false; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
111. How do I change the colors for the selected item
extree1.SelBackColor = Color.FromArgb(0,0,0); extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
110. How do I get ride of the rectangle arround focused item
extree1.ShowFocusRect = false; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1);
109. How can I change the control's font
extree1.Font.Name = "Tahoma"; extree1.Columns.Add("Column");
108. I can't scroll to the end of the data. What can I do
extree1.ScrollBySingleLine = true; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_ItemHeight(var_Items.AddItem(0),13); extree1.PutItems(extree1.GetItems(0),null); exontrol.EXTREELib.Items var_Items1 = extree1.Items; var_Items1.set_ItemHeight(var_Items1.AddItem(1),26); extree1.PutItems(extree1.GetItems(0),null); exontrol.EXTREELib.Items var_Items2 = extree1.Items; var_Items2.set_ItemHeight(var_Items2.AddItem(2),36); extree1.PutItems(extree1.GetItems(0),null); exontrol.EXTREELib.Items var_Items3 = extree1.Items; var_Items3.set_ItemHeight(var_Items3.AddItem(3),48); extree1.PutItems(extree1.GetItems(0),null);
107. How do I specify the column where the tree lines / hierarchy are shown
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot; extree1.TreeColumnIndex = 1; extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1.1"); var_Items.set_CellCaption(h,1,"Root 1.2"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Child 1.1"),1,"Child 1.2"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Child 2.1"),1,"Child 2.2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2.1"); var_Items.set_CellCaption(h,1,"Root 2.2"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Child 1.1"),1,"Child 1.2");
106. How do I specify the indentation of the child items relative to their parents
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot; extree1.Indent = 11; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child");
105. Is there any option to select an item using the right button of the mouse (rclick)
extree1.RClickSelect = true; extree1.Columns.Add("Column"); extree1.Items.AddItem("Item 1"); extree1.Items.AddItem("Item 2");
104. How do I edit a cell
extree1.AllowEdit = true; extree1.Columns.Add("Column"); extree1.Items.AddItem("Item 1"); extree1.Items.AddItem("Item 2");
103. I have FullRowSelect property on False, how do I select a column
extree1.SelectColumnIndex = 1; extree1.FullRowSelect = false;
102. How can I scroll columns one by one, not pixel by pixel
extree1.ContinueColumnScroll = false; extree1.ColumnAutoResize = false; (extree1.Columns.Add("1") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("2") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("3") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("4") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("5") as exontrol.EXTREELib.Column).Width = 128;
101. How can I enable multiple items selection
extree1.SingleSel = false; extree1.Columns.Add("Column"); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2);
100. How can I programmatically change the column where incremental searching is performed
extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("Item 1"),1,"SubItem 1"); extree1.SearchColumnIndex = 1;
99. How do I disable the full-row selection in the control
extree1.FullRowSelect = false; extree1.Columns.Add("Column"); extree1.Items.AddItem("One"); extree1.Items.AddItem("Two");
98. Is there any option to specify the height of the items, before adding them
extree1.DefaultItemHeight = 32; extree1.Columns.Add("Column"); extree1.Items.AddItem("One"); extree1.Items.AddItem("Two");
97. How do lock / fix some columns to the control, so I can see them all the time, event if I scroll the columns
extree1.CountLockedColumns = 1; extree1.BackColorLock = Color.FromArgb(240,240,240); extree1.ColumnAutoResize = false; (extree1.Columns.Add("Locked") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("Un-Locked 1") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("Un-Locked 2") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("Un-Locked 3") as exontrol.EXTREELib.Column).Width = 128; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("locked"),1,"unlocked");
96. How do I change the control's background / foreground color on the locked area
extree1.CountLockedColumns = 1; extree1.ForeColorLock = Color.FromArgb(240,240,240); extree1.BackColorLock = Color.FromArgb(128,128,128); extree1.ColumnAutoResize = false; (extree1.Columns.Add("Locked") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("Un-Locked 1") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("Un-Locked 2") as exontrol.EXTREELib.Column).Width = 128; (extree1.Columns.Add("Un-Locked 3") as exontrol.EXTREELib.Column).Width = 128; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("locked"),1,"unlocked");
95. How do I change the control's foreground color
extree1.ForeColor = Color.FromArgb(120,120,120); extree1.Columns.Add("Column"); extree1.Items.AddItem("item");
94. How do I change the control's background color
extree1.BackColor = Color.FromArgb(200,200,200);
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.set_RadioImage(false,1); extree1.set_RadioImage(true,2); (extree1.Columns.Add("Radio") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasRadioButton,true); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Radio 1"); var_Items.set_CellState(var_Items.AddItem("Radio 2"),0,1); var_Items.AddItem("Radio 3");
92. How do I use my own icons for checkbox cells
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Unchecked,1); extree1.set_CheckImage(exontrol.EXTREELib.CheckStateEnum.Checked,2); (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("Check 1"); var_Items.set_CellState(var_Items.AddItem("Check 2"),0,1);
91. How do I perform my own sorting when user clicks the column's header
extree1.SortOnClick = exontrol.EXTREELib.SortOnClickEnum.exUserSort; extree1.Columns.Add("Column"); extree1.Items.AddItem("Item 1"); extree1.Items.AddItem("Item 2");
90. How do I disable sorting a specified column when clicking its header
extree1.Columns.Add("1"); (extree1.Columns.Add("NoSort") as exontrol.EXTREELib.Column).AllowSort = false;
89. How do I disable sorting the columns when clicking the control's header
extree1.SortOnClick = exontrol.EXTREELib.SortOnClickEnum.exNoSort; extree1.Columns.Add("1"); extree1.Columns.Add("2");
88. How do I put a picture on the center of the control
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.PictureDisplay = exontrol.EXTREELib.PictureDisplayEnum.MiddleCenter;
87. How do I resize/stretch a picture on the control's background
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.PictureDisplay = exontrol.EXTREELib.PictureDisplayEnum.Stretch;
86. How do I put a picture on the control's center right bottom side
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.PictureDisplay = exontrol.EXTREELib.PictureDisplayEnum.LowerRight;
85. How do I put a picture on the control's center left bottom side
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.PictureDisplay = exontrol.EXTREELib.PictureDisplayEnum.LowerLeft;
84. How do I put a picture on the control's center top side
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.PictureDisplay = exontrol.EXTREELib.PictureDisplayEnum.UpperCenter;
83. How do I put a picture on the control's right top corner
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.PictureDisplay = exontrol.EXTREELib.PictureDisplayEnum.UpperRight;
82. How do I put a picture on the control's left top corner
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); extree1.PictureDisplay = exontrol.EXTREELib.PictureDisplayEnum.UpperLeft;
81. How do I put a picture on the control's background
extree1.Picture = (extree1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp);
80. How do I sort descending a column, and put the sorting icon in the column's header
extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Item 1"); var_Items.AddItem("Item 2"); var_Items.AddItem("Item 3"); extree1.Columns[0].SortOrder = exontrol.EXTREELib.SortOrderEnum.SortDescending;
79. How do I sort ascending a column, and put the sorting icon in the column's header
extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("Item 3"); var_Items.AddItem("Item 1"); var_Items.AddItem("Item 2"); extree1.Columns[0].SortOrder = exontrol.EXTREELib.SortOrderEnum.SortAscending;
78. How do I perform my own/custom sort, using my extra strings
(extree1.Columns.Add("desc") as exontrol.EXTREELib.Column).SortType = exontrol.EXTREELib.SortTypeEnum.SortUserData; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellData(var_Items.AddItem("A"),0,"C"); var_Items.set_CellData(var_Items.AddItem("B"),0,"B"); var_Items.set_CellData(var_Items.AddItem("C"),0,"A"); var_Items.SortChildren(0,0,false);
77. How do I perform my own/custom sort, using my extra numbers
(extree1.Columns.Add("desc") as exontrol.EXTREELib.Column).SortType = exontrol.EXTREELib.SortTypeEnum.SortUserData; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellData(var_Items.AddItem(0),0,2); var_Items.set_CellData(var_Items.AddItem(1),0,1); var_Items.set_CellData(var_Items.AddItem(2),0,0); var_Items.SortChildren(0,0,false);
76. By default, the column gets sorted as strings, so how do I sort a column by time only
(extree1.Columns.Add("desc") as exontrol.EXTREELib.Column).SortType = exontrol.EXTREELib.SortTypeEnum.SortTime; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("11:00"); var_Items.AddItem("10:10"); var_Items.AddItem("12:12"); var_Items.SortChildren(0,0,false);
75. By default, the column gets sorted as strings, so how do I sort a column by date and time
(extree1.Columns.Add("desc") as exontrol.EXTREELib.Column).SortType = exontrol.EXTREELib.SortTypeEnum.SortDateTime; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("1/1/2001 11:00"); var_Items.AddItem("1/1/2001 10:10"); var_Items.AddItem("1/3/2003"); var_Items.SortChildren(0,0,false);
74. By default, the column gets sorted as strings, so how do I sort a column by dates
(extree1.Columns.Add("desc") as exontrol.EXTREELib.Column).SortType = exontrol.EXTREELib.SortTypeEnum.SortDate; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem("1/1/2001"); var_Items.AddItem("1/2/2002"); var_Items.AddItem("1/3/2003"); var_Items.SortChildren(0,0,false);
73. How do I sort a column by numbers
(extree1.Columns.Add("desc") as exontrol.EXTREELib.Column).SortType = exontrol.EXTREELib.SortTypeEnum.SortNumeric; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem(1); var_Items.AddItem(5); var_Items.AddItem(10); var_Items.SortChildren(0,0,false);
72. How do I hide the control's header bar
extree1.HeaderVisible = false;
extree1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); extree1.BackColorHeader32 = 0x1000000;
70. How do I remove the control's border
extree1.Appearance = exontrol.EXTREELib.AppearanceEnum.None2;
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.FilterInclude = exontrol.EXTREELib.FilterIncludeEnum.exRootsWithChilds; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exFilter; var_Column.Filter = "R1"; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,0,"C1"); var_Items.InsertItem(h,0,"C2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,0,"C1"); var_Items.InsertItem(h,0,"C2"); extree1.ApplyFilter();
68. I have a hierarchy and I need to filter only root items that match, without thier childs
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.FilterInclude = exontrol.EXTREELib.FilterIncludeEnum.exRootsWithoutChilds; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exFilter; var_Column.Filter = "R1"; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,0,"C1"); var_Items.InsertItem(h,0,"C2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,0,"C1"); var_Items.InsertItem(h,0,"C2"); extree1.ApplyFilter();
67. I have a hierarchy and I need to filter only parent items that match, including thier childs
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.FilterInclude = exontrol.EXTREELib.FilterIncludeEnum.exItemsWithChilds; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exFilter; var_Column.Filter = "R1"; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("R1"); var_Items.InsertItem(h,0,"C1"); var_Items.InsertItem(h,0,"C2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("R2"); var_Items.InsertItem(h,0,"C1"); var_Items.InsertItem(h,0,"C2"); extree1.ApplyFilter();
66. How can I get ride/hide of the "Filter For" field
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false;
65. Is there any way to get listed only visible items in the drop down filter window
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarAll,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarBlanks,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarNonBlanks,""); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("P1") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false; var_Column.FilterList = exontrol.EXTREELib.FilterListEnum.exVisibleItems; exontrol.EXTREELib.Column var_Column1 = (extree1.Columns.Add("P2") as exontrol.EXTREELib.Column); var_Column1.DisplayFilterButton = true; var_Column1.DisplayFilterPattern = false; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("R1"); var_Items.set_CellCaption(h,1,"R2"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Cell 1.1"),1,"Cell 1.2"); var_Items.set_CellCaption(var_Items.InsertItem(h,0,"Cell 2.1"),1,"Cell 2.2");
64. How do I filter for items that match exactly the specified string
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exFilter; var_Column.Filter = "Item 1"; extree1.Items.AddItem("Item 1"); extree1.Items.AddItem("Item 2"); extree1.Items.AddItem("Item 3"); extree1.ApplyFilter();
63. How can I can I programmatically filter for items with a specified icon assigned
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exImage; var_Column.Filter = 1.ToString(); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellImage(var_Items.AddItem("Image 1"),0,1); var_Items.set_CellImage(var_Items.AddItem("Image 1"),0,1); var_Items.set_CellImage(var_Items.AddItem("Image 2"),0,2); var_Items.set_CellImage(var_Items.AddItem("Image 3"),0,3); extree1.ApplyFilter();
62. How can I can I programmatically filter the checked items
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exCheck; var_Column.Filter = 0.ToString(); extree1.Items.AddItem(0); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellState(var_Items.AddItem(1),0,1); extree1.Items.AddItem(2); extree1.ApplyFilter();
61. How can I can I filter programmatically the items based on some numerichal rules
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exNumeric; var_Column.Filter = "> 0 <= 1"; extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2); extree1.ApplyFilter();
60. How can I can I filter programmatically the items based on a range/interval of dates
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exDate; var_Column.Filter = "1/1/2001 to 1/1/2002"; extree1.Items.AddItem("1/1/2001"); extree1.Items.AddItem("2/1/2002"); extree1.ApplyFilter();
59. How can I can I filter programmatically given a specified pattern using wild characters like * or
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exPattern; var_Column.Filter = "0*"; extree1.Items.AddItem(0); extree1.Items.AddItem("00"); extree1.Items.AddItem(1); extree1.Items.AddItem("11"); extree1.ApplyFilter();
58. How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.ApplyFilter();
57. How can I display the column's filter
(extree1.Columns.Add("") as exontrol.EXTREELib.Column).DisplayFilterButton = true;
56. How can I show only the vertical scroll bar
extree1.ColumnAutoResize = true; extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableNoVertical; extree1.Columns.Add(1.ToString()); extree1.Columns.Add(2.ToString());
55. How can I show the control's grid lines only for added/visible items
extree1.MarkSearchColumn = false; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2);
54. Can I hide the hierarchy lines
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot; extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exNoLine; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child");
53. Can I change the style or type for the hierarchy lines
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot; extree1.HasLines = exontrol.EXTREELib.HierarchyLineEnum.exThinLine; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child");
52. Can I use my own icons for the +/- ( expand/collapse ) buttons
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot; extree1.HasButtons = exontrol.EXTREELib.ExpandButtonEnum.exCustom; extree1.set_HasButtonsCustom(false,1); extree1.set_HasButtonsCustom(true,2); extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child");
51. How do I change visual appearance of the +/- ( expand/collapse ) buttons
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exGroupLinesAtRoot; extree1.HasButtons = exontrol.EXTREELib.ExpandButtonEnum.exWPlus; extree1.Columns.Add("Column"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root 1"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true); h = var_Items.AddItem("Root 2"); var_Items.InsertItem(h,0,"Child");
50. How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exCheck; var_Column.Filter = 0.ToString(); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarIsChecked,"Check_On"); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarIsUnchecked,"Check_Off"); extree1.ApplyFilter();
49. How can I change the "Checked" caption in the drop down filter window, when I filter for checked items
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exCheck; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarChecked,"with check on"); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarUnchecked,"with check off");
48. How can I change the name of the week days in the drop down calendar window, being displayed when I filter items between dates
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarDateWeekDays,"Du Lu Ma Mi Jo Vi Si"); extree1.ApplyFilter();
47. How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarDateMonths,"Janvier Février Mars Avril Mai Juin Juillet Août Septembre Octobre Novembre Décembre"); extree1.ApplyFilter();
46. Can I change the "Today" caption being displayed in the drop down calendar, when I filter for dates
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarDateTodayCaption,"Azi"); extree1.ApplyFilter();
45. The drop down filter window displays a "to" string between two datem when I filter dates. Can I change that
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarDateTo,"->"); extree1.ApplyFilter();
44. How can I filter the items that are between an interval/range of dates
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; extree1.ApplyFilter();
43. Can I change the "Date:" caption when the column's drop down filter window is shown
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarDate,"Range"); extree1.ApplyFilter();
42. Can I filter for values using OR - NOT , instead AND operator
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; exontrol.EXTREELib.Column var_Column1 = (extree1.Columns.Add("Column 2") as exontrol.EXTREELib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; exontrol.EXTREELib.Column var_Column2 = (extree1.Columns.Add("Column 3") as exontrol.EXTREELib.Column); var_Column2.DisplayFilterButton = true; var_Column2.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.FilterCriteria = "%0 or not %1 and %2"; extree1.ApplyFilter();
41. Can I change the NOT string in the filter bar
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; exontrol.EXTREELib.Column var_Column1 = (extree1.Columns.Add("Column 2") as exontrol.EXTREELib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXTREELib.FilterTypeEnum.exNonBlanks; extree1.FilterCriteria = "not %0 or %1"; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarNot," ! "); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarIsNonBlank," ! IsBlank"); extree1.ApplyFilter();
40. Can I change the OR string in the filter bar
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; exontrol.EXTREELib.Column var_Column1 = (extree1.Columns.Add("Column 2") as exontrol.EXTREELib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXTREELib.FilterTypeEnum.exNonBlanks; extree1.FilterCriteria = "%0 or %1"; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarOr," | "); extree1.ApplyFilter();
39. Can I change the AND string in the filter bar
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; exontrol.EXTREELib.Column var_Column1 = (extree1.Columns.Add("Column 2") as exontrol.EXTREELib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXTREELib.FilterTypeEnum.exNonBlanks; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarAnd," & "); extree1.ApplyFilter();
38. The "IsBlank" caption shown in the control's filterbar when I select "Blanks" or "NonBlanks" items in the column's drop down filter window
exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Column") as exontrol.EXTREELib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXTREELib.FilterTypeEnum.exBlanks; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarIsBlank,"Is Empty"); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarIsNonBlank,"Is Not Empty"); extree1.ApplyFilter();
37. Is there any option to remove the tooltip when the cursor hovers the column's drop down filter window
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).DisplayFilterButton = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarFilterTitle,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarPatternFilterTitle,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarTooltip,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarPatternTooltip,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarFilterForTooltip,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarDateTooltip,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarDateTitle,"");
36. How can I change the "Filter For" caption in the column's drop down filter window
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).DisplayFilterButton = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarFilterForCaption,"new caption");
35. Can I remove the "All", "Blanks" and "NonBlanks" items in the drop down filter window
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).DisplayFilterButton = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarAll,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarBlanks,""); extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarNonBlanks,"");
34. How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window
(extree1.Columns.Add("Column") as exontrol.EXTREELib.Column).DisplayFilterButton = true; extree1.set_Description(exontrol.EXTREELib.DescriptionTypeEnum.exFilterBarAll,"new name for (All)");
33. How can I change the position of the column
extree1.Columns.Add("Column 1"); (extree1.Columns.Add("Column 2") as exontrol.EXTREELib.Column).Position = 0;
32. Can I make strikeout the column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HeaderStrikeOut = true;
31. How can I apply an strikeout font only a portion of the column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HTMLCaption = "<s>Col</s>umn 1";
30. How can I get underlined only a portion of column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HTMLCaption = "<u>Col</u>umn 1";
29. How can I underline the column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HeaderUnderline = true;
28. How can I apply an italic font only a portion of the column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HTMLCaption = "<i>Col</i>umn 1";
27. Is there any option to make italic the column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HeaderItalic = true;
26. How can I bold only a portion of the column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HTMLCaption = "<b>Col</b>umn 1";
25. Is there any option to bold the column's header
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HeaderBold = true;
24. Why child items are not shown
extree1.LinesAtRoot = exontrol.EXTREELib.LinesAtRootEnum.exLinesAtRoot; extree1.Columns.Add("Column 1"); exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
23. Does your control support partial-check ( three states ) feature for each column
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.Column var_Column1 = (extree1.Columns.Add("P2") as exontrol.EXTREELib.Column); var_Column1.set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true); var_Column1.PartialCheck = true; exontrol.EXTREELib.Items var_Items = extree1.Items; int h = var_Items.AddItem("Root"); var_Items.InsertItem(h,0,"Child 1"); var_Items.InsertItem(h,0,"Child 2"); var_Items.set_ExpandItem(h,true);
22. Is there any option to change the color for the grid lines
extree1.Columns.Add(""); extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exAllLines; extree1.GridLineColor = Color.FromArgb(255,0,0);
21. Can I change the font to display the column's header
extree1.HeaderHeight = 34; (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HTMLCaption = "<font Tahoma;14>Column</font> 1";
20. Can I change the height of the header bar
extree1.HeaderHeight = 32;
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).HTMLCaption = "1<img>1</img> 2 <img>2</img>...";
18. How can I draw grid lines only for visible items
extree1.MarkSearchColumn = false; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exRowLines; extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2);
17. How can I show the control's grid lines
extree1.MarkSearchColumn = false; extree1.DrawGridLines = exontrol.EXTREELib.GridLinesEnum.exAllLines; extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2);
16. How can I assign a different background color for the entire column
extree1.MarkSearchColumn = false; (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellBackColor,255); extree1.Columns.Add("Column 2"); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2);
15. How can I assign a check box for a cell
extree1.Columns.Add("Column 1"); exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.AddItem(0); var_Items.set_CellHasCheckBox(var_Items.AddItem(1),0,true); var_Items.AddItem(2);
14. How can I assign checkboxes for the entire column
(extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).set_Def(exontrol.EXTREELib.DefColumnEnum.exCellHasCheckBox,true); extree1.Items.AddItem(0); extree1.Items.AddItem(1); extree1.Items.AddItem(2);
13. How can I show both scrollbars
extree1.ScrollBars = exontrol.EXTREELib.ScrollBarsEnum.exDisableBoth;
extree1.ColumnAutoResize = false; (extree1.Columns.Add("Column 1") as exontrol.EXTREELib.Column).Width = 64; (extree1.Columns.Add("Column 2") as exontrol.EXTREELib.Column).Width = 128;
11. How can I show or hide a column
(extree1.Columns.Add("Hidden") as exontrol.EXTREELib.Column).Visible = false;
10. How can I hide the searching column
extree1.MarkSearchColumn = false; extree1.Columns.Add("Column 1"); extree1.Columns.Add("Column 2"); extree1.Items.AddItem(null);
9. Can I disable sorting a column, when the user clicks the column's header, or drag it to the sort bar
(extree1.Columns.Add("Unsortable") as exontrol.EXTREELib.Column).AllowSort = false; extree1.Columns.Add("Sortable");
8. Is there any option to align the header to the left and the data to the right
(extree1.Columns.Add("Left") as exontrol.EXTREELib.Column).Alignment = exontrol.EXTREELib.AlignmentEnum.LeftAlignment; exontrol.EXTREELib.Column var_Column = (extree1.Columns.Add("Right") as exontrol.EXTREELib.Column); var_Column.Alignment = exontrol.EXTREELib.AlignmentEnum.RightAlignment; var_Column.HeaderAlignment = exontrol.EXTREELib.AlignmentEnum.RightAlignment; exontrol.EXTREELib.Items var_Items = extree1.Items; var_Items.set_CellCaption(var_Items.AddItem("left"),1,"right");
7. Can I displays a custom size picture to column's header
extree1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif"); extree1.HeaderHeight = 48; (extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column).HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture";
6. How can I insert an icon to column's header
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column).HTMLCaption = "<b>HTML</b> Column <img>1</img> Icon";
5. How can I insert an icon to column's header
extree1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column).HeaderImage = 1;
4. How can I use HTML format in column's header
(extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column).HTMLCaption = "<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn";
3. How can I change/rename the column's name
(extree1.Columns.Add("ColumnName") as exontrol.EXTREELib.Column).Caption = "NewName";
2. How can I add multiple columns
exontrol.EXTREELib.Columns var_Columns = extree1.Columns; var_Columns.Add("Column 1"); var_Columns.Add("Column 2");
1. How can I add a new column
extree1.Columns.Add("ColumnName");