Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / TextCellType Class / ScrollBars Property

In This Topic
    ScrollBars Property (TextCellType)
    In This Topic
    Gets or sets which scroll bars to display for the text cell.
    Public Property ScrollBars As ScrollBars
    Dim instance As TextCellType
    Dim value As ScrollBars
    instance.ScrollBars = value
    value = instance.ScrollBars
    public ScrollBars ScrollBars {get; set;}

    Property Value

    ScrollBars setting that determines which scroll bars are displayed
    This example displays a scrollbar if the cell is in edit mode.
    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