Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / MultiColumnComboBoxCellType Class / VerticalAlign Property
Example


In This Topic
    VerticalAlign Property (MultiColumnComboBoxCellType)
    In This Topic
    Gets or sets the vertical alignment of content in MultiColumnComboBox items.
    Syntax
    'Declaration
     
    Public Property VerticalAlign As VerticalAlign
    'Usage
     
    Dim instance As MultiColumnComboBoxCellType
    Dim value As VerticalAlign
     
    instance.VerticalAlign = value
     
    value = instance.VerticalAlign
    public VerticalAlign VerticalAlign {get; set;}
    Example
    This example sets the VerticalAlign property.
    System.Data.DataSet ds = new System.Data.DataSet();
    System.Data.DataTable emp = new System.Data.DataTable("Employees");
    System.Data.DataTable div = new System.Data.DataTable("Division");
    emp.Columns.Add("LastName");
    emp.Columns.Add("FirstName");
    emp.Rows.Add(new Object[] { "Jones", "Marianne" });
    emp.Rows.Add(new Object[] { "Fieldes", "Anna" });
    div.Columns.Add("Section");
    div.Columns.Add("Specialty");
    div.Rows.Add(new Object[] { "Finance", "Taxes" });
    div.Rows.Add(new Object[] { "Mergers", "Legal" });
    ds.Tables.AddRange(new System.Data.DataTable[] { emp, div });
    FarPoint.Web.Spread.MultiColumnComboBoxCellType mccbct = new FarPoint.Web.Spread.MultiColumnComboBoxCellType();
    mccbct.DataSource = ds;
    mccbct.VerticalAlign = VerticalAlign.Top;
    FpSpread1.ActiveSheetView.Cells[0, 0].CellType = mccbct;
    Dim ds As New DataSet()
    Dim emp As New DataTable("Employees")
    Dim div As New DataTable("Division")
    emp.Columns.Add("LastName")
    emp.Columns.Add("FirstName")
    emp.Rows.Add(New Object() {"Jones", "Marianne"})
    emp.Rows.Add(New Object() {"Fieldes", "Anna"})
    div.Columns.Add("Section")
    div.Columns.Add("Specialty")
    div.Rows.Add(New Object() {"Finance", "Taxes"})
    div.Rows.Add(New Object() {"Mergers", "Legal"})
    ds.Tables.AddRange(New DataTable() {emp, div})
    Dim mccbct As New FarPoint.Web.Spread.MultiColumnComboBoxCellType
    mccbct.DataSource = ds
    mccbct.VerticalAlign = VerticalAlign.Top
    FpSpread1.ActiveSheetView.Cells(0, 0).CellType = mccbct
    See Also