Spread Windows Forms 12.0 Product Documentation
Static Property (EditBaseCellType)

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > EditBaseCellType Class : Static Property
Gets or sets whether the cell is static, which prohibits user interaction.
Public Property Static As Boolean
Dim instance As EditBaseCellType
Dim value As Boolean
instance.Static = value
value = instance.Static
public bool Static {get; set;}

Property Value

Boolean: true if cell is static (not allowing edit mode); false otherwise

When set to true, this property prohibits the user from entering edit mode when clicking on the cell. It forces the cell to be a label cell because it displays whatever text is set for this cell but does not allow the user to edit it.

Compare this with the Editable property (inherited), which turns on or off the ability to make changes in edit mode, but still allows edit mode to be entered.

This example sets the Static property.
FarPoint.Win.Spread.CellType.TextCellType txt = new FarPoint.Win.Spread.CellType.TextCellType();
txt.CharacterCasing = CharacterCasing.Upper;
txt.CharacterSet = FarPoint.Win.Spread.CellType.CharacterSet.Ascii;
txt.Multiline = true;
txt.ScrollBars = ScrollBars.Horizontal;
txt.Static = false;
fpSpread1.Sheets[0].Cells[0, 0].CellType = txt;
fpSpread1.Sheets[0].Cells[0, 0].Text = "This is a text cell.  It can provide a wide range of functionality.";
fpSpread1.Sheets[0].Columns[0].Width = 200;
fpSpread1.Sheets[0].Rows[0].Height = 50;
Dim txt As New FarPoint.Win.Spread.CellType.TextCellType()
txt.CharacterCasing = CharacterCasing.Upper
txt.CharacterSet = FarPoint.Win.Spread.CellType.CharacterSet.Ascii
txt.Multiline = True
txt.ScrollBars = ScrollBars.Horizontal
txt.Static = False
FpSpread1.Sheets(0).Cells(0, 0).CellType = txt
FpSpread1.Sheets(0).Cells(0, 0).Text = "This is a text cell.  It can provide a wide range of functionality."
FpSpread1.Sheets(0).Columns(0).Width = 200
FpSpread1.Sheets(0).Rows(0).Height = 50
See Also


EditBaseCellType Class
EditBaseCellType Members