| 4D v18VP SET FORMULAS | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 
 | 
    4D v18
 VP SET FORMULAS 
         | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| VP SET FORMULAS ( rangeObj ; formulasCol ) | ||||||||
| Parameter | Type | Description | ||||||
| rangeObj | Object |   | Cell range object | |||||
| formulasCol | Collection |   | Collection of formulas | |||||
The VP SET FORMULAS command assigns a collection of formulas starting at the specified cell range.
In rangeObj, pass a range of the cell (created with VP Cell) whose formula you want to specify. If rangeObj includes multiple ranges, only the first range is used.
The formulasCol is a two-dimensional collection:
This code:
 $formulas:=New collection
 $formulas.push(New collection("MAX(B11,C11,D11)";"myMethod(G4)")) // First row
 $formulas.push(New collection("SUM(B11:D11)";"AVERAGE(B11:D11)")) // Second row
 
 VP SET FORMULAS(VP Cell("ViewProArea";6;3);$formulas) // Set the cells with the formulaswill set the formulas in the designated range:
 
 
myMethod:
 $0:=$1*3.33
	Product:  4D
	Theme:  4D View Pro Language
	Number:  
        9774
        
        
        
	
	Created:  4D v17 R6
	
	4D View Pro Reference ( 4D v18)
	
	
	
 Add a comment
Add a comment