Spread Windows Forms 11.0 Product Documentation
CharacterCasing Property (TextCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > TextCellType Class : CharacterCasing Property
Gets or sets the case of characters in the text cell.
Syntax
'Declaration
 
Public Property CharacterCasing As CharacterCasing
'Usage
 
Dim instance As TextCellType
Dim value As CharacterCasing
 
instance.CharacterCasing = value
 
value = instance.CharacterCasing
public CharacterCasing CharacterCasing {get; set;}

Property Value

CharacterCasing setting that determines the casing of characters
Example
This example specifies how text can be displayed including the letter case and whether it can wrap to multiple lines.
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

TextCellType Class
TextCellType Members