Spread Windows Forms 11.0 Product Documentation
SpinButton Property (CurrencyCellType)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread.CellType Namespace > CurrencyCellType Class : SpinButton Property
Gets or sets whether a spin button is displayed when editing.
Syntax
'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;
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
See Also

Reference

CurrencyCellType Class
CurrencyCellType Members

User-Task Documentation

Displaying Spin Buttons