Spread Windows Forms 11.0 Product Documentation
Static Property (EditBaseCellType)
Example 


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.
Syntax
'Declaration
 
Public Property Static As Boolean
'Usage
 
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
Remarks

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.

Example
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

Reference

EditBaseCellType Class
EditBaseCellType Members