VP Get formula
VP Get formula ( rangeObj : Object) : Text
| Paramètres | Type | Description | ||
|---|---|---|---|---|
| rangeObj | Object | -> | Objet plage | |
| Résultat | Text | <- | Formula |
Description
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.
Exemple
//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)"