getCellValue

returns the value of the cell

string getCellValue(number row,number column,boolean math);

Parameters

row	number	the row number
column	number	the column number
math	boolean	if true returns the cell math value (if any)

Returns

string

the value of the cell

Example

var value = $$("ssheet").getCellValue(2, 3);

Details

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"