Cell spans are supported in the sheet corner. Any number of rows and columns of cells can be selected and merged to create cell spans. You can set spans of cells in rows or columns or both.
For more information on creating cell spans, refer to Creating a Span of Cells.
Example
The following code creates a span of row cells and a span of column cells in the sheet corner.
| C# |
Copy Code
|
|---|---|
fpSpread1.ActiveSheet.AllowTableCorner = true;
fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 6;
fpSpread1.ActiveSheet.SheetCorner.RowCount = 7;
fpSpread1.ActiveSheet.SheetCorner.Cells[1, 2].ColumnSpan = 3;
fpSpread1.ActiveSheet.SheetCorner.Cells[1, 2].RowSpan = 4;
|
|
| VB |
Copy Code
|
|---|---|
FpSpread1.ActiveSheet.AllowTableCorner = True
FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 6
FpSpread1.ActiveSheet.SheetCorner.RowCount = 7
FpSpread1.ActiveSheet.SheetCorner.Cells(1, 2).ColumnSpan = 3
FpSpread1.ActiveSheet.SheetCorner.Cells(1, 2).RowSpan = 4
|
|
See Also