SpinButton Property (CurrencyCellType)

Gets or sets whether a spin button is displayed when editing.

Syntax

Visual Basic
C#

'Declaration
 
Public Property SpinButton As Boolean

'Usage
 
Dim instance As CurrencyCellType
Dim value As Boolean
 
instance.SpinButton = value
 
value = instance.SpinButton

public bool SpinButton {get; set;}

Property Value

Boolean: true to display spin buttons; false otherwise

Example

This example specifies a currency cell and sets spin button properties.

FarPoint.Win.Spread.CellType.CurrencyCellType crcycell = new FarPoint.Win.Spread.CellType.CurrencyCellType();
crcycell.SpinButton = true;
crcycell.SpinDecimalIncrement = 0.5F;
crcycell.SpinIntegerIncrement = 5;
crcycell.SpinWrap = true;
crcycell.MaximumValue = 500;
crcycell.MinimumValue = -100;
fpSpread1.Sheets[0].Cells[6,2].CellType = crcycell;
fpSpread1.Sheets[0].Cells[6,2].Value = 443.3482;

Visual Basic

Dim curr As New FarPoint.Win.Spread.CellType.CurrencyCellType()
curr.SpinButton = True
curr.SpinDecimalIncrement = 0.5
curr.SpinIntegerIncrement = 5
curr.SpinWrap = True
curr.MaximumValue = 500
curr.MinimumValue = -100
fpSpread1.ActiveSheet.Cells(0, 0).CellType = curr
fpSpread1.ActiveSheet.Cells(0, 0).Value = 443.3482

Reference

CurrencyCellType Class
CurrencyCellType Members

User-Task Documentation

Displaying Spin Buttons