Skip to main content
Version: 20 R6 BETA

VP SET COLUMN ATTRIBUTES

VP SET COLUMN ATTRIBUTES ( rangeObj : Object ; propertyObj : Object)

ParameterTypeDescription
rangeObjObject->Range object
propertyObjObject->Object containing column properties

Description

The VP SET COLUMN ATTRIBUTES command applies the attributes defined in the propertyObj to the columns in the rangeObj.

In rangeObj, pass an object containing a range. If the range contains both columns and rows, attributes are applied only to the columns.

The propertyObj parameter lets you specify the attributes to apply to the columns in the rangeObj. These attributes are:

PropertyTypeDescription
widthnumberColumn width expressed in pixels
pageBreakbooleanTrue to insert a page break before the first column of the range, else false
visiblebooleanTrue if the column is visible, else false
resizablebooleanTrue if the column can be resized, else false
headertextColumn header text

Example

To change the size of the second column and set the header, you write:

C_OBJECT($column;$properties)

$column:=VP Column("ViewProArea";1) //column B
$properties:=New object("width";100;"header";"Hello World")

VP SET COLUMN ATTRIBUTES($column;$properties)

See also

VP Column
VP Get column attributes
VP Get row attributes
VP SET ROW ATTRIBUTES