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


In This Topic
    ScrollBars Property (TextCellType)
    In This Topic
    Gets or sets which scroll bars to display for the text cell.
    Syntax
    'Declaration
     
    Public Property ScrollBars As ScrollBars
    'Usage
     
    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
    Example
    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