Spread Windows Forms 11.0 Product Documentation
CellSpanSelectionPolicy Property (FpSpread)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class : CellSpanSelectionPolicy Property
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

Reference

FpSpread Class
FpSpread Members

Developer's Guide

Creating a Span in a Header