VP Get formula

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

4D v19

VP Get formula


VP Get formula ( rangeObj ) -> Function result

Parameter	Type	Description
rangeObj	Object	Range object
Function result	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 command returns an empty string.

Example

  //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)"