Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / EditBaseCellType Class / Static Property

In This Topic
    Static Property (EditBaseCellType)
    In This Topic
    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