Example

---

The following example adds cells A2 and A3 on sheet 2 and places the total in cell A1 on sheet 1.

C++

// Set number of sheets

m_Spread.SetSheetCount(3);

// Set properties for sheet 1

m_Spread.SetSheet(1);

m_Spread.SetSheetName("test");

m_Spread.SetAllowUserFormulas(TRUE);

m_Spread.SetMaxRows(5);
m_Spread.SetMaxCols(5);

m_Spread.SetCol(-1);

m_Spread.SetRow(-1);

m_Spread.SetCellType(13);

// Set properties for sheet 2

m_Spread.SetSheet(2);

m_Spread.SetSheetName("test2");

m_Spread.SetAllowUserFormulas(TRUE);

m_Spread.SetMaxRows(5);
m_Spread.SetMaxCols(5);

m_Spread.SetCol(-1);

m_Spread.SetRow(-1);

m_Spread.SetCellType(13);

m_Spread.SetSheet(1);

m_Spread.SetCol(1);

m_Spread.SetRow(1);
m_Spread.SetFormula("test2!A2+test2!A3");

Visual Basic

Private Sub Form_Load()

' Create sheets

fpSpread1.SheetCount = 3

' Set properties for sheet 1

fpSpread1.Sheet = 1

fpSpread1.SheetName = "test"

fpSpread1.AllowUserFormulas = True

fpSpread1.MaxCols = 5

fpSpread1.MaxRows = 5

fpSpread1.Col = -1

fpSpread1.Row = -1

fpSpread1.CellType = CellTypeNumber

' Set properties for sheet 2

fpSpread1.Sheet = 2

fpSpread1.SheetName = "test2"

fpSpread1.AllowUserFormulas = True

fpSpread1.MaxCols = 5

fpSpread1.MaxRows = 5

fpSpread1.Col = -1

fpSpread1.Row = -1

fpSpread1.CellType = CellTypeNumber

' Set formula for sheet 1 that uses sheet 2

fpSpread1.Sheet = 1

fpSpread1.Col = 1

fpSpread1.Row = 1

fpSpread1.Formula = "test2!A2+test2!A3"

End Sub