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)
$cell = new SpreadSheetCell($res, "1","B1", $db_prefix);
$cell->setValue("=(8+10)/2");
$parsedValue = $cell->getValue(); // -> =(8+10)/2
$calcValue = $cell->getCalculatedValue(); // -> 9
Back to top