CharacterSet Property (TextCellType)

Visual Basic
C#

'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

This example specifies how text can be displayed including the letter case and whether it can wrap to multiple lines.

C#

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;

Visual Basic

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

Reference

TextCellType Class
TextCellType Members
CharacterSet Enum

User-Task Documentation

Setting a Text Cell