GrapeCity.Win.PluginInputMan Assembly > GrapeCity.Win.Spread.InputMan.CellType Namespace > GcComboBoxCellType Class : TextBoxStyle Property |
'Declaration Public Property TextBoxStyle As TextBoxStyle
'Usage Dim instance As GcComboBoxCellType Dim value As TextBoxStyle instance.TextBoxStyle = value value = instance.TextBoxStyle
public TextBoxStyle TextBoxStyle {get; set;}
ImageList img = new ImageList(); img.Images.Add(Image.FromFile("C:\\Program Files (x86)\\GrapeCity\\rasp.png")); img.Images.Add(Image.FromFile("C:\\Program Files (x86)\\GrapeCity\\vanilla.png")); img.Images.Add(Image.FromFile("C:\\Program Files (x86)\\GrapeCity\\choco.png")); img.Images.Add(Image.FromFile("C:\\Program Files (x86)\\GrapeCity\\banana.png")); GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType gccombo = new GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType(); gccombo.DropDownStyle = ComboBoxStyle.DropDownList; gccombo.Items.AddRange(new String[] { "Raspberry", "Vanilla", "Chocolate", "Banana" }); gccombo.Items[0].BackColor = Color.Fuchsia; gccombo.Items[1].BackColor = Color.Ivory; gccombo.Items[2].BackColor = Color.Chocolate; gccombo.Items[3].BackColor = Color.LightYellow; gccombo.ImageList = img; gccombo.Items[0].Image = 0; gccombo.Items[1].Image = 1; gccombo.Items[2].Image = 2; gccombo.Items[3].Image = 3; gccombo.ShowListBoxImage = true; gccombo.ImageAlign = HorizontalAlignment.Right; gccombo.ListSelectedItemStyle.BackColor = Color.Bisque; gccombo.ListSelectedItemStyle.ForeColor = Color.Black; gccombo.TextBoxStyle = GrapeCity.Win.Spread.InputMan.CellType.TextBoxStyle.Both; fpSpread1.Sheets[0].Cells[1, 1].CellType = gccombo; fpSpread1.Sheets[0].Columns[1].Width = 200; fpSpread1.Sheets[0].Rows[1].Height = 40; FarPoint.Win.Spread.CellType.CurrencyCellType currencycell = new FarPoint.Win.Spread.CellType.CurrencyCellType(); fpSpread1.Sheets[0].Cells[1, 2].CellType = currencycell; fpSpread1.Sheets[0].Cells[0, 1].Text = "Select a flavor"; fpSpread1.Sheets[0].Cells[0, 2].Text = "Total"; fpSpread1.Sheets[0].Columns[1, 2].Font = new Font("Calibri", 10, FontStyle.Bold); fpSpread1.Sheets[0].Columns[1, 2].HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center; fpSpread1.Sheets[0].Rows[1].VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center; private void fpSpread1_ComboSelChange(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e) { string caseSwitch; caseSwitch = fpSpread1.Sheets[0].Cells[1, 1].Text; switch (caseSwitch) { case "Raspberry": fpSpread1.Sheets[0].Cells[1, 2].Value = 5.00; break; case "Vanilla": fpSpread1.Sheets[0].Cells[1, 2].Value = 4.00; break; case "Chocolate": fpSpread1.Sheets[0].Cells[1, 2].Value = 4.25; break; case "Banana": fpSpread1.Sheets[0].Cells[1, 2].Value = 4.75; break; } }
Dim img As New ImageList() img.Images.Add(Image.FromFile("C:\Program Files (x86)\GrapeCity\rasp.png")) img.Images.Add(Image.FromFile("C:\Program Files (x86)\GrapeCity\vanilla.png")) img.Images.Add(Image.FromFile("C:\Program Files (x86)\GrapeCity\choco.png")) img.Images.Add(Image.FromFile("C:\Program Files (x86)\GrapeCity\banana.png")) Dim gccombo As New GrapeCity.Win.Spread.InputMan.CellType.GcComboBoxCellType() gccombo.DropDownStyle = ComboBoxStyle.DropDownList gccombo.Items.AddRange(New String() {"Raspberry", "Vanilla", "Chocolate", "Banana"}) gccombo.Items(0).BackColor = Color.Fuchsia gccombo.Items(1).BackColor = Color.Ivory gccombo.Items(2).BackColor = Color.Chocolate gccombo.Items(3).BackColor = Color.LightYellow gccombo.ImageList = img gccombo.Items(0).Image = 0 gccombo.Items(1).Image = 1 gccombo.Items(2).Image = 2 gccombo.Items(3).Image = 3 gccombo.ShowListBoxImage = True gccombo.ImageAlign = HorizontalAlignment.Right gccombo.ListSelectedItemStyle.BackColor = Color.Bisque gccombo.ListSelectedItemStyle.ForeColor = Color.Black gccombo.TextBoxStyle = GrapeCity.Win.Spread.InputMan.CellType.TextBoxStyle.Both FpSpread1.Sheets(0).Cells(1, 1).CellType = gccombo FpSpread1.Sheets(0).Columns(1).Width = 200 FpSpread1.Sheets(0).Rows(1).Height = 40 Dim currencycell As New FarPoint.Win.Spread.CellType.CurrencyCellType() FpSpread1.Sheets(0).Cells(1, 2).CellType = currencycell FpSpread1.Sheets(0).Cells(0, 1).Text = "Select a flavor" FpSpread1.Sheets(0).Cells(0, 2).Text = "Total" FpSpread1.Sheets(0).Columns(1, 2).Font = New Font("Calibri", 10, FontStyle.Bold) FpSpread1.Sheets(0).Columns(1, 2).HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Center FpSpread1.Sheets(0).Rows(1).VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Center Private Sub FpSpread1_ComboSelChange(sender As Object, e As FarPoint.Win.Spread.EditorNotifyEventArgs) Handles FpSpread1.ComboSelChange Dim caseSwitch As String caseSwitch = FpSpread1.Sheets(0).Cells(1, 1).Text Select Case caseSwitch Case "Raspberry" FpSpread1.Sheets(0).Cells(1, 2).Value = 5.0 Exit Select Case "Vanilla" FpSpread1.Sheets(0).Cells(1, 2).Value = 4.0 Exit Select Case "Chocolate" FpSpread1.Sheets(0).Cells(1, 2).Value = 4.25 Exit Select Case "Banana" FpSpread1.Sheets(0).Cells(1, 2).Value = 4.75 Exit Select End Select End Sub
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