Spreadsheet Integrator - Online Help
Available for:
Spreadsheet Integrator
Questions / Feedback?

CellStyle Type

This type defines the cell's style.

Remarks

This type defines the cell's style. This includes information such as color, bold, borders, etc.

Fields

BackgroundColor
String

The background color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

BottomBorderColor
String

The bottom border color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

BottomBorderStyle
BorderStyles

The bottom border style.

Possible border styles are:

  • 0 (bsNone - default)
  • 1 (bsThin)
  • 2 (bsMedium)
  • 3 (bsDashed)
  • 4 (bsDotted)
  • 5 (bsThick)
  • 6 (bsDouble)
  • 7 (bsHair)
  • 8 (bsMediumDashed)
  • 9 (bsDashDot)
  • 10 (bsMediumDashdot)
  • 11 (bsDashDotDot)
  • 12 (bsMediumDashDotDot)
  • 13 (bsSlantDashDot)
  • 100 (bsMixedStyle)

FontColor
String

The font color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

FontEffect
FontEffects

The font effect.

Possible values are:

  • 0 (feNormal - default)
  • 1 (feStrikethrough)
  • 2 (feSuperscript)
  • 3 (feSubscript)
  • 4 (feStrikeAndSup)
  • 5 (feStrikeAndSub)

FontName
String

The font name.

FontSize
Integer

The font size. The default value is 11.

FontStyle
FontStyles

The font style.

Possible values are:

  • 0 (fsRegular - default)
  • 1 (fsBold)
  • 2 (fsItalic)
  • 3 (fsBoldAndItalic)

FontUnderline
FontUnderlines

The font underline style.

Possible values are:

  • 0 (ulNone - default)
  • 1 (ulSingleUnderLine)
  • 2 (ulDoubleUnderLine)
  • 3 (ulAccountingSingleUnderLine)
  • 4 (ulAccountDoubleUnderLine)

ForegroundColor
String

The foreground color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

HorizontalAlignment
HorizontalAlignments

The horizontal alignment.

Possible values are:

  • 0 (haGeneral - default)
  • 1 (haLeft)
  • 2 (haCenter)
  • 3 (haRight)
  • 4 (haFill)
  • 5 (haJustify)
  • 6 (haCenterContinuous)
  • 7 (haDistributed)

HorizontalBorderColor
String

The horizontal border color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

HorizontalBorderStyle
BorderStyles

The horizontal border style.

Possible border styles are:

  • 0 (bsNone - default)
  • 1 (bsThin)
  • 2 (bsMedium)
  • 3 (bsDashed)
  • 4 (bsDotted)
  • 5 (bsThick)
  • 6 (bsDouble)
  • 7 (bsHair)
  • 8 (bsMediumDashed)
  • 9 (bsDashDot)
  • 10 (bsMediumDashdot)
  • 11 (bsDashDotDot)
  • 12 (bsMediumDashDotDot)
  • 13 (bsSlantDashDot)
  • 100 (bsMixedStyle)

LeftBorderColor
String

The left border color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

LeftBorderStyle
BorderStyles

The left border style.

Possible border styles are:

  • 0 (bsNone - default)
  • 1 (bsThin)
  • 2 (bsMedium)
  • 3 (bsDashed)
  • 4 (bsDotted)
  • 5 (bsThick)
  • 6 (bsDouble)
  • 7 (bsHair)
  • 8 (bsMediumDashed)
  • 9 (bsDashDot)
  • 10 (bsMediumDashdot)
  • 11 (bsDashDotDot)
  • 12 (bsMediumDashDotDot)
  • 13 (bsSlantDashDot)
  • 100 (bsMixedStyle)

RightBorderColor
String

The right border color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

RightBorderStyle
BorderStyles

The right border style.

Possible border styles are:

  • 0 (bsNone - default)
  • 1 (bsThin)
  • 2 (bsMedium)
  • 3 (bsDashed)
  • 4 (bsDotted)
  • 5 (bsThick)
  • 6 (bsDouble)
  • 7 (bsHair)
  • 8 (bsMediumDashed)
  • 9 (bsDashDot)
  • 10 (bsMediumDashdot)
  • 11 (bsDashDotDot)
  • 12 (bsMediumDashDotDot)
  • 13 (bsSlantDashDot)
  • 100 (bsMixedStyle)

TextOrientation
Integer

The text orientation. This is the angle relative to the horizontal line. The default value is 0.

TopBorderColor
String

The top border color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

TopBorderStyle
BorderStyles

The top border style.

Possible border styles are:

  • 0 (bsNone - default)
  • 1 (bsThin)
  • 2 (bsMedium)
  • 3 (bsDashed)
  • 4 (bsDotted)
  • 5 (bsThick)
  • 6 (bsDouble)
  • 7 (bsHair)
  • 8 (bsMediumDashed)
  • 9 (bsDashDot)
  • 10 (bsMediumDashdot)
  • 11 (bsDashDotDot)
  • 12 (bsMediumDashDotDot)
  • 13 (bsSlantDashDot)
  • 100 (bsMixedStyle)

VerticalAlignment
VerticalAlignments

The vertical alignment.

Possible values are

  • 0 (vaBottom - default)
  • 1 (vaTop)
  • 2 (vaCenter)
  • 3 (vaJustify)
  • 4 (vaDistributed)

VerticalBorderColor
String

The vertical border color.

Colors are comprised of several values which are represented as a string, for instance "auto=;indexed=;rgb=FFFFFF00;tint=;theme=". Note that the value of rgb is actually comprised of four octets which correspond to ARGB values where A represents the Alpha value (transparency).

VerticalBorderStyle
BorderStyles

The vertical border style.

Possible border styles are:

  • 0 (bsNone - default)
  • 1 (bsThin)
  • 2 (bsMedium)
  • 3 (bsDashed)
  • 4 (bsDotted)
  • 5 (bsThick)
  • 6 (bsDouble)
  • 7 (bsHair)
  • 8 (bsMediumDashed)
  • 9 (bsDashDot)
  • 10 (bsMediumDashdot)
  • 11 (bsDashDotDot)
  • 12 (bsMediumDashDotDot)
  • 13 (bsSlantDashDot)
  • 100 (bsMixedStyle)

WrapText
Boolean

Whether text is wrapped. The default value is False.

Constructors

[VB.NET]
Public CellStyle()

[C#]
public CellStyle();



 
 
Copyright (c) 2017 /n software inc. - All rights reserved.
Build 1.0.6240.0