setCellFormula

Sets the formula for a cell.

setCellFormula( workbook, formula, row, column )

Required arguments

• workbook spreadsheet object
• formula string
• row numeric
• column numeric

Chainable? Yes.

Example

spreadsheet = New spreadsheet();
workbook = spreadsheet.new();
spreadsheet.addColumn( workbook, "1, 1" );
spreadsheet.setCellFormula( workbook, "SUM(A1:A2)", 3, 1 );