Named styles

Styles

The containing element for Style definitions.

All expressions supplied for property values on this element, and any descendants, will be resolved in the context of the ClassLibrary node (see Context nodes and expression syntax).

Style

geicl:id

Assign an identifier to the style, which can be used to reference the style elsewhere in the configuration.

All items inside a collection element, such as Styles must have an identifier which is unique within the containing collection

Alignment

horizontal

Specifies how text in a cell should be aligned horizontally. Valid values are those supported by Microsoft Excel:

vertical

Specifies how text in a cell should be aligned vertically. Valid values are those supported by Microsoft Excel:

textRotation

Specifies how text in a cell should be rotated in number of degrees, from -90 to 90. Default value "0" will render the text horizontally

shrinkToFit

Specifies whether the font size of the text in a cell should be shrinked ("true") until the text fit within the cell boundaries. Default value is "false"

wrapText

Specifies whether text in a cell should be wrapped ("true") to fit within the cells width. Default values is "false".

If you specify wrapText="true", you can include the newline character ("\n") in a cell to force line break.

Borders

diagonalUp

Specifies whether a Diagonal border should go from bottom-left to top-right corner of a cell ("true"). The default value is "false"

You must specify style and color for the Diagonal border (see below), to get a diagonal border in the cell

diagonalDown

Specifies whether a Diagonal border should go from top-left to bottom-right corner of a cell ("true"). The default value is "false".

You must specify style and color for the Diagonal border (see below), to get a diagonal border in the cell.

If you set both diagonalUp and diagonalDown to "true" you will get a cell border looking like a cross

Bottom

Diagonal

Left

Right

Top

style

Specifies the style of the bottom/diagonal/left/right/top border of a cell. Valid values are those supported by Microsoft Excel:

color

Specifies the colour of the bottom cell border. There are two options on how to specify a colour value:

Hexadecimal: color="#000000"
The first two digits specifies the amount of Red colour, the next two digits specifies the amount of Green colour, and the last two digits specifies the amount of Blue colour.
The value for each primary colour is hexadecimal, and can range from "00" to "ff", case insensitive

RedGreenBlue (RGB): color="rgb(255,255,255)"
The first value specifies the amount of Red colour, the next value specifies the amount of Green colour, and the last value specifies the amount of Blue colour.
The value for each primary colour can range from "0" to "255".

You can get assistance from Microsoft Excel to find the RGB values:

Select a cell having the fill colour of your choice, click the Fill Colour button in the ribbon, select More Colors… in the menu

Click on the tab named Custom, and there you will see the RGB values for the selected colour:

Fill

pattern

Specifies what pattern to use for the fill colour of the cell. Valid values are those supported by Microsoft Excel:

patternColor

Specifies what colour to use for the pattern. The colour value is specified the same way as for border colour (see above)

backgroundColor

Specifies what colour to use for the background of the cell. This value has effect only for patterns that do not cover the cell entirely (i.e. no effect when using pattern Solid). The colour value is specified the same way as for border colour (see above)

Font

name

The name of the font for the cell. Valid values are those fonts supported by Microsoft Excel

size

The size of the font, as a decimal value. Valid values are those font sizes supported by Microsoft Excel

color

The colour of the font. The colour value is specified the same way as for border colour (see above)

bold

Specifies whether the font should be bold ("true"). Default value is "false"

italic

Specifies whether the font should be italic ("true"). Default value is "false"

underline

Specifies how the font should be underlined. Valid values are those supported by Microsoft Excel:

strike

Specifies whether the font should be strike through ("true"). Default value is "false"

verticalTextAlignment

Specifies how text in the cell should be aligned vertically. Valid values are those supported by Microsoft Excel:

NumberingFormat

format

Specifies how numeric values in a cell should be formatted. Valid values are those format patterns supported by Microsoft Excel