Example

The following example creates a scientific cell that allows three decimal places and has a custom decimal character and maximum and minimum values.

C++

// Set sheets
m_Spread.SetSheetCount(3);
// Set coordinates for cell type
m_Spread.SetSheet(1);
m_Spread.SetCol(1);
m_Spread.SetRow(1);
// Set cell type to scientific
m_Spread.SetCellType(CellTypeScientific);
// Set cell type properties
m_Spread.SetTypeScientificDecimal("R");
m_Spread.SetTypeScientificDecPlaces(3);
m_Spread.SetTypeScientificMax(1E+20);
m_Spread.SetTypeScientificMin(-1E+20);

Visual Basic

' Set sheets
fpSpread1.SheetCount = 3
' Set coordinates for cell type
fpSpread1.Sheet = 1
fpSpread1.Col = 1
fpSpread1.Row = 1
' Set cell type
fpSpread1.CellType = CellTypeScientific
' Set cell type properties
fpSpread1.TypeScientificDecimal = "R"
fpSpread1.TypeScientificDecPlaces = 3
fpSpread1.TypeScientificMax = 1E+20
fpSpread1.TypeScientificMin = -1E+20