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
Return to the overview of Customizing the Sheet Corner Appearance
Example
Here is the code for setting 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
|
|