Example

The following example creates a sheet of number cells. Numbers in the cells use a carat (^) as the decimal character and a asterisk (*) as the separator character, display a leading zero and the separator character, and use parentheses to denote a negative number.

C++

m_Spread1.Col(-1);
m_Spread1.Row(-1);
m_Spread1.ColWidth(-1,12);
m_Spread1.CellType(CellTypeNumber);
m_Spread1.TypeNumberDecimal("^");
m_Spread1.TypeNumberLeadingZero(TypeLeadingZeroYes);
m_Spread1.TypeNumberMin(-1000);
m_Spread1.TypeNumberNegStyle(TypeNumberNegStyle1);
m_Spread1.TypeNumberSeparator("*");
m_Spread1.TypeNumberShowSep(TRUE);

Visual Basic

fpSpread1.Col = -1
fpSpread1.Row = -1
fpSpread1.ColWidth(-1) = 12
fpSpread1.CellType = CellTypeNumber
fpSpread1.TypeNumberDecimal = "^"
fpSpread1.TypeNumberLeadingZero = TypeLeadingZeroYes
fpSpread1.TypeNumberMin = -1000
fpSpread1.TypeNumberNegStyle = TypeNumberNegStyle1
fpSpread1.TypeNumberSeparator = "*"
fpSpread1.TypeNumberShowSep = True