VP Get value

4D v19

VP Get value


VP Get value ( rangeObj ) -> Resultado

Parâmetro	Tipo	Descrição
rangeObj	Objeto	Range object
Resultado	Objeto	Object containing a cell value

Descrição

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.

Exemplo

 $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

Ver também

VP Get values
VP SET VALUE
VP SET VALUES