Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FpSpread Class / CellSpanSelectionPolicy Property
Example


In This Topic
    CellSpanSelectionPolicy Property (FpSpread)
    In This Topic
    Gets or sets the selection model to use with the span.
    Syntax
    'Declaration
     
    Public Property CellSpanSelectionPolicy As CellSpanSelectionPolicy
    'Usage
     
    Dim instance As FpSpread
    Dim value As CellSpanSelectionPolicy
     
    instance.CellSpanSelectionPolicy = value
     
    value = instance.CellSpanSelectionPolicy
    public CellSpanSelectionPolicy CellSpanSelectionPolicy {get; set;}
    Remarks
    Use this property to specify how header spans are selected.
    Example
    This example sets the CellSpanSelectionPolicy property.
    fpSpread1.CellSpanSelectionPolicy = FarPoint.Win.Spread.CellSpanSelectionPolicy.Intersected;
    fpSpread1.ActiveSheet.ColumnHeader.RowCount = 3;
    // Set the number of columns in the row header.
    fpSpread1.ActiveSheet.RowHeader.ColumnCount = 2;
    // Define the labels for the spanned column header cells.
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 0].Text = "East";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 1].Text = "West";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 2].Text = "East";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 3].Text = "West";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 4].Text = "East";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 5].Text = "West";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 6].Text = "East";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[2, 7].Text = "West";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 0].Text = "1st Quarter";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 2].Text = "2nd Quarter";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 4].Text = "3rd Quarter";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[1, 6].Text = "4th Quarter";
    fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].Text = "Fiscal Year 2004";
    // Define the column header cell spans.
    fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 0, 1, 2);
    fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 2, 1, 2);
    fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 4, 1, 2);
    fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 6, 1, 2);
    fpSpread1.ActiveSheet.AddColumnHeaderSpanCell(0, 0, 1, 8);
    FpSpread1.CellSpanSelectionPolicy = FarPoint.Win.Spread.CellSpanSelectionPolicy.Intersected
    FpSpread1.ActiveSheet.ColumnHeader.RowCount = 3
    ' Set the number of columns in the row header.
    FpSpread1.ActiveSheet.RowHeader.ColumnCount = 2
    ' Define the labels for the spanned column header cells.
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 0).Text = "East"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 1).Text = "West"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 2).Text = "East"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 3).Text = "West"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 4).Text = "East"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 5).Text = "West"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 6).Text = "East"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(2, 7).Text = "West"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 0).Text = "1st Quarter"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 2).Text = "2nd Quarter"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 4).Text = "3rd Quarter"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(1, 6).Text = "4th Quarter"
    FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "Fiscal Year 2004"
    ' Define the column header cell spans.
    FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 0, 1, 2)
    FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 2, 1, 2)
    FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 4, 1, 2)
    FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(1, 6, 1, 2)
    FpSpread1.ActiveSheet.AddColumnHeaderSpanCell(0, 0, 1, 8)
    See Also