VP Get value

Home

4D v18

VP Get value


VP Get value ( rangeObj ) -> Function result

Parameter	Type	Description
rangeObj	Object	Range object
Function result	Object	Object containing a cell value

Description

The VP Get value command retrieves a cell value from a designated cell range.

In rangeObj, pass a range whose value you want to retrieve.

The object returned will contain the value property, as well as a time property in case of date value:

Property	Type	Description
value	Longint, Real, Boolean, Text, Date	Value in the rangeObj (except- time)
time	Real	Time value (in seconds) if rangeObj if the value is of the js date type

If the object returned includes a date or time, it is treated as a datetime and completed as follows:

time value - the date portion is completed as December 30, 1899 in dd/MM/yyyy format (30/12/1899)
date value - the time portion is completed as midnight in HH:mm:ss format (00:00:00)

If rangeObj contains multiple cells or multiple ranges, the value of the first cell is returned. The command returns a null object if the cell is empty.

Example

 $cell:=VP Cell("ViewProArea";5;2)

 $value:=VP Get value($cell)

 If(Value type($value.value)=Is text)

    VP SET TEXT VALUE($cell;New object("value";Uppercase($value.value))

 End if