Class ListBoxActiveXControl
Contents
[
Hide
]ListBoxActiveXControl class
Represents a ListBox ActiveX control.
public class ListBoxActiveXControl : ActiveXControl
Properties
| Name | Description |
|---|---|
| virtual BackOleColor { get; set; } | Gets and sets the ole color of the background.(Inherited from ActiveXControlBase.) |
| BorderOleColor { get; set; } | Gets and sets the ole color of the background. |
| BorderStyle { get; set; } | Gets and set the type of border used by the control. |
| BoundColumn { get; set; } | Represents how the Value property is determined for a ComboBox or ListBox when the MultiSelect properties value (fmMultiSelectSingle). |
| ColumnCount { get; set; } | Represents the number of columns to display in a ComboBox or ListBox. |
| ColumnWidths { get; set; } | Gets and sets the width of the column. |
| override Data { get; } | Gets and sets the binary data of the control.(Inherited from ActiveXControl.) |
| Font { get; } | Represents the font of the control.(Inherited from ActiveXControl.) |
| virtual ForeOleColor { get; set; } | Gets and sets the ole color of the foreground.(Inherited from ActiveXControlBase.) |
| virtual Height { get; set; } | Gets and sets the height of the control in unit of points.(Inherited from ActiveXControlBase.) |
| IMEMode { get; set; } | Gets and sets the default run-time mode of the Input Method Editor for the control as it receives focus.(Inherited from ActiveXControl.) |
| IntegralHeight { get; set; } | Indicates whether the control will only show complete lines of text without showing any partial lines. |
| virtual IsAutoSize { get; set; } | Indicates whether the control will automatically resize to display its entire contents.(Inherited from ActiveXControl.) |
| IsEnabled { get; set; } | Indicates whether the control can receive the focus and respond to user-generated events.(Inherited from ActiveXControl.) |
| IsLocked { get; set; } | Indicates whether data in the control is locked for editing.(Inherited from ActiveXControl.) |
| IsTransparent { get; set; } | Indicates whether the control is transparent.(Inherited from ActiveXControl.) |
| virtual IsVisible { get; set; } | Indicates whether this control is visible.(Inherited from ActiveXControlBase.) |
| LinkedCell { get; set; } | Gets and sets the linked cell.(Inherited from ActiveXControlBase.) |
| ListFillRange { get; set; } | Gets and sets the list fill range.(Inherited from ActiveXControlBase.) |
| ListStyle { get; set; } | Gets and sets the visual appearance. |
| ListWidth { get; set; } | Gets and set the width in unit of points. |
| MatchEntry { get; set; } | Indicates how a ListBox or ComboBox searches its list as the user types. |
| MouseIcon { get; set; } | Gets and sets a custom icon to display as the mouse pointer for the control.(Inherited from ActiveXControlBase.) |
| MousePointer { get; set; } | Gets and sets the type of icon displayed as the mouse pointer for the control.(Inherited from ActiveXControlBase.) |
| ScrollBars { get; set; } | Indicates specifies whether the control has vertical scroll bars, horizontal scroll bars, both, or neither. |
| SelectionType { get; set; } | Indicates whether the control permits multiple selections. |
| virtual Shadow { get; set; } | Indicates whether to show a shadow.(Inherited from ActiveXControlBase.) |
| ShowColumnHeads { get; set; } | Indicates whether column headings are displayed. |
| SpecialEffect { get; set; } | Gets and sets the special effect of the control. |
| TextAlign { get; set; } | Represents how to align the text used by the control.(Inherited from ActiveXControl.) |
| TextColumn { get; set; } | Represents the column in a ComboBox or ListBox to display to the user. |
| override Type { get; } | Gets the type of the ActiveX control. |
| Value { get; set; } | Gets and sets the value of the control. |
| virtual Width { get; set; } | Gets and sets the width of the control in unit of points.(Inherited from ActiveXControlBase.) |
| Workbook { get; } | Gets the Workbook object.(Inherited from ActiveXControlBase.) |
Examples
[C#]
using Aspose.Cells;
using Aspose.Cells.Drawing;
using Aspose.Cells.Drawing.ActiveXControls;
using System;
namespace Demos
{
public class ListBoxActiveXControlDemo
{
public static void RunDemo()
{
// Create a new workbook
Workbook workbook = new Workbook();
// Add a new worksheet to the workbook
Worksheet worksheet = workbook.Worksheets[0];
// Add a ListBox ActiveX control to the worksheet
var shape = worksheet.Shapes.AddActiveXControl(ControlType.ListBox, 5, 0, 1, 1, 100, 100);
ListBoxActiveXControl listBox = (ListBoxActiveXControl)shape.ActiveXControl;
// Set properties for the ListBox
listBox.ListWidth = 100;
listBox.BoundColumn = 1;
listBox.TextColumn = 1;
listBox.ColumnCount = 2;
listBox.MatchEntry = ControlMatchEntryType.Complete;
listBox.ListStyle = ControlListStyle.Plain;
listBox.SelectionType = SelectionType.Multi;
listBox.Value = "Item1";
listBox.BorderOleColor = 0x000000; // Black color
listBox.SpecialEffect = ControlSpecialEffectType.Flat;
listBox.ShowColumnHeads = true;
listBox.IntegralHeight = true;
listBox.ColumnWidths = 50;
// Set additional properties inherited from ActiveXControl
listBox.IsEnabled = true;
listBox.IsLocked = false;
listBox.IsTransparent = false;
listBox.IsAutoSize = false;
listBox.IMEMode = InputMethodEditorMode.NoControl;
listBox.TextAlign = TextAlignmentType.Left;
listBox.IsVisible = true;
listBox.Shadow = false;
listBox.LinkedCell = "A1";
listBox.ListFillRange = "A2:A5";
// Add some sample data to the worksheet for the ListBox
worksheet.Cells["A2"].PutValue("Item1");
worksheet.Cells["A3"].PutValue("Item2");
worksheet.Cells["A4"].PutValue("Item3");
worksheet.Cells["A5"].PutValue("Item4");
// Save the workbook
workbook.Save("ListBoxActiveXControlDemo.xlsx");
// Output the results
Console.WriteLine("ListBox ActiveX Control created and configured successfully.");
}
}
}
See Also
- class ActiveXControl
- namespace Aspose.Cells.Drawing.ActiveXControls
- assembly Aspose.Cells
