VP Get cell style

Home

4D v18

VP Get cell style


VP Get cell style ( rangeObj ) -> Function result

Parameter	Type	Description
rangeObj	Object	Range object
Function result	Object	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
}