setCellFormula

Sets the formula for a cell.

setCellFormula( workbook, formula, row, column )

Required arguments

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

Example

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