VP SET NUM VALUE

Home

4D v19

VP SET NUM VALUE


VP SET NUM VALUE ( rangeObj ; numberValue {; formatPattern} )

Parameter	Type	Description
rangeObj	Object	Range object
numberValue	Longint, Real	Number value to set
formatPattern	Text	Format of value

Description

The VP SET NUM VALUE command assigns a specified numeric value to a designated cell range.

In rangeObj, pass a range of the cell(s) (created for example with VP Cell or VP Column) whose value you want to specify. If rangeObj includes multiple cells, the value specified will be repeated in each cell.

The numberValue parameter specifies a numeric value to be assigned to the rangeObj.

The optional formatPattern defines a pattern for the numberValue parameter. For information on patterns and formatting characters, please refer to the 4D View Pro Cell Format section.

Example

  //Set the cell value to 2

 VP SET NUM VALUE(VP Cell("ViewProArea";3;2);2)

 

  //Set the cell value and format it in dollars

 VP SET NUM VALUE(VP Cell("ViewProArea";3;2);12.356;"_($* #,##0.00_)")