Gets or sets which scroll bars to display for the text cell.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property ScrollBars As ScrollBars |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As TextCellType
Dim value As ScrollBars
instance.ScrollBars = value
value = instance.ScrollBars |
Property Value
ScrollBars setting that determines which scroll bars are displayed
Example
This example specifies how text can be displayed including the letter case, the length, and whether it can wrap to multiple lines.
| C# | Copy Code |
|---|
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.HotkeyPrefix = System.Drawing.Text.HotkeyPrefix.Show;
txt.MaxLength = 40;
txt.Multiline = true;
txt.PasswordChar = Convert.ToChar("*");
txt.ScrollBars = ScrollBars.Vertical;
txt.Static = true;
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 for handling
a large amount of data that a user might want to include" + " in a single cell."; |
| Visual Basic | Copy Code |
|---|
Dim txt As New FarPoint.Win.Spread.CellType.TextCellType()
txt.CharacterCasing = CharacterCasing.Upper
txt.CharacterSet = FarPoint.Win.Spread.CellType.CharacterSet.Ascii
txt.HotkeyPrefix = System.Drawing.Text.HotkeyPrefix.Show
txt.MaxLength = 40
txt.Multiline = True
txt.PasswordChar = "*"
txt.ScrollBars = ScrollBars.Vertical
txt.Static = True
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 for handling a large amount of data that a user might want to include" & _
" in a single cell." |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
