| 4D v18VP Get values | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| 
 | 
    4D v18
 VP Get values 
         | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| VP Get values ( rangeObj ) -> Function result | ||||||||
| Parameter | Type | Description | ||||||
| rangeObj | Object |   | Range object | |||||
| Function result | Collection |   | Collection of values | |||||
The VP Get values command retrieves the values from the designated rangeObj.
In rangeObj, pass a range whose values you want to retrieve. If rangeObj includes multiple ranges, only the first range is used.
The collection returned by VP Get values contains a two-dimensional collection:
| Property | Type | Description | 
| value | Date | Value in the cell (except- time) | 
| time | Real | Time value (in seconds) if the value is of the js date type | 
You want to get values from C4 to G6:

 $result:=VP Get values(VP Cells("ViewProArea";2;3;5;3))
  // $result[0]=[4,5,null,hello,world]
  // $result[1]=[6,7,8,9,null]
  // $result[2]=[null,{time:42,value:2019-05-29T00:00:00.000Z},null,null,null]
	Product:  4D
	Theme:  4D View Pro Language
	Number:  
        9773
        
        
        
	
	Created:  4D v17 R6
	
	4D View Pro Reference ( 4D v18)
	
	
	
 Add a comment
Add a comment