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


In This Topic
    CharacterSet Property (TextCellType)
    In This Topic
    Gets or sets what characters to allow for the text cell.
    Syntax
    'Declaration
     
    Public Property CharacterSet As CharacterSet
    'Usage
     
    Dim instance As TextCellType
    Dim value As CharacterSet
     
    instance.CharacterSet = value
     
    value = instance.CharacterSet
    public CharacterSet CharacterSet {get; set;}

    Property Value

    CharacterSet setting that specifies the character set
    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