Gets or sets how the text aligns itself in relation to the button image.
Syntax
Example
This example sets up a cell in the first sheet as a two-state button cell (so each time the user clicks on it, it toggles) with the Picture image displayed in one state and PictureDown image displayed in the other state. The text is displayed above the image in the button.
| C# |  Copy Code |
|---|
FarPoint.Win.Spread.CellType.ButtonCellType butncell = new FarPoint.Win.Spread.CellType.ButtonCellType();
butncell.TwoState = true;
Image upimage;
Image dnimage;
upimage = Image.FromFile("..\\images\\up.jpg");
dnimage = Image.FromFile("..\\images\\down.jpg");
butncell.Picture = upimage;
butncell.PictureDown = dnimage;
butncell.TextAlign = FarPoint.Win.ButtonTextAlign.TextTopPictBottom;
butncell.Text = "Now up - Click";
butncell.TextDown ="Now down - Click";
fpSpread1.Sheets[0].Cells[4,2].CellType = butncell; |
| Visual Basic | Copy Code |
|---|
Dim butncell As New FarPoint.Win.Spread.CellType.ButtonCellType()
butncell.TwoState = True
Dim upimage As Image
Dim dnimage As Image
butncell.Picture = upimage.FromFile("..\images\up.jpg")
butncell.PictureDown = dnimage.FromFile("..\images\down.jpg")
butncell.TextAlign = FarPoint.Win.ButtonTextAlign.TextTopPictBottom
butncell.Text = "Now up - Click"
butncell.TextDown ="Now down - Click"
fpSpread1.Sheets(0).Cells(4,2).CellType = butncell |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2
See Also
