returns the value of the cell
row | number | the row number |
column | number | the column number |
math | boolean | if true returns the cell math value (if any) |
string | the value of the cell |
var value = $$("ssheet").getCellValue(2, 3);
If the math parameter is true the method will return the math value from the specified cell. If there is no math value, the cell value itself will be returned. The parameter is false by default.
// assuming the cell value (A1) is "=5"
$$("ssheet").getCellValue(1,1); // "5"
$$("ssheet").getCellValue(1,1, true); // "=5"