| 4D v18VP SET VALUES | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 
 | 
    4D v18
 VP SET VALUES 
         | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| VP SET VALUES ( rangeObj ; valuesCol ) | ||||||||
| Parameter | Type | Description | ||||||
| rangeObj | Object |   | Cell range object | |||||
| valuesCol | Collection |   | Collection of values | |||||
The VP SET VALUES command assigns a collection of values starting at the specified cell range.
In rangeObj, pass a range of the cell (created with VP Cell) whose value you want to specify. The cell defined in the rangeObj is used to determine the starting point.
Notes:
The valuesCol parameter is two-dimensional:
| Property | Type | Description | 
| value | Longint, Real, Boolean, Text, Date, Null | Value in the cell (except- time) | 
| time | Real | Time value (in seconds) | 
The following code:
 $param:=New collection
 $param.push(New collection(1;2;3;False)) //first row, 4 values
 $param.push(New collection) //second row, untouched
 $param.push(New collection(4;5;Null;"hello";"world")) // third row, 5 values
 $param.push(New collection(6;7;8;9)) // fourth row, 4 values
 $param.push(New collection(Null;New object("value";Current date;"time";42))) //fifth row, 1 value
 VP SET VALUES(VP Cell("ViewProArea";2;1);$param)... produces the following result:

									VP Get formulas
									
									VP Get value
									
									VP Get values
									
									VP SET FORMULAS
									
									VP SET VALUE
									
	Product:  4D
	Theme:  4D View Pro Language
	Number:  
        9772
        
        
        
	
	Created:  4D v17 R6
	
	4D View Pro Reference ( 4D v18)
	
	
	
 Add a comment
Add a comment