Aller au contenu principal
Version: 20 R6 BETA

VP Get formula

VP Get formula ( rangeObj : Object) : Text

ParamètresTypeDescription
rangeObjObject->Objet plage
RésultatText<-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)"

Voir également

VP Get formulas
VP SET FORMULA
VP SET ROW COUNT