Table of Contents

Class XlsConditionalFormat

Namespace
Spire.Xls.Core.Spreadsheet
Assembly
Spire.XLS.dll
public class XlsConditionalFormat : XlsObject, IDisposable, IConditionalFormat, IExcelApplication, ICloneParent
Inheritance
XlsConditionalFormat
Implements
Derived
Inherited Members

Properties

Average 

public Average Average { get; }

Property Value

Average

BackColor

Pattern background color.

public Color BackColor { get; set; }

Property Value

Color

BackColorObject

Conditional format background color. Read-only.

public OColor BackColorObject { get; }

Property Value

OColor

BackKnownColor

Pattern background excel color.

public ExcelColors BackKnownColor { get; set; }

Property Value

ExcelColors

BottomBorderColor

Color of the bottom line.

public Color BottomBorderColor { get; set; }

Property Value

Color

BottomBorderColorObject

Conditional format bottom border color. Read-only.

public OColor BottomBorderColorObject { get; }

Property Value

OColor

BottomBorderKnownColor

Excel color of the bottom line.

public ExcelColors BottomBorderKnownColor { get; set; }

Property Value

ExcelColors

BottomBorderStyle

Bottom border line style.

public LineStyleType BottomBorderStyle { get; set; }

Property Value

LineStyleType

Color

Pattern foreground color.

public Color Color { get; set; }

Property Value

Color

ColorScale

Get the conditional formatting's "ColorScale" instance. The default instance is a "green-red" 2ColorScale . Valid only for type = ColorScale.

public ColorScale ColorScale { get; }

Property Value

ColorScale

ColorScale instance

DataBar 

public DataBar DataBar { get; }

Property Value

DataBar

DxfId 

public int DxfId { get; set; }

Property Value

int

FillPattern

XlsFill pattern type.

public ExcelPatternType FillPattern { get; set; }

Property Value

ExcelPatternType

FirstFormula

First formula.

public string FirstFormula { get; set; }

Property Value

string

FirstFormulaR1C1 

[Obsolete("This Property is Obsolete;")]
public string FirstFormulaR1C1 { get; set; }

Property Value

string

FontColor 

public Color FontColor { get; set; }

Property Value

Color

FontColorObject

Conditional format font color. Read-only.

public OColor FontColorObject { get; }

Property Value

OColor

FontKnownColor

Font excel color.

public ExcelColors FontKnownColor { get; set; }

Property Value

ExcelColors

FormatType 

public ConditionalFormatType FormatType { get; set; }

Property Value

ConditionalFormatType

IconSet 

public IconSet IconSet { get; }

Property Value

IconSet

IsBackgroundColorPresent

Indicates whether background color present.

public bool IsBackgroundColorPresent { get; set; }

Property Value

bool

IsBold

Indicates whether font is bold.

public bool IsBold { get; set; }

Property Value

bool

IsBorderFormatPresent

Indicates whether contains border formatting.

public bool IsBorderFormatPresent { get; set; }

Property Value

bool

IsBottomBorderModified

Indicates whether bottom border style and color are modified.

public bool IsBottomBorderModified { get; set; }

Property Value

bool

IsFontColorPresent

Indicates whether format color present.

public bool IsFontColorPresent { get; set; }

Property Value

bool

IsFontFormatPresent

Indicates whether contains font formatting.

public bool IsFontFormatPresent { get; set; }

Property Value

bool

IsItalic

Indicates whether font is italic.

public bool IsItalic { get; set; }

Property Value

bool

IsLeftBorderModified

Indicates whether left border style and color are modified.

public bool IsLeftBorderModified { get; set; }

Property Value

bool

IsNumberFormatPresent 

public bool IsNumberFormatPresent { get; }

Property Value

bool

IsPatternColorPresent

Indicates whether presents pattern color.

public bool IsPatternColorPresent { get; set; }

Property Value

bool

IsPatternFormatPresent

Indicates whether contains pattern formatting.

public bool IsPatternFormatPresent { get; set; }

Property Value

bool

IsPatternStyleModified

Indicates whether pattern style was modified.

public bool IsPatternStyleModified { get; set; }

Property Value

bool

IsRightBorderModified

Indicates right border style and color modified.

public bool IsRightBorderModified { get; set; }

