4D Doc Center : PV Get range property

Home

4D View v14

PV Get range property


PV Get range property ( area ; left ; top ; right ; bottom ; property ) -> Function result

Parameter	Type	Description
area	Longint	4D View area
left	Longint	Left cell column number
top	Longint	Top cell row number
right	Longint	Right cell column number
bottom	Longint	Bottom cell row number
property	Longint	Property number
Function result	Longint	Property value

Description

The PV Get range property command returns the value of the property for the selected cells defined using left, top, right and bottom parameters. For more information on cell ranges, refer to the PV Selection, Introduction section.

To define the property parameter, use the constants of the PV Style properties and PV Cell properties themes. For more information on these constants, see the description of the PV SET RANGE PROPERTY command.

Mixed values

For some properties, the PV Get range property may return the values 65535 or 255, which correspond to the "mixed" type constants of the PV Style values theme.
For instance, the statement :

$value:=PV Get range property(area;column;row;pv style color back even)

will return 65535 if the cells of the even-numbered rows in the range do not all have the same background color. This value corresponds to the pv value format mixed constant of the PV Style values theme. If the cells of the even-numbered rows in the range all have the same background color, the actual color number is returned.

This principle applies to the following properties:

Property	Value/Constant returned if mixed selection
pv style format alpha	65535 (pv value format mixed)
pv style format num	65535 (pv value format mixed)
pv style format bool	65535 (pv value format mixed)
pv style format date time	65535 (pv value format mixed)
pv style format picture	65535 (pv value format mixed)
pv style color back even	65535 (pv value format mixed)
pv style color back odd	65535 (pv value format mixed)
pv style color text even	65535 (pv value format mixed)
pv style color text odd	65535 (pv value format mixed)
pv style color zero even	65535 (pv value format mixed)
pv style color zero odd	65535 (pv value format mixed)
pv style hor alignment	255 (pv value hor alignment mixed)
pv style vert alignment	255 (pv value vert alignment mixed)
pv style rotation	255 (pv value rotation mixed)

Example

See the example for the PV Get cell property command.