Gets or sets the amount by which the value increments when using the spin buttons and the cursor is in the decimal portion.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Property SpinDecimalIncrement As Single |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As CurrencyCellType
Dim value As Single
instance.SpinDecimalIncrement = value
value = instance.SpinDecimalIncrement |
| C# | |
|---|
public float SpinDecimalIncrement {get; set;} |
Property Value
Numeric amount (
single-precision, floating-point number) by which to increment value
Remarks
Example
This example specifies a currency cell and sets spin button properties.
| C# | Copy Code |
|---|
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 | Copy Code |
|---|
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 |
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
