Spread Windows Forms 10.0 Product Documentation
Table Display in the Sheet Corner

The sheet corner can have a table or grid display with columns and rows of cells, though cells are not editable. You can set the sheet corner to a table (range) display or a single cell display with the AllowTableCorner property of the sheet (SheetView class).

The sheet corner also supports cell spans in the table display.

When you set the AllowTableCorner property of the sheet to true, the sheet corner displays as a table with the number of columns equal to the number of row headers of the sheet and the number of rows equal to the number of column headers of the sheet. The following figure illustrates a table sheet corner display:

table sheet corner display

When you set the AllowTableCorner property of the sheet to false, the first cell of the sheet corner spans the entire area of the sheet corner, based on the number of columns and rows set for the corner. The following figure illustrates a single-cell sheet corner display:

sheet corner with single-cell display (no table)

Example

The following code sets the sheet corner to appear as a table.

C#
Copy Code
fpSpread1.ActiveSheet.AllowTableCorner = true;
fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4;
fpSpread1.ActiveSheet.SheetCorner.RowCount = 5; 
VB
Copy Code
FpSpread1.ActiveSheet.AllowTableCorner = True
FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4
FpSpread1.ActiveSheet.SheetCorner.RowCount = 5 

Example

The following code sets the sheet corner to appear as a single cell.

C#
Copy Code
fpSpread1.ActiveSheet.AllowTableCorner = false;
fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4;
fpSpread1.ActiveSheet.SheetCorner.RowCount = 5; 
VB
Copy Code
FpSpread1.ActiveSheet.AllowTableCorner = False
FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4
FpSpread1.ActiveSheet.SheetCorner.RowCount = 5 
See Also

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options | Documentation Feedback