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


In This Topic
    CharacterCasing Property (TextCellType)
    In This Topic
    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