Spread Windows Forms 10.0 Product Documentation > Developer's Guide > Customizing Row, Column, and Cell Appearance > Customizing the Appearance of Headers > Creating a Span in a Header |
You can create cell spans in a header, for example, to make a header for multiple columns or rows, or both, as shown in the figure below.
You can create cell spans in either the column headers or row headers or both. For more background about creating cell spans, refer to Creating a Span of Cells.
Use these methods when creating a span in a header:
You can specify how the header spans are selected with the CellSpanSelectionPolicy property.
For information on creating multiple rows in the column headers or multiple columns in the row headers, refer to Creating a Header with Multiple Rows or Columns.
You can customize the labels in these headers. For instructions for customizing the labels, see Customizing Header Label Text.
Call the Sheets object AddColumnHeaderSpanCell or AddRowHeaderSpanCell method.
This example code sets the first cell in the column header to span across two columns.
C# |
Copy Code
|
---|---|
// Set the number of rows in the column header. 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); // Define the label for the spanned row header cells. FpSpread1.ActiveSheet.RowHeader.Cells[0,0].Text ="Branch #"; // Define the row header cell span. FpSpread1.ActiveSheet.AddRowHeaderSpanCell(0, 0, 12, 1); |
VB |
Copy Code
|
---|---|
' Set the number of rows in the column header. 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) ' Define the label for the spanned row header cells. FpSpread1.ActiveSheet.RowHeader.Cells(0,0).Text ="Branch #" ' Define the row header cell span. FpSpread1.ActiveSheet.AddRowHeaderSpanCell(0, 0, 12, 1) |