VP Get formula
VP Get formula ( rangeObj : Object) : Text
| Parâmetro | Tipo | Descrição | ||
|---|---|---|---|---|
| rangeObj | Object | -> | Objeto intervalo | |
| Resultados | Text | <- | Formula |
Descrição
The VP Get formula command retrieves the formula from a designated cell range.
In rangeObj, pass a range whose formula you want to retrieve. If rangeObj designates multiple cells or multiple ranges, the formula of the first cell is returned. If rangeObj is a cell that does not contain a formula, the method returns an empty string.
Exemplo
//set a formula
VP SET FORMULA(VP Cell("ViewProArea";5;2);"SUM($A$1:$C$10)")
$result:=VP Get formula(VP Cell("ViewProArea";5;2)) // $result="SUM($A$1:$C$10)"