439. How can I change the background appearance (ebn) for the filter field in the bottom part of the drop down portion
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BeginUpdate()
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.FilterForVisible = True
.FilterForBackColor32 = &H1000000
.ColumnAutoResize = True
.IntegralHeight = True
.Columns.Add("Default")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.AddItem("Item 3")
.AddItem("Item 4")
.AddItem("Item 5")
End With
.EndUpdate()
End With
|
438. How can I change the background color for the filter field in the bottom part of the drop down portion
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BeginUpdate()
.FilterForVisible = True
.FilterForBackColor = Color.FromArgb(240,240,240)
.ColumnAutoResize = True
.IntegralHeight = True
.Columns.Add("Default")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.AddItem("Item 3")
.AddItem("Item 4")
.AddItem("Item 5")
End With
.EndUpdate()
End With
|
437. How can I display a filter field in the bottom part of the drop down portion
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BeginUpdate()
.FilterForVisible = True
.ColumnAutoResize = True
.IntegralHeight = True
.Columns.Add("Default")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.AddItem("Item 3")
.AddItem("Item 4")
.AddItem("Item 5")
End With
.EndUpdate()
End With
|
436. Does your control support RightToLeft property for RTL languages or right to left
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BeginUpdate()
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
With .Columns.Add("P1")
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True)
.PartialCheck = True
End With
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
.RightToLeft = True
.EndUpdate()
End With
|
435. Is there any way to display the vertical scroll bar on the left side, as I want to align my data to the right
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BeginUpdate()
With .Columns
.Add("C1")
.Add("C2")
.Add("C3")
.Add("C4")
.Add("C5")
.Add("C6")
.Add("C7")
.Add("C8")
End With
.RightToLeft = True
.EndUpdate()
End With
|
434. Can I display the cell's check box after the text
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Column")
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True)
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check")
End With
With .Items
.set_CellHasCheckBox(.AddItem("Caption 1"),0,True)
.set_CellHasCheckBox(.AddItem("Caption 2"),0,True)
End With
End With
|
433. Can I change the order of the parts in the cell, as checkbox after the text, and so on
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Column").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellDrawPartsOrder,"caption,check,icon,icons,picture")
With .Items
h = .AddItem("Text")
.set_CellImage(h,0,1)
.set_CellHasCheckBox(h,0,True)
End With
End With
|
432. Can I have an image displayed after the text. Can I get that effect without using HTML content
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Column").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellDrawPartsOrder,"caption,icon,check,icons,picture")
With .Items
h = .AddItem("Text")
.set_CellImage(h,0,1)
End With
End With
|
431. How can I display the column using currency format and enlarge the font for certain values
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Currency")
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1)
End With
With .Items
.AddItem("1.23")
.AddItem("2.34")
.AddItem("9.94")
.AddItem("11.94")
.AddItem("1000")
End With
End With
|
430. How can I get the number of occurrences of a specified string in the cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("")
With .Columns.Add("occurrences")
.ComputedField = "lower(%0) count 'o'"
End With
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1 oooof the root")
.InsertItem(h,0,"Child 2")
.InsertItem(h,0,"Child 3")
.set_ExpandItem(h,True)
End With
End With
|
429. How can I display dates in my format
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Date")
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1)
End With
With .Items
.AddItem(#1/21/2001#)
.AddItem(#2/22/2002#)
.AddItem(#3/13/2003#)
.AddItem(#4/24/2004#)
End With
End With
|
428. How can I display dates in short format
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True With .Items .AddItem(#1/1/2001#) .AddItem(#2/2/2002#) .AddItem(#3/3/2003#) .AddItem(#4/4/2004#) End With End With |
427. How can I display dates in long format
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True With .Items .AddItem(#1/1/2001#) .AddItem(#2/2/2002#) .AddItem(#3/3/2003#) .AddItem(#4/4/2004#) End With End With |
426. How can I display only the right part of the cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("")
With .Columns.Add("Right")
.ComputedField = "%0 right 2"
End With
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.InsertItem(h,0,"SChild 3")
.set_ExpandItem(h,True)
End With
End With
|
425. How can I display only the left part of the cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("")
.Columns.Add("Left").ComputedField = "%0 left 2"
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.InsertItem(h,0,"SChild 3")
.set_ExpandItem(h,True)
End With
End With
|
424. How can I display true or false instead 0 and -1
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True With .Items .AddItem(True) .AddItem(False) .AddItem(True) .AddItem(0) .AddItem(1) End With End With |
423. How can I display icons or images instead numbers
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
With .Columns.Add("Icons")
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1)
End With
With .Items
.AddItem(1)
.AddItem(2)
.AddItem(3)
End With
End With
|
422. How can I display the column using currency
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Items
.AddItem("1.23")
.AddItem("2.34")
.AddItem("0")
.AddItem(5)
.AddItem("10000.99")
End With
End With
|
421. How can I display the currency only for not empty cells
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Currency").ComputedField = "len(%0) ? currency(dbl(%0)) : ''"
With .Items
.AddItem("1.23")
.AddItem("2.34")
.AddItem("0")
.set_ItemBackColor(.AddItem(),Color.FromArgb(255,128,128))
.AddItem("10000.99")
End With
End With
|
420. Is there a function to display the number of days between two date including the number of hours
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Start").Width = 32
.Columns.Add("End")
.Columns.Add("Duration").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)' : '' )"
With .Items
h = .AddItem(#1/11/2001#)
.set_CellCaption(h,1,#1/14/2001#)
h = .AddItem(#2/22/2002 0:00:00 PM#)
.set_CellCaption(h,1,#3/14/2002 1:00:00 PM#)
h = .AddItem(#3/13/2003#)
.set_CellCaption(h,1,#4/11/2003 11:00:00 AM#)
End With
End With
|
419. Is there a function to display the number of days between two date including the number of hours
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Start")
.Columns.Add("End")
.Columns.Add("Duration").ComputedField = """D "" + int(date(%1)-date(%0)) + "" H "" + round(24*(date(%1)-date(%0) - floor(date(%1)-date(%" & _
"0))))"
With .Items
h = .AddItem(#1/11/2001#)
.set_CellCaption(h,1,#1/14/2001 11:00:00 PM#)
h = .AddItem(#2/22/2002 0:00:00 PM#)
.set_CellCaption(h,1,#3/14/2002 1:00:00 PM#)
h = .AddItem(#3/13/2003#)
.set_CellCaption(h,1,#4/11/2003 11:00:00 AM#)
End With
End With
|
418. How can I display the number of days between two dates
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Start")
.Columns.Add("End")
.Columns.Add("Duration").ComputedField = "(date(%1)-date(%0)) + ' days'"
With .Items
h = .AddItem(#1/11/2001#)
.set_CellCaption(h,1,#1/14/2001#)
h = .AddItem(#2/22/2002#)
.set_CellCaption(h,1,#3/14/2002#)
h = .AddItem(#3/13/2003#)
.set_CellCaption(h,1,#4/11/2003#)
End With
End With
|
417. How can I get second part of the date
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("Second").ComputedField = "sec(date(%0))"
With .Items
.AddItem(#1/11/2001 10:10:00 AM#)
.AddItem(#2/22/2002 11:01:22 AM#)
.AddItem(#3/13/2003 0:23:01 PM#)
.AddItem(#4/14/2004 1:11:59 PM#)
End With
End With
|
416. How can I get minute part of the date
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("Minute").ComputedField = "min(date(%0))"
With .Items
.AddItem(#1/11/2001 10:10:00 AM#)
.AddItem(#2/22/2002 11:01:00 AM#)
.AddItem(#3/13/2003 0:23:00 PM#)
.AddItem(#4/14/2004 1:11:00 PM#)
End With
End With
|
415. How can I check the hour part only so I know it was afternoon
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("hour(%0)>=12").Bold = True
.Columns.Add("Date")
.Columns.Add("Hour").ComputedField = "hour(%0)"
With .Items
.AddItem(#1/11/2001 10:00:00 AM#)
.AddItem(#2/22/2002 11:00:00 AM#)
.AddItem(#3/13/2003 0:00:00 PM#)
.AddItem(#4/14/2004 1:00:00 PM#)
End With
End With
|
414. What about a function to get the day in the week, or days since Sunday
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("WeekDay").ComputedField = "weekday(%0)"
With .Items
.AddItem(#1/11/2001 10:00:00 AM#)
.AddItem(#2/22/2002 11:00:00 AM#)
.AddItem(#3/13/2003 0:00:00 PM#)
.AddItem(#4/14/2004 1:00:00 PM#)
End With
End With
|
413. Is there any function to get the day of the year or number of days since January 1st
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("Day since January 1st").ComputedField = "yearday(%0)"
With .Items
.AddItem(#1/11/2001 10:00:00 AM#)
.AddItem(#2/22/2002 11:00:00 AM#)
.AddItem(#3/13/2003 0:00:00 PM#)
.AddItem(#4/14/2004 1:00:00 PM#)
End With
End With
|
412. How can I display only the day of the date
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("Day").ComputedField = "day(%0)"
With .Items
.AddItem(#1/11/2001 10:00:00 AM#)
.AddItem(#2/22/2002 11:00:00 AM#)
.AddItem(#3/13/2003 0:00:00 PM#)
.AddItem(#4/14/2004 1:00:00 PM#)
End With
End With
|
411. How can I display only the month of the date
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("Month").ComputedField = "month(%0)"
With .Items
.AddItem(#1/1/2001 10:00:00 AM#)
.AddItem(#2/2/2002 11:00:00 AM#)
.AddItem(#3/3/2003 0:00:00 PM#)
.AddItem(#4/4/2004 1:00:00 PM#)
End With
End With
|
410. How can I get only the year part from a date expression
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("Year").ComputedField = "year(%0)"
With .Items
.AddItem(#1/1/2001 10:00:00 AM#)
.AddItem(#2/2/2002 11:00:00 AM#)
.AddItem(#3/3/2003 0:00:00 PM#)
.AddItem(#4/4/2004 1:00:00 PM#)
End With
End With
|
409. Can I convert the expression to date
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Date").ComputedField = "date(dbl(%0))"
With .Items
.AddItem("-1.98")
.AddItem("30000.99")
.AddItem("3561.23")
.AddItem("1232.34")
End With
End With
|
408. Can I convert the expression to a number, double or float
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Number + 2").ComputedField = "dbl(%0)+2"
With .Items
.AddItem("-1.98")
.AddItem("0.99")
.AddItem("1.23")
.AddItem("2.34")
End With
End With
|
407. How can I display dates in long format
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("LongFormat").ComputedField = "longdate(%0)"
With .Items
.AddItem(#1/1/2001 10:00:00 AM#)
.AddItem(#2/2/2002 11:00:00 AM#)
.AddItem(#3/3/2003 0:00:00 PM#)
.AddItem(#4/4/2004 1:00:00 PM#)
End With
End With
|
406. How can I display dates in short format
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("ShortFormat").ComputedField = "shortdate(%0)"
With .Items
.AddItem(#1/1/2001 10:00:00 AM#)
.AddItem(#2/2/2002 11:00:00 AM#)
.AddItem(#3/3/2003 0:00:00 PM#)
.AddItem(#4/4/2004 1:00:00 PM#)
End With
End With
|
405. How can I display the time only of a date expression
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Date")
.Columns.Add("Time").ComputedField = "'time is:' + time(date(%0))"
With .Items
.AddItem(#1/1/2001 10:00:00 AM#)
.AddItem(#2/2/2002 11:00:00 AM#)
.AddItem(#3/3/2003 0:00:00 PM#)
.AddItem(#4/4/2004 1:00:00 PM#)
End With
End With
|
404. Is there any function to display currencies, or money formatted as in the control panel
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Currency").ComputedField = "currency(dbl(%0))"
With .Items
.AddItem("1.23")
.AddItem("2.34")
.AddItem("10000.99")
End With
End With
|
403. How can I convert the expression to a string so I can look into the date string expression for month's name
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Str").ComputedField = "str(%0) + ' AA'"
With .Items
.AddItem("-1.98")
.AddItem("0.99")
.AddItem("1.23")
.AddItem("2.34")
End With
End With
|
402. Can I display the absolute value or positive part of the number
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Abs").ComputedField = "abs(%0)"
With .Items
.AddItem("-1.98")
.AddItem("0.99")
.AddItem("1.23")
.AddItem("2.34")
End With
End With
|
401. Is there any function to get largest number with no fraction part that is not greater than the value
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Floor").ComputedField = "floor(%0)"
With .Items
.AddItem("-1.98")
.AddItem("0.99")
.AddItem("1.23")
.AddItem("2.34")
End With
End With
|
400. Is there any function to round the values base on the .5 value
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Round").ComputedField = "round(%0)"
With .Items
.AddItem("-1.98")
.AddItem("0.99")
.AddItem("1.23")
.AddItem("2.34")
End With
End With
|
399. How can I get or display the integer part of the cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Number")
.Columns.Add("Int").ComputedField = "int(%0)"
With .Items
.AddItem("-1.98")
.AddItem("0.99")
.AddItem("1.23")
.AddItem("2.34")
End With
End With
|
398. How can I display names as proper ( first leter of the word must be in uppercase, and the rest in lowercase )
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("").ComputedField = "proper(%0)"
With .Items
h = .AddItem("root")
.InsertItem(h,0,"child child")
.InsertItem(h,0,"child child")
.InsertItem(h,0,"child child")
.set_ExpandItem(h,True)
End With
End With
|
397. Is there any option to display cells in uppercase
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("").ComputedField = "upper(%0)"
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.InsertItem(h,0,"Chld 3")
.set_ExpandItem(h,True)
End With
End With
|
396. Is there any option to display cells in lowercase
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("").ComputedField = "lower(%0)"
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.InsertItem(h,0,"Chld 3")
.set_ExpandItem(h,True)
End With
End With
|
395. How can I mark the cells that has a specified type, ie strings only
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("type(%0) = 8").ForeColor = Color.FromArgb(255,0,0)
.Columns.Add("")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,2)
.InsertItem(h,0,"Chld 3")
.set_ExpandItem(h,True)
End With
End With
|
394. How can I bold the items that contains data or those who displays empty strings
| VB.NET |
|---|
Dim h,hC
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("not len(%1)=0").Bold = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
hC = .InsertItem(h,0,"Child 2")
.set_CellCaption(hC,1,"1")
.InsertItem(h,0,"Child 3")
.set_ExpandItem(h,True)
End With
End With
|
393. Can I change the background color for items or cells that contains a specified string
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 contains 'hi'").BackColor = Color.FromArgb(255,0,0)
.Columns.Add("")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.InsertItem(h,0,"Chld 3")
.set_ExpandItem(h,True)
End With
End With
|
392. Is there any option to change the fore color for cells or items that ends with a specified string
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 endwith '22'").ForeColor = Color.FromArgb(255,0,0)
.Columns.Add("")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 1.22")
.InsertItem(h,0,"Child 2.22")
.set_ExpandItem(h,True)
End With
End With
|
391. How can I highlight the cells or items that starts with a specified string
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 startwith 'C'").Underline = True
.Columns.Add("")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.InsertItem(h,0,"SChild 3")
.set_ExpandItem(h,True)
End With
End With
|
390. How can I change the background color or the visual appearance using ebn for a particular column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
With .Columns
.Add("Column 1")
.Add("Column 2").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor,16777216)
.Add("Column 3").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor,16777471)
.Add("Column 4")
End With
End With
|
389. How can I change the background color for a particular column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns
.Add("Column 1")
.Add("Column 2").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exHeaderBackColor,8439039)
.Add("Column 3")
End With
End With
|
388. Does your control support prompt feature
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.AutoComplete = False
.Columns.Add("Column 1").Prompt = "<img>1</img><i><fgcolor=808080>type to search</fgcolor></i>"
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
End With
|
387. How can I display the column's header using multiple lines
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnAutoResize = True
.HeaderHeight = 128
.HeaderSingleLine = False
.Columns.Add("This is just a column that should break the header.").Width = 32
.Columns.Add("This is just another column that should break the header.")
End With
|
386. How can I sort the value gets listed in the drop down filter window
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.MarkSearchColumn = False
.set_Description(exontrol.EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarAll,"")
.set_Description(exontrol.EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarBlanks,"")
.set_Description(exontrol.EXCOMBOBOXLib.DescriptionTypeEnum.exFilterBarNonBlanks,"")
With .Columns.Add("P1")
.DisplayFilterButton = True
.DisplayFilterPattern = False
.FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsDesc
End With
With .Columns.Add("P2")
.DisplayFilterButton = True
.DisplayFilterPattern = False
.FilterList = exontrol.EXCOMBOBOXLib.FilterListEnum.exSortItemsAsc
End With
With .Items
h = .AddItem("Z3")
.set_CellCaption(h,1,"C")
.set_CellCaption(.InsertItem(h,0,"Z1"),1,"B")
.set_CellCaption(.InsertItem(h,0,"Z2"),1,"A")
.set_ExpandItem(h,True)
End With
End With
|
385. Is there any property to disable the popup/context menu being shown when the user does a right click in the control's label area
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default").AllowEditContextMenu = False
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
End With
|
384. How can I align the text/caption on the scroll bar
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .ColumnAutoResize = True .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLowerBackPart,"left") .set_ScrollPartCaptionAlignment(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLowerBackPart,exontrol.EXCOMBOBOXLib.AlignmentEnum.LeftAlignment) .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exUpperBackPart,"right") .set_ScrollPartCaptionAlignment(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exUpperBackPart,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment) .ColumnAutoResize = False .Columns.Add(1) .Columns.Add(2) .Columns.Add(3) .Columns.Add(4) .Columns.Add(5) .Columns.Add(6) End With |
383. Does you control support RTL languages or if there is a property RightToLeft
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.RightToLeft = True
.ItemsAllowSizing = exontrol.EXCOMBOBOXLib.ItemsAllowSizingEnum.exResizeItem
.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exHLines
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.ScrollBySingleLine = True
.DefaultItemHeight = 64
.ColumnAutoResize = True
With .Columns.Add("Column")
.Alignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.HeaderAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.EditAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
End With
With .Items
.AddItem("Item 1")
.set_ItemHeight(.InsertItem(.AddItem("Parent"),0,"Item 2"),48)
.AddItem("Item 3")
.set_ExpandItem(.get_ItemByIndex(1),True)
End With
End With
|
382. How do I enable resizing all the items at runtime
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnAutoResize = True
.ItemsAllowSizing = exontrol.EXCOMBOBOXLib.ItemsAllowSizingEnum.exResizeAllItems
.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exHLines
.Columns.Add("Column")
.Items.AddItem("Item 1")
With .Items
.set_ItemHeight(.AddItem("Item 2"),48)
End With
.Items.AddItem("Item 3")
End With
|
381. How can I remove the filter
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
.ClearFilter()
End With
|
380. How do I display the icons being selected in the control's label
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Column")
With .Items
.set_CellImage(.AddItem("Image 1"),0,1)
.set_CellImage(.AddItem("Image 2"),0,2)
.set_CellImage(.AddItem("Image 3"),0,3)
End With
.set_AssignEditImageOnSelect(0,True)
.Value = "Image 2"
End With
|
379. How do I select a value
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.IntegralHeight = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
.Value = "Root 1.1"
End With
|
378. How do I select a value
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.IntegralHeight = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
.set_Select(1,"Root 1.2")
End With
|
377. How do change the visual appearance for the drop down border, using EBN
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .DropDownBorder = &H1000000 End With |
376. How do I remove the drop down's border
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .DropDownBorder = exontrol.EXCOMBOBOXLib.AppearanceEnum.None2 End With |
375. How can I change the foreground color for edit controls
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ForeColorEdit = Color.FromArgb(255,0,0)
.IntegralHeight = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
.set_Select(0,"Root 1.1")
End With
|
374. How can I change the background color for edit controls
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BackColorEdit = Color.FromArgb(255,0,0)
.IntegralHeight = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
.set_Select(0,"Root 1.1")
End With
|
373. How can I hide the drop down buttons when the control loses the focus
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.HideDropDownButton = True
.IntegralHeight = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
End With
|
372. How can I ensure that the drop down portions doesn't show partial items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.IntegralHeight = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
End With
|
371. How can I close the drop down window when user double clicks it
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.CloseOnDblClk = True
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
End With
|
370. How do I get the handle of the drop down window
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .Columns.Add(0) End With |
369. How do I specify the height of the control's label
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LabelHeight = 34
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
368. The control selects the portion of text that doesn't match with the selected item. How can I avoid that
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AutoSelect = False
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
367. How can I show the drop down window as soon as user starts typing in the control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AutoDropDown = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
366. How do I change the text in the edit or label area
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
.set_EditText(0,"Test")
End With
|
365. How do I lock or make read-only the control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Locked = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
364. How do I let user to resize only the height of the drop down window, at runtime
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AllowSizeGrip = True
.AllowHResize = False
.MinWidthList = 100
.MinHeightList = 100
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
363. How do I let user to resize only the width of the drop down window, at runtime
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AllowSizeGrip = True
.AllowVResize = False
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
362. How do I let user to resize the drop down window, at runtime
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AllowSizeGrip = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
361. How do I specify the height of the drop down window
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_HeightList(,400)
.MinWidthList = 100
.AllowSizeGrip = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
360. How do I specify the minimum height of the drop down window
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MinHeightList = 100
.AllowSizeGrip = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
359. How do I specify the width of the drop down window
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_WidthList(,100)
.AllowSizeGrip = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
358. How do I specify the minimum width of the drop down window
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MinWidthList = 100
.AllowSizeGrip = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
357. I have multiple columns, how can I display a single edit in the control's label
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.SingleEdit = True
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
.set_CellCaption(.AddItem("Item 1"),1,"SubItem 1")
.set_CellCaption(.AddItem("Item 2"),1,"SubItem 2")
.set_CellCaption(.AddItem("Item 3"),1,"SubItem 3")
End With
End With
|
356. How do I turn off the auto complete feature
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AutoComplete = False
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.AddItem("Item 2")
End With
End With
|
355. The control supports three styles: Simple, DropDown and DropDownList. How can I change the style
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .Style = exontrol.EXCOMBOBOXLib.StyleEnum.DropDownList End With |
354. Is there any option to align the header to the left and the data to the right
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Left").Alignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.LeftAlignment
With .Columns.Add("Right")
.Alignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.HeaderAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.EditAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
End With
With .Items
.set_CellCaption(.AddItem("left"),1,"right")
End With
End With
|
353. How do I change the control's border, using your EBN files
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .Appearance = &H1000000 End With |
352. Can I change the default border of the tooltip, using your EBN files
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
.ToolTipWidth = 364
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exToolTipAppearance,16777216)
.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
End With
|
351. Can I change the background color for the tooltip
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
.ToolTipWidth = 364
.set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exToolTipBackColor,Color.FromArgb(255,0,0))
.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
End With
|
350. Does the tooltip support HTML format
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
.ToolTipWidth = 364
.Columns.Add("tootip").ToolTip = "<font Tahoma;11>T</font>his is an HTML <b>tooltip</b> assigned to a <fgcolor=FF0000>column</fgc" & _
"olor>"
End With
|
349. Can I change the forecolor for the tooltip
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
.ToolTipWidth = 364
.set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exToolTipForeColor,Color.FromArgb(255,0,0))
.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
End With
|
348. Can I change the foreground color for the tooltip
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
.ToolTipWidth = 364
.Columns.Add("tootip").ToolTip = "<fgcolor=FF0000>this is a tooltip assigned to a column</fgcolor>"
End With
|
347. How can I merge cells
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exAllLines
.MarkSearchColumn = False
.Columns.Add("C1")
.Columns.Add("C2")
.Columns.Add("C3")
With .Items
h = .AddItem("this cell merges the first two columns")
.set_CellMerge(h,0,1)
h = .AddItem()
.set_CellCaption(h,1,"this cell merges the last two columns")
.set_CellMerge(h,1,2)
h = .AddItem("this cell merges the all three columns")
.set_CellMerge(h,0,1)
.set_CellMerge(h,0,2)
h = .AddItem("this draws a divider item")
.set_ItemDivider(h,0)
End With
End With
|
346. How can I merge cells
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.TreeColumnIndex = -1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
h = .AddItem("This is bit of text merges all cells in the item")
.set_ItemDivider(h,0)
.set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment)
End With
End With
|
345. Can I select an item giving its general position
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
344. How can I change the color for separator / dividers items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.TreeColumnIndex = -1
.ScrollBySingleLine = False
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
h = .AddItem()
.set_ItemDivider(h,0)
.set_ItemDividerLine(h,exontrol.EXCOMBOBOXLib.DividerLineEnum.DoubleDotLine)
.set_ItemDividerLineAlignment(h,exontrol.EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter)
.set_ItemHeight(h,6)
.set_SelectableItem(h,False)
h = .AddItem("Cell 2")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
End With
End With
|
343. How can I add separator - dividers items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.TreeColumnIndex = -1
.ScrollBySingleLine = False
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
h = .AddItem()
.set_ItemDivider(h,0)
.set_ItemDividerLine(h,exontrol.EXCOMBOBOXLib.DividerLineEnum.DoubleDotLine)
.set_ItemDividerLineAlignment(h,exontrol.EXCOMBOBOXLib.DividerAlignmentEnum.DividerCenter)
.set_ItemHeight(h,6)
.set_SelectableItem(h,False)
h = .AddItem("Cell 2")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
End With
End With
|
342. Can I change the style of the line being displayed by a divider item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.TreeColumnIndex = -1
.ScrollBySingleLine = False
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
h = .AddItem("This is bit of text that's displayed on the entire item, divider.")
.set_ItemDivider(h,0)
.set_ItemDividerLine(h,exontrol.EXCOMBOBOXLib.DividerLineEnum.DoubleDotLine)
.set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment)
.set_ItemHeight(h,24)
End With
End With
|
341. Can I remove the line being displayed by a divider item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.TreeColumnIndex = -1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
h = .AddItem("This is bit of text that's displayed on the entire item, divider.")
.set_ItemDivider(h,0)
.set_ItemDividerLine(h,exontrol.EXCOMBOBOXLib.DividerLineEnum.EmptyLine)
.set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment)
End With
End With
|
340. How can I display a divider item, merging all cells
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.TreeColumnIndex = -1
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
h = .AddItem("This is bit of text that's displayed on the entire item, divider.")
.set_ItemDivider(h,0)
.set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment)
End With
End With
|
339. How can I fix or lock items
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1)
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"This is a locked item, fixed to the top side of the control.")
.set_ItemBackColor(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),Color.FromArgb(196,196,186))
.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,2)
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,0),0,"This is a locked item, fixed to the top side of the control.")
.set_ItemBackColor(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,0),Color.FromArgb(196,196,186))
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,1),0,"This is a locked item, fixed to the top side of the control.")
.set_ItemBackColor(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,1),Color.FromArgb(186,186,186))
End With
End With
|
338. How can I fix or lock an item on the bottom side of the control
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,1)
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom,0),0,"This is a locked item, fixed to the bottom side of the control.")
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
337. How can I fix or lock an item on the top of the control
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1)
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"This is a locked item, fixed to the top side of the control.")
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
336. Is there any function to limit the height of the items when I display it using multiple lines
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ScrollBySingleLine = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines. This is bit of text that's shown on multipl" & _
"e lines.")
.set_CellSingleLine(h,1,False)
.set_ItemMaxHeight(h,48)
End With
End With
|
335. Why I cannot center my cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.TreeColumnIndex = -1
.DrawGridLines = &Hfffffffc Or exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines
.Columns.Add("Default").Alignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
.Items.AddItem("item 1")
.Items.AddItem("item 2")
.Items.AddItem("item 3")
End With
|
334. How can I align the cell to the left, center or to the right
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.TreeColumnIndex = -1
.DrawGridLines = &Hfffffffc Or exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines
.Columns.Add("Default")
With .Items
.set_CellHAlignment(.AddItem("left"),0,exontrol.EXCOMBOBOXLib.AlignmentEnum.LeftAlignment)
.set_CellHAlignment(.AddItem("center"),0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment)
.set_CellHAlignment(.AddItem("right"),0,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment)
End With
End With
|
333. How do I apply HTML format to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.TreeColumnIndex = -1
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.set_HTMLPicture("p1","c:\exontrol\images\zipdisk.gif")
.set_HTMLPicture("p2","c:\exontrol\images\auction.gif")
.Columns.Add("Default")
With .Items
h = .AddItem("The following item shows some of the HTML format supported:")
.set_CellHAlignment(h,0,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment)
h = .AddItem("<br>text icons <img>1</img>, <img>2</img>, ... pictures <img>p1</img>, <img>p2</img> <br><br>te" & _
"xt <b>bold</b>, <i>italic</i>, <u>underline</u>, <s>strikeout</s>, ...<br><dotline>and so on...<" & _
"br> <a>anchor</a> or <a2>hyperlink</a><br><fgcolor=FF0000>fgcolor</fgcolor> or <bgcolor=00FF00>b" & _
"gcolor</bgcolor> ")
.set_CellCaptionFormat(h,0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
.set_CellSingleLine(h,0,False)
End With
End With
|
332. How can I change the font for a cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
.Items.AddItem("std font")
With .Items
.set_CellCaptionFormat(.AddItem("this <font tahoma;12>is a bit of text with</font> a different font"),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
331. How can I change the font for a cell
| VB.NET |
|---|
Dim f
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
.Items.AddItem("default font")
f = New stdole.StdFont()
With f
.Name = "Tahoma"
.Size = 12
End With
With .Items
.set_CellFont(.AddItem("new font"),0,f)
End With
End With
|
330. How can I change the font for entire item
| VB.NET |
|---|
Dim f
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
.Items.AddItem("default font")
f = New stdole.StdFont()
With f
.Name = "Tahoma"
.Size = 12
End With
With .Items
.set_ItemFont(.AddItem("new font"),f)
End With
End With
|
329. How do I vertically align a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.DrawGridLines = &Hfffffffc Or exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines
.Columns.Add("MultipleLine").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,False)
.Columns.Add("VAlign")
With .Items
h = .AddItem("This is a bit of long text that should break the line")
.set_CellCaption(h,1,"top")
.set_CellVAlignment(h,1,exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop)
h = .AddItem("This is a bit of long text that should break the line")
.set_CellCaption(h,1,"middle")
.set_CellVAlignment(h,1,exontrol.EXCOMBOBOXLib.VAlignmentEnum.exMiddle)
h = .AddItem("This is a bit of long text that should break the line")
.set_CellCaption(h,1,"bottom")
.set_CellVAlignment(h,1,exontrol.EXCOMBOBOXLib.VAlignmentEnum.exBottom)
End With
End With
|
328. How can I change the position of an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.set_ItemPosition(.AddItem("Item 3"),0)
End With
End With
|
327. How do I find an item based on a path
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.set_ItemData(.InsertItem(h,0,"Child 2"),1234)
.set_ExpandItem(h,True)
.set_ItemBold(.get_FindPath("Root 1\Child 1"),True)
End With
End With
|
326. How do I find an item based on my extra data
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.set_ItemData(.InsertItem(h,0,"Child 2"),1234)
.set_ExpandItem(h,True)
End With
End With
|
325. How do I find an item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_ItemBold(.get_FindItem("Child 2",0),True)
End With
End With
|
324. How can I insert a hyperlink or an anchor element
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
With .Items
.set_CellCaptionFormat(.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
With .Items
.set_CellCaptionFormat(.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
323. How do I find the index of the item based on its handle
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_ItemBold(.get_ItemByIndex(.get_ItemToIndex(h)),True)
End With
End With
|
322. How do I find the handle of the item based on its index
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_ItemBold(.get_ItemByIndex(1),True)
End With
End With
|
321. How can I find the cell being clicked in a radio group
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.SelBackColor = Color.FromArgb(255,255,128)
.SelForeColor = Color.FromArgb(0,0,0)
.Columns.Add("C1")
.Columns.Add("C2")
.Columns.Add("C3")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Radio 1")
.set_CellHasRadioButton(h,1,True)
.set_CellRadioGroup(h,1,1234)
.set_CellCaption(h,2,"Radio 2")
.set_CellHasRadioButton(h,2,True)
.set_CellRadioGroup(h,2,1234)
.set_CellState(h,1,1)
.set_CellBold(0,.get_CellChecked(1234),True)
End With
End With
|
320. Can I add a +/- ( expand / collapse ) buttons to each item, so I can load the child items later
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Default")
With .Items
.set_ItemHasChildren(.AddItem("parent item with no child items"),True)
.AddItem("next item")
End With
End With
|
319. Can I let the user to resize at runtime the specified item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ScrollBySingleLine = True
.DrawGridLines = &Hfffffffc Or exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines
.Columns.Add("Default")
With .Items
.set_ItemAllowSizing(.AddItem("resizable item"),True)
.AddItem("not resizable item")
End With
End With
|
318. How can I change the size ( width, height ) of the picture
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.set_CellPicture(h,0,Excombobox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)"))
.set_CellPictureWidth(h,0,24)
.set_CellPictureHeight(h,0,24)
.set_ItemHeight(h,32)
h = .AddItem("Root 2")
.set_CellPicture(h,0,Excombobox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)"))
.set_ItemHeight(h,48)
End With
End With
|
317. How can I find the number or the count of selected items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_SelectItem(.get_ItemChild(h),True)
.set_SelectItem(.get_NextSiblingItem(.get_ItemChild(h)),True)
.AddItem(.SelectCount)
End With
End With
|
316. How do I unselect an item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_SelectItem(h,False)
End With
End With
|
315. How do I find the selected item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_SelectItem(h,True)
.set_ItemBold(.get_SelectedItem(0),True)
End With
End With
|
314. How do I un select all items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
313. How do I select multiple items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_SelectItem(.get_ItemChild(h),True)
.set_SelectItem(.get_NextSiblingItem(.get_ItemChild(h)),True)
End With
End With
|
312. How do I select all items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
311. How do I select an item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_SelectItem(h,True)
End With
End With
|
310. Can I display a button with some picture or icon inside
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_HTMLPicture("p1","c:\exontrol\images\zipdisk.gif")
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1," Button <img>p1</img> ")
.set_CellCaptionFormat(h,1,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
.set_CellHAlignment(h,1,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment)
.set_CellHasButton(h,1,True)
.set_ItemHeight(h,48)
End With
End With
|
309. Can I display a button with some picture or icon inside
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1," Button <img>1</img> ")
.set_CellCaptionFormat(h,1,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
.set_CellHAlignment(h,1,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment)
.set_CellHasButton(h,1,True)
End With
End With
|
308. Can I display a button with some icon inside
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1," <img>1</img> ")
.set_CellCaptionFormat(h,1,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
.set_CellHAlignment(h,1,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment)
.set_CellHasButton(h,1,True)
End With
End With
|
307. How can I assign multiple icon/picture to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_HTMLPicture("p1","c:\exontrol\images\zipdisk.gif")
.set_HTMLPicture("p2","c:\exontrol\images\auction.gif")
.Columns.Add("Default")
With .Items
h = .AddItem("text <img>p1</img> another picture <img>p2</img> and so on")
.set_CellCaptionFormat(h,0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
.set_CellPicture(h,0,Excombobox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\colorize.gif`)"))
.set_ItemHeight(h,48)
.AddItem("Root 2")
End With
End With
|
306. How can I assign an icon/picture to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.set_CellPicture(h,0,Excombobox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)"))
.set_ItemHeight(h,48)
.AddItem("Root 2")
End With
End With
|
305. How can I assign multiple icons/pictures to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Default")
With .Items
h = .AddItem("Root <img>1</img> 1, <img>2</img>, ... and so on ")
.set_CellCaptionFormat(h,0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
304. How can I assign multiple icons/pictures to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.set_CellImages(h,0,"1,2,3")
End With
End With
|
303. How can I assign an icon/picture to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.set_CellImage(h,0,1)
.set_CellImage(.InsertItem(h,0,"Child 1"),0,2)
.set_CellImage(.InsertItem(h,0,"Child 2"),0,3)
.set_ExpandItem(h,True)
End With
End With
|
302. How can I get the handle of an item based on the handle of the cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_ItemBold(.get_CellItem(.get_ItemCell(h,0)),True)
End With
End With
|
301. How can I display a button inside the item or cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1," Button 1 ")
.set_CellHAlignment(h,1,exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment)
.set_CellHasButton(h,1,True)
h = .AddItem("Cell 2")
.set_CellCaption(h,1," Button 2 ")
.set_CellHAlignment(h,1,exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment)
.set_CellHasButton(h,1,True)
End With
End With
|
300. How can I change the state of a radio button
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.SelBackColor = Color.FromArgb(255,255,128)
.SelForeColor = Color.FromArgb(0,0,0)
.Columns.Add("C1")
.Columns.Add("C2")
.Columns.Add("C3")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Radio 1")
.set_CellHasRadioButton(h,1,True)
.set_CellRadioGroup(h,1,1234)
.set_CellCaption(h,2,"Radio 2")
.set_CellHasRadioButton(h,2,True)
.set_CellRadioGroup(h,2,1234)
.set_CellState(h,1,1)
End With
End With
|
299. How can I assign a radio button to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.MarkSearchColumn = False
.SelBackColor = Color.FromArgb(255,255,128)
.SelForeColor = Color.FromArgb(0,0,0)
.Columns.Add("C1")
.Columns.Add("C2")
.Columns.Add("C3")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Radio 1")
.set_CellHasRadioButton(h,1,True)
.set_CellRadioGroup(h,1,1234)
.set_CellCaption(h,2,"Radio 2")
.set_CellHasRadioButton(h,2,True)
.set_CellRadioGroup(h,2,1234)
.set_CellState(h,1,1)
End With
End With
|
298. How can I change the state of a checkbox
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Check Box")
.set_CellHasCheckBox(h,1,True)
.set_CellState(h,1,1)
End With
End With
|
297. How can I assign a checkbox to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Check Box")
.set_CellHasCheckBox(h,1,True)
End With
End With
|
296. How can I display an item or a cell on multiple lines
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ScrollBySingleLine = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"This is bit of text that's shown on multiple lines")
.set_CellSingleLine(h,1,False)
End With
End With
|
295. How can I assign a tooltip to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"tooltip")
.set_CellToolTip(h,1,"This is bit of text that's shown when the user hovers the cell")
End With
End With
|
294. How can I associate an extra data to a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Cell 2")
.set_CellData(h,1,"your extra data")
End With
End With
|
293. How do I enable or disable a cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Cell 2")
.set_CellEnabled(h,1,False)
End With
End With
|
292. How do I change the cell's foreground color
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Cell 2")
.set_CellForeColor(h,1,Color.FromArgb(255,0,0))
End With
End With
|
291. How do I change the visual effect for the cell, using your EBN files
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Cell 2")
.set_CellBackColor32(h,1,16777216)
End With
End With
|
290. How do I change the cell's background color
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Cell 2")
.set_CellBackColor(h,1,Color.FromArgb(255,0,0))
End With
End With
|
289. How do I change the caption or value for a particular cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
.set_CellCaption(.AddItem("Cell 1"),1,"Cell 2")
End With
End With
|
288. How do I get the handle of the cell
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_CellBold(0,.get_ItemCell(h,0),True)
End With
End With
|
287. How do I retrieve the focused item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_ItemBold(.FocusItem,True)
End With
End With
|
286. How do I get the number or count of child items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.AddItem(.get_ChildCount(h))
End With
End With
|
285. How do I enumerate the visible items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2")
.set_ItemBold(.FirstVisibleItem,True)
.set_ItemBold(.get_NextVisibleItem(.FirstVisibleItem),True)
End With
End With
|
284. How do I enumerate the siblings items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2")
.set_ItemBold(.get_NextSiblingItem(.FirstVisibleItem),True)
.set_ItemBold(.get_PrevSiblingItem(.get_NextSiblingItem(.FirstVisibleItem)),True)
End With
End With
|
283. How do I get the parent item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_ItemBold(.get_ItemParent(.get_ItemChild(h)),True)
End With
End With
|
282. How do I get the first child item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.set_ItemBold(.get_ItemChild(h),True)
End With
End With
|
281. How do I enumerate the root items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ItemBold(.get_RootItem(0),True)
.set_ItemUnderline(.get_RootItem(1),True)
End With
End With
|
280. I have a hierarchy, how can I count the number of root items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.AddItem(.RootCount)
End With
End With
|
279. How can I make an item unselectable, or not selectable
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
With .Items
h = .AddItem("unselectable - you can't get selected")
.set_SelectableItem(h,False)
.AddItem("selectable")
End With
End With
|
278. How can I hide or show an item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
With .Items
h = .AddItem("hidden")
.set_ItemHeight(h,0)
.set_SelectableItem(h,False)
.AddItem("visible")
End With
End With
|
277. How can I change the height for all items
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.DefaultItemHeight = 32
.Columns.Add("Column")
.Items.AddItem("One")
.Items.AddItem("Two")
End With
|
276. How do I change the height of an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ScrollBySingleLine = True
.Columns.Add("Default")
With .Items
.set_ItemHeight(.AddItem("height"),128)
End With
.Items.AddItem("enabled")
End With
|
275. How do I disable or enable an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_EnableItem(.AddItem("disabled"),False)
End With
.Items.AddItem("enabled")
End With
|
274. How do I display as strikeout a cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellStrikeOut(.AddItem("strikeout"),0,True)
End With
End With
|
273. How do I display as strikeout a cell or an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellCaptionFormat(.AddItem("gets <s>strikeout</s> only a portion of text"),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
272. How do I display as strikeout an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_ItemStrikeOut(.AddItem("strikeout"),True)
End With
End With
|
271. How do I underline a cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellUnderline(.AddItem("underline"),0,True)
End With
End With
|
270. How do I underline a cell or an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellCaptionFormat(.AddItem("gets <u>underline</u> only a portion of text"),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
269. How do I underline an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_ItemUnderline(.AddItem("underline"),True)
End With
End With
|
268. How do I display as italic a cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellItalic(.AddItem("italic"),0,True)
End With
End With
|
267. How do I display as italic a cell or an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellCaptionFormat(.AddItem("gets <i>italic</i> only a portion of text"),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
266. How do I display as italic an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_ItemItalic(.AddItem("italic"),True)
End With
End With
|
265. How do I bold a cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellBold(.AddItem("bold"),0,True)
End With
End With
|
264. How do I bold a cell or an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_CellCaptionFormat(.AddItem("gets <b>bold</b> only a portion of text"),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
263. How do I bold an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_ItemBold(.AddItem("bold"),True)
End With
End With
|
262. How do I change the foreground color for the item
| VB.NET |
|---|
Dim h,hC
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
hC = .InsertItem(h,0,"Child 1")
.set_ItemForeColor(hC,Color.FromArgb(255,0,0))
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
261. How do I change the visual appearance for the item, using your EBN technology
| VB.NET |
|---|
Dim h,hC
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
hC = .InsertItem(h,0,"Child 1")
.set_ItemBackColor32(hC,16777216)
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
260. How do I change the background color for the item
| VB.NET |
|---|
Dim h,hC
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
hC = .InsertItem(h,0,"Child 1")
.set_ItemBackColor(hC,Color.FromArgb(255,0,0))
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
259. How do I expand or collapse an item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
258. How do I associate an extra data to an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
.set_ItemData(.AddItem("item"),"your extra data")
End With
End With
|
257. How do I get the number or count of items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
.Items.AddItem(0.ItemCount)
End With
|
256. How do I programmatically edit a cell
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True End With |
255. How can I change at runtime the parent of the item
| VB.NET |
|---|
Dim hC,hP
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Default")
With .Items
hP = .AddItem("Root")
hC = .AddItem("Child")
.SetParent(hC,hP)
End With
End With
|
254. How can I sort the items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
.Columns.Item("Default").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending
End With
|
253. How do I sort the child items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
.SortChildren(h,0,False)
End With
End With
|
252. How can I ensure or scroll the control so the item fits the control's client area
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
h = .Items.AddItem("item")
End With
|
251. How can I remove or delete all items
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
.Items.AddItem("removed item")
.Items.RemoveAllItems()
End With
|
250. How can I remove or delete an item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
h = .Items.AddItem("removed item")
.Items.RemoveItem(h)
End With
|
249. How can I add or insert child items
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
h = .AddItem("Cell 1")
.set_CellCaption(h,1,"Cell 2")
.set_CellCaption(.InsertItem(h,0,"Cell 3"),1,"Cell 4")
.set_CellCaption(.InsertItem(h,0,"Cell 5"),1,"Cell 6")
.set_ExpandItem(h,True)
End With
End With
|
248. How can I add or insert a child item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Default")
With .Items
.InsertItem(.AddItem("root"),0,"child")
End With
End With
|
247. How can I add or insert an item
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("C2")
With .Items
.set_CellCaption(.AddItem("Cell 1"),1,"Cell 2")
h = .AddItem("Cell 3")
.set_CellCaption(h,1,"Cell 4")
End With
End With
|
246. How can I add or insert an item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Default")
.Items.AddItem("new item")
End With
|
245. How can I get the columns as they are shown in the control's sortbar
| VB.NET |
|---|
Dim var_Object With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True var_Object = .Columns.get_ItemBySortPosition(0) End With |
244. How can I access the properties of a column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("A")
.Columns.Item("A").HeaderBold = True
End With
|
243. How can I remove all the columns
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .Columns.Clear() End With |
242. How can I remove a column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Remove("A")
End With
|
241. How can I get the number or the count of columns
| VB.NET |
|---|
Dim var_Count With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True var_Count = .Columns.Count End With |
240. How can I change the font for all cells in the entire column
| VB.NET |
|---|
Dim f
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
f = New stdole.StdFont()
With f
.Name = "Tahoma"
.Size = 12
End With
With .ConditionalFormats.Add("1")
.Font = f
.ApplyTo = exontrol.EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
239. How can I change the background color for all cells in the column
| VB.NET |
|---|
Dim var_ConditionalFormat
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.BackColor = Color.FromArgb(255,0,0)
.ApplyTo = exontrol.EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
238. How can I change the foreground color for all cells in the column
| VB.NET |
|---|
Dim var_ConditionalFormat
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.ForeColor = Color.FromArgb(255,0,0)
.ApplyTo = exontrol.EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
237. How can I show as strikeout all cells in the column
| VB.NET |
|---|
Dim var_ConditionalFormat
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.StrikeOut = True
.ApplyTo = exontrol.EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
236. How can I underline all cells in the column
| VB.NET |
|---|
Dim var_ConditionalFormat
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.Underline = True
.ApplyTo = exontrol.EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
235. How can I show in italic all data in the column
| VB.NET |
|---|
Dim var_ConditionalFormat
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.Italic = True
.ApplyTo = exontrol.EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
234. How can I bold the entire column
| VB.NET |
|---|
Dim var_ConditionalFormat
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_ConditionalFormat = .ConditionalFormats.Add("1")
With var_ConditionalFormat
.Bold = True
.ApplyTo = exontrol.EXCOMBOBOXLib.FormatApplyToEnum.exFormatToColumns
End With
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
233. How can I display a computed column and highlight some values that are negative or less than a value
| VB.NET |
|---|
Dim var_ConditionalFormat
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("A")
.Columns.Add("B")
.Columns.Add("(A+B)*1.19").ComputedField = "(%0 + %1) * 1.19"
With .Items
.set_CellCaption(.AddItem(1),1,2)
End With
With .Items
.set_CellCaption(.AddItem(10),1,20)
End With
var_ConditionalFormat = .ConditionalFormats.Add("%2 > 10")
With var_ConditionalFormat
.Bold = True
.ForeColor = Color.FromArgb(255,0,0)
.ApplyTo = &H2
End With
End With
|
232. Can I display a computed column so it displays the VAT, or SUM
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("A")
.Columns.Add("B")
.Columns.Add("(A+B)*1.19").ComputedField = "(%0 + %1) * 1.19"
With .Items
.set_CellCaption(.AddItem(1),1,2)
End With
With .Items
.set_CellCaption(.AddItem(10),1,20)
End With
End With
|
231. How can I show a column that adds values in the cells
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("A")
.Columns.Add("B")
.Columns.Add("A+B").ComputedField = "%0 + %1"
With .Items
.set_CellCaption(.AddItem(1),1,2)
End With
With .Items
.set_CellCaption(.AddItem(10),1,20)
End With
End With
|
230. Is there any function to filter the control's data as I type, so the items being displayed include the typed characters
| VB.NET |
|---|
Dim var_Column
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_Column = .Columns.Add("Filter")
With var_Column
.FilterOnType = True
.DisplayFilterButton = True
.AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains
End With
.Items.AddItem("Canada")
.Items.AddItem("USA")
End With
|
229. Is there any function to filter the control's data as I type, something like filter on type
| VB.NET |
|---|
Dim var_Column
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
var_Column = .Columns.Add("Filter")
With var_Column
.FilterOnType = True
.DisplayFilterButton = True
End With
.Items.AddItem("Canada")
.Items.AddItem("USA")
End With
|
228. How can I programmatically filter a column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Filter")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exNonBlanks
End With
.Items.AddItem()
.Items.AddItem("not empty")
.ApplyFilter()
End With
|
227. How can I show or display the control's filter
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Filter").DisplayFilterButton = True
End With
|
226. How can I customize the items being displayed in the drop down filter window
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Custom Filter")
.DisplayFilterButton = True
.DisplayFilterPattern = False
.CustomFilter = "Excel Spreadsheets (*.xls )||*.xls|||Word Documents||*.doc|||Powerpoint Presentations||*.pps|||" & _
"Text Documents (*.log,*.txt)||*.txt|*.log"
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern
.Filter = "*.xls"
End With
.Items.AddItem("excel.xls")
.Items.AddItem("word.doc")
.Items.AddItem("pp.pps")
.Items.AddItem("text.txt")
.ApplyFilter()
End With
|
225. How can I change the order or the position of the columns in the sort bar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.SortBarVisible = True
.SortBarColumnWidth = 48
.Columns.Add("C1").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Add("C2").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending
.Columns.Item("C2").SortPosition = 0
End With
|
224. How do I arrange my columns on multiple levels
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("S").Width = 32
.Columns.Add("Level 2").LevelKey = 1
.Columns.Add("Level 3").LevelKey = 1
.Columns.Add("Level 4").LevelKey = 1
.Columns.Add("Level 1").LevelKey = "2"
.Columns.Add("Level 2").LevelKey = "2"
.Columns.Add("Level 3").LevelKey = "2"
.Columns.Add("Level 4").LevelKey = "2"
.Columns.Add("E").Width = 32
End With
|
223. How do I arrange my columns on multiple lines
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.HeaderHeight = 32
.Columns.Add("").HTMLCaption = "Line 1<br>Line 2"
End With
|
222. How can I display all cells using HTML format
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("HTML").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellCaptionFormat,1)
.Items.AddItem("<font ;12>T</font>his <b>is</b> an <a>html</a> <font Tahoma><fgcolor=FF0000>text</fgcolor></fon" & _
"t>.")
End With
|
221. How can I display all cells using multiple lines
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("MultipleLine").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,False)
.Columns.Add("SingleLine").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,True)
With .Items
.set_CellCaption(.AddItem("This is a bit of long text that should break the line"),1,"this is a bit of long text that's displayed on a single line")
End With
End With
|
220. How do change the vertical alignment for all cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("MultipleLine").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellSingleLine,False)
.Columns.Add("VAlign").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellVAlignment,2)
With .Items
.set_CellCaption(.AddItem("This is a bit of long text that should break the line"),1,"bottom")
End With
With .Items
.set_CellCaption(.AddItem("This is a bit of long text that should break the line"),1,"bottom")
End With
End With
|
219. How do change the foreground color for all cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("ForeColor").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellForeColor,255)
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
218. How do change the background color for all cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("BackColor").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellBackColor,255)
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
217. How do I show buttons for all cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Button")
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True)
.set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellButtonAutoWidth,True)
End With
.Items.AddItem(" Button 1 ")
.Items.AddItem(" Button 2 ")
End With
|
216. How do I show buttons for all cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Button").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True)
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
215. How do I display radio buttons for all cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Radio").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasRadioButton,True)
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
214. How do I display checkboxes for all cells in the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Check").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True)
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
213. How can I display a tooltip when the cursor hovers the column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("tooltip").ToolTip = "This is a bit of text that is shown when user hovers the column."
End With
|
212. Is there any function to assign a key to a column instead using its name or capion
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Data").Key = "DKey"
.Columns.Item("DKey").Caption = "new caption"
End With
|
211. Is there any function to assign any extra data to a column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Data").Data = "your extra data"
End With
|
210. 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
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Sort").DefaultSortOrder = True
End With
|
209. How can I specify the maximum width for the column, if I use WidthAutoResize property
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Auto")
.WidthAutoResize = True
.MinWidthAutoResize = 32
.MaxWidthAutoResize = 128
End With
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
208. How can I specify the minimum width for the column, if I use WidthAutoResize property
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Auto")
.WidthAutoResize = True
.MinWidthAutoResize = 32
End With
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
207. Is there any option to resize the column based on its data, captions
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("A").WidthAutoResize = True
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
206. How can I align the icon in the column's header in the center
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
With .Columns.Add("")
.HeaderImage = 1
.HeaderImageAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.CenterAlignment
End With
End With
|
205. How do I align the icon in the column's header to the right
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
With .Columns.Add("ColumnName")
.HeaderImage = 1
.HeaderImageAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
End With
End With
|
204. How do I show or hide the sorting icons, but still need sorting
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Sorted").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Item(0).DisplaySortIcon = False
End With
|
203. How do I enable or disable the entire column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1")
.Columns.Add("Disabled").Enabled = False
With .Items
.set_CellCaption(.AddItem(0),1,"0.1")
End With
With .Items
.set_CellCaption(.AddItem(1),1,"1.1")
End With
End With
|
202. How do I disable drag and drop columns
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("C1").AllowDragging = False
.Columns.Add("C2").AllowDragging = False
End With
|
201. How do I disable resizing a column at runtime
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Unsizable").AllowSizing = False
.Columns.Add("C2")
.Columns.Add("C3")
.Columns.Add("C4")
End With
|
200. How can I align the column to the right, and its caption too
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Column")
.Alignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.HeaderAlignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
End With
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
199. How can I align the column to the right
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column").Alignment = exontrol.EXCOMBOBOXLib.AlignmentEnum.RightAlignment
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
198. How do I change the column's caption
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column").Caption = "new caption"
End With
|
197. Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions, after the user clicks it
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_FormatAnchor(False,"<b><u><fgcolor=880000> </fgcolor></u></b>")
.Columns.Add("Column")
With .Items
.set_CellCaptionFormat(.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
With .Items
.set_CellCaptionFormat(.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
.Items.AddItem("next item")
End With
|
196. Can I change the visual effect, appearance for the anchor, hyperlink elements, in HTML captions
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_FormatAnchor(True,"<b><u><fgcolor=FF0000> </fgcolor></u></b>")
.Columns.Add("Column")
With .Items
.set_CellCaptionFormat(.AddItem("Just an <a1>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
With .Items
.set_CellCaptionFormat(.AddItem("Just another <a2>anchor</a> element ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
195. Can I change the font for the tooltip
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
.ToolTipWidth = 364
.Columns.Add("tootip").ToolTip = "<br><font Tahoma;14>this</font> is a tooltip assigned to a column<br>"
End With
|
194. Can I change the font for the tooltip
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
With .ToolTipFont
.Name = "Tahoma"
.Size = 14
End With
.ToolTipWidth = 364
.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
End With
|
193. Can I change the order of the buttons in the scroll bar
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .set_ScrollOrderParts(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,"t,l,r") .set_ScrollOrderParts(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exVScroll,"t,l,r") End With |
192. The thumb size seems to be very small. Can I make it bigger
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnAutoResize = False
.Columns.Add("C1").Width = 256
.Columns.Add("C2").Width = 256
.Columns.Add("C3").Width = 256
.set_ScrollThumbSize(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,64)
End With
|
191. How can I display my text on the scroll bar, using a different font
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"This is <s><font Tahoma;12> just </font></s> text")
.ColumnAutoResize = False
.ScrollHeight = 20
.Columns.Add("C1").Width = 256
.Columns.Add("C2").Width = 256
.Columns.Add("C3").Width = 256
End With
|
190. How can I display my text on the scroll bar, using a different font
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"This is just a text")
.get_ScrollFont(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll).Size = 12
.ColumnAutoResize = False
.ScrollHeight = 20
.Columns.Add("C1").Width = 256
.Columns.Add("C2").Width = 256
.Columns.Add("C3").Width = 256
End With
|
189. How can I display my text on the scroll bar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exThumbPart,"this is just a text")
.ColumnAutoResize = False
.Columns.Add("C1").Width = 256
.Columns.Add("C2").Width = 256
.Columns.Add("C3").Width = 256
End With
|
188. How do I enlarge or change the size of the control's scrollbars
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .ScrollHeight = 18 .ScrollWidth = 18 .ScrollButtonWidth = 18 .ScrollButtonHeight = 18 End With |
187. How do I assign a tooltip to a scrollbar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.set_ScrollToolTip(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,"This is a tooltip being shown when you click and drag the thumb in the horizontal scroll bar")
.ColumnAutoResize = False
.Columns.Add("C1").Width = 256
.Columns.Add("C2").Width = 256
.Columns.Add("C3").Width = 256
End With
|
186. How do I assign an icon to the button in the scrollbar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Images("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0" & _
"/oFBoVDolFo1HpFJpVLplNp1PqFRqVTqlVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1" & _
"/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qO" & _
"x3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" & _
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA=")
.set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,True)
.set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,"<img>1</img>")
.ScrollHeight = 18
.ScrollButtonWidth = 18
End With
|
185. I need to add a button in the scroll bar. Is this possible
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,True) .set_ScrollPartCaption(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,"1") End With |
184. Can I display an additional buttons in the scroll bar
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB1Part,True) .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exLeftB2Part,True) .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exRightB6Part,True) .set_ScrollPartVisible(exontrol.EXCOMBOBOXLib.ScrollBarEnum.exHScroll,exontrol.EXCOMBOBOXLib.ScrollPartEnum.exRightB5Part,True) End With |
183. How can I display a custom size picture to a cell or item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.DefaultItemHeight = 48
.Columns.Add("C1")
With .Items
.set_CellPicture(.AddItem("Text"),0,Excombobox1.ExecuteTemplate("loadpicture(`c:\exontrol\images\zipdisk.gif`)"))
End With
End With
|
182. How can I display a multiple pictures to a cell or item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.DefaultItemHeight = 48
.set_HTMLPicture("pic1","c:\exontrol\images\zipdisk.gif")
.set_HTMLPicture("pic2","c:\exontrol\images\auction.gif")
.Columns.Add("C1")
With .Items
.set_CellCaptionFormat(.AddItem("<img>pic1</img> Text <img>pic2</img> another text ..."),0,exontrol.EXCOMBOBOXLib.CaptionFormatEnum.exHTML)
End With
End With
|
181. How do I change the column's foreground color for numbers between an interval - Range
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .ConditionalFormats.Add("%0 >= 2 and %0 <= 10")
.Bold = True
.ForeColor = Color.FromArgb(255,0,0)
.ApplyTo = &H1
End With
.Columns.Add("N1")
.Columns.Add("N2")
With .Items
.set_CellCaption(.AddItem(1),1,2)
End With
With .Items
.set_CellCaption(.AddItem(3),1,3)
End With
With .Items
.set_CellCaption(.AddItem(10),1,11)
End With
With .Items
.set_CellCaption(.AddItem(13),1,31)
End With
.SearchColumnIndex = 1
End With
|
180. How do I change the item's foreground color for numbers between an interval - Range
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 >= 2 and %0 <= 10").ForeColor = Color.FromArgb(255,0,0)
.Columns.Add("Numbers")
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(10)
.Items.AddItem(20)
End With
|
179. How do I change the item's background color for numbers less than a value
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 < 10").BackColor = Color.FromArgb(255,0,0)
.Columns.Add("Numbers")
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(10)
.Items.AddItem(20)
End With
|
178. How do I underline the numbers greater than a value
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 >= 10").Underline = True
.Columns.Add("Numbers")
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(10)
.Items.AddItem(20)
End With
|
177. How do I highlight in italic the numbers greater than a value
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 >= 10").StrikeOut = True
.Columns.Add("Numbers")
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(10)
.Items.AddItem(20)
End With
|
176. How do I highlight in italic the numbers greater than a value
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 >= 10").Italic = True
.Columns.Add("Numbers")
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(10)
.Items.AddItem(20)
End With
|
175. How do I highlight in bold the numbers greater than a value
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ConditionalFormats.Add("%0 >= 10").Bold = True
.Columns.Add("Numbers")
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(10)
.Items.AddItem(20)
End With
|
174. Can I use your EBN files to change the visual appearance for +/- expand - collapse buttons
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.HasButtons = exontrol.EXCOMBOBOXLib.ExpandButtonEnum.exCustom
.set_HasButtonsCustom(False,16777216)
.set_HasButtonsCustom(True,33554432)
.Columns.Add("Column")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2")
.InsertItem(h,0,"Child")
End With
End With
|
173. Can I use your EBN files to change the visual appearance for radio buttons
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.set_RadioImage(False,16777216)
.set_RadioImage(True,33554432)
.Columns.Add("Radio").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasRadioButton,True)
With .Items
.AddItem("Radio 1")
.set_CellState(.AddItem("Radio 2"),0,1)
.AddItem("Radio 3")
End With
End With
|
172. Can I use your EBN files to change the visual appearance for checkbox cells
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.set_CheckImage(exontrol.EXCOMBOBOXLib.CheckStateEnum.Unchecked,16777216)
.set_CheckImage(exontrol.EXCOMBOBOXLib.CheckStateEnum.Checked,33554432)
.Columns.Add("Check").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasCheckBox,True)
With .Items
.AddItem("Check 1")
.set_CellState(.AddItem("Check 2"),0,1)
End With
End With
|
171. How do I change the visual aspect for thumb parts in the scroll bars, using EBN
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumb,16777216)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbP,33554432)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbH,50331648)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSThumb,16777216)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSThumbP,33554432)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSThumbH,50331648)
.ColumnAutoResize = False
.ScrollBySingleLine = True
.Columns.Add("S").Width = 483
With .Items
.set_ItemHeight(.AddItem("Item 1"),248)
End With
.Items.AddItem("Item 2")
End With
|
170. How do I change the visual aspect only for the thumb in the scroll bar, using EBN
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumb,16777216)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbP,33554432)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSThumbH,50331648)
.ColumnAutoResize = False
.Columns.Add("S").Width = 483
End With
|
169. I've seen that you can change the visual appearance for the scroll bar. How can I do that
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.VisualAppearance.Add(3,"c:\exontrol\images\hot.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSBtn,16777216)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSBtnP,33554432)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSBtnH,50331648)
.set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHSBack,Color.FromArgb(240,240,240))
.set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSBack,Color.FromArgb(240,240,240))
.set_Background(&H90 Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exFooterFilterBarButton Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exCellButtonUp Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDropDownButtonUp Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateHeader Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exCursorHoverColumn Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exToolTipAppearance Or exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exVSUp,Color.FromArgb(240,240,240))
.Columns.Add("S").Width = 32
.Columns.Add("Level 1").LevelKey = 1
.Columns.Add("Level 2").LevelKey = 1
.Columns.Add("Level 3").LevelKey = 1
.Columns.Add("E1").Width = 32
.Columns.Add("E2").Width = 32
.Columns.Add("E3").Width = 32
.Columns.Add("E4").Width = 32
.ColumnAutoResize = False
End With
|
168. Is there any option to highligth the column from the cursor - point
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exCursorHoverColumn,16777216)
.Columns.Add("S").Width = 32
.Columns.Add("Level 1").LevelKey = 1
.Columns.Add("Level 2").LevelKey = 1
.Columns.Add("Level 3").LevelKey = 1
.Columns.Add("E1").Width = 32
.Columns.Add("E2").Width = 32
.Columns.Add("E3").Width = 32
.Columns.Add("E4").Width = 32
End With
|
167. How do I change the visual aspect of selected item in the drop down filter window, using your EBN technology
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSelBackColorFilter,16777216)
.set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSelForeColorFilter,Color.FromArgb(255,20,20))
.Columns.Add("Filter").DisplayFilterButton = True
End With
|
166. 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
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateHeader,16777216)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateTodayUp,16777216)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateTodayDown,33554432)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateScrollThumb,16777216)
.set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateScrollRange,Color.FromArgb(230,230,230))
.set_Background(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateSeparatorBar,Color.FromArgb(230,230,230))
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exDateSelect,16777216)
With .Columns.Add("Date")
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exDate
.DisplayFilterButton = True
.DisplayFilterDate = True
End With
End With
|
165. How do I change the visual aspect of the close button in the filter bar, using EBN
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exFooterFilterBarButton,16777216)
.Columns.Add("Filter").FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
.ApplyFilter()
End With
|
164. How do I change the visual aspect of buttons in the cell, using EBN
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exCellButtonUp,16777216)
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exSizeGrip,33554432)
.SelForeColor = Color.FromArgb(0,0,0)
.ShowFocusRect = False
.Columns.Add("Column 1").set_Def(exontrol.EXCOMBOBOXLib.DefColumnEnum.exCellHasButton,True)
.Items.AddItem("Button 1")
.Items.AddItem("Button 2")
.Columns.Add("Column 2")
End With
|
163. How do I change the visual aspect of the drop down filter button, using EBN
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.set_Background32(exontrol.EXCOMBOBOXLib.BackgroundPartEnum.exHeaderFilterBarButton,16777216)
.Columns.Add("Filter").DisplayFilterButton = True
End With
|
162. Is there any function to get the control's data in your x-script format / template
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem(0)
End With
|
161. How do I enable resizing the columns at runtime
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnsAllowSizing = True
.MarkSearchColumn = False
.HeaderVisible = False
.Columns.Add("Column 1")
.Columns.Add("Column 2")
.DrawGridLines = exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines
With .Items
.set_CellCaption(.AddItem("Item 1"),1,"Sub Item 1")
End With
With .Items
.set_CellCaption(.AddItem("Item 2"),1,"Sub Item 2")
End With
End With
|
160. How do I enable resizing ( changing the height ) the items at runtime
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ItemsAllowSizing = exontrol.EXCOMBOBOXLib.ItemsAllowSizingEnum.exResizeItem
.ScrollBySingleLine = True
.Columns.Add("Column")
.Items.AddItem("Item 1")
With .Items
.set_ItemHeight(.AddItem("Item 2"),48)
End With
.Items.AddItem("Item 3")
End With
|
159. How can I sort by multiple columns
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.SingleSort = False
.Columns.Add("C1").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Add("C2").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending
.Columns.Add("C3").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending
End With
|
158. How can I add several columns to control's sort bar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.SortBarVisible = True
.SortBarColumnWidth = 48
.Columns.Add("C1").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Add("C2").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending
End With
|
157. How can I change the width of the columns being displayed in the sort bar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.SortBarVisible = True
.SortBarColumnWidth = 48
.Columns.Add("C1").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortAscending
.Columns.Add("C2").SortOrder = exontrol.EXCOMBOBOXLib.SortOrderEnum.SortDescending
End With
|
156. How can I change the height of the sort bar's
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .SortBarVisible = True .SortBarHeight = 48 End With |
155. How can I change the sort bar's foreground color
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .SortBarVisible = True .ForeColorSortBar = Color.FromArgb(255,0,0) End With |
154. How can I change the visual appearance of the control's sort bar, using EBN files
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn") .VisualAppearance.Add(2,"c:\exontrol\images\pushed.ebn") .SortBarVisible = True .BackColorSortBar32 = &H1000000 .BackColorSortBarCaption32 = &H2000000 .Appearance = exontrol.EXCOMBOBOXLib.AppearanceEnum.None2 End With |
153. How can I change the sort bar's background color
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .SortBarVisible = True .BackColorSortBar = Color.FromArgb(255,0,0) .BackColorSortBarCaption = Color.FromArgb(128,0,0) End With |
152. How can I change the default caption being displayed in the control's sort bar
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .SortBarVisible = True .SortBarCaption = "new caption" End With |
151. How can I show the locked / fixed items on the bottom side of the control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ShowLockedItems = True
.Columns.Add("Column")
With .Items
.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exMiddle,2)
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exMiddle,0),0,"locked item 1")
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exMiddle,1),0,"locked item 2")
.AddItem("un-locked item")
End With
End With
|
150. How can I show the locked / fixed items
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ShowLockedItems = True
.Columns.Add("Column")
With .Items
.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,2)
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"locked item 1")
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1),0,"locked item 2")
.AddItem("un-locked item")
End With
End With
|
149. How can I hide the locked / fixed items
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ShowLockedItems = False
.Columns.Add("Column")
With .Items
.set_LockedItemCount(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,1)
.set_CellCaption(.get_LockedItem(exontrol.EXCOMBOBOXLib.VAlignmentEnum.exTop,0),0,"locked item")
.AddItem("un-locked item")
End With
End With
|
148. How can I show the control's sort bar
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .SortBarVisible = True End With |
147. How can I change the header's background color, when multiple levels are displayed
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BackColorLevelHeader = Color.FromArgb(250,0,0)
.Columns.Add("S").Width = 32
.Columns.Add("Level 1").LevelKey = 1
.Columns.Add("Level 2").LevelKey = 1
.Columns.Add("Level 3").LevelKey = 1
End With
|
146. Can I programmatically scroll the control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(3)
End With
|
145. How do I disable expanding or collapsing an item when user presses the arrow keys
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Columns.Add("Column 1")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
144. How do I expand automatically the items while user types characters to searching for something ( incremental searching )
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ExpandOnSearch = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.AutoSearch = True
.Columns.Add("Column").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains
With .Items
.InsertItem(.InsertItem(.AddItem("text"),0,"some text"),0,"another text")
.InsertItem(.InsertItem(.AddItem("text"),0,"some text"),0,"another text")
End With
End With
|
143. Can I programmatically scroll the control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(3)
End With
|
142. Do you have some function to load data from a safe array
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem(0)
End With
|
141. Do you have some function to retrieve all items to a safe array
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
.Items.AddItem(3)
End With
|
140. How can still display the selected items when the control loses the focus
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
With .Items
.AddItem("Item 3")
.AddItem("Item 1")
.set_SelectItem(.AddItem("Item 2"),True)
End With
End With
|
139. How can I hide a column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Hidden").Visible = False
.Columns.Add("2")
.Columns.Add("3")
.Columns.Add("4")
.Columns.Add("5")
End With
|
138. How can I ensure that a column is visible and fits the control's client area
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnAutoResize = False
.Columns.Add("1").Width = 128
.Columns.Add("2").Width = 128
.Columns.Add("3").Width = 128
.Columns.Add("4").Width = 128
.Columns.Add("5").Width = 128
End With
|
137. I've seen that the width of the tooltip is variable. Can I make it larger
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipWidth = 328
.Columns.Add("tootip").ToolTip = "this is a tooltip that should be very very very very very very very long"
End With
|
136. How do I disable showing the tooltip for all control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 0
.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
End With
|
135. How do I let the tooltip being displayed longer
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipPopDelay = 10000
.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
End With
|
134. How do I show the tooltip quicker
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ToolTipDelay = 1
.Columns.Add("tootip").ToolTip = "this is a tooltip assigned to a column"
End With
|
133. How do I change the caption being displayed in the control's filter bar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FilterBarCaption = "your filter caption"
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
End With
|
132. How do I disable expanding or collapsing an item when user double clicks it
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exLinesAtRoot
.Indent = 13
.Columns.Add("Column 1")
With .Items
h = .AddItem("Root")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
End With
End With
|
131. How do I search case sensitive, using your incremental search feature
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AutoSearch = True
.ASCIILower = ""
With .Columns
.Add("exStartWith").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exStartWith
.Add("exContains").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains
End With
With .Items
.set_CellCaption(.AddItem("text"),1,"another text")
End With
With .Items
.set_CellCaption(.AddItem("text"),1,"another text")
End With
End With
|
130. How do I disable the control
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .Enabled = False End With |
129. How do I enable the incremental search feature within a column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.AutoSearch = True
With .Columns
.Add("exStartWith").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exStartWith
.Add("exContains").AutoSearch = exontrol.EXCOMBOBOXLib.AutoSearchEnum.exContains
End With
With .Items
.set_CellCaption(.AddItem("text"),1,"another text")
End With
With .Items
.set_CellCaption(.AddItem("text"),1,"another text")
End With
End With
|
128. How do I call your x-script language
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .ExecuteTemplate("Columns.Add(`Column`)")
.HeaderStrikeOut = True
.HeaderBold = True
End With
End With
|
127. How do I call your x-script language
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .Template = "Columns.Add(`Column`).HTMLCaption = `<b>C</b>olumn`" End With |
126. How do I show alternate rows in different background color
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.BackColorAlternate = Color.FromArgb(240,240,240)
.Columns.Add("Column")
With .Items
.AddItem("Item 1")
.AddItem("Item 2")
.AddItem("Item 3")
.AddItem("Item 4")
.AddItem("Item 5")
End With
End With
|
125. How do I enlarge the drop down filter window
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FilterBarDropDownHeight = "-320"
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterBarDropDownWidth = "-320"
End With
.Items.AddItem("Item 1")
.Items.AddItem("Item 2")
End With
|
124. How do I filter programatically the control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exPattern
.Filter = "Item*"
End With
.Items.AddItem("Item 1")
.Items.AddItem("")
.Items.AddItem("Item 2")
.ApplyFilter()
End With
|
123. How do I change the font of the control's filterbar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FilterBarFont.Size = 20
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
End With
|
122. Can I apply an EBN skin to the control's filter bar so I can change its visual appearance
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.FilterBarBackColor32 = &H1000000
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
End With
|
121. How do I change the background color of the control's filterbar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FilterBarBackColor = Color.FromArgb(240,240,240)
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
End With
|
120. How do I change the foreground color of the control's filterbar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FilterBarForeColor = Color.FromArgb(255,0,0)
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
End With
|
119. How do I change the height of the control's filterbar
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FilterBarHeight = 32
With .Columns.Add("Column")
.DisplayFilterButton = True
.FilterType = exontrol.EXCOMBOBOXLib.FilterTypeEnum.exBlanks
End With
.ApplyFilter()
End With
|
118. How do select only a portion of text when the control starts editing a cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.SelStart = 1
.SelLength = 1
.Columns.Add("Column")
.Items.AddItem("Item 1")
.Items.AddItem("Item 2")
End With
|
117. How do I change the header's foreground color
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column 1")
.Columns.Add("Column 2")
.Items.AddItem("Item 1")
End With
|
116. I have a picture on the control's background, the question is how do I draw selection as semi-transparent
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem("Item 1")
.Items.AddItem("Item 2")
End With
|
115. It seems that the control uses the TAB key, is there any way to avoid that
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .UseTabKey = False End With |
114. I have FullRowSelect property on False, how do I force the user to select cells only in a specified column
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FullRowSelect = False
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
.set_CellCaption(.AddItem("Item 1"),1,"SubItem 1")
End With
End With
|
113. How do I assign a database to your control, using ADO, ADOR or ADODB objects
| VB.NET |
|---|
Dim rs
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnAutoResize = False
rs = New ADODB.Recordset()
With rs
.Open("Orders","Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files\Exontrol\ExTree\Sample\VB\SAMPLE." & _
"MDB",3,3)
End With
.DataSource = rs
End With
|
112. How do I change the visual appearance effect for the selected item, using EBN
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.VisualAppearance.Add(1,"c:\exontrol\images\normal.ebn")
.SelBackColor32 = &H1000000
.SelForeColor = Color.FromArgb(0,0,0)
.ShowFocusRect = False
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
111. How do I change the colors for the selected item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.SelBackColor = Color.FromArgb(0,0,0)
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
110. How do I get ride of the rectangle arround focused item
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ShowFocusRect = False
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
End With
|
109. How can I change the control's font
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Font.Name = "Tahoma"
.Columns.Add("Column")
End With
|
108. I can't scroll to the end of the data. What can I do
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ScrollBySingleLine = True
.DrawGridLines = &Hfffffffc Or exontrol.EXCOMBOBOXLib.GridLinesEnum.exVLines
.Columns.Add("Column")
With .Items
.set_ItemHeight(.AddItem(0),13)
End With
With .Items
.set_ItemHeight(.AddItem(1),26)
End With
With .Items
.set_ItemHeight(.AddItem(2),36)
End With
With .Items
.set_ItemHeight(.AddItem(3),48)
End With
End With
|
107. How do I specify the column where the tree lines / hierarchy are shown
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.TreeColumnIndex = 1
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
h = .AddItem("Root 1.1")
.set_CellCaption(h,1,"Root 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
.set_CellCaption(.InsertItem(h,0,"Child 2.1"),1,"Child 2.2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2.1")
.set_CellCaption(h,1,"Root 2.2")
.set_CellCaption(.InsertItem(h,0,"Child 1.1"),1,"Child 1.2")
End With
End With
|
106. How do I specify the indentation of the child items relative to their parents
| VB.NET |
|---|
Dim h
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.LinesAtRoot = exontrol.EXCOMBOBOXLib.LinesAtRootEnum.exGroupLinesAtRoot
.Indent = 11
.Columns.Add("Column")
With .Items
h = .AddItem("Root 1")
.InsertItem(h,0,"Child 1")
.InsertItem(h,0,"Child 2")
.set_ExpandItem(h,True)
h = .AddItem("Root 2")
.InsertItem(h,0,"Child")
End With
End With
|
105. Is there any option to select an item using the right button of the mouse (rclick)
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem("Item 1")
.Items.AddItem("Item 2")
End With
|
104. How do I edit a cell
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem("Item 1")
.Items.AddItem("Item 2")
End With
|
103. I have FullRowSelect property on False, how do I select a column
| VB.NET |
|---|
With Excombobox1 .MinHeightList = 304 .ColumnAutoResize = True .FullRowSelect = False End With |
102. How can I scroll columns one by one, not pixel by pixel
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ColumnAutoResize = False
.Columns.Add("1").Width = 128
.Columns.Add("2").Width = 128
.Columns.Add("3").Width = 128
.Columns.Add("4").Width = 128
.Columns.Add("5").Width = 128
End With
|
101. How can I enable multiple items selection
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column")
.Items.AddItem(0)
.Items.AddItem(1)
.Items.AddItem(2)
End With
|
100. How can I programmatically change the column where incremental searching is performed
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.Columns.Add("Column 1")
.Columns.Add("Column 2")
With .Items
.set_CellCaption(.AddItem("Item 1"),1,"SubItem 1")
End With
.SearchColumnIndex = 1
End With
|
99. How do I disable the full-row selection in the control
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.FullRowSelect = False
.Columns.Add("Column")
.Items.AddItem("One")
.Items.AddItem("Two")
End With
|
98. Is there any option to specify the height of the items, before adding them
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.DefaultItemHeight = 32
.Columns.Add("Column")
.Items.AddItem("One")
.Items.AddItem("Two")
End With
|
97. How do lock / fix some columns to the control, so I can see them all the time, event if I scroll the columns
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.CountLockedColumns = 1
.BackColorLock = Color.FromArgb(240,240,240)
.ColumnAutoResize = False
.Columns.Add("Locked").Width = 128
.Columns.Add("Un-Locked 1").Width = 128
.Columns.Add("Un-Locked 2").Width = 128
.Columns.Add("Un-Locked 3").Width = 128
With .Items
.set_CellCaption(.AddItem("locked"),1,"unlocked")
End With
End With
|
96. How do I change the control's background / foreground color on the locked area
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.CountLockedColumns = 1
.ForeColorLock = Color.FromArgb(240,240,240)
.BackColorLock = Color.FromArgb(128,128,128)
.ColumnAutoResize = False
.Columns.Add("Locked").Width = 128
.Columns.Add("Un-Locked 1").Width = 128
.Columns.Add("Un-Locked 2").Width = 128
.Columns.Add("Un-Locked 3").Width = 128
With .Items
.set_CellCaption(.AddItem("locked"),1,"unlocked")
End With
End With
|
95. How do I change the control's foreground color
| VB.NET |
|---|
With Excombobox1
.MinHeightList = 304
.ColumnAutoResize = True
.ForeColor = Color.FromArgb(120,120,120)
.Columns.Add("Column")
.Items.AddItem( |