Text Property (ButtonCellType)

Visual Basic
C#

'Declaration
 
Public Property Text As String

'Usage
 
Dim instance As ButtonCellType
Dim value As String
 
instance.Text = value
 
value = instance.Text

public string Text {get; set;}

Property Value

String containing the text to display in the button

This example sets up a cell on the first sheet as a button cell and specifies the colors for the bottom and right-side of the button (DarkColor) and the top and left sides (LightColor) and the shadow and the text. It shows how the text can be different when the button is pressed (and held) and how text can wrap to multiple lines.

C#

FarPoint.Win.Spread.CellType.ButtonCellType bttncell = new FarPoint.Win.Spread.CellType.ButtonCellType();
bttncell.ButtonColor = Color.Cyan;
bttncell.DarkColor = Color.DarkCyan;
bttncell.LightColor = Color.AliceBlue;
bttncell.ShadowSize = 3;
bttncell.Text = "Click and hold...";
bttncell.TextDown = "...you can see how words go to multiple lines. Now let go.";
bttncell.TextColor = Color.Green;
bttncell.WordWrap = true;
bttncell.UseVisualStyleBackColor = false;
fpSpread1.Sheets[0].Cells[3,2].CellType = bttncell;

Visual Basic

Dim bttncell As New FarPoint.Win.Spread.CellType.ButtonCellType()
bttncell.ButtonColor = Color.Cyan
bttncell.DarkColor = Color.DarkCyan
bttncell.LightColor = Color.AliceBlue
bttncell.ShadowSize = 3
bttncell.Text = "Click and hold..."
bttncell.TextDown = "...you can see how words go to multiple lines. Now let go."
bttncell.TextColor = Color.Green
bttncell.WordWrap = True
bttncell.UseVisualStyleBackColor = False
fpSpread1.Sheets(0).Cells(3,2).CellType = bttncell

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

ButtonCellType Class
ButtonCellType Members