| 4D v18VP Get formulas | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 
 | 
    4D v18
 VP Get formulas 
         | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| VP Get formulas ( rangeObj ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| rangeObj | Object |   | Range object | |||||
| Function result | Collection |   | Collection of formula values | |||||
The VP Get formulas command retrieves the formulas from a designated rangeObj.
In rangeObj, pass a range whose formulas you want to retrieve. If rangeObj designates multiple ranges, the formula of the first range is returned. If rangeObj does not contain any formulas, the command returns an empty string.
The returned collection is two-dimensional:
You want to retrieve the formulas in the Sum and Average columns from this document:

You can use this code:
 $formulas:=VP Get formulas(VP Cells("ViewProArea";5;1;2;3))
  //$formulas[0]=[Sum(B2:D2),Average(B2:D2)]
  //$formulas[1]=[Sum(B3:D3),Average(B3:D3)]
  //$formulas[2]=[Sum(B4:D4),Average(C4:D4)]
	Product:  4D
	Theme:  4D View Pro Language
	Number:  
        9775
        
        
        
	
	Created:  4D v17 R6
	
	4D View Pro Reference ( 4D v18)
	
	
	
 Add a comment
Add a comment