Spread Windows Forms 17
GrapeCity.Win.PluginInputMan Assembly / GrapeCity.Win.Spread.InputMan.CellType Namespace / GcComboBoxCellType Class / AutoFilter Property
Example


In This Topic
    AutoFilter Property (GcComboBoxCellType)
    In This Topic
    Gets the automatic filter related settings.
    Syntax
    'Declaration
     
    
    Public ReadOnly Property AutoFilter As AutoFilterInfo
    'Usage
     
    
    Dim instance As GcComboBoxCellType
    Dim value As AutoFilterInfo
     
    value = instance.AutoFilter
    public AutoFilterInfo AutoFilter {get;}

    Property Value

    The automatic filter settings.
    Example
    次のサンプルコードは、GcComboBoxセルを作成します。
    GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType gcCombo = new GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType();
    
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem1 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem2 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem3 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem4 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem5 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem6 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem7 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem8 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo listItem9 = new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ItemTemplateInfo itemTemplate1 = new GrapeCity.Win.Spread.InputMan.CellType.ItemTemplateInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ItemTemplateInfo itemTemplate2 = new GrapeCity.Win.Spread.InputMan.CellType.ItemTemplateInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo listColumn1 = new GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo();
    GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo listColumn2 = new GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo();
    Image img1 = Image.FromFile("C:\\Program Files (x86)\\GrapeCity\\Image.ico");
    Image img2 = Image.FromFile("C:\\Program Files (x86)\\GrapeCity\\Image.jpeg");
    
    System.Windows.Forms.ImageList imageList = new System.Windows.Forms.ImageList();
    imageList.TransparentColor = System.Drawing.Color.Transparent;
    imageList.Images.Add("0", img1);
    imageList.Images.Add("1", img2);
    
    gcCombo.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
    gcCombo.AcceptsCrLf = GrapeCity.Win.Spread.InputMan.CellType.CrLfMode.Filter;
    gcCombo.AcceptsTabChar = GrapeCity.Win.Spread.InputMan.CellType.TabCharMode.Filter;
    gcCombo.AllowSpace = GrapeCity.Win.Spread.InputMan.CellType.AllowSpace.Both;
    
    gcCombo.AlternateText.DisplayNull.Text = "DisplayNull";
    gcCombo.AlternateText.DisplayNull.ForeColor = Color.Red;
    gcCombo.AlternateText.Null.Text = "Null";
    gcCombo.AlternateText.Null.ForeColor = Color.RosyBrown;
    
    gcCombo.AutoComplete.MatchingMode = GrapeCity.Win.Spread.InputMan.CellType.AutoCompleteMatchingMode.MatchAll;
    gcCombo.AutoComplete.CandidateListItemFont = SystemFonts.DefaultFont;
    gcCombo.AutoComplete.HighlightMatchedText = true;
    gcCombo.AutoComplete.HighlightStyle.Font = SystemFonts.MenuFont;
    gcCombo.AutoComplete.HighlightStyle.ForeColor = Color.BlueViolet;
    
    gcCombo.AutoCompleteCustomSource = new System.Windows.Forms.AutoCompleteStringCollection() { "GcTextBox", "GcNumber", "GcComboBox", "GcDateTime" };
    gcCombo.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;
    gcCombo.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.CustomSource;
    gcCombo.AutoConvert = true;
    
    gcCombo.AutoFilter.Enabled = true;
    gcCombo.AutoFilter.Interval = 250;
    gcCombo.AutoFilter.MatchingMode = GrapeCity.Win.Spread.InputMan.CellType.AutoCompleteMatchingMode.MatchAll;
    gcCombo.AutoFilter.MatchingSource = GrapeCity.Win.Spread.InputMan.CellType.FilterMatchingSource.AllSubItems;
    gcCombo.AutoFilter.MaxFilteredItems = 10;
    gcCombo.AutoFilter.MinimumPrefixLength = 1;
    
    gcCombo.AutoGenerateColumns = true;
    gcCombo.AutoSelect = true;
    
    gcCombo.DropDown.AllowDrop = true;
    gcCombo.DropDown.AllowResize = true;
    gcCombo.DropDown.AutoHideTouchKeyboard = GrapeCity.Win.Spread.InputMan.CellType.AutoHideTouchKeyboard.HideAndReshow;
    gcCombo.DropDown.AutoWidth = true;
    gcCombo.DropDown.ClosingAnimation = GrapeCity.Win.Spread.InputMan.CellType.DropDownAnimation.Fade;
    gcCombo.DropDown.Direction = GrapeCity.Win.Spread.InputMan.CellType.DropDownDirection.Default;
    gcCombo.DropDown.OpeningAnimation = GrapeCity.Win.Spread.InputMan.CellType.DropDownAnimation.Extend;
    gcCombo.DropDown.ShowShadow = true;
    
    gcCombo.DropDownMaxHeight = 200;
    gcCombo.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown;
    gcCombo.EditMode = GrapeCity.Win.Spread.InputMan.CellType.EditMode.Insert;
    gcCombo.Ellipsis = GrapeCity.Win.Spread.InputMan.CellType.EllipsisMode.EllipsisEnd;
    gcCombo.EllipsisString = "....";
    gcCombo.ExitOnLastChar = true;
    gcCombo.FocusPosition = GrapeCity.Win.Spread.InputMan.CellType.EditorBaseFocusCursorPosition.Inherit;
    gcCombo.FormatString = String.Empty;
    gcCombo.ImageAlign = System.Windows.Forms.HorizontalAlignment.Center;
    gcCombo.ImageList = imageList;
    gcCombo.ImageWidth = 50;
    
    listItem1.Image = 0;
    listItem1.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcTextBox"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("テキストコントロール")
            });
    listItem2.Image = 1;
    listItem2.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcMask"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("マスクコントロール")
          });
    listItem3.Image = 0;
    listItem3.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcCharMask"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("キャラクタボックスコントロール")
          });
    listItem4.Image = 1;
    listItem4.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcDate"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("日付コントロール")
          });
    listItem5.Image = 0;
    listItem5.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcTimeSpan"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("タイムスパンコントロール")
          });
    listItem6.Image = 1;
    listItem6.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcNumber"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("数値コントロール")
          });
    listItem7.Image = 0;
    listItem7.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
         new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcComboBox"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("コンボコントロール")
          });
    listItem8.Image = 1;
    listItem8.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcListBox"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("リストコントロール")
          });
    listItem9.Image = 0;
    listItem9.SubItems.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo[] {
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcRichTextBox"),
          new GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("リッチテキストコントロール")
          });
    gcCombo.Items.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo[] {
          listItem1,
          listItem2,
          listItem3,
          listItem4,
          listItem5,
          listItem6,
          listItem7,
          listItem8,
          listItem9});
    
    listColumn1.AutoWidth = true;
    listColumn1.Header.Text = "コントロール";
    listColumn1.Header.Image = img1;
    
    listColumn2.AutoWidth = true;
    listColumn2.Header.Text = "名称";
    listColumn2.Header.Image = img2;
    gcCombo.ListColumns.AddRange(new GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo[] {
          listColumn1,
          listColumn2});
    
    gcCombo.ListDefaultColumn.AutoWidth = true;
    gcCombo.ListDefaultColumn.DataDisplayType = GrapeCity.Win.Spread.InputMan.CellType.DataDisplayType.Text;
    
    gcCombo.ListDefaultColumn.Header.AllowResize = true;
    gcCombo.ListDefaultColumn.Header.BackColor = Color.WhiteSmoke;
    gcCombo.ListDefaultColumn.Header.ContentAlignment = ContentAlignment.MiddleCenter;
    gcCombo.ListDefaultColumn.Header.Ellipsis = true;
    gcCombo.ListDefaultColumn.Header.ForeColor = Color.OrangeRed;
    gcCombo.ListDefaultColumn.Header.GradientEffect = new GrapeCity.Win.Spread.InputMan.CellType.GradientEffect(GrapeCity.Win.Spread.InputMan.CellType.GradientStyle.Circular, GrapeCity.Win.Spread.InputMan.CellType.GradientDirection.Center, Color.CadetBlue, Color.FloralWhite);
    gcCombo.ListDefaultColumn.Header.Image = img1;
    gcCombo.ListDefaultColumn.Header.ImageTextSpace = 40;
    gcCombo.ListDefaultColumn.Header.Text = "DefaultColumn";
    gcCombo.ListDefaultColumn.Header.TextAttachAlignment = GrapeCity.Win.Spread.InputMan.CellType.AttachAlignment.RightMiddle;
    gcCombo.ListDefaultColumn.Header.TextEffect = GrapeCity.Win.Spread.InputMan.CellType.TextEffect.InsetLite;
    
    gcCombo.ListDefaultColumn.Visible = true;
    gcCombo.ListDefaultColumn.Width = 500; //No effect when auto width = true
    
    gcCombo.ListDefaultColumn.DefaultSubItem.ContentAlignment = ContentAlignment.MiddleCenter;
    gcCombo.ListDefaultColumn.DefaultSubItem.Ellipsis = false;
    gcCombo.ListDefaultColumn.DefaultSubItem.Padding = new System.Windows.Forms.Padding(5);
    gcCombo.ListDefaultColumn.DefaultSubItem.WordWrap = true;
    
    gcCombo.ListDescriptionFormat = "[0] : [1]";
    gcCombo.ListDescriptionSubItemIndex = 1; //No effect with ListDescriptionFormat
    
    gcCombo.ListDisabledItemStyle.BackColor = Color.Gray;
    gcCombo.ListDisabledItemStyle.ForeColor = Color.White;
    gcCombo.ListDisabledItemStyle.GradientEffect = null;
    
    gcCombo.ListGradientEffect = new GrapeCity.Win.Spread.InputMan.CellType.GradientEffect(GrapeCity.Win.Spread.InputMan.CellType.GradientStyle.Elliptical, GrapeCity.Win.Spread.InputMan.CellType.GradientDirection.Forward, Color.White, Color.AliceBlue);
    
    gcCombo.ListGridLines.HorizontalLines = new GrapeCity.Win.Spread.InputMan.CellType.Line(GrapeCity.Win.Spread.InputMan.CellType.LineStyle.Dotted, Color.Black);
    gcCombo.ListGridLines.VerticalLines = new GrapeCity.Win.Spread.InputMan.CellType.Line(GrapeCity.Win.Spread.InputMan.CellType.LineStyle.Dotted, Color.Black);
    
    gcCombo.ListHeaderPane.Height = 100; //No effect when AutoHeight = true
    gcCombo.ListHeaderPane.AutoHeight = true;
    gcCombo.ListHeaderPane.BackColor = Color.Brown;
    gcCombo.ListHeaderPane.GradientEffect = null;
    gcCombo.ListHeaderPane.Visible = true;
    
    itemTemplate1.AutoItemHeight = true;
    itemTemplate1.BackColor = Color.Beige;
    itemTemplate1.Height = 30;
    itemTemplate1.Indent = 10;
    
    itemTemplate2.AutoItemHeight = true;
    itemTemplate2.BackColor = Color.Crimson;
    itemTemplate2.Height = 30;
    
    gcCombo.ListItemTemplates.Add(itemTemplate1);
    gcCombo.ListItemTemplates.Add(itemTemplate2);
    
    gcCombo.ListSelectedItemStyle.BackColor = Color.DarkBlue;
    gcCombo.ListSelectedItemStyle.ForeColor = Color.White;
    gcCombo.MaxDropDownItems = 5;
    gcCombo.MaxLength = 10;    
    gcCombo.RecommendedValue = "Recommended Value";
    gcCombo.ShowRecommendedValue = true;
    gcCombo.ScrollBarMode = GrapeCity.Win.Spread.InputMan.CellType.ScrollBarMode.Automatic;
    gcCombo.ScrollBars = System.Windows.Forms.ScrollBars.Both;  
    gcCombo.ShowItemTip = true;
    gcCombo.ShowListBoxImage = true;
    gcCombo.ShowOverflowTip = true;
    gcCombo.ShowTouchToolBar = GrapeCity.Win.Spread.InputMan.CellType.TouchToolBarDisplayOptions.TapGripper;     
    gcCombo.StatusBar.Visible = true;
    gcCombo.StatusBar.Text = "StatusBar";
    
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = gcCombo;
    Dim gcCombo As New GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType()
    
    Dim listItem1 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem2 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem3 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem4 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem5 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem6 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem7 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem8 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim listItem9 As New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo()
    Dim itemTemplate1 As New GrapeCity.Win.Spread.InputMan.CellType.ItemTemplateInfo()
    Dim itemTemplate2 As New GrapeCity.Win.Spread.InputMan.CellType.ItemTemplateInfo()
    Dim listColumn1 As New GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo()
    Dim listColumn2 As New GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo()
    Dim img1 As Image = Image.FromFile("C:\Program Files (x86)\GrapeCity\Image.ico")
    Dim img2 As Image = Image.FromFile("C:\Program Files (x86)\GrapeCity\Image.jpeg")
    
    Dim ImageList As New System.Windows.Forms.ImageList()
    ImageList.TransparentColor = System.Drawing.Color.Transparent
    ImageList.Images.Add("0", img1)
    ImageList.Images.Add("1", img2)
    
    gcCombo.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows
    gcCombo.AcceptsCrLf = GrapeCity.Win.Spread.InputMan.CellType.CrLfMode.Filter
    gcCombo.AcceptsTabChar = GrapeCity.Win.Spread.InputMan.CellType.TabCharMode.Filter
    gcCombo.AllowSpace = GrapeCity.Win.Spread.InputMan.CellType.AllowSpace.Both
    
    gcCombo.AlternateText.DisplayNull.Text = "DisplayNull"
    gcCombo.AlternateText.DisplayNull.ForeColor = Color.Red
    gcCombo.AlternateText.Null.Text = "Null"
    gcCombo.AlternateText.Null.ForeColor = Color.RosyBrown
    
    gcCombo.AutoComplete.MatchingMode = GrapeCity.Win.Spread.InputMan.CellType.AutoCompleteMatchingMode.MatchAll
    gcCombo.AutoComplete.CandidateListItemFont = SystemFonts.DefaultFont
    gcCombo.AutoComplete.HighlightMatchedText = True
    gcCombo.AutoComplete.HighlightStyle.Font = SystemFonts.MenuFont
    gcCombo.AutoComplete.HighlightStyle.ForeColor = Color.BlueViolet
    
    gcCombo.AutoCompleteCustomSource = New System.Windows.Forms.AutoCompleteStringCollection() From {"GcTextBox", "GcNumber", "GcComboBox", "GcDateTime"}
    gcCombo.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest
    gcCombo.AutoCompleteSource = System.Windows.Forms.AutoCompleteSource.CustomSource
    gcCombo.AutoConvert = True
    
    gcCombo.AutoFilter.Enabled = True
    gcCombo.AutoFilter.Interval = 250
    gcCombo.AutoFilter.MatchingMode = GrapeCity.Win.Spread.InputMan.CellType.AutoCompleteMatchingMode.MatchAll
    gcCombo.AutoFilter.MatchingSource = GrapeCity.Win.Spread.InputMan.CellType.FilterMatchingSource.AllSubItems
    gcCombo.AutoFilter.MaxFilteredItems = 10
    gcCombo.AutoFilter.MinimumPrefixLength = 1
    
    gcCombo.AutoGenerateColumns = True
    gcCombo.AutoSelect = True
    
    gcCombo.DropDown.AllowDrop = True
    gcCombo.DropDown.AllowResize = True
    gcCombo.DropDown.AutoHideTouchKeyboard = GrapeCity.Win.Spread.InputMan.CellType.AutoHideTouchKeyboard.HideAndReshow
    gcCombo.DropDown.AutoWidth = True
    gcCombo.DropDown.ClosingAnimation = GrapeCity.Win.Spread.InputMan.CellType.DropDownAnimation.Fade
    gcCombo.DropDown.Direction = GrapeCity.Win.Spread.InputMan.CellType.DropDownDirection.Default
    gcCombo.DropDown.OpeningAnimation = GrapeCity.Win.Spread.InputMan.CellType.DropDownAnimation.Extend
    gcCombo.DropDown.ShowShadow = True
    
    gcCombo.DropDownMaxHeight = 200
    gcCombo.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDown
    gcCombo.EditMode = GrapeCity.Win.Spread.InputMan.CellType.EditMode.Insert
    gcCombo.Ellipsis = GrapeCity.Win.Spread.InputMan.CellType.EllipsisMode.EllipsisEnd
    gcCombo.EllipsisString = "...."
    gcCombo.ExitOnLastChar = True
    gcCombo.FocusPosition = GrapeCity.Win.Spread.InputMan.CellType.EditorBaseFocusCursorPosition.Inherit
    gcCombo.FormatString = String.Empty
    gcCombo.ImageAlign = System.Windows.Forms.HorizontalAlignment.Center
    gcCombo.ImageList = ImageList
    gcCombo.ImageWidth = 50
    
    listItem1.Image = 0
    listItem1.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcTextBox"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("テキストコントロール")
    })
    listItem2.Image = 1
    listItem2.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcMask"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("マスクコントロール")
          })
    listItem3.Image = 0
    listItem3.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcCharMask"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("キャラクタボックスコントロール")
          })
    listItem4.Image = 1
    listItem4.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcDate"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("日付コントロール")
          })
    listItem5.Image = 0
    listItem5.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcTimeSpan"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("タイムスパンコントロール")
          })
    listItem6.Image = 1
    listItem6.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcNumber"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("数値コントロール")
          })
    listItem7.Image = 0
    listItem7.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
         New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcComboBox"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("コンボコントロール")
          })
    listItem8.Image = 1
    listItem8.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcListBox"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("リストコントロール")
          })
    listItem9.Image = 0
    listItem9.SubItems.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo() {
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("GcRichTextBox"),
          New GrapeCity.Win.Spread.InputMan.CellType.SubItemInfo("リッチテキストコントロール")
          })
    gcCombo.Items.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.ListItemInfo() {
          listItem1,
          listItem2,
          listItem3,
          listItem4,
          listItem5,
          listItem6,
          listItem7,
          listItem8,
          listItem9})
    
    listColumn1.AutoWidth = True
    listColumn1.Header.Text = "コントロール"
    listColumn1.Header.Image = img1
    
    listColumn2.AutoWidth = True
    listColumn2.Header.Text = "名称"
    listColumn2.Header.Image = img2
    gcCombo.ListColumns.AddRange(New GrapeCity.Win.Spread.InputMan.CellType.ListColumnInfo() {
          listColumn1,
          listColumn2})
    
    gcCombo.ListDefaultColumn.AutoWidth = True
    gcCombo.ListDefaultColumn.DataDisplayType = GrapeCity.Win.Spread.InputMan.CellType.DataDisplayType.Text
    
    gcCombo.ListDefaultColumn.Header.AllowResize = True
    gcCombo.ListDefaultColumn.Header.BackColor = Color.WhiteSmoke
    gcCombo.ListDefaultColumn.Header.ContentAlignment = ContentAlignment.MiddleCenter
    gcCombo.ListDefaultColumn.Header.Ellipsis = True
    gcCombo.ListDefaultColumn.Header.ForeColor = Color.OrangeRed
    gcCombo.ListDefaultColumn.Header.GradientEffect = New GrapeCity.Win.Spread.InputMan.CellType.GradientEffect(GrapeCity.Win.Spread.InputMan.CellType.GradientStyle.Circular, GrapeCity.Win.Spread.InputMan.CellType.GradientDirection.Center, Color.CadetBlue, Color.FloralWhite)
    gcCombo.ListDefaultColumn.Header.Image = img1
    gcCombo.ListDefaultColumn.Header.ImageTextSpace = 40
    gcCombo.ListDefaultColumn.Header.Text = "DefaultColumn"
    gcCombo.ListDefaultColumn.Header.TextAttachAlignment = GrapeCity.Win.Spread.InputMan.CellType.AttachAlignment.RightMiddle
    gcCombo.ListDefaultColumn.Header.TextEffect = GrapeCity.Win.Spread.InputMan.CellType.TextEffect.InsetLite
    
    gcCombo.ListDefaultColumn.Visible = True
    gcCombo.ListDefaultColumn.Width = 500 'No effect When auto width = True
    
    gcCombo.ListDefaultColumn.DefaultSubItem.ContentAlignment = ContentAlignment.MiddleCenter
    gcCombo.ListDefaultColumn.DefaultSubItem.Ellipsis = False
    gcCombo.ListDefaultColumn.DefaultSubItem.Padding = New System.Windows.Forms.Padding(5)
    gcCombo.ListDefaultColumn.DefaultSubItem.WordWrap = True
    
    gcCombo.ListDescriptionFormat = "[0] : [1]"
    gcCombo.ListDescriptionSubItemIndex = 1 'No effect With ListDescriptionFormat
    
    gcCombo.ListDisabledItemStyle.BackColor = Color.Gray
    gcCombo.ListDisabledItemStyle.ForeColor = Color.White
    gcCombo.ListDisabledItemStyle.GradientEffect = Nothing
    
    gcCombo.ListGradientEffect = New GrapeCity.Win.Spread.InputMan.CellType.GradientEffect(GrapeCity.Win.Spread.InputMan.CellType.GradientStyle.Elliptical, GrapeCity.Win.Spread.InputMan.CellType.GradientDirection.Forward, Color.White, Color.AliceBlue)
    
    gcCombo.ListGridLines.HorizontalLines = New GrapeCity.Win.Spread.InputMan.CellType.Line(GrapeCity.Win.Spread.InputMan.CellType.LineStyle.Dotted, Color.Black)
    gcCombo.ListGridLines.VerticalLines = New GrapeCity.Win.Spread.InputMan.CellType.Line(GrapeCity.Win.Spread.InputMan.CellType.LineStyle.Dotted, Color.Black)
    
    gcCombo.ListHeaderPane.Height = 100 'No effect When AutoHeight = True
    gcCombo.ListHeaderPane.AutoHeight = True
    gcCombo.ListHeaderPane.BackColor = Color.Brown
    gcCombo.ListHeaderPane.GradientEffect = Nothing
    gcCombo.ListHeaderPane.Visible = True
    
    itemTemplate1.AutoItemHeight = True
    itemTemplate1.BackColor = Color.Beige
    itemTemplate1.Height = 30
    itemTemplate1.Indent = 10
    
    itemTemplate2.AutoItemHeight = True
    itemTemplate2.BackColor = Color.Crimson
    itemTemplate2.Height = 30
    
    gcCombo.ListItemTemplates.Add(itemTemplate1)
    gcCombo.ListItemTemplates.Add(itemTemplate2)
    
    gcCombo.ListSelectedItemStyle.BackColor = Color.DarkBlue
    gcCombo.ListSelectedItemStyle.ForeColor = Color.White
    gcCombo.MaxDropDownItems = 5
    gcCombo.MaxLength = 10
    gcCombo.RecommendedValue = "Recommended Value"
    gcCombo.ShowRecommendedValue = True
    gcCombo.ScrollBarMode = GrapeCity.Win.Spread.InputMan.CellType.ScrollBarMode.Automatic
    gcCombo.ScrollBars = System.Windows.Forms.ScrollBars.Both
    gcCombo.ShowItemTip = True
    gcCombo.ShowListBoxImage = True
    gcCombo.ShowOverflowTip = True
    gcCombo.ShowTouchToolBar = GrapeCity.Win.Spread.InputMan.CellType.TouchToolBarDisplayOptions.TapGripper
    gcCombo.StatusBar.Visible = True
    gcCombo.StatusBar.Text = "StatusBar"
    
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = gcCombo
    See Also