Skip to main content
Version: 20 R6 BETA

VP Get cell style

VP Get cell style ( rangeObj : Object ) : Object

ParameterTypeDescription
rangeObjObject->Range object
ResultObject<-Style object

Description

The VP Get cell style command returns a style object for the first cell in the rangeObj.

In rangeObj, pass a range containing the style to retrieve.

  • If rangeObj contains a cell range, the cell style is returned.
  • If rangeObj contains a range that is not a cell range, the style of the first cell in the range is returned.
  • If rangeObj contains several ranges, only the style of the first cell in the first range is returned.

Example

To get the details about the style in the selected cell (B2):

This code:

$cellStyle:=VP Get cell style(VP Get selection("myDoc"))

... will return this object:

{
"backColor":"Azure",
"borderBottom":
{
"color":#800080,
"style":5
}
"font":"8pt Arial",
"foreColor":"red",
"hAlign":1,
"isVerticalText":"true",
"vAlign":0
}

See also

VP GET DEFAULT STYLE
VP SET CELL STYLE