Property Value

bool

IsStrikeThrough

Indicates whether font is striked through.

public bool IsStrikeThrough { get; set; }

Property Value

bool

IsSubScript

Indicates whether font is subscript.

public bool IsSubScript { get; set; }

Property Value

bool

IsSuperScript

Indicates whether font is superscript.

public bool IsSuperScript { get; set; }

Property Value

bool

IsTopBorderModified

Indicates whether top border style and color are modified.

public bool IsTopBorderModified { get; set; }

Property Value

bool

KnownColor

Pattern foreground excel color.

public ExcelColors KnownColor { get; set; }

Property Value

ExcelColors

LeftBorderColor 

public Color LeftBorderColor { get; set; }

Property Value

Color

LeftBorderColorObject

Conditional format left border color. Read-only.

public OColor LeftBorderColorObject { get; }

Property Value

OColor

LeftBorderKnownColor

Excel color of the left line.

public ExcelColors LeftBorderKnownColor { get; set; }

Property Value

ExcelColors

LeftBorderStyle

Left border line style.

public LineStyleType LeftBorderStyle { get; set; }

Property Value

LineStyleType

NumberFormat 

public string NumberFormat { get; set; }

Property Value

string

OColor

Conditional format color. Read-only.

public OColor OColor { get; }

Property Value

OColor

Operator

Type of the comparison operator.

public ComparisonOperatorType Operator { get; set; }

Property Value

ComparisonOperatorType

Priority 

public int Priority { get; set; }

Property Value

int

RightBorderColor

Color of the right line.

public Color RightBorderColor { get; set; }

Property Value

Color

RightBorderColorObject

Conditional format right border color. Read-only.

public OColor RightBorderColorObject { get; }

Property Value

OColor

RightBorderKnownColor

Color of the right line.

public ExcelColors RightBorderKnownColor { get; set; }

Property Value

ExcelColors

RightBorderStyle

Right border line style.

public LineStyleType RightBorderStyle { get; set; }

Property Value

LineStyleType

SecondFormula

Second formula.

public string SecondFormula { get; set; }

Property Value

string

SecondFormulaR1C1 

[Obsolete("This Property is Obsolete;")]
public string SecondFormulaR1C1 { get; set; }

Property Value

string

StopIfTrue 

public bool StopIfTrue { get; set; }

Property Value

bool

TopBorderColor 

public Color TopBorderColor { get; set; }

Property Value

Color

TopBorderColorObject

Conditional format top border color. Read-only.

public OColor TopBorderColorObject { get; }

Property Value

OColor

TopBorderKnownColor

Excel color of the top line.

public ExcelColors TopBorderKnownColor { get; set; }

Property Value

ExcelColors

TopBorderStyle

Top border line style.

public LineStyleType TopBorderStyle { get; set; }

Property Value

LineStyleType

TopBottom 

public TopBottom TopBottom { get; }

Property Value

TopBottom

Underline

Underline type.

public FontUnderlineType Underline { get; set; }

Property Value

FontUnderlineType

Methods

Clone(object)

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

public object Clone(object parent)

Parameters

parent object

Parent object for a copy of this instance.

Returns

object

A new object that is a copy of this instance.

Equals(object) 

public override bool Equals(object obj)

Parameters

obj object

Returns

bool

GetHashCode() 

public override int GetHashCode()

Returns

int

MakeFormula() 

public string MakeFormula()

Returns

string

MakeFormula(double) 

public string MakeFormula(double para)

Parameters

para double

Returns

string

MakeFormula(string) 

[Obsolete("the method is not implemented")]
public string MakeFormula(string para)

Parameters

para string

Returns

string

SetTimePeriod(TimePeriodType) 

public void SetTimePeriod(TimePeriodType timePeriod)

Parameters

timePeriod TimePeriodType

UpdateFormula(int, int, Rectangle, int, Rectangle, int, int) 

[Obsolete("the method is not implemented")]
public void UpdateFormula(int iCurIndex, int iSourceIndex, Rectangle sourceRect, int iDestIndex, Rectangle destRect, int row, int column)

Parameters

iCurIndex int
iSourceIndex int
sourceRect Rectangle
iDestIndex int
destRect Rectangle
row int
column int