TwoState Property (ButtonCellType)

Visual Basic
C#

'Declaration
 
Public Property TwoState As Boolean

'Usage
 
Dim instance As ButtonCellType
Dim value As Boolean
 
instance.TwoState = value
 
value = instance.TwoState

public bool TwoState {get; set;}

Property Value

Boolean: true if button behaves as a two-state button; false for one-state button

By default the button cell acts like a push button, which you can press by clicking the left button of the mouse. It does not stay pressed when you release the mouse button. (This is a one-state button.) If you prefer, you can set this property to true and the button cell acts like toggle, or two-state, button. In this case, it stays pressed when you click it with the left mouse 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