VP SET VALUES

Home

4D v18

VP SET VALUES


VP SET VALUES ( rangeObj ; valuesCol )

Parameter	Type	Description
rangeObj	Object	Cell range object
valuesCol	Collection	Collection of values

Description

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:

If rangeObj is not a cell range, only the first cell of the range is used.
If rangeObj includes multiple ranges, only the first cell of the first range is used.

The valuesCol parameter is two-dimensional:

The first-level collection contains subcollections of values. Each subcollection defines a row. Pass an empty collection to skip a row.
Each subcollection defines cell values for the row. Values can be Longint, Real, Boolean, Text, Date, Null, or Object. If the value is an object, it can have the following properties:

Property Type Description
value Longint, Real, Boolean, Text, Date, Null Value in the cell (except- time)
time Real Time value (in seconds)

Example

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: