Check documentation for the latest version of dhtmlxSuite getCalculatedValue DHTMLX Docs

getCalculatedValue

Returns the calculated value of the cell (if a formula is specified for the cell the method returns the calculated value, not the formula text)

Return value

  • (string or false) the cell value or false if the specified cell doesn't exist

Example

$cell = new SpreadSheetCell($res, "1","B1", $db_prefix);
$cell->setValue("=(8+10)/2");
 
$parsedValue = $cell->getValue();  // ->  =(8+10)/2
$calcValue = $cell->getCalculatedValue(); // -> 9

See also: calculate, getValue

Back to top