VP SET CELL STYLE

Home

4D v18

VP SET CELL STYLE


VP SET CELL STYLE ( rangeObj ; styleObj )

Parameter	Type	Description
rangeObj	Object	Range object
styleObj	Object	Style object

Description

The VP SET CELL STYLE command applies the style(s) defined in the styleObj to the cells defined in the rangeObj.

In rangeObj, pass a range of cells where the style will be applied. If the rangeObj contains multiple cells, the style is applied to each cell.

The styleObj parameter lets you pass an object containing style settings. You can use an existing style sheet or create a new style. If the styleObj contains both an existing style sheet and additional style settings, the existing style sheet is applied first, followed by the additional settings. Giving the styleObj parameter a NULL value will remove any style settings from the rangeObj and revert to the default style settings (if any).

For more information about style objects and style sheets, see 4D View Pro Style Objects and Style Sheets.

Example

The following code:

 $style:=New object

 $style.font:="8pt Arial"

 $style.backColor:="Azure"

 $style.foreColor:="red"

 $style.hAlign:=1

 $style.isVerticalText:=True

 $style.borderBottom:=New object("color";"#800080";"style";vk line style thick)

 

 VP SET CELL STYLE(VP Cell("ViewProArea";1;1);$style)

Will result in the following display:

Note: Borders applied with VP SET CELL STYLE will be applied to each cell of the rangeObj, as opposed to the VP SET BORDER command which applies borders to the rangeObj as a whole.