GrapeCity.Win.PluginInputMan Assembly > GrapeCity.Win.Spread.InputMan.CellType Namespace > GcComboBoxCellType Class : AutoFilter Property |
'Declaration Public ReadOnly Property AutoFilter As AutoFilterInfo
'Usage Dim instance As GcComboBoxCellType Dim value As AutoFilterInfo value = instance.AutoFilter
public AutoFilterInfo AutoFilter {get;}
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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10