XlsConditionalFormat module

class XlsConditionalFormat.XlsConditionalFormat

Bases: XlsObject, IConditionalFormat, ICloneParent

property Average: Average

property BackColor: Color

<summary>

Pattern background color.

</summary>

property BackColorObject: OColor

<summary>

Conditional format background color. Read-only.

</summary>

property BackKnownColor: ExcelColors

<summary>

Pattern background excel color.

</summary>

property BottomBorderColor: Color

<summary>

Color of the bottom line.

</summary>

property BottomBorderColorObject: OColor

<summary>

Conditional format bottom border color. Read-only.

</summary>

property BottomBorderKnownColor: ExcelColors

<summary>

Excel color of the bottom line.

</summary>

property BottomBorderStyle: LineStyleType

<summary>

Bottom border line style.

</summary>

Clone(parent: SpireObject) → SpireObject

<summary>

Creates a new object that is a copy of the current instance.

</summary> <param name=”parent”>Parent object for a copy of this instance.</param> <returns>A new object that is a copy of this instance.</returns>

property Color: Color

<summary>

Pattern foreground color.

</summary>

property ColorScale: ColorScale

<summary>

Get the conditional formatting’s “ColorScale” instance.

The default instance is a “green-red” 2ColorScale . Valid only for type = ColorScale.

</summary> <returns>ColorScale instance</returns>

property DataBar: DataBar

property DxfId: int

Equals(obj: SpireObject) → bool

property FillPattern: ExcelPatternType

<summary>

XlsFill pattern type.

</summary>

property FirstFormula: str

<summary>

First formula.

</summary>

property FirstFormulaR1C1: str

property FontColor: Color

property FontColorObject: OColor

<summary>

Conditional format font color. Read-only.

</summary>

property FontKnownColor: ExcelColors

<summary>

Font excel color.

</summary>

property FormatType: ConditionalFormatType

GetHashCode() → int

property IconSet: IconSet

property IsBackgroundColorPresent: bool

<summary>

Indicates whether background color present.

</summary>

property IsBold: bool

<summary>

Indicates whether font is bold.

</summary>

property IsBorderFormatPresent: bool

<summary>

Indicates whether contains border formatting.

</summary>

property IsBottomBorderModified: bool

<summary>

Indicates whether bottom border style and color are modified.

</summary>

property IsFontColorPresent: bool

<summary>

Indicates whether format color present.

</summary>

property IsFontFormatPresent: bool

<summary>

Indicates whether contains font formatting.

</summary>

property IsItalic: bool

<summary>

Indicates whether font is italic.

</summary>

property IsLeftBorderModified: bool

<summary>

Indicates whether left border style and color are modified.

</summary>

property IsNumberFormatPresent: bool

property IsPatternColorPresent: bool

<summary>

Indicates whether presents pattern color.

</summary>

property IsPatternFormatPresent: bool

<summary>

Indicates whether contains pattern formatting.

</summary>

property IsPatternStyleModified: bool

<summary>

Indicates whether pattern style was modified.

</summary>

property IsRightBorderModified: bool

<summary>

Indicates right border style and color modified.

</summary>

property IsStrikeThrough: bool

<summary>

Indicates whether font is striked through.

</summary>

property IsSubScript: bool

<summary>

Indicates whether font is subscript.

</summary>

property IsSuperScript: bool

<summary>

Indicates whether font is superscript.

</summary>

property IsTopBorderModified: bool

<summary>

Indicates whether top border style and color are modified.

</summary>

property KnownColor: ExcelColors

<summary>

Pattern foreground excel color.

</summary>

property LeftBorderColor: Color

property LeftBorderColorObject: OColor

<summary>

Conditional format left border color. Read-only.

</summary>

property LeftBorderKnownColor: ExcelColors

<summary>

Excel color of the left line.

</summary>

property LeftBorderStyle: LineStyleType

<summary>

Left border line style.

</summary>

MakeFormula

property NumberFormat: str

property OColor: OColor

<summary>

Conditional format color. Read-only.

</summary>

property Operator: ComparisonOperatorType

<summary>

Type of the comparison operator.

</summary>

property Priority: int

property RightBorderColor: Color

<summary>

Color of the right line.

</summary>

property RightBorderColorObject: OColor

<summary>

Conditional format right border color. Read-only.

</summary>

property RightBorderKnownColor: ExcelColors

<summary>

Color of the right line.

</summary>

property RightBorderStyle: LineStyleType

<summary>

Right border line style.

</summary>

property SecondFormula: str

<summary>

Second formula.

</summary>

property SecondFormulaR1C1: str

SetTimePeriod(timePeriod: TimePeriodType)

property StopIfTrue: bool

property TopBorderColor: Color

property TopBorderColorObject: OColor

<summary>

Conditional format top border color. Read-only.

</summary>

property TopBorderKnownColor: ExcelColors

<summary>

Excel color of the top line.

</summary>

property TopBorderStyle: LineStyleType

<summary>

Top border line style.

</summary>

property TopBottom: TopBottom

property Underline: FontUnderlineType

<summary>

Underline type.

</summary>

UpdateFormula(iCurIndex: int, iSourceIndex: int, sourceRect: Rectangle, iDestIndex: int, destRect: Rectangle, row: int, column: int)