395. How can I apply the same ConditionalFormat on more than 1(one) column (multiple columns and not on item)
exlist1.BeginUpdate(); exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1","K1"); var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x1; exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat1 = exlist1.ConditionalFormats.Add("1","K2"); var_ConditionalFormat1.BackColor = Color.FromArgb(255,0,0); var_ConditionalFormat1.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x2; exlist1.MarkSearchColumn = false; exlist1.DrawGridLines = (exontrol.EXLISTLib.GridLinesEnum)0xfffffffc | exontrol.EXLISTLib.GridLinesEnum.exVLines; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Column 1"); var_Columns.Add("Column 2"); var_Columns.Add("Column 3"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(0); var_Items.Add(0); var_Items.Add(0); exlist1.EndUpdate();
394. How can I get the list of items as they are displayed
exlist1.BeginUpdate(); exlist1.BackColorAlternate = Color.FromArgb(240,240,240); exlist1.Columns.Add("Names"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Mantel"); var_Items.Add("Mechanik"); var_Items.Add("Motor"); var_Items.Add("Murks"); var_Items.Add("Märchen"); var_Items.Add("Möhren"); var_Items.Add("Mühle"); exlist1.Columns[0].SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending; exlist1.EndUpdate(); System.Diagnostics.Debug.Print( exlist1.GetItems(1).ToString() );
393. Is posible to reduce the size of the picture to be shown in the column's caption
exlist1.BeginUpdate(); exlist1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif"); exlist1.HeaderHeight = 48; (exlist1.Columns.Add("DefaultSize") as exontrol.EXLISTLib.Column).HTMLCaption = "Default-Size <img>pic1</img> Picture"; (exlist1.Columns.Add("CustomSize") as exontrol.EXLISTLib.Column).HTMLCaption = "Custom-Size <img>pic1:16</img> Picture"; exlist1.EndUpdate();
392. How can I change the color, font, bold etc for the items/cells in the same column or for the entire column
exlist1.BeginUpdate(); exlist1.MarkSearchColumn = false; exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x1; exlist1.Columns.Add("C1"); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column); var_Column.HeaderBold = true; var_Column.HTMLCaption = "<fgcolor=FF0000>C2"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add(10),1,11); var_Items.set_Caption(var_Items.Add(12),1,13); exlist1.EndUpdate();
391. Is it possible to limit the height of item while resizing the row
// AddItem event - Occurs after a new Item is inserted to Items collection. private void exlist1_AddItem(object sender,int Item) { exlist1.Items.set_ItemMinHeight(Item,18); exlist1.Items.set_ItemMaxHeight(Item,72); } //this.exlist1.AddItem += new exontrol.EXLISTLib.exg2antt.AddItemEventHandler(this.exlist1_AddItem); exlist1.BeginUpdate(); exlist1.ItemsAllowSizing = exontrol.EXLISTLib.ItemsAllowSizingEnum.exResizeItem; exlist1.ScrollBySingleLine = false; exlist1.BackColorAlternate = Color.FromArgb(240,240,240); exlist1.Columns.Add("Names"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Mantel"); var_Items.Add("Mechanik"); var_Items.Add("Motor"); var_Items.Add("Murks"); var_Items.Add("Märchen"); var_Items.Add("Möhren"); var_Items.Add("Mühle"); exlist1.Columns[0].SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending; exlist1.EndUpdate();
390. Can I specify un-sortable items so they keep their position once the user sorts the columns
(exlist1.Columns.Add("Def") as exontrol.EXLISTLib.Column).SortType = exontrol.EXLISTLib.SortTypeEnum.SortNumeric; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_SortableItem(var_Items.Add("Unsortable"),false); var_Items.Add(1); var_Items.Add(2); var_Items.Add(3);
389. The item is not getting selected when clicking the cell's checkbox. What should I do
// CellStateChanged event - Fired after cell's state is changed.
private void exlist1_CellStateChanged(object sender,int ItemIndex,int ColIndex)
{
exlist1.Items.set_SelectItem(ItemIndex,true);
}
//this.exlist1.CellStateChanged += new exontrol.EXLISTLib.exg2antt.CellStateChangedEventHandler(this.exlist1_CellStateChanged);
(exlist1.Columns.Add("Check") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasCheckBox,true);
exontrol.EXLISTLib.Items var_Items = exlist1.Items;
var_Items.Add(0);
var_Items.Add(1);
var_Items.Add(2);
var_Items.Add(3);
exlist1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif");
exlist1.ToolTipDelay = 1;
(exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.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>";
exlist1.VisualAppearance.Add(1,"gBFLBCJwBAEHhEJAEGg4BI0IQAAYAQGKIYBkAKBQAGaAoDDUOQzQwAAxDKKUEwsACEIrjKCYVgOHYYRrIMYgBCMJhLEoaZL" + "hEZRQiqDYtRDFQBSDDcPw/EaRZohGaYJgEgI="); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,0x1000000); (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("E1") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E2") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E3") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E4") as exontrol.EXLISTLib.Column).Width = 32;
386. Is there any option to show the tooltip programmatically
// MouseMove event - Occurs when the user moves the mouse.
private void exlist1_MouseMoveEvent(object sender,short Button,short Shift,int X,int Y)
{
exlist1.ShowToolTip(exlist1.get_ItemFromPoint(-1,-1,c,hit).ToString(),"","8","8",null);
}
//this.exlist1.MouseMoveEvent += new exontrol.EXLISTLib.exg2antt.MouseMoveEventHandler(this.exlist1_MouseMoveEvent);
exlist1.BeginUpdate();
exlist1.Columns.Add("Def");
exontrol.EXLISTLib.Items var_Items = exlist1.Items;
var_Items.Add("Item 1");
var_Items.Add("Item 2");
var_Items.Add("Item 3");
exlist1.EndUpdate();
exlist1.SelBackMode = exontrol.EXLISTLib.BackModeEnum.exTransparent; exlist1.BackColorAlternate = Color.FromArgb(240,240,240); exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.Add("Item 4"); var_Items.Add("Item 5");
384. Can I use PNG images to display pictures in the control
exlist1.set_HTMLPicture("pic1","c:\\exontrol\\images\\card.png"); exlist1.HeaderHeight = 48; (exlist1.Columns.Add("ColumnName") as exontrol.EXLISTLib.Column).HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture";
383. Does your control support conditional format and computed fields
exlist1.BeginUpdate(); exlist1.MarkSearchColumn = false; exontrol.EXLISTLib.ConditionalFormats var_ConditionalFormats = exlist1.ConditionalFormats; exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = var_ConditionalFormats.Add("%1 >4",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.StrikeOut = true; var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x1; exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat1 = var_ConditionalFormats.Add("%2 > 4",null); var_ConditionalFormat1.Bold = true; var_ConditionalFormat1.StrikeOut = true; var_ConditionalFormat1.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat1.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x2; exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat2 = var_ConditionalFormats.Add("%3 > 4",null); var_ConditionalFormat2.Bold = true; var_ConditionalFormat2.StrikeOut = true; var_ConditionalFormat2.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat2.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x3; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Name"); exontrol.EXLISTLib.Column var_Column = (var_Columns.Add("A") as exontrol.EXLISTLib.Column); var_Column.SortType = exontrol.EXLISTLib.SortTypeEnum.SortNumeric; var_Column.AllowSizing = false; var_Column.Width = 36; var_Column.FormatColumn = "len(value) ? value + ' +'"; exontrol.EXLISTLib.Column var_Column1 = (var_Columns.Add("B") as exontrol.EXLISTLib.Column); var_Column1.SortType = exontrol.EXLISTLib.SortTypeEnum.SortNumeric; var_Column1.AllowSizing = false; var_Column1.Width = 36; var_Column1.FormatColumn = "len(value) ? value + ' +'"; exontrol.EXLISTLib.Column var_Column2 = (var_Columns.Add("C") as exontrol.EXLISTLib.Column); var_Column2.SortType = exontrol.EXLISTLib.SortTypeEnum.SortNumeric; var_Column2.AllowSizing = false; var_Column2.Width = 36; var_Column2.FormatColumn = "len(value) ? value + ' ='"; exontrol.EXLISTLib.Column var_Column3 = (var_Columns.Add("A+B+C") as exontrol.EXLISTLib.Column); var_Column3.SortType = exontrol.EXLISTLib.SortTypeEnum.SortNumeric; var_Column3.AllowSizing = false; var_Column3.Width = 64; var_Column3.ComputedField = "%1+%2+%3"; var_Column3.FormatColumn = "((0:=dbl(value)) < 10? '<fgcolor=808080><font ;7>' :'<b>') + currency(=:0)"; var_Column3.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCaptionFormat,1); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h1 = var_Items.Add("Item 1"); var_Items.set_Caption(h1,1,7); var_Items.set_Caption(h1,2,3); var_Items.set_Caption(h1,3,1); h1 = var_Items.Add("Item 2"); var_Items.set_Caption(h1,1,2); var_Items.set_Caption(h1,2,5); var_Items.set_Caption(h1,3,12); h1 = var_Items.Add("Item 3"); var_Items.set_Caption(h1,1,2); var_Items.set_Caption(h1,2,2); var_Items.set_Caption(h1,3,4); h1 = var_Items.Add("Item 4"); var_Items.set_Caption(h1,1,2); var_Items.set_Caption(h1,2,9); var_Items.set_Caption(h1,3,4); exlist1.EndUpdate();
382. Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
exlist1.BeginUpdate(); exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableBoth; exontrol.EXLISTLib.Columns var_Columns = exlist1.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"); exlist1.RightToLeft = true; exlist1.EndUpdate();
381. Can I display the cell's check box after the text
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellHasCheckBox(var_Items.Add("Caption 1"),0,true); var_Items.set_CellHasCheckBox(var_Items.Add("Caption 2"),0,true);
380. Can I change the order of the parts in the cell, as checkbox after the text, and so on
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Text"); var_Items.set_CellImage(h,0,1); var_Items.set_CellHasCheckBox(h,0,true);
379. Can I have an image displayed after the text. Can I get that effect without using HTML content
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellDrawPartsOrder,"caption,icon,check,icons,picture"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Text"); var_Items.set_CellImage(h,0,1);
378. Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
exlist1.BeginUpdate(); exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableBoth; exontrol.EXLISTLib.Columns var_Columns = exlist1.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"); exlist1.RightToLeft = true; exlist1.EndUpdate();
377. How can I change the foreground color for a particular column
exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Column 1"); (var_Columns.Add("Column 2") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exHeaderForeColor,8439039); var_Columns.Add("Column 3");
376. How can I change the background color for a particular column
exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Column 1"); (var_Columns.Add("Column 2") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exHeaderBackColor,8439039); var_Columns.Add("Column 3");
375. How can I display the column using currency format and enlarge the font for certain values
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Currency") as exontrol.EXLISTLib.Column); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "len(value) ? ((0:=dbl(value)) < 10 ? '<fgcolor=808080><font ;7>' : '<b>') + currency(=:0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("1.23"); var_Items.Add("2.34"); var_Items.Add("9.94"); var_Items.Add("11.94"); var_Items.Add("1000");
374. How can I highlight only parts of the cells
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("") as exontrol.EXLISTLib.Column); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "value replace 'hil' with '<fgcolor=FF0000><b>hil</b></fgcolor>'"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Root"); var_Items.Add("Child 1"); var_Items.Add("Child 2"); var_Items.Add("Child 3");
373. How can I get the number of occurrences of a specified string in the cell
exlist1.Columns.Add(""); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("occurrences") as exontrol.EXLISTLib.Column); var_Column.ComputedField = "lower(%0) count 'o'"; var_Column.FormatColumn = "'contains ' + value + ' of \\'o\\' chars'"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Root"); var_Items.Add("Child 1 oooof the root"); var_Items.Add("Child 2"); var_Items.Add("Child 3");
372. How can I display dates in my format
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Date") as exontrol.EXLISTLib.Column); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "'<b>' + year(0:=date(value)) + '</b><fgcolor=808080><font ;6> (' + month(=:0) + ' - ' + day(=:0" + ") +')'"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/21/2001")); var_Items.Add(Convert.ToDateTime("2/22/2002")); var_Items.Add(Convert.ToDateTime("3/13/2003")); var_Items.Add(Convert.ToDateTime("4/24/2004"));
371. How can I display dates in short format
(exlist1.Columns.Add("Date") as exontrol.EXLISTLib.Column).FormatColumn = "shortdate(value)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/1/2001")); var_Items.Add(Convert.ToDateTime("2/2/2002")); var_Items.Add(Convert.ToDateTime("3/3/2003")); var_Items.Add(Convert.ToDateTime("4/4/2004"));
370. How can I display dates in long format
(exlist1.Columns.Add("Date") as exontrol.EXLISTLib.Column).FormatColumn = "longdate(value)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/1/2001")); var_Items.Add(Convert.ToDateTime("2/2/2002")); var_Items.Add(Convert.ToDateTime("3/3/2003")); var_Items.Add(Convert.ToDateTime("4/4/2004"));
369. How can I display only the right part of the cell
exlist1.Columns.Add(""); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Right") as exontrol.EXLISTLib.Column); var_Column.ComputedField = "%0 right 2"; var_Column.FormatColumn = "'\"' + value + '\"'"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Root"); var_Items.Add("Child 1"); var_Items.Add("Child 2"); var_Items.Add("SChild 3");
368. How can I display only the left part of the cell
exlist1.Columns.Add(""); (exlist1.Columns.Add("Left") as exontrol.EXLISTLib.Column).ComputedField = "%0 left 2"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Root"); var_Items.Add("Child 1"); var_Items.Add("Child 2"); var_Items.Add("SChild 3");
367. How can I display true or false instead 0 and -1
(exlist1.Columns.Add("Boolean") as exontrol.EXLISTLib.Column).FormatColumn = "value != 0 ? 'true' : 'false'"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(true); var_Items.Add(false); var_Items.Add(true); var_Items.Add(0); var_Items.Add(1);
366. How can I display icons or images instead numbers
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Icons") as exontrol.EXLISTLib.Column); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCaptionFormat,1); var_Column.FormatColumn = "'The cell displays the icon <img>'+value+'</img> instead ' + value"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(1); var_Items.Add(2); var_Items.Add(3);
365. How can I display the column using currency
(exlist1.Columns.Add("Currency") as exontrol.EXLISTLib.Column).FormatColumn = "currency(dbl(value))"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("1.23"); var_Items.Add("2.34"); var_Items.Add("0"); var_Items.Add(5); var_Items.Add("10000.99");
364. Is is possible to use HTML tags to display in the filter caption
exlist1.BeginUpdate(); exlist1.FilterBarPromptVisible = true; exlist1.FilterBarCaption = "This is a bit of text being displayed in the filter bar."; exlist1.Columns.Add(""); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); exlist1.EndUpdate();
363. How can I find the number of items after filtering
exlist1.BeginUpdate(); exlist1.Columns.Add(""); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add(""); var_Items.set_Caption(h,0,var_Items.VisibleItemCount); exlist1.EndUpdate();
362. How can I change the filter caption
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = (exontrol.EXLISTLib.FilterPromptEnum)0x2000 | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptContainsAll | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptStartWords; exlist1.FilterBarPromptPattern = "london robert"; exlist1.FilterBarCaption = "<r>Found: ... "; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
361. While using the filter prompt is it is possible to use wild characters
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptPattern; exlist1.FilterBarPromptPattern = "lon* seat*"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
360. How can I list all items that contains any of specified words, not necessary at the beggining
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptStartWords; exlist1.FilterBarPromptPattern = "london davolio"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
359. How can I list all items that contains any of specified words, not strings
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = (exontrol.EXLISTLib.FilterPromptEnum)0x2000 | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptStartWords; exlist1.FilterBarPromptPattern = "london nancy"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
358. How can I list all items that contains all specified words, not strings
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = (exontrol.EXLISTLib.FilterPromptEnum)0x2000 | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptContainsAll | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptStartWords; exlist1.FilterBarPromptPattern = "london robert"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
357. I've noticed that the filtering by prompt is not case sensitive, is is possible to make it case sensitive
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny | exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptCaseSensitive; exlist1.FilterBarPromptPattern = "Anne"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
356. Is it possible to list only items that ends with any of specified strings
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptEndWith; exlist1.FilterBarPromptColumns = "0"; exlist1.FilterBarPromptPattern = "Fuller"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
355. Is it possible to list only items that ends with any of specified strings
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptEndWith; exlist1.FilterBarPromptColumns = "0"; exlist1.FilterBarPromptPattern = "Fuller"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
354. Is it possible to list only items that starts with any of specified strings
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptStartWith; exlist1.FilterBarPromptColumns = "0"; exlist1.FilterBarPromptPattern = "An M"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
353. Is it possible to list only items that starts with specified string
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptStartWith; exlist1.FilterBarPromptColumns = "0"; exlist1.FilterBarPromptPattern = "A"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
352. How can I specify that the list should include any of the seqeunces in the pattern
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptContainsAny; exlist1.FilterBarPromptPattern = "london seattle"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
351. How can I specify that all sequences in the filter pattern must be included in the list
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptType = exontrol.EXLISTLib.FilterPromptEnum.exFilterPromptContainsAll; exlist1.FilterBarPromptPattern = "london manager"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
350. How do I change at runtime the filter prompt
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptPattern = "london manager"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
349. How do I specify to filter only a single column when using the filter prompt
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPromptColumns = "2,3"; exlist1.FilterBarPromptPattern = "london"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
348. How do I change the prompt or the caption being displayed in the filter bar
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exlist1.FilterBarPrompt = "changed"; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exlist1.EndUpdate();
347. How do I enable the filter prompt feature
exlist1.BeginUpdate(); exlist1.ColumnAutoResize = true; exlist1.ContinueColumnScroll = false; exlist1.MarkSearchColumn = false; exlist1.SearchColumnIndex = 1; exlist1.FilterBarPromptVisible = true; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("Name") as exontrol.EXLISTLib.Column).Width = 96; (var_Columns.Add("Title") as exontrol.EXLISTLib.Column).Width = 96; var_Columns.Add("City"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h0 = var_Items.Add("Nancy Davolio"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Andrew Fuller"); var_Items.set_Caption(h0,1,"Vice President, Sales"); var_Items.set_Caption(h0,2,"Tacoma"); var_Items.set_SelectItem(h0,true); h0 = var_Items.Add("Janet Leverling"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Kirkland"); h0 = var_Items.Add("Margaret Peacock"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"Redmond"); h0 = var_Items.Add("Steven Buchanan"); var_Items.set_Caption(h0,1,"Sales Manager"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Michael Suyama"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Robert King"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); h0 = var_Items.Add("Laura Callahan"); var_Items.set_Caption(h0,1,"Inside Sales Coordinator"); var_Items.set_Caption(h0,2,"Seattle"); h0 = var_Items.Add("Anne Dodsworth"); var_Items.set_Caption(h0,1,"Sales Representative"); var_Items.set_Caption(h0,2,"London"); exlist1.EndUpdate();
346. Is it possible to change the style for the vertical or horizontal grid lines, in the list area
exlist1.BeginUpdate(); exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; exlist1.GridLineStyle = exontrol.EXLISTLib.GridLinesStyleEnum.exGridLinesHDot4 | exontrol.EXLISTLib.GridLinesStyleEnum.exGridLinesVSolid; exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exlist1.Columns.Add("C3"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.set_Caption(h,1,"SubItem 1.2"); var_Items.set_Caption(h,2,"SubItem 1.3"); h = var_Items.Add("Item 2"); var_Items.set_Caption(h,1,"SubItem 2.2"); var_Items.set_Caption(h,2,"SubItem 2.3"); exlist1.EndUpdate();
345. Is it possible to change the style for the grid lines, for instance to be solid not dotted
exlist1.BeginUpdate(); exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; exlist1.GridLineStyle = exontrol.EXLISTLib.GridLinesStyleEnum.exGridLinesSolid; exlist1.Columns.Add("Column"); exlist1.EndUpdate();
344. How can I filter programatically using more columns
exlist1.BeginUpdate(); exlist1.MarkSearchColumn = false; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Car"); var_Columns.Add("Equipment"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("Mazda"),1,"Air Bag"); var_Items.set_Caption(var_Items.Add("Toyota"),1,"Air Bag,Air condition"); var_Items.set_Caption(var_Items.Add("Ford"),1,"Air condition"); var_Items.set_Caption(var_Items.Add("Nissan"),1,"Air Bag,ABS,ESP"); var_Items.set_Caption(var_Items.Add("Mazda"),1,"Air Bag, ABS,ESP"); var_Items.set_Caption(var_Items.Add("Mazda"),1,"ABS,ESP"); exontrol.EXLISTLib.Column var_Column = exlist1.Columns["Car"]; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exFilter; var_Column.Filter = "Mazda"; exontrol.EXLISTLib.Column var_Column1 = exlist1.Columns["Equipment"]; var_Column1.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exPattern; var_Column1.Filter = "*ABS*|*ESP*"; exlist1.ApplyFilter(); exlist1.EndUpdate();
343. How do I find an item based on my extra data
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.set_ItemData(var_Items.Add("Item 3"),1234); var_Items.Add("Item 4"); var_Items.set_ItemBold(var_Items.get_FindItemData(1234,null),true);
342. How do I print the control's content
exlist1.BeginUpdate(); exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Currency") as exontrol.EXLISTLib.Column).ComputedField = "len(%0) ? currency(dbl(%0)) : ''"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("1.23"); var_Items.Add("2.34"); var_Items.Add("0"); var_Items.set_ItemBackColor(var_Items.Add(null),Color.FromArgb(0,0,0)); var_Items.Add("10000.99"); exlist1.EndUpdate(); // Add 'exontrol.exprint.dll' reference to your project. // Add 'ExPrint 1.0 Control Library' reference to your project. exontrol.EXPRINTLib.exprint var_Print = new exontrol.EXPRINTLib.exprint(); var_Print.PrintExt = (exlist1 as exontrol.EXLISTLib.exlist); var_Print.Preview();
341. How can I display the currency only for not empty cells
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Currency") as exontrol.EXLISTLib.Column).ComputedField = "len(%0) ? currency(dbl(%0)) : ''"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("1.23"); var_Items.Add("2.34"); var_Items.Add("0"); var_Items.set_ItemBackColor(var_Items.Add(null),Color.FromArgb(0,0,0)); var_Items.Add("10000.99");
340. Is there a function to display the number of days between two date including the number of hours
(exlist1.Columns.Add("Start") as exontrol.EXLISTLib.Column).Width = 32; exlist1.Columns.Add("End"); (exlist1.Columns.Add("Duration") as exontrol.EXLISTLib.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.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add(Convert.ToDateTime("1/11/2001")); var_Items.set_Caption(h,1,Convert.ToDateTime("1/14/2001")); h = var_Items.Add(Convert.ToDateTime("2/22/2002 12:00:00 PM")); var_Items.set_Caption(h,1,Convert.ToDateTime("3/14/2002 1:00:00 PM")); h = var_Items.Add(Convert.ToDateTime("3/13/2003")); var_Items.set_Caption(h,1,Convert.ToDateTime("4/11/2003 11:00:00 AM"));
339. Is there a function to display the number of days between two date including the number of hours
exlist1.Columns.Add("Start"); exlist1.Columns.Add("End"); (exlist1.Columns.Add("Duration") as exontrol.EXLISTLib.Column).ComputedField = "\"D \" + int(date(%1)-date(%0)) + \" H \" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%" + "0))))"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add(Convert.ToDateTime("1/11/2001")); var_Items.set_Caption(h,1,Convert.ToDateTime("1/14/2001 11:00:00 PM")); h = var_Items.Add(Convert.ToDateTime("2/22/2002 12:00:00 PM")); var_Items.set_Caption(h,1,Convert.ToDateTime("3/14/2002 1:00:00 PM")); h = var_Items.Add(Convert.ToDateTime("3/13/2003")); var_Items.set_Caption(h,1,Convert.ToDateTime("4/11/2003 11:00:00 AM"));
338. How can I display the number of days between two dates
exlist1.Columns.Add("Start"); exlist1.Columns.Add("End"); (exlist1.Columns.Add("Duration") as exontrol.EXLISTLib.Column).ComputedField = "(date(%1)-date(%0)) + ' days'"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add(Convert.ToDateTime("1/11/2001")); var_Items.set_Caption(h,1,Convert.ToDateTime("1/14/2001")); h = var_Items.Add(Convert.ToDateTime("2/22/2002")); var_Items.set_Caption(h,1,Convert.ToDateTime("3/14/2002")); h = var_Items.Add(Convert.ToDateTime("3/13/2003")); var_Items.set_Caption(h,1,Convert.ToDateTime("4/11/2003"));
337. How can I get second part of the date
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Second") as exontrol.EXLISTLib.Column).ComputedField = "sec(date(%0))"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/11/2001 10:10:00 AM")); var_Items.Add(Convert.ToDateTime("2/22/2002 11:01:22 AM")); var_Items.Add(Convert.ToDateTime("3/13/2003 12:23:01 PM")); var_Items.Add(Convert.ToDateTime("4/14/2004 1:11:59 PM"));
336. How can I get minute part of the date
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Minute") as exontrol.EXLISTLib.Column).ComputedField = "min(date(%0))"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/11/2001 10:10:00 AM")); var_Items.Add(Convert.ToDateTime("2/22/2002 11:01:00 AM")); var_Items.Add(Convert.ToDateTime("3/13/2003 12:23:00 PM")); var_Items.Add(Convert.ToDateTime("4/14/2004 1:11:00 PM"));
335. How can I check the hour part only so I know it was afternoon
exlist1.ConditionalFormats.Add("hour(%0)>=12",null).Bold = true; exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Hour") as exontrol.EXLISTLib.Column).ComputedField = "hour(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/11/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
334. What about a function to get the day in the week, or days since Sunday
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("WeekDay") as exontrol.EXLISTLib.Column).ComputedField = "weekday(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/11/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
333. Is there any function to get the day of the year or number of days since January 1st
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Day since January 1st") as exontrol.EXLISTLib.Column).ComputedField = "yearday(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/11/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
332. How can I display only the day of the date
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Day") as exontrol.EXLISTLib.Column).ComputedField = "day(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/11/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/22/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/13/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/14/2004 1:00:00 PM"));
331. How can I display only the month of the date
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Month") as exontrol.EXLISTLib.Column).ComputedField = "month(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
330. How can I get only the year part from a date expression
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Year") as exontrol.EXLISTLib.Column).ComputedField = "year(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
329. Can I convert the expression to date
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Date") as exontrol.EXLISTLib.Column).ComputedField = "date(dbl(%0))"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("-1.98"); var_Items.Add("30000.99"); var_Items.Add("3561.23"); var_Items.Add("1232.34");
328. Can I convert the expression to a number, double or float
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Number + 2") as exontrol.EXLISTLib.Column).ComputedField = "dbl(%0)+2"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("-1.98"); var_Items.Add("0.99"); var_Items.Add("1.23"); var_Items.Add("2.34");
327. How can I display dates in long format
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("LongFormat") as exontrol.EXLISTLib.Column).ComputedField = "longdate(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
326. How can I display dates in short format
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("ShortFormat") as exontrol.EXLISTLib.Column).ComputedField = "shortdate(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
325. How can I display the time only of a date expression
exlist1.Columns.Add("Date"); (exlist1.Columns.Add("Time") as exontrol.EXLISTLib.Column).ComputedField = "'time is:' + time(date(%0))"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(Convert.ToDateTime("1/1/2001 10:00:00 AM")); var_Items.Add(Convert.ToDateTime("2/2/2002 11:00:00 AM")); var_Items.Add(Convert.ToDateTime("3/3/2003 12:00:00 PM")); var_Items.Add(Convert.ToDateTime("4/4/2004 1:00:00 PM"));
324. Is there any function to display currencies, or money formatted as in the control panel
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Currency") as exontrol.EXLISTLib.Column).ComputedField = "currency(dbl(%0))"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("1.23"); var_Items.Add("2.34"); var_Items.Add("10000.99");
323. How can I convert the expression to a string so I can look into the date string expression for month's name
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Str") as exontrol.EXLISTLib.Column).ComputedField = "str(%0) + ' AA'"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("-1.98"); var_Items.Add("0.99"); var_Items.Add("1.23"); var_Items.Add("2.34");
322. Can I display the absolute value or positive part of the number
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Abs") as exontrol.EXLISTLib.Column).ComputedField = "abs(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("-1.98"); var_Items.Add("0.99"); var_Items.Add("1.23"); var_Items.Add("2.34");
321. Is there any function to get largest number with no fraction part that is not greater than the value
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Floor") as exontrol.EXLISTLib.Column).ComputedField = "floor(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("-1.98"); var_Items.Add("0.99"); var_Items.Add("1.23"); var_Items.Add("2.34");
320. Is there any function to round the values base on the .5 value
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Round") as exontrol.EXLISTLib.Column).ComputedField = "round(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("-1.98"); var_Items.Add("0.99"); var_Items.Add("1.23"); var_Items.Add("2.34");
319. How can I get or display the integer part of the cell
exlist1.Columns.Add("Number"); (exlist1.Columns.Add("Int") as exontrol.EXLISTLib.Column).ComputedField = "int(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("-1.98"); var_Items.Add("0.99"); var_Items.Add("1.23"); var_Items.Add("2.34");
318. How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
(exlist1.Columns.Add("") as exontrol.EXLISTLib.Column).ComputedField = "proper(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("item item"); var_Items.Add("item item"); var_Items.Add("item item");
317. Is there any option to display cells in uppercase
(exlist1.Columns.Add("") as exontrol.EXLISTLib.Column).ComputedField = "upper(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.Add("Item 4 - child");
316. Is there any option to display cells in lowercase
(exlist1.Columns.Add("") as exontrol.EXLISTLib.Column).ComputedField = "lower(%0)"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.Add("Item 4 - child");
315. How can I mark the cells that has a specified type, ie strings only
exlist1.ConditionalFormats.Add("type(%0) = 8",null).ForeColor = Color.FromArgb(255,0,0); exlist1.Columns.Add(""); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add(2); var_Items.Add("Item 4 - child");
314. How can I bold the items that contains data or those who displays empty strings
exlist1.ConditionalFormats.Add("not len(%1)=0",null).Bold = true; exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); int hC = var_Items.Add("Item 3"); var_Items.set_Caption(hC,1,"1"); var_Items.Add("Item 3");
313. Can I change the background color for items or cells that contains a specified string
exlist1.ConditionalFormats.Add("%0 contains 'hi'",null).BackColor = Color.FromArgb(255,0,0); exlist1.Columns.Add(""); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.Add("Item 4 - child");
312. Is there any option to change the fore color for cells or items that ends with a specified string
exlist1.ConditionalFormats.Add("%0 endwith '22'",null).ForeColor = Color.FromArgb(255,0,0); exlist1.Columns.Add(""); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 1.22"); var_Items.Add("Item 2.22");
311. How can I highlight the cells or items that starts with a specified string
exlist1.ConditionalFormats.Add("%0 startwith 'C'",null).Underline = true; exlist1.Columns.Add(""); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("CItem 2"); var_Items.Add("Item 3"); var_Items.Add("Item 4");
310. How can I change the foreground color for a particular column
exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Column 1"); (var_Columns.Add("Column 2") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exHeaderForeColor,8439039); var_Columns.Add("Column 3");
309. How can I change the background color for a particular column
exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Column 1"); (var_Columns.Add("Column 2") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exHeaderBackColor,8439039); var_Columns.Add("Column 3");
308. How can I display the column's header using multiple lines
exlist1.HeaderHeight = 128; exlist1.HeaderSingleLine = false; (exlist1.Columns.Add("This is just a column that should break the header.") as exontrol.EXLISTLib.Column).Width = 32; exlist1.Columns.Add("This is just another column that should break the header.");
307. How can I align the text/caption on the scroll bar
exlist1.set_ScrollPartCaption(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLowerBackPart,"left"); exlist1.set_ScrollPartCaptionAlignment(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLowerBackPart,exontrol.EXLISTLib.AlignmentEnum.LeftAlignment); exlist1.set_ScrollPartCaption(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exUpperBackPart,"right"); exlist1.set_ScrollPartCaptionAlignment(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exUpperBackPart,exontrol.EXLISTLib.AlignmentEnum.RightAlignment); exlist1.ColumnAutoResize = false; exlist1.Columns.Add(1.ToString()); exlist1.Columns.Add(2.ToString()); exlist1.Columns.Add(3.ToString()); exlist1.Columns.Add(4.ToString()); exlist1.Columns.Add(5.ToString()); exlist1.Columns.Add(6.ToString());
306. How do I select the next row/item
exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_SelectItem(var_Items.get_NextVisibleItem(var_Items.FocusItem),true);
305. How do I enable resizing ( changing the height ) the items at runtime
exlist1.ItemsAllowSizing = exontrol.EXLISTLib.ItemsAllowSizingEnum.exResizeItem; exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exHLines; exlist1.ScrollBySingleLine = true; exlist1.Columns.Add("Column"); exlist1.Items.Add("Item 1"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemHeight(var_Items.Add("Item 2"),48); exlist1.Items.Add("Item 3"); exlist1.Items.Add("Item 4");
304. How do I enable resizing all the items at runtime
exlist1.ItemsAllowSizing = exontrol.EXLISTLib.ItemsAllowSizingEnum.exResizeAllItems; exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exHLines; exlist1.Columns.Add("Column"); exlist1.Items.Add("Item 1"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemHeight(var_Items.Add("Item 2"),48); exlist1.Items.Add("Item 3");
303. How can I remove the filter
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter(); exlist1.ClearFilter();
302. How do I change the control's border, using your EBN files
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.Appearance = (exontrol.EXLISTLib.AppearanceEnum)0x1000000;
301. Can I change the style for break or divider line
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); int h = var_Items.Add(null); var_Items.set_ItemBreak(h,exontrol.EXLISTLib.BreakLineEnum.DoubleLine); var_Items.set_SelectableItem(h,false); var_Items.Add("Item 3");
300. Can I add any break or divider line
exlist1.ScrollBySingleLine = false; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); int h = var_Items.Add(null); var_Items.set_ItemBreak(h,exontrol.EXLISTLib.BreakLineEnum.SingleLine); var_Items.set_SelectableItem(h,false); var_Items.set_ItemHeight(h,6); var_Items.Add("Item 3");
299. Can I change the default border of the tooltip, using your EBN files
exlist1.ToolTipDelay = 1; exlist1.ToolTipWidth = 364; exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exToolTipAppearance,0x1000000); (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
298. Can I change the background color for the tooltip
exlist1.ToolTipDelay = 1; exlist1.ToolTipWidth = 364; exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exToolTipBackColor,Color.FromArgb(0,0,0)); (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
297. Does the tooltip support HTML format
exlist1.ToolTipDelay = 1; exlist1.ToolTipWidth = 364; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "<font Tahoma;11>T</font>his is an HTML <b>tooltip</b> assigned to a <fgcolor=FF0000>column</fgc" + "olor>";
296. Can I change the forecolor for the tooltip
exlist1.ToolTipDelay = 1; exlist1.ToolTipWidth = 364; exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exToolTipForeColor,Color.FromArgb(0,0,0)); (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
295. Can I change the foreground color for the tooltip
exlist1.ToolTipDelay = 1; exlist1.ToolTipWidth = 364; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "<fgcolor=FF0000>this is a tooltip assigned to a column</fgcolor>";
294. Is there any function to limit the height of the items when I display it using multiple lines
exlist1.ScrollBySingleLine = true; exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(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);
293. Why I cannot center my cells in the column
exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; (exlist1.Columns.Add("Default") as exontrol.EXLISTLib.Column).Alignment = exontrol.EXLISTLib.AlignmentEnum.CenterAlignment; exlist1.Items.Add("item 1"); exlist1.Items.Add("item 2"); exlist1.Items.Add("item 3");
292. How can I align the cell to the left, center or to the right
exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellHAlignment(var_Items.Add("left"),0,exontrol.EXLISTLib.AlignmentEnum.LeftAlignment); var_Items.set_CellHAlignment(var_Items.Add("center"),0,exontrol.EXLISTLib.AlignmentEnum.CenterAlignment); var_Items.set_CellHAlignment(var_Items.Add("right"),0,exontrol.EXLISTLib.AlignmentEnum.RightAlignment);
291. How do I apply HTML format to a cell
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.set_HTMLPicture("p1","c:\\exontrol\\images\\zipdisk.gif"); exlist1.set_HTMLPicture("p2","c:\\exontrol\\images\\auction.gif"); exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("The following item shows some of the HTML format supported:"); var_Items.set_CellHAlignment(h,0,exontrol.EXLISTLib.AlignmentEnum.CenterAlignment); h = var_Items.Add("<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_CaptionFormat(h,0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellSingleLine(h,0,false);
290. How can I change the font for a cell
exlist1.Columns.Add("Default"); exlist1.Items.Add("std font"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("this <font tahoma;12>is a bit of text with</font> a different font"),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
289. How can I change the font for a cell
exlist1.Columns.Add("Default"); exlist1.Items.Add("default font"); stdole.IFontDisp f = new stdole.StdFont(); f.Name = "Tahoma"; f.Size = 12; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellFont(var_Items.Add("new font"),0,(f as stdole.IFontDisp));
288. How can I change the font for entire item
exlist1.Columns.Add("Default"); exlist1.Items.Add("default font"); stdole.IFontDisp f = new stdole.StdFont(); f.Name = "Tahoma"; f.Size = 12; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemFont(var_Items.Add("new font"),(f as stdole.IFontDisp));
287. How do I vertically align a cell
exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; (exlist1.Columns.Add("MultipleLine") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellSingleLine,false); exlist1.Columns.Add("VAlign"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("This is a bit of long text that should break the line"); var_Items.set_Caption(h,1,"top"); var_Items.set_CellVAlignment(h,1,exontrol.EXLISTLib.VAlignmentEnum.TopAlignment); h = var_Items.Add("This is a bit of long text that should break the line"); var_Items.set_Caption(h,1,"middle"); var_Items.set_CellVAlignment(h,1,exontrol.EXLISTLib.VAlignmentEnum.MiddleAlignment); h = var_Items.Add("This is a bit of long text that should break the line"); var_Items.set_Caption(h,1,"bottom"); var_Items.set_CellVAlignment(h,1,exontrol.EXLISTLib.VAlignmentEnum.BottomAlignment);
286. How can I change the position of an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.set_ItemPosition(var_Items.Add("Item 3"),0);
285. How do I find an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_ItemBold(var_Items.get_FindItem("Item 2",0,null),true);
284. How can I insert a hyperlink or an anchor element
exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("Just an <a1>anchor</a> element ..."),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_CaptionFormat(var_Items1.Add("Just another <a2>anchor</a> element ..."),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
283. How do I find the handle of the item based on its index
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_ItemBold(1,true);
282. How can I find the cell being clicked in a radio group
exlist1.MarkSearchColumn = false; exlist1.SelBackColor = Color.FromArgb(255,255,128); exlist1.SelForeColor = Color.FromArgb(0,0,0); exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exlist1.Columns.Add("C3"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Radio 1"); var_Items.set_CellHasRadioButton(h,1,true); var_Items.set_CellRadioGroup(h,1,1234); var_Items.set_Caption(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,0,true);
281. Can I let the user to resize at runtime the specified item
exlist1.ScrollBySingleLine = true; exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemAllowSizing(var_Items.Add("resizable item"),true); var_Items.Add("not resizable item");
280. How can I change the size ( width, height ) of the picture
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.set_CellPicture(h,0,(exlist1.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.Add("Item 2"); var_Items.set_CellPicture(h,0,(exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp)); var_Items.set_ItemHeight(h,48);
279. How can I find the number or the count of selected items
exlist1.SingleSel = false; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_SelectItem(var_Items.FirstVisibleItem,true); var_Items.set_SelectItem(var_Items.get_NextVisibleItem(var_Items.FirstVisibleItem),true); var_Items.Add(var_Items.SelectCount);
278. How do I unselect an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_SelectItem(h,false);
277. How do I find the selected item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_SelectItem(h,true); var_Items.set_ItemBold(var_Items.get_SelectedItem(0),true);
276. How do I un select all items
exlist1.SingleSel = false; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.UnselectAll();
275. How do I select multiple items
exlist1.SingleSel = false; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_SelectItem(var_Items.FirstVisibleItem,true); var_Items.set_SelectItem(var_Items.get_NextVisibleItem(var_Items.FirstVisibleItem),true);
274. How do I select all items
exlist1.SingleSel = false; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.SelectAll();
273. How do I select an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_SelectItem(var_Items.get_NextVisibleItem(var_Items.FocusItem),true);
272. Can I display a button with some picture or icon inside
exlist1.set_HTMLPicture("p1","c:\\exontrol\\images\\zipdisk.gif");
exlist1.Columns.Add("C1");
exlist1.Columns.Add("C2");
exontrol.EXLISTLib.Items var_Items = exlist1.Items;
int h = var_Items.Add("Cell 1");
var_Items.set_Caption(h,1," Button <img>p1</img> ");
var_Items.set_CaptionFormat(h,1,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
var_Items.set_CellHAlignment(h,1,exontrol.EXLISTLib.AlignmentEnum.RightAlignment);
var_Items.set_CellHasButton(h,1,true);
var_Items.set_ItemHeight(h,48);
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1," Button <img>1</img> "); var_Items.set_CaptionFormat(h,1,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellHAlignment(h,1,exontrol.EXLISTLib.AlignmentEnum.RightAlignment); var_Items.set_CellHasButton(h,1,true);
270. Can I display a button with some icon inside
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1," <img>1</img> "); var_Items.set_CaptionFormat(h,1,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellHAlignment(h,1,exontrol.EXLISTLib.AlignmentEnum.RightAlignment); var_Items.set_CellHasButton(h,1,true);
269. How can I assign multiple icon/picture to a cell
exlist1.set_HTMLPicture("p1","c:\\exontrol\\images\\zipdisk.gif"); exlist1.set_HTMLPicture("p2","c:\\exontrol\\images\\auction.gif"); exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("text <img>p1</img> another picture <img>p2</img> and so on"); var_Items.set_CaptionFormat(h,0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); var_Items.set_CellPicture(h,0,(exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\colorize.gif`)") as stdole.IPictureDisp)); var_Items.set_ItemHeight(h,48); var_Items.Add("Item 2");
268. How can I assign an icon/picture to a cell
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.set_CellPicture(h,0,(exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp)); var_Items.set_ItemHeight(h,48); var_Items.Add("Item 2");
267. How can I assign multiple icons/pictures to a cell
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item <img>1</img> 1, <img>2</img>, ... and so on "); var_Items.set_CaptionFormat(h,0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
266. How can I assign multiple icons/pictures to a cell
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.set_CellImages(h,0,"1,2,3");
265. How can I assign an icon/picture to a cell
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); var_Items.set_CellImage(h,0,1); var_Items.set_CellImage(var_Items.Add("Item 2"),0,2); var_Items.set_CellImage(var_Items.Add("Item 3"),0,3);
264. How can I display a button inside the item or cell
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1," Button 1 "); var_Items.set_CellHAlignment(h,1,exontrol.EXLISTLib.AlignmentEnum.RightAlignment); var_Items.set_CellHasButton(h,1,true); h = var_Items.Add("Cell 2"); var_Items.set_Caption(h,1," Button 2 "); var_Items.set_CellHAlignment(h,1,exontrol.EXLISTLib.AlignmentEnum.CenterAlignment); var_Items.set_CellHasButton(h,1,true);
263. How can I change the state of a radio button
exlist1.MarkSearchColumn = false; exlist1.SelBackColor = Color.FromArgb(255,255,128); exlist1.SelForeColor = Color.FromArgb(0,0,0); exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exlist1.Columns.Add("C3"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Radio 1"); var_Items.set_CellHasRadioButton(h,1,true); var_Items.set_CellRadioGroup(h,1,1234); var_Items.set_Caption(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);
262. How can I assign a radio button to a cell
exlist1.MarkSearchColumn = false; exlist1.SelBackColor = Color.FromArgb(255,255,128); exlist1.SelForeColor = Color.FromArgb(0,0,0); exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exlist1.Columns.Add("C3"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Radio 1"); var_Items.set_CellHasRadioButton(h,1,true); var_Items.set_CellRadioGroup(h,1,1234); var_Items.set_Caption(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);
261. How can I change the state of a checkbox
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Check Box"); var_Items.set_CellHasCheckBox(h,1,true); var_Items.set_CellState(h,1,1);
260. How can I assign a checkbox to a cell
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Check Box"); var_Items.set_CellHasCheckBox(h,1,true);
259. How can I display an item or a cell on multiple lines
exlist1.ScrollBySingleLine = true; exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"This is bit of text that's shown on multiple lines"); var_Items.set_CellSingleLine(h,1,false);
258. How can I assign a tooltip to a cell
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"tooltip"); var_Items.set_CellToolTip(h,1,"This is bit of text that's shown when the user hovers the cell");
257. How can I associate an extra data to a cell
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Cell 2"); var_Items.set_CellData(h,1,"your extra data");
256. How do I enable or disable a cell
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Cell 2"); var_Items.set_CellEnabled(h,1,false);
255. How do I change the cell's foreground color
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Cell 2"); var_Items.set_CellForeColor(h,1,Color.FromArgb(0,0,0));
254. How do I change the visual effect for the cell, using your EBN files
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Cell 2"); var_Items.set_CellBackColor32(h,1,0x1000000);
253. How do I change the cell's background color
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Cell 1"); var_Items.set_Caption(h,1,"Cell 2"); var_Items.set_CellBackColor(h,1,Color.FromArgb(0,0,0));
252. How do I change the caption or value for a particular cell
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("Cell 1"),1,"Cell 2");
251. How do I retrieve the focused item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.set_ItemBold(var_Items.FocusItem,true);
250. How do I enumerate the visible items
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item 1"); h = var_Items.Add("Item 2"); var_Items.set_ItemBold(var_Items.FirstVisibleItem,true); var_Items.set_ItemBold(var_Items.get_NextVisibleItem(var_Items.FirstVisibleItem),true);
249. How can I make an item unselectable, or not selectable
exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("unselectable - you can't get selected"); var_Items.set_SelectableItem(h,false); var_Items.Add("selectable");
248. How can I hide or show an item
exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("hidden"); var_Items.set_ItemHeight(h,0); var_Items.set_SelectableItem(h,false); var_Items.Add("visible");
247. How can I change the height for all items
exlist1.DefaultItemHeight = 32; exlist1.Columns.Add("Column"); exlist1.Items.Add("One"); exlist1.Items.Add("Two");
246. How do I change the height of an item
exlist1.ScrollBySingleLine = true; exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemHeight(var_Items.Add("height"),128); exlist1.Items.Add("enabled");
245. How do I disable or enable an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_EnableItem(var_Items.Add("disabled"),false); exlist1.Items.Add("enabled");
244. How do I display as strikeout a cell
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellStrikeOut(var_Items.Add("strikeout"),0,true);
243. How do I display as strikeout a cell or an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("gets <s>strikeout</s> only a portion of text"),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
242. How do I display as strikeout an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemStrikeOut(var_Items.Add("strikeout"),true);
241. How do I underline a cell
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellUnderline(var_Items.Add("underline"),0,true);
240. How do I underline a cell or an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("gets <u>underline</u> only a portion of text"),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
239. How do I underline an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemUnderline(var_Items.Add("underline"),true);
238. How do I display as italic a cell
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellItalic(var_Items.Add("italic"),0,true);
237. How do I display as italic a cell or an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("gets <i>italic</i> only a portion of text"),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
236. How do I display as italic an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemItalic(var_Items.Add("italic"),true);
235. How do I bold a cell
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellBold(var_Items.Add("bold"),0,true);
234. How do I bold a cell or an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("gets <b>bold</b> only a portion of text"),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
233. How do I bold an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemBold(var_Items.Add("bold"),true);
232. How do I change the foreground color for the item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemForeColor(var_Items.Add("Item"),Color.FromArgb(0,0,0));
231. How do I change the visual appearance for the item, using your EBN technology
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; int h = var_Items.Add("Item"); var_Items.set_ItemBackColor32(0,0x1000000);
230. How do I change the background color for the item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemBackColor(var_Items.Add("Item"),Color.FromArgb(0,0,0));
229. How do I associate an extra data to an item
exlist1.Columns.Add("Default"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemData(var_Items.Add("item"),"your extra data");
228. How do I programmatically edit a cell
// Click event - Occurs when the user presses and then releases the left mouse button over the list control.
private void exlist1_Click(object sender)
{
exlist1.Items.Edit(0.FocusItem,0);
}
//this.exlist1.Click += new exontrol.EXLISTLib.exg2antt.ClickEventHandler(this.exlist1_Click);
exlist1.AllowEdit = true;
exlist1.Columns.Add("Default");
exontrol.EXLISTLib.Items var_Items = exlist1.Items;
var_Items.Add("");
exlist1.Columns.Add("Default"); int h = exlist1.Items.Add("item"); exlist1.Items.EnsureVisibleItem(h);
226. How can I remove or delete all items
exlist1.Columns.Add("Default"); exlist1.Items.Add("removed item"); exlist1.Items.RemoveAll();
225. How can I remove or delete an item
exlist1.Columns.Add("Default"); int h = exlist1.Items.Add("removed item"); exlist1.Items.Remove(h);
224. How can I add or insert an item
exlist1.Columns.Add("C1"); exlist1.Columns.Add("C2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("Cell 1"),1,"Cell 2"); int h = var_Items.Add("Cell 3"); var_Items.set_Caption(h,1,"Cell 4");
223. How can I add or insert an item
exlist1.Columns.Add("Default"); exlist1.Items.Add("new item");
222. How can I get the columns as they are shown in the control's sortbar
Object var_Object = (exlist1.Columns.get_ItemBySortPosition(0) as Object);
221. How can I access the properties of a column
exlist1.Columns.Add("A"); exlist1.Columns["A"].HeaderBold = true;
220. How can I remove all the columns
exlist1.Columns.Clear();
219. How can I remove a column
exlist1.Columns.Remove("A");
218. How can I get the number or the count of columns
int var_Count = exlist1.Columns.Count;
217. 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.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Font = (f as stdole.IFontDisp); var_ConditionalFormat.ApplyTo = exontrol.EXLISTLib.FormatApplyToEnum.exFormatToColumns; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
216. How can I change the background color for all cells in the column
exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.BackColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = exontrol.EXLISTLib.FormatApplyToEnum.exFormatToColumns; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
215. How can I change the foreground color for all cells in the column
exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = exontrol.EXLISTLib.FormatApplyToEnum.exFormatToColumns; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
214. How can I show as strikeout all cells in the column
exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.StrikeOut = true; var_ConditionalFormat.ApplyTo = exontrol.EXLISTLib.FormatApplyToEnum.exFormatToColumns; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
213. How can I underline all cells in the column
exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Underline = true; var_ConditionalFormat.ApplyTo = exontrol.EXLISTLib.FormatApplyToEnum.exFormatToColumns; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
212. How can I show in italic all data in the column
exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Italic = true; var_ConditionalFormat.ApplyTo = exontrol.EXLISTLib.FormatApplyToEnum.exFormatToColumns; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
211. How can I bold the entire column
exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("1",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.ApplyTo = exontrol.EXLISTLib.FormatApplyToEnum.exFormatToColumns; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
210. How can I display a computed column and highlight some values that are negative or less than a value
exlist1.Columns.Add("A"); exlist1.Columns.Add("B"); (exlist1.Columns.Add("(A+B)*1.19") as exontrol.EXLISTLib.Column).ComputedField = "(%0 + %1) * 1.19"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add(1),1,2); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add(10),1,20); exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("%2 > 10",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x2;
209. Can I display a computed column so it displays the VAT, or SUM
exlist1.Columns.Add("A"); exlist1.Columns.Add("B"); (exlist1.Columns.Add("(A+B)*1.19") as exontrol.EXLISTLib.Column).ComputedField = "(%0 + %1) * 1.19"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add(1),1,2); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add(10),1,20);
208. How can I show a column that adds values in the cells
exlist1.Columns.Add("A"); exlist1.Columns.Add("B"); (exlist1.Columns.Add("A+B") as exontrol.EXLISTLib.Column).ComputedField = "%0 + %1"; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add(1),1,2); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add(10),1,20);
207. Is there any function to filter the control's data as I type, so the items being displayed include the typed characters
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Filter") as exontrol.EXLISTLib.Column); var_Column.FilterOnType = true; var_Column.DisplayFilterButton = true; var_Column.AutoSearch = exontrol.EXLISTLib.AutoSearchEnum.exContains; exlist1.Items.Add("Canada"); exlist1.Items.Add("USA");
206. Is there any function to filter the control's data as I type, something like filter on type
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Filter") as exontrol.EXLISTLib.Column); var_Column.FilterOnType = true; var_Column.DisplayFilterButton = true; exlist1.Items.Add("Canada"); exlist1.Items.Add("USA");
205. How can I programmatically filter a column
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Filter") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exNonBlanks; exlist1.Items.Add(null); exlist1.Items.Add("not empty"); exlist1.ApplyFilter();
204. How can I show or display the control's filter
(exlist1.Columns.Add("Filter") as exontrol.EXLISTLib.Column).DisplayFilterButton = true;
203. How can I customize the items being displayed in the drop down filter window
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Custom Filter") as exontrol.EXLISTLib.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.EXLISTLib.FilterTypeEnum.exPattern; var_Column.Filter = "*.xls"; exlist1.Items.Add("excel.xls"); exlist1.Items.Add("word.doc"); exlist1.Items.Add("pp.pps"); exlist1.Items.Add("text.txt"); exlist1.ApplyFilter();
202. How can I change the order or the position of the columns in the sort bar
exlist1.SortBarVisible = true; exlist1.SortBarColumnWidth = 48; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortDescending; exlist1.Columns["C2"].SortPosition = 0;
201. How do I arrange my columns on multiple levels
(exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 4") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = "2"; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = "2"; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = "2"; (exlist1.Columns.Add("Level 4") as exontrol.EXLISTLib.Column).LevelKey = "2"; (exlist1.Columns.Add("E") as exontrol.EXLISTLib.Column).Width = 32;
200. How do I arrange my columns on multiple lines
exlist1.HeaderHeight = 32; (exlist1.Columns.Add("") as exontrol.EXLISTLib.Column).HTMLCaption = "Line 1<br>Line 2";
199. How can I display all cells using HTML format
(exlist1.Columns.Add("HTML") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCaptionFormat,1); exlist1.Items.Add("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></fon" + "t>.");
198. How can I display all cells using multiple lines
(exlist1.Columns.Add("MultipleLine") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellSingleLine,false); (exlist1.Columns.Add("SingleLine") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellSingleLine,true); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("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");
197. How do change the vertical alignment for all cells in the column
(exlist1.Columns.Add("MultipleLine") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellSingleLine,false); (exlist1.Columns.Add("VAlign") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellVAlignment,2); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("This is a bit of long text that should break the line"),1,"bottom"); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add("This is a bit of long text that should break the line"),1,"bottom");
196. How do change the foreground color for all cells in the column
(exlist1.Columns.Add("ForeColor") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellForeColor,255); exlist1.Items.Add(0); exlist1.Items.Add(1);
195. How do change the background color for all cells in the column
(exlist1.Columns.Add("BackColor") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellBackColor,255); exlist1.Items.Add(0); exlist1.Items.Add(1);
194. How do I show buttons for all cells in the column
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Button") as exontrol.EXLISTLib.Column); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasButton,true); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasRadioButton | exontrol.EXLISTLib.DefColumnEnum.exCellHasButton,true); exlist1.Items.Add(" Button 1 "); exlist1.Items.Add(" Button 2 ");
193. How do I show buttons for all cells in the column
(exlist1.Columns.Add("Button") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasButton,true); exlist1.Items.Add(0); exlist1.Items.Add(1);
192. How do I display radio buttons for all cells in the column
(exlist1.Columns.Add("Radio") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasRadioButton,true); exlist1.Items.Add(0); exlist1.Items.Add(1);
191. How do I display checkboxes for all cells in the column
(exlist1.Columns.Add("Check") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); exlist1.Items.Add(0); exlist1.Items.Add(1);
190. How can I display a tooltip when the cursor hovers the column
(exlist1.Columns.Add("tooltip") as exontrol.EXLISTLib.Column).ToolTip = "This is a bit of text that is shown when user hovers the column.";
189. Is there any function to assign a key to a column instead using its name or capion
(exlist1.Columns.Add("Data") as exontrol.EXLISTLib.Column).Key = "DKey"; exlist1.Columns["DKey"].Caption = "new caption";
188. Is there any function to assign any extra data to a column
(exlist1.Columns.Add("Data") as exontrol.EXLISTLib.Column).Data = "your extra data";
187. 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
(exlist1.Columns.Add("Sort") as exontrol.EXLISTLib.Column).DefaultSortOrder = true;
186. How can I specify the maximum width for the column, if I use WidthAutoResize property
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Auto") as exontrol.EXLISTLib.Column); var_Column.WidthAutoResize = true; var_Column.MinWidthAutoResize = 32; var_Column.MaxWidthAutoResize = 128; exlist1.Items.Add(0); exlist1.Items.Add(1);
185. How can I specify the minimum width for the column, if I use WidthAutoResize property
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Auto") as exontrol.EXLISTLib.Column); var_Column.WidthAutoResize = true; var_Column.MinWidthAutoResize = 32; exlist1.Items.Add(0); exlist1.Items.Add(1);
184. Is there any option to resize the column based on its data, captions
(exlist1.Columns.Add("A") as exontrol.EXLISTLib.Column).WidthAutoResize = true; exlist1.Items.Add(0); exlist1.Items.Add(1);
183. How can I align the icon in the column's header in the center
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("") as exontrol.EXLISTLib.Column); var_Column.HeaderImage = 1; var_Column.HeaderImageAlignment = exontrol.EXLISTLib.AlignmentEnum.CenterAlignment;
182. How do I align the icon in the column's header to the right
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("ColumnName") as exontrol.EXLISTLib.Column); var_Column.HeaderImage = 1; var_Column.HeaderImageAlignment = exontrol.EXLISTLib.AlignmentEnum.RightAlignment;
181. How do I show or hide the sorting icons, but still need sorting
(exlist1.Columns.Add("Sorted") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending; exlist1.Columns[0].DisplaySortIcon = false;
180. How do I enable or disable the entire column
exlist1.Columns.Add("C1"); (exlist1.Columns.Add("Disabled") as exontrol.EXLISTLib.Column).Enabled = false; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add(0),1,"0.1"); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add(1),1,"1.1");
179. How do I disable drag and drop columns
(exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).AllowDragging = false; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).AllowDragging = false;
178. How do I disable resizing a column at runtime
(exlist1.Columns.Add("Unsizable") as exontrol.EXLISTLib.Column).AllowSizing = false; exlist1.Columns.Add("C2"); exlist1.Columns.Add("C3"); exlist1.Columns.Add("C4");
177. How can I align the column to the right, and its caption too
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.Alignment = exontrol.EXLISTLib.AlignmentEnum.RightAlignment; var_Column.HeaderAlignment = exontrol.EXLISTLib.AlignmentEnum.RightAlignment; exlist1.Items.Add(0); exlist1.Items.Add(1);
176. How can I align the column to the right
(exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).Alignment = exontrol.EXLISTLib.AlignmentEnum.RightAlignment; exlist1.Items.Add(0); exlist1.Items.Add(1);
175. How do I change the column's caption
(exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).Caption = "new caption";
174. Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions, after the user clicks it
exlist1.set_FormatAnchor(false,"<b><u><fgcolor=880000> </fgcolor></u></b>"); exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("Just an <a1>anchor</a> element ..."),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_CaptionFormat(var_Items1.Add("Just another <a2>anchor</a> element ..."),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); exlist1.Items.Add("next item");
173. Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions
exlist1.set_FormatAnchor(true,"<b><u><fgcolor=FF0000> </fgcolor></u></b>"); exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("Just an <a1>anchor</a> element ..."),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_CaptionFormat(var_Items1.Add("Just another <a2>anchor</a> element ..."),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
172. Can I change the font for the tooltip
exlist1.ToolTipDelay = 1; exlist1.ToolTipWidth = 364; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "<br><font Tahoma;14>this</font> is a tooltip assigned to a column<br>";
171. Can I change the font for the tooltip
exlist1.ToolTipDelay = 1; stdole.IFontDisp var_StdFont = exlist1.ToolTipFont; var_StdFont.Name = "Tahoma"; var_StdFont.Size = 14; exlist1.ToolTipWidth = 364; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
170. Can I change the order of the buttons in the scroll bar
exlist1.set_ScrollOrderParts(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,"t,l,r"); exlist1.set_ScrollOrderParts(exontrol.EXLISTLib.ScrollBarEnum.exVScroll,"t,l,r"); exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableBoth;
169. The thumb size seems to be very small. Can I make it bigger
exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C3") as exontrol.EXLISTLib.Column).Width = 256; exlist1.set_ScrollThumbSize(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,64);
168. How can I display my text on the scroll bar, using a different font
exlist1.set_ScrollPartCaption(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exThumbPart,"This is <s><font Tahoma;12> just </font></s> text"); exlist1.ColumnAutoResize = false; exlist1.ScrollHeight = 20; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C3") as exontrol.EXLISTLib.Column).Width = 256;
167. How can I display my text on the scroll bar, using a different font
exlist1.set_ScrollPartCaption(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exThumbPart,"This is just a text"); exlist1.get_ScrollFont(exontrol.EXLISTLib.ScrollBarEnum.exHScroll).Size = 12; exlist1.ColumnAutoResize = false; exlist1.ScrollHeight = 20; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C3") as exontrol.EXLISTLib.Column).Width = 256;
166. How can I display my text on the scroll bar
exlist1.set_ScrollPartCaption(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exThumbPart,"this is just a text"); exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C3") as exontrol.EXLISTLib.Column).Width = 256;
165. How do I enlarge or change the size of the control's scrollbars
exlist1.ScrollHeight = 18; exlist1.ScrollWidth = 18; exlist1.ScrollButtonWidth = 18; exlist1.ScrollButtonHeight = 18; exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableBoth;
164. How do I assign a tooltip to a scrollbar
exlist1.set_ScrollToolTip(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,"This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar"); exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).Width = 256; (exlist1.Columns.Add("C3") as exontrol.EXLISTLib.Column).Width = 256;
163. How do I assign an icon to the button in the scrollbar
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.set_ScrollPartVisible(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLeftB1Part,true); exlist1.set_ScrollPartCaption(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLeftB1Part,"<img>1</img>"); exlist1.ScrollHeight = 18; exlist1.ScrollButtonWidth = 18; exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableNoHorizontal;
162. I need to add a button in the scroll bar. Is this possible
exlist1.set_ScrollPartVisible(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLeftB1Part,true); exlist1.set_ScrollPartCaption(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLeftB1Part,"1"); exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableNoHorizontal;
161. Can I display an additional buttons in the scroll bar
exlist1.set_ScrollPartVisible(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLeftB1Part,true); exlist1.set_ScrollPartVisible(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exLeftB2Part,true); exlist1.set_ScrollPartVisible(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exRightB6Part,true); exlist1.set_ScrollPartVisible(exontrol.EXLISTLib.ScrollBarEnum.exHScroll,exontrol.EXLISTLib.ScrollPartEnum.exRightB5Part,true); exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableNoHorizontal;
160. How can I display a custom size picture to a cell or item
exlist1.DefaultItemHeight = 48; exlist1.Columns.Add("C1"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellPicture(var_Items.Add("Text"),0,(exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp));
159. How can I display a multiple pictures to a cell or item
exlist1.DefaultItemHeight = 48; exlist1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif"); exlist1.set_HTMLPicture("pic2","c:\\exontrol\\images\\auction.gif"); exlist1.Columns.Add("C1"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CaptionFormat(var_Items.Add("<img>pic1</img> Text <img>pic2</img> another text ..."),0,exontrol.EXLISTLib.CaptionFormatEnum.exHTML);
158. How do I change the column's foreground color for numbers between an interval - Range
exontrol.EXLISTLib.ConditionalFormat var_ConditionalFormat = exlist1.ConditionalFormats.Add("%0 >= 2 and %0 <= 10",null); var_ConditionalFormat.Bold = true; var_ConditionalFormat.ForeColor = Color.FromArgb(255,0,0); var_ConditionalFormat.ApplyTo = (exontrol.EXLISTLib.FormatApplyToEnum)0x1; exlist1.Columns.Add("N1"); exlist1.Columns.Add("N2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add(1),1,2); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add(3),1,3); exontrol.EXLISTLib.Items var_Items2 = exlist1.Items; var_Items2.set_Caption(var_Items2.Add(10),1,11); exontrol.EXLISTLib.Items var_Items3 = exlist1.Items; var_Items3.set_Caption(var_Items3.Add(13),1,31); exlist1.SearchColumnIndex = 1;
157. How do I change the item's foreground color for numbers between an interval - Range
exlist1.ConditionalFormats.Add("%0 >= 2 and %0 <= 10",null).ForeColor = Color.FromArgb(255,0,0); exlist1.Columns.Add("Numbers"); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.Items.Add(10); exlist1.Items.Add(20);
156. How do I change the item's background color for numbers less than a value
exlist1.ConditionalFormats.Add("%0 < 10",null).BackColor = Color.FromArgb(255,0,0); exlist1.Columns.Add("Numbers"); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.Items.Add(10); exlist1.Items.Add(20);
155. How do I underline the numbers greater than a value
exlist1.ConditionalFormats.Add("%0 >= 10",null).Underline = true; exlist1.Columns.Add("Numbers"); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.Items.Add(10); exlist1.Items.Add(20);
154. How do I highlight in italic the numbers greater than a value
exlist1.ConditionalFormats.Add("%0 >= 10",null).StrikeOut = true; exlist1.Columns.Add("Numbers"); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.Items.Add(10); exlist1.Items.Add(20);
153. How do I highlight in italic the numbers greater than a value
exlist1.ConditionalFormats.Add("%0 >= 10",null).Italic = true; exlist1.Columns.Add("Numbers"); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.Items.Add(10); exlist1.Items.Add(20);
152. How do I highlight in bold the numbers greater than a value
exlist1.ConditionalFormats.Add("%0 >= 10",null).Bold = true; exlist1.Columns.Add("Numbers"); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.Items.Add(10); exlist1.Items.Add(20);
151. Can I use your EBN files to change the visual appearance for radio buttons
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.set_RadioImage(false,16777216); exlist1.set_RadioImage(true,33554432); (exlist1.Columns.Add("Radio") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasRadioButton,true); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Radio 1"); var_Items.set_CellState(var_Items.Add("Radio 2"),0,1); var_Items.Add("Radio 3");
150. Can I use your EBN files to change the visual appearance for checkbox cells
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.set_CheckImage(exontrol.EXLISTLib.CheckStateEnum.Unchecked,16777216); exlist1.set_CheckImage(exontrol.EXLISTLib.CheckStateEnum.Checked,33554432); (exlist1.Columns.Add("Check") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Check 1"); var_Items.set_CellState(var_Items.Add("Check 2"),0,1);
149. How do I change the visual aspect for thumb parts in the scroll bars, using EBN
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.VisualAppearance.Add(3,"c:\\exontrol\\images\\hot.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exHSThumb,0x1000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exHSThumbP,0x2000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exHSThumbH,0x3000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exVSThumb,0x1000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exVSThumbP,0x2000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exVSThumbH,0x3000000); exlist1.ColumnAutoResize = false; exlist1.ScrollBySingleLine = true; (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 483; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemHeight(var_Items.Add("Item 1"),248); exlist1.Items.Add("Item 2");
148. How do I change the visual aspect only for the thumb in the scroll bar, using EBN
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.VisualAppearance.Add(3,"c:\\exontrol\\images\\hot.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exHSThumb,0x1000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exHSThumbP,0x2000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exHSThumbH,0x3000000); exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 483;
147. I've seen that you can change the visual appearance for the scroll bar. How can I do that
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.VisualAppearance.Add(3,"c:\\exontrol\\images\\hot.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exSBtn,0x1000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exSBtnP,0x2000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exSBtnH,0x3000000); exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exHSBack,Color.FromArgb(0,0,0)); exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exVSBack,Color.FromArgb(0,0,0)); exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exScrollSizeGrip,Color.FromArgb(0,0,0)); (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("E1") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E2") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E3") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E4") as exontrol.EXLISTLib.Column).Width = 32; exlist1.ColumnAutoResize = false; exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableBoth;
146. Is there any option to highligth the column from the cursor - point
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exCursorHoverColumn,0x1000000); (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("E1") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E2") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E3") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E4") as exontrol.EXLISTLib.Column).Width = 32;
145. How do I change the visual aspect of selected item in the drop down filter window, using your EBN technology
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exSelBackColorFilter,0x1000000); exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exSelForeColorFilter,Color.FromArgb(0,0,0)); (exlist1.Columns.Add("Filter") as exontrol.EXLISTLib.Column).DisplayFilterButton = true;
144. 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
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exDateHeader,0x1000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exDateTodayUp,0x1000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exDateTodayDown,0x2000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exDateScrollThumb,0x1000000); exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exDateScrollRange,Color.FromArgb(0,0,0)); exlist1.set_Background(exontrol.EXLISTLib.BackgroundPartEnum.exDateSeparatorBar,Color.FromArgb(0,0,0)); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exDateSelect,0x1000000); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Date") as exontrol.EXLISTLib.Column); var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exDate; var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true;
143. How do I change the visual aspect of the close button in the filter bar, using EBN
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exFooterFilterBarButton,0x1000000); (exlist1.Columns.Add("Filter") as exontrol.EXLISTLib.Column).FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
142. How do I change the visual aspect of buttons in the cell, using EBN
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exCellButtonUp,0x1000000); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exCellButtonDown,0x2000000); exlist1.SelForeColor = Color.FromArgb(0,0,0); exlist1.ShowFocusRect = false; (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasButton,true); exlist1.Items.Add("Button 1"); exlist1.Items.Add("Button 2"); exlist1.Columns.Add("Column 2");
141. How do I change the visual aspect of the drop down filter button, using EBN
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.set_Background32(exontrol.EXLISTLib.BackgroundPartEnum.exHeaderFilterBarButton,0x1000000); (exlist1.Columns.Add("Filter") as exontrol.EXLISTLib.Column).DisplayFilterButton = true;
140. How do I enable resizing the columns at runtime
exlist1.ColumnsAllowSizing = true; exlist1.MarkSearchColumn = false; exlist1.HeaderVisible = false; exlist1.Columns.Add("Column 1"); exlist1.Columns.Add("Column 2"); exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exVLines; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("Item 1"),1,"Sub Item 1"); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add("Item 2"),1,"Sub Item 2");
139. How can I sort by multiple columns
exlist1.SingleSort = false; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortDescending; (exlist1.Columns.Add("C3") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending;
138. How can I add several columns to control's sort bar
exlist1.SortBarVisible = true; exlist1.SortBarColumnWidth = 48; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortDescending;
137. How can I change the width of the columns being displayed in the sort bar
exlist1.SortBarVisible = true; exlist1.SortBarColumnWidth = 48; (exlist1.Columns.Add("C1") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending; (exlist1.Columns.Add("C2") as exontrol.EXLISTLib.Column).SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortDescending;
136. How can I change the height of the sort bar's
exlist1.SortBarVisible = true; exlist1.SortBarHeight = 48;
135. How can I change the sort bar's foreground color
exlist1.SortBarVisible = true; exlist1.ForeColorSortBar = Color.FromArgb(255,0,0);
134. How can I change the visual appearance of the control's sort bar, using EBN files
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.VisualAppearance.Add(2,"c:\\exontrol\\images\\pushed.ebn"); exlist1.SortBarVisible = true; exlist1.BackColorSortBar32 = 0x1000000; exlist1.BackColorSortBarCaption32 = 0x2000000; exlist1.Appearance = exontrol.EXLISTLib.AppearanceEnum.None2;
133. How can I change the sort bar's background color
exlist1.SortBarVisible = true; exlist1.BackColorSortBar = Color.FromArgb(255,0,0); exlist1.BackColorSortBarCaption = Color.FromArgb(128,0,0);
132. How can I change the default caption being displayed in the control's sort bar
exlist1.SortBarVisible = true; exlist1.SortBarCaption = "new caption";
131. How can I show the control's sort bar
exlist1.SortBarVisible = true;
exlist1.PictureLevelHeader = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\colorize.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplayLevelHeader = exontrol.EXLISTLib.PictureDisplayEnum.Stretch; (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("E1") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E2") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E3") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("E4") as exontrol.EXLISTLib.Column).Width = 32;
129. How can I display a picture on the control's header, when multiple levels are displayed, so it is not tiled
exlist1.PictureLevelHeader = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\colorize.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplayLevelHeader = exontrol.EXLISTLib.PictureDisplayEnum.MiddleRight; (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("E") as exontrol.EXLISTLib.Column).Width = 32;
128. How can I display a picture on the control's header, when multiple levels are displayed
exlist1.PictureLevelHeader = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1;
127. How can I change the header's background color, when multiple levels are displayed
exlist1.BackColorLevelHeader = Color.FromArgb(250,0,0); (exlist1.Columns.Add("S") as exontrol.EXLISTLib.Column).Width = 32; (exlist1.Columns.Add("Level 1") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 2") as exontrol.EXLISTLib.Column).LevelKey = 1; (exlist1.Columns.Add("Level 3") as exontrol.EXLISTLib.Column).LevelKey = 1;
126. Can I programmatically scroll the control
exlist1.DefaultItemHeight = 32; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.Items.Add(3); exlist1.PutItems(exlist1.GetItems(0),null); exlist1.PutItems(exlist1.GetItems(0),null); exlist1.set_ScrollPos(true,1);
125. Do you have some function to load data from a safe array
exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.PutItems(exlist1.GetItems(0),null);
124. Do you have some function to retrieve all items to a safe array
exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.PutItems(exlist1.GetItems(0),null); exlist1.Items.Add(1); exlist1.PutItems(exlist1.GetItems(0),null); exlist1.Items.Add(2); exlist1.PutItems(exlist1.GetItems(0),null); exlist1.Items.Add(3);
123. How can still display the selected items when the control loses the focus
exlist1.HideSelection = false; exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 3"); var_Items.Add("Item 1"); var_Items.set_SelectItem(var_Items.Add("Item 2"),true);
122. How can I hide a column
(exlist1.Columns.Add("Hidden") as exontrol.EXLISTLib.Column).Visible = false; exlist1.Columns.Add("2"); exlist1.Columns.Add("3"); exlist1.Columns.Add("4"); exlist1.Columns.Add("5");
121. How can I ensure that a column is visible and fits the control's client area
exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("1") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("2") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("3") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("4") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("5") as exontrol.EXLISTLib.Column).Width = 128; exlist1.Items.EnsureVisibleColumn("5");
120. I've seen that the width of the tooltip is variable. Can I make it larger
exlist1.ToolTipWidth = 328; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip that should be very very very very very very very long";
119. How do I disable showing the tooltip for all control
exlist1.ToolTipDelay = 0; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
118. How do I let the tooltip being displayed longer
exlist1.ToolTipPopDelay = 10000; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
117. How do I show the tooltip quicker
exlist1.ToolTipDelay = 1; (exlist1.Columns.Add("tootip") as exontrol.EXLISTLib.Column).ToolTip = "this is a tooltip assigned to a column";
116. How do I change the caption being displayed in the control's filter bar
exlist1.FilterBarCaption = "your filter caption"; exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
115. How do I search case sensitive, using your incremental search feature
exlist1.AutoSearch = true; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("exStartWith") as exontrol.EXLISTLib.Column).AutoSearch = exontrol.EXLISTLib.AutoSearchEnum.exStartWith; (var_Columns.Add("exContains") as exontrol.EXLISTLib.Column).AutoSearch = exontrol.EXLISTLib.AutoSearchEnum.exContains; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("text"),1,"another text"); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add("text"),1,"another text");
114. How do I disable the control
exlist1.Enabled = false;
exlist1.AutoSearch = true; exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; (var_Columns.Add("exStartWith") as exontrol.EXLISTLib.Column).AutoSearch = exontrol.EXLISTLib.AutoSearchEnum.exStartWith; (var_Columns.Add("exContains") as exontrol.EXLISTLib.Column).AutoSearch = exontrol.EXLISTLib.AutoSearchEnum.exContains; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("text"),1,"another text"); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_Caption(var_Items1.Add("text"),1,"another text");
112. How do I call your x-script language
exontrol.EXLISTLib.Column var_Column = (exlist1.ExecuteTemplate("Columns.Add(`Column`)") as exontrol.EXLISTLib.Column); var_Column.HeaderStrikeOut = true; var_Column.HeaderBold = true;
111. How do I call your x-script language
exlist1.Template = "Columns.Add(`Column`).HTMLCaption = `<b>C</b>olumn`";
exlist1.BackColorAlternate = Color.FromArgb(240,240,240); exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); var_Items.Add("Item 4"); var_Items.Add("Item 5");
109. How do I enlarge the drop down filter window
exlist1.FilterBarDropDownHeight = -320; exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterBarDropDownWidth = -320; exlist1.Items.Add("Item 1"); exlist1.Items.Add("Item 2");
108. How do I filter programatically the control
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exPattern; var_Column.Filter = "Item*"; exlist1.Items.Add("Item 1"); exlist1.Items.Add(""); exlist1.Items.Add("Item 2"); exlist1.ApplyFilter();
107. How do I change the font of the control's filterbar
exlist1.FilterBarFont.Size = 20; exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
106. Can I apply an EBN skin to the control's filter bar so I can change its visual appearance
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.FilterBarBackColor32 = 0x1000000; exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
105. How do I change the background color of the control's filterbar
exlist1.FilterBarBackColor = Color.FromArgb(240,240,240); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
104. How do I change the foreground color of the control's filterbar
exlist1.FilterBarForeColor = Color.FromArgb(255,0,0); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
103. How do I change the height of the control's filterbar
exlist1.FilterBarHeight = 32; exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
102. How do select only a portion of text when the control starts editing a cell
exlist1.AllowEdit = true; exlist1.SelStart = 1; exlist1.SelLength = 1; exlist1.Columns.Add("Column"); exlist1.Items.Add("Item 1"); exlist1.Items.Add("Item 2");
101. How do I change the header's foreground color
exlist1.ForeColorHeader = Color.FromArgb(255,0,0); exlist1.Columns.Add("Column 1"); exlist1.Columns.Add("Column 2"); exlist1.Items.Add("Item 1");
100. I have a picture on the control's background, the question is how do I draw selection as semi-transparent
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.SelBackMode = exontrol.EXLISTLib.BackModeEnum.exTransparent; exlist1.Columns.Add("Column"); exlist1.Items.Add("Item 1"); exlist1.Items.Add("Item 2");
99. It seems that the control uses the TAB key, is there any way to avoid that
exlist1.UseTabKey = false;
exlist1.ColumnAutoResize = false; exlist1.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); exlist1.DataSource = (rs as ADODB.Recordset);
97. How do I change the visual appearance effect for the selected item, using EBN
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.SelBackColor32 = 0x1000000; exlist1.SelForeColor = Color.FromArgb(0,0,0); exlist1.ShowFocusRect = false; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
96. How do I change the colors for the selected item
exlist1.SelBackColor = Color.FromArgb(0,0,0); exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
95. How do I get ride of the rectangle arround focused item
exlist1.ShowFocusRect = false; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1);
94. How can I change the control's font
exlist1.Font.Name = "Tahoma"; exlist1.Columns.Add("Column");
93. I can't scroll to the end of the data. What can I do
exlist1.ScrollBySingleLine = true; exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_ItemHeight(var_Items.Add(0),13); exlist1.PutItems(exlist1.GetItems(0),null); exontrol.EXLISTLib.Items var_Items1 = exlist1.Items; var_Items1.set_ItemHeight(var_Items1.Add(1),26); exlist1.PutItems(exlist1.GetItems(0),null); exontrol.EXLISTLib.Items var_Items2 = exlist1.Items; var_Items2.set_ItemHeight(var_Items2.Add(2),36); exlist1.PutItems(exlist1.GetItems(0),null); exontrol.EXLISTLib.Items var_Items3 = exlist1.Items; var_Items3.set_ItemHeight(var_Items3.Add(3),48); exlist1.PutItems(exlist1.GetItems(0),null);
92. Is there any option to select an item using the right button of the mouse (rclick)
exlist1.RClickSelect = true; exlist1.Columns.Add("Column"); exlist1.Items.Add("Item 1"); exlist1.Items.Add("Item 2");
91. How do I edit a cell
exlist1.AllowEdit = true; exlist1.Columns.Add("Column"); exlist1.Items.Add("Item 1"); exlist1.Items.Add("Item 2");
90. I have FullRowSelect property on False, how do I select a column
exlist1.SelectColumnIndex = 1; exlist1.FullRowSelect = false;
89. How can I scroll columns one by one, not pixel by pixel
exlist1.ContinueColumnScroll = false; exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("1") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("2") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("3") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("4") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("5") as exontrol.EXLISTLib.Column).Width = 128;
88. How can I enable multiple items selection
exlist1.SingleSel = false; exlist1.Columns.Add("Column"); exlist1.Items.Add(0); exlist1.Items.Add(1); exlist1.Items.Add(2);
87. How can I programmatically change the column where incremental searching is performed
exlist1.Columns.Add("Column 1"); exlist1.Columns.Add("Column 2"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("Item 1"),1,"SubItem 1"); exlist1.SearchColumnIndex = 1;
86. How do I disable the full-row selection in the control
exlist1.FullRowSelect = false; exlist1.Columns.Add("Column"); exlist1.Items.Add("One"); exlist1.Items.Add("Two");
85. Is there any option to specify the height of the items, before adding them
exlist1.DefaultItemHeight = 32; exlist1.Columns.Add("Column"); exlist1.Items.Add("One"); exlist1.Items.Add("Two");
84. How do lock / fix some columns to the control, so I can see them all the time, event if I scroll the columns
exlist1.CountLockedColumns = 1; exlist1.BackColorLock = Color.FromArgb(240,240,240); exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("Locked") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("Un-Locked 1") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("Un-Locked 2") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("Un-Locked 3") as exontrol.EXLISTLib.Column).Width = 128; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("locked"),1,"unlocked");
83. How do I change the control's background / foreground color on the locked area
exlist1.CountLockedColumns = 1; exlist1.ForeColorLock = Color.FromArgb(240,240,240); exlist1.BackColorLock = Color.FromArgb(128,128,128); exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("Locked") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("Un-Locked 1") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("Un-Locked 2") as exontrol.EXLISTLib.Column).Width = 128; (exlist1.Columns.Add("Un-Locked 3") as exontrol.EXLISTLib.Column).Width = 128; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("locked"),1,"unlocked");
82. How do I change the control's foreground color
exlist1.ForeColor = Color.FromArgb(120,120,120); exlist1.Columns.Add("Column"); exlist1.Items.Add("item");
81. How do I change the control's background color
exlist1.BackColor = Color.FromArgb(200,200,200);
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.set_RadioImage(false,1); exlist1.set_RadioImage(true,2); (exlist1.Columns.Add("Radio") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasRadioButton,true); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Radio 1"); var_Items.set_CellState(var_Items.Add("Radio 2"),0,1); var_Items.Add("Radio 3");
79. How do I use my own icons for checkbox cells
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exlist1.set_CheckImage(exontrol.EXLISTLib.CheckStateEnum.Unchecked,1); exlist1.set_CheckImage(exontrol.EXLISTLib.CheckStateEnum.Checked,2); (exlist1.Columns.Add("Check") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Check 1"); var_Items.set_CellState(var_Items.Add("Check 2"),0,1);
78. How do I perform my own sorting when user clicks the column's header
exlist1.SortOnClick = exontrol.EXLISTLib.SortOnClickEnum.exUserSort; exlist1.Columns.Add("Column"); exlist1.Items.Add("Item 1"); exlist1.Items.Add("Item 2");
77. How do I disable sorting a specified column when clicking its header
exlist1.Columns.Add("1"); (exlist1.Columns.Add("NoSort") as exontrol.EXLISTLib.Column).AllowSort = false;
76. How do I disable sorting the columns when clicking the control's header
exlist1.SortOnClick = exontrol.EXLISTLib.SortOnClickEnum.exNoSort; exlist1.Columns.Add("1"); exlist1.Columns.Add("2");
75. How do I put a picture on the center of the control
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplay = exontrol.EXLISTLib.PictureDisplayEnum.MiddleCenter;
74. How do I resize/stretch a picture on the control's background
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplay = exontrol.EXLISTLib.PictureDisplayEnum.Stretch;
73. How do I put a picture on the control's center right bottom side
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplay = exontrol.EXLISTLib.PictureDisplayEnum.LowerRight;
72. How do I put a picture on the control's center left bottom side
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplay = exontrol.EXLISTLib.PictureDisplayEnum.LowerLeft;
71. How do I put a picture on the control's center top side
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplay = exontrol.EXLISTLib.PictureDisplayEnum.UpperCenter;
70. How do I put a picture on the control's right top corner
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplay = exontrol.EXLISTLib.PictureDisplayEnum.UpperRight;
69. How do I put a picture on the control's left top corner
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp); exlist1.PictureDisplay = exontrol.EXLISTLib.PictureDisplayEnum.UpperLeft;
68. How do I put a picture on the control's background
exlist1.Picture = (exlist1.ExecuteTemplate("loadpicture(`c:\\exontrol\\images\\zipdisk.gif`)") as stdole.IPictureDisp);
67. How do I sort descending a column, and put the sorting icon in the column's header
exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 1"); var_Items.Add("Item 2"); var_Items.Add("Item 3"); exlist1.Columns[0].SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortDescending;
66. How do I sort ascending a column, and put the sorting icon in the column's header
exlist1.Columns.Add("Column"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("Item 3"); var_Items.Add("Item 1"); var_Items.Add("Item 2"); exlist1.Columns[0].SortOrder = exontrol.EXLISTLib.SortOrderEnum.SortAscending;
65. How do I perform my own/custom sort, using my extra numbers
(exlist1.Columns.Add("desc") as exontrol.EXLISTLib.Column).SortType = exontrol.EXLISTLib.SortTypeEnum.SortUserData; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellData(var_Items.Add(0),0,2); var_Items.set_CellData(var_Items.Add(1),0,1); var_Items.set_CellData(var_Items.Add(2),0,0); var_Items.Sort(0,false);
64. By default, the column gets sorted as strings, so how do I sort a column by time only
(exlist1.Columns.Add("desc") as exontrol.EXLISTLib.Column).SortType = exontrol.EXLISTLib.SortTypeEnum.SortTime; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("11:00"); var_Items.Add("10:10"); var_Items.Add("12:12"); var_Items.Sort(0,false);
63. By default, the column gets sorted as strings, so how do I sort a column by date and time
(exlist1.Columns.Add("desc") as exontrol.EXLISTLib.Column).SortType = exontrol.EXLISTLib.SortTypeEnum.SortDateTime; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("1/1/2001 11:00"); var_Items.Add("1/1/2001 10:10"); var_Items.Add("1/3/2003"); var_Items.Sort(0,false);
62. By default, the column gets sorted as strings, so how do I sort a column by dates
(exlist1.Columns.Add("desc") as exontrol.EXLISTLib.Column).SortType = exontrol.EXLISTLib.SortTypeEnum.SortDate; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add("1/1/2001"); var_Items.Add("1/2/2002"); var_Items.Add("1/3/2003"); var_Items.Sort(0,false);
61. How do I sort a column by numbers
(exlist1.Columns.Add("desc") as exontrol.EXLISTLib.Column).SortType = exontrol.EXLISTLib.SortTypeEnum.SortNumeric; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(1); var_Items.Add(5); var_Items.Add(10); var_Items.Sort(0,false);
60. How do I hide the control's header bar
exlist1.HeaderVisible = false;
exlist1.VisualAppearance.Add(1,"c:\\exontrol\\images\\normal.ebn"); exlist1.BackColorHeader32 = 0x1000000;
58. How do I remove the control's border
exlist1.Appearance = exontrol.EXLISTLib.AppearanceEnum.None2;
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterPattern = false;
56. How do I filter for items that match exactly the specified string
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exFilter; var_Column.Filter = "Item 1"; exlist1.Items.Add("Item 1"); exlist1.Items.Add("Item 2"); exlist1.Items.Add("Item 3"); exlist1.ApplyFilter();
55. How can I can I programmatically filter for items with a specified icon assigned
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exImage; var_Column.Filter = 1.ToString(); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellImage(var_Items.Add("Image 1"),0,1); var_Items.set_CellImage(var_Items.Add("Image 1"),0,1); var_Items.set_CellImage(var_Items.Add("Image 2"),0,2); var_Items.set_CellImage(var_Items.Add("Image 3"),0,3); exlist1.ApplyFilter();
54. How can I can I programmatically filter the checked items
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exCheck; var_Column.Filter = 0.ToString(); exlist1.Items.Add(0); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_CellState(var_Items.Add(1),0,1); exlist1.Items.Add(2); exlist1.ApplyFilter();
53. How can I can I filter programmatically the items based on some numerichal rules
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exNumeric; var_Column.Filter = "> 0 <= 1"; exlist1.Items.Add(0); exlist1.Items.Add(1); exlist1.Items.Add(2); exlist1.ApplyFilter();
52. How can I can I filter programmatically the items based on a range/interval of dates
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exDate; var_Column.Filter = "1/1/2001 to 1/1/2002"; exlist1.Items.Add("1/1/2001"); exlist1.Items.Add("2/1/2002"); exlist1.ApplyFilter();
51. How can I can I filter programmatically given a specified pattern using wild characters like * or
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exPattern; var_Column.Filter = "0*"; exlist1.Items.Add(0); exlist1.Items.Add("00"); exlist1.Items.Add(1); exlist1.Items.Add("11"); exlist1.ApplyFilter();
50. How can I can I select programmatically "Blanks/NonBlanks" option in the column's drop down filter
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.ApplyFilter();
49. How can I display the column's filter
(exlist1.Columns.Add("") as exontrol.EXLISTLib.Column).DisplayFilterButton = true;
48. How can I show only the vertical scroll bar
exlist1.ColumnAutoResize = true; exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableNoVertical; exlist1.Columns.Add(1.ToString()); exlist1.Columns.Add(2.ToString());
47. How can I change the "IsChecked/IsUnchecked" caption in the control's filter bar, when I filter for checked items
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exCheck; var_Column.Filter = 0.ToString(); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarIsChecked,"Check_On"); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarIsUnchecked,"Check_Off"); exlist1.ApplyFilter();
46. How can I change the "Checked" caption in the drop down filter window, when I filter for checked items
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exCheck; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarChecked,"with check on"); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarUnchecked,"with check off");
45. 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.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarDateWeekDays,"Du Lu Ma Mi Jo Vi Si"); exlist1.ApplyFilter();
44. How can I change the name of the months in the drop down calendar window, being displayed when I filter items between dates
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarDateMonths,"Janvier Février Mars Avril Mai Juin Juillet Août Septembre Octobre Novembre Décembre"); exlist1.ApplyFilter();
43. Can I change the "Today" caption being displayed in the drop down calendar, when I filter for dates
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarDateTodayCaption,"Azi"); exlist1.ApplyFilter();
42. The drop down filter window displays a "to" string between two datem when I filter dates. Can I change that
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarDateTo,"->"); exlist1.ApplyFilter();
41. How can I filter the items that are between an interval/range of dates
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; exlist1.ApplyFilter();
40. Can I change the "Date:" caption when the column's drop down filter window is shown
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.DisplayFilterDate = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarDate,"Range"); exlist1.ApplyFilter();
39. Can I filter for values using OR - NOT , instead AND operator
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exontrol.EXLISTLib.Column var_Column1 = (exlist1.Columns.Add("Column 2") as exontrol.EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exontrol.EXLISTLib.Column var_Column2 = (exlist1.Columns.Add("Column 3") as exontrol.EXLISTLib.Column); var_Column2.DisplayFilterButton = true; var_Column2.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.FilterCriteria = "%0 or not %1 and %2"; exlist1.ApplyFilter();
38. Can I change the NOT string in the filter bar
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exontrol.EXLISTLib.Column var_Column1 = (exlist1.Columns.Add("Column 2") as exontrol.EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exNonBlanks; exlist1.FilterCriteria = "not %0 or %1"; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarNot," ! "); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarIsNonBlank," ! IsBlank"); exlist1.ApplyFilter();
37. Can I change the OR string in the filter bar
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exontrol.EXLISTLib.Column var_Column1 = (exlist1.Columns.Add("Column 2") as exontrol.EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exNonBlanks; exlist1.FilterCriteria = "%0 or %1"; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarOr," | "); exlist1.ApplyFilter();
36. Can I change the AND string in the filter bar
exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exontrol.EXLISTLib.Column var_Column1 = (exlist1.Columns.Add("Column 2") as exontrol.EXLISTLib.Column); var_Column1.DisplayFilterButton = true; var_Column1.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exNonBlanks; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarAnd," & "); exlist1.ApplyFilter();
35. 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.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column); var_Column.DisplayFilterButton = true; var_Column.FilterType = exontrol.EXLISTLib.FilterTypeEnum.exBlanks; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarIsBlank,"Is Empty"); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarIsNonBlank,"Is Not Empty"); exlist1.ApplyFilter();
34. Is there any option to remove the tooltip when the cursor hovers the column's drop down filter window
(exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).DisplayFilterButton = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarFilterTitle,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarPatternFilterTitle,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarTooltip,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarPatternTooltip,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarFilterForTooltip,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarDateTooltip,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarDateTitle,"");
33. How can I change the "Filter For" caption in the column's drop down filter window
(exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).DisplayFilterButton = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarFilterForCaption,"new caption");
32. Can I remove the "All", "Blanks" and "NonBlanks" items in the drop down filter window
(exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).DisplayFilterButton = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarAll,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarBlanks,""); exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarNonBlanks,"");
31. How do I change the "All", "Blanks" or/and "NonBlanks" caption in the drop down filter window
(exlist1.Columns.Add("Column") as exontrol.EXLISTLib.Column).DisplayFilterButton = true; exlist1.set_Description(exontrol.EXLISTLib.DescriptionTypeEnum.exFilterBarAll,"new name for (All)");
30. How can I change the position of the column
exlist1.Columns.Add("Column 1"); (exlist1.Columns.Add("Column 2") as exontrol.EXLISTLib.Column).Position = 0;
29. Can I make strikeout the column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HeaderStrikeOut = true;
28. How can I apply an strikeout font only a portion of the column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HTMLCaption = "<s>Col</s>umn 1";
27. How can I get underlined only a portion of column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HTMLCaption = "<u>Col</u>umn 1";
26. How can I underline the column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HeaderUnderline = true;
25. How can I apply an italic font only a portion of the column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HTMLCaption = "<i>Col</i>umn 1";
24. Is there any option to make italic the column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HeaderItalic = true;
23. How can I bold only a portion of the column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HTMLCaption = "<b>Col</b>umn 1";
22. Is there any option to bold the column's header
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HeaderBold = true;
21. Is there any option to change the color for the grid lines
exlist1.Columns.Add(""); exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; exlist1.GridLineColor = Color.FromArgb(255,0,0);
20. Can I change the font to display the column's header
exlist1.HeaderHeight = 34; (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HTMLCaption = "<font Tahoma;14>Column</font> 1";
19. Can I change the height of the header bar
exlist1.HeaderHeight = 32;
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).HTMLCaption = "1<img>1</img> 2 <img>2</img>...";
17. How can I show the control's grid lines
exlist1.MarkSearchColumn = false; exlist1.DrawGridLines = exontrol.EXLISTLib.GridLinesEnum.exAllLines; exlist1.Columns.Add("Column 1"); exlist1.Columns.Add("Column 2"); exlist1.Items.Add(0); exlist1.Items.Add(1); exlist1.Items.Add(2);
16. How can I assign a different background color for the entire column
exlist1.MarkSearchColumn = false; (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellBackColor,255); exlist1.Columns.Add("Column 2"); exlist1.Items.Add(0); exlist1.Items.Add(1); exlist1.Items.Add(2);
15. How can I assign a check box for a cell
exlist1.Columns.Add("Column 1"); exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.Add(0); var_Items.set_CellHasCheckBox(var_Items.Add(1),0,true); var_Items.Add(2);
14. How can I assign checkboxes for the entire column
(exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).set_Def(exontrol.EXLISTLib.DefColumnEnum.exCellHasCheckBox,true); exlist1.Items.Add(0); exlist1.Items.Add(1); exlist1.Items.Add(2);
13. How can I show both scrollbars
exlist1.ScrollBars = exontrol.EXLISTLib.ScrollBarsEnum.DisableBoth;
exlist1.ColumnAutoResize = false; (exlist1.Columns.Add("Column 1") as exontrol.EXLISTLib.Column).Width = 64; (exlist1.Columns.Add("Column 2") as exontrol.EXLISTLib.Column).Width = 128;
11. How can I show or hide a column
(exlist1.Columns.Add("Hidden") as exontrol.EXLISTLib.Column).Visible = false;
10. How can I hide the searching column
exlist1.MarkSearchColumn = false; exlist1.Columns.Add("Column 1"); exlist1.Columns.Add("Column 2"); exlist1.Items.Add(null);
9. Can I disable sorting a column, when the user clicks the column's header, or drag it to the sort bar
(exlist1.Columns.Add("Unsortable") as exontrol.EXLISTLib.Column).AllowSort = false; exlist1.Columns.Add("Sortable");
8. Is there any option to align the header to the left and the data to the right
(exlist1.Columns.Add("Left") as exontrol.EXLISTLib.Column).Alignment = exontrol.EXLISTLib.AlignmentEnum.LeftAlignment; exontrol.EXLISTLib.Column var_Column = (exlist1.Columns.Add("Right") as exontrol.EXLISTLib.Column); var_Column.Alignment = exontrol.EXLISTLib.AlignmentEnum.RightAlignment; var_Column.HeaderAlignment = exontrol.EXLISTLib.AlignmentEnum.RightAlignment; exontrol.EXLISTLib.Items var_Items = exlist1.Items; var_Items.set_Caption(var_Items.Add("left"),1,"right");
7. Can I displays a custom size picture to column's header
exlist1.set_HTMLPicture("pic1","c:\\exontrol\\images\\zipdisk.gif"); exlist1.HeaderHeight = 48; (exlist1.Columns.Add("ColumnName") as exontrol.EXLISTLib.Column).HTMLCaption = "<b>HTML</b> Column <img>pic1</img> Picture";
6. How can I insert an icon to column's header
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (exlist1.Columns.Add("ColumnName") as exontrol.EXLISTLib.Column).HTMLCaption = "<b>HTML</b> Column <img>1</img> Icon";
5. How can I insert an icon to column's header
exlist1.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" + "/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" + "/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" + "x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" + "NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="); (exlist1.Columns.Add("ColumnName") as exontrol.EXLISTLib.Column).HeaderImage = 1;
4. How can I use HTML format in column's header
(exlist1.Columns.Add("ColumnName") as exontrol.EXLISTLib.Column).HTMLCaption = "<b>HTML</b> <fgcolor=0000FF>Col</fgcolor>umn";
3. How can I change/rename the column's name
(exlist1.Columns.Add("ColumnName") as exontrol.EXLISTLib.Column).Caption = "NewName";
2. How can I add multiple columns
exontrol.EXLISTLib.Columns var_Columns = exlist1.Columns; var_Columns.Add("Column 1"); var_Columns.Add("Column 2");
1. How can I add a new column
exlist1.Columns.Add("ColumnName");