The single cell or table of cells in the sheet corner can be customized. You can set the cells to any of the cell type that are supported by Spread. You can customize properties of Cell also. The customization now can do through writing customize cell code

You can change the cell type of the cells in the sheet corner by setting a new cell type for SheetCornerStyle property of the sheet (SheetView class). When you set the SheetCornerStyle.CellType, all the cells in the sheet corner are changed to that type.

Example (Set Check Box in Style)

Here is the code for setting the sheet corner to have the cells have a check box cell type by setting the sheet corner style (as shown in the figure above).

fpSpread1.ActiveSheet.AllowTableCorner = true;
fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4;
fpSpread1.ActiveSheet.SheetCorner.RowCount = 5;
fpSpread1.ActiveSheet.SheetCornerStyle.CellType = new CheckBoxCellType();

FpSpread1.ActiveSheet.AllowTableCorner = True
FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4
FpSpread1.ActiveSheet.SheetCorner.RowCount = 5
FpSpread1.ActiveSheet.SheetCornerStyle.CellType = New CheckBoxCellType()

Example (Set Button in Cells)

Here is the code for setting the sheet corner to have the cells have a button cell type by simply assigning the button cell type to the cells in the sheet corner (as shown in the figure above).

fpSpread1.ActiveSheet.AllowTableCorner = true;
fpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4;
fpSpread1.ActiveSheet.SheetCorner.RowCount = 5;
fpSpread1.ActiveSheet.SheetCorner.Cells[2,3].CellType = new ButtonCellType();

FpSpread1.ActiveSheet.AllowTableCorner = True
FpSpread1.ActiveSheet.SheetCorner.ColumnCount = 4
FpSpread1.ActiveSheet.SheetCorner.RowCount = 5
FpSpread1.ActiveSheet.SheetCorner.Cells(2,3).CellType = New ButtonCellType()

Copyright © GrapeCity, inc. All rights reserved.