SSpread.TypeCurrencyMin Property

Set the maximum value that can be entered in a currency type cell.

Only valid for cells with the CellType property set to $CellTypeCurrency(currency type). Before setting this property, use the Col , Row properties etc. to specify what you want to process.

The initial value is -9999999.99 .

The upper limit is specified by the TypeCurrencyMax property. The spin button displayed by the TypeSpin property allows you to increase or decrease the value within the specified range. When the TypeSpinWrap property is set to $TRUE , the values ​​that have reached the upper and lower limits are wrapped.

This property is subject to property inheritance of currency type cells.

Precautions for specifying the range based on the lower and upper limits

Use case

Col = 3;
Row = 2;
CellType = $CellTypeCurrency;
TypeCurrencyMin = 0;
TypeCurrencyMax = 100;
Value = 0;
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
CellType = $CellTypeCurrency;
TypeCurrencyMin = -100;
TypeCurrencyMax = 100;
Value = 0;
BlockMode = $FALSE;

Related item
CellType , TypeCurrencyMax , TypeSpin , TypeSpinWrap property