setCellFormula

Jump to bottom Edit New page

Julian Halliwell edited this page Sep 20, 2021 · 5 revisions

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 );