The PivotOpenXlsxStyle class specifies the styling for cells in an Excel worksheet.

## Format

R6Class object.

## Active bindings

baseStyleName

The name of the base style in the pivot table.

isBaseStyle

TRUE when this style is the equivalent of a named style in the pivot table, FALSE if this style has additional settings over and above the base style of the same name.

fontName

The name of the font (single font name, not a CSS style list).

fontSize

The size of the font (units: point, 4-72).

bold

TRUE if text is bold.

italic

TRUE if text is italic.

underline

TRUE if text is underlined.

strikethrough

TRUE if text has a line through it.

superscript

TRUE if text is small and raised.

subscript

TRUE if text is small and lowered.

fillColor

The background colour for the cell (as a hex value, e.g. #00FF00).

textColor

The color of the text (as a hex value).

hAlign

The horizontal alignment of the text: left, center or right.

vAlign

The vertical alignment of the text: top, middle or bottom.

wrapText

TRUE if the text is allowed to wrap onto multiple lines.

textRotation

The rotation angle of the text (0 to 359) or 255 for vertical.

indent

Horizontal indentation of cell contents (0 to 250.).

borderAll

A list (with elements style and color) specifying the border settings for all four sides of each cell at once.

borderLeft

A list (with elements style and color) specifying the border settings for the left border of each cell.

borderRight

A list (with elements style and color) specifying the border settings for the right border of each cell.

borderTop

A list (with elements style and color) specifying the border settings for the top border of each cell.

borderBottom

A list (with elements style and color) specifying the border settings for the bottom border of each cell.

valueFormat

The Excel formatting applied to the field value. One of the following values: GENERAL, NUMBER, CURRENCY, ACCOUNTING, DATE, LONGDATE, TIME, PERCENTAGE, FRACTION, SCIENTIFIC, TEXT, COMMA. Or for dates/datetimes, a combination of d, m, y. Or for numeric values, use a numeric format code such as 0.00, #,###.00, etc

minColumnWidth

The minimum width of this column (0 to 255).

minRowHeight

The minimum height of this row (0 to 400).

openxlsxStyle

The style object returned from openxlsx::createStyle().

## Methods

### Method new()

Create a new PivotOpenXlsxStyle object.

#### Arguments

baseStyleName

The name of the style to match.

No return value.

### Method isFullStyleDetailMatch()

Test whether a style has matching style attributes.

#### Returns

No return value. Retrieve the style using the openxlsxStyle property.

### Method asList()

Return the contents of this object as a list for debugging.

#### Returns

A JSON representation of various object properties.

### Method asString()

Return a representation of this object as a character value.

#### Arguments

deep

Whether to make a deep clone.

## Examples

# PivotOpenXlsxStyle objects are created by the PivotOpenXlsxRenderer class.
# See that class for details.