Class ConditionalFormatWrapper

Namespace

Spire.Xls

Assembly

Spire.XLS.dll

public class ConditionalFormatWrapper : CommonWrapper, IOptimizedUpdate, ICloneParent, IConditionalFormat, IExcelApplication

Inheritance

object

CommonWrapper

ConditionalFormatWrapper

Implements

IOptimizedUpdate

ICloneParent

IConditionalFormat

IExcelApplication

Inherited Members

CommonWrapper.Clone(object)

CommonWrapper.BeginCallsCount

object.GetType()

object.MemberwiseClone()

object.ToString()

object.Equals(object)

object.Equals(object, object)

object.ReferenceEquals(object, object)

object.GetHashCode()

Constructors

ConditionalFormatWrapper(CondFormatCollectionWrapper, int)

public ConditionalFormatWrapper(CondFormatCollectionWrapper formats, int iIndex)

Parameters

formats CondFormatCollectionWrapper

iIndex int

Properties

Average

public Average Average { get; }

Property Value

Average

BackColor

public Color BackColor { get; set; }

Property Value

Color

BackColorObject

public OColor BackColorObject { get; }

Property Value

OColor

BackKnownColor

public ExcelColors BackKnownColor { get; set; }

Property Value

ExcelColors

BottomBorderColor

public Color BottomBorderColor { get; set; }

Property Value

Color

BottomBorderColorObject

public OColor BottomBorderColorObject { get; }

Property Value

OColor

BottomBorderKnownColor

public ExcelColors BottomBorderKnownColor { get; set; }

Property Value

ExcelColors

BottomBorderStyle

public LineStyleType BottomBorderStyle { get; set; }

Property Value

LineStyleType

Color

public Color Color { get; set; }

Property Value

Color

ColorScale

public ColorScale ColorScale { get; }

Property Value

ColorScale

DataBar

public DataBar DataBar { get; }

Property Value

DataBar

DxfId

public int DxfId { get; set; }

Property Value

int

FillPattern

public ExcelPatternType FillPattern { get; set; }

Property Value

ExcelPatternType

FirstFormula

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

public OColor FontColorObject { get; }

Property Value

OColor

FontKnownColor

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

public bool IsBackgroundColorPresent { get; set; }

Property Value

bool

IsBold

public bool IsBold { get; set; }

Property Value

bool

IsBorderFormatPresent

public bool IsBorderFormatPresent { get; set; }

Property Value

bool

IsBottomBorderModified

public bool IsBottomBorderModified { get; set; }

Property Value

bool

IsFontColorPresent

public bool IsFontColorPresent { get; set; }

Property Value

bool

IsFontFormatPresent

public bool IsFontFormatPresent { get; set; }

Property Value

bool

IsItalic

public bool IsItalic { get; set; }

Property Value

bool

IsLeftBorderModified

public bool IsLeftBorderModified { get; set; }

Property Value

bool

IsPatternColorPresent

Indicates whether pattern color .

public bool IsPatternColorPresent { get; set; }

Property Value

bool

IsPatternFormatPresent

public bool IsPatternFormatPresent { get; set; }

Property Value

bool

IsPatternStyleModified

public bool IsPatternStyleModified { get; set; }

Property Value

bool

IsRightBorderModified

public bool IsRightBorderModified { get; set; }

Property Value

bool

IsStrikeThrough

public bool IsStrikeThrough { get; set; }

Property Value

bool

IsSubScript

public bool IsSubScript { get; set; }

Property Value

bool

IsSuperScript

public bool IsSuperScript { get; set; }

Property Value

bool

IsTopBorderModified

public bool IsTopBorderModified { get; set; }

Property Value

bool

KnownColor

public ExcelColors KnownColor { get; set; }

Property Value

ExcelColors

LeftBorderColor

public Color LeftBorderColor { get; set; }

Property Value

Color

LeftBorderColorObject

public OColor LeftBorderColorObject { get; }

Property Value

OColor

LeftBorderKnownColor

public ExcelColors LeftBorderKnownColor { get; set; }

Property Value

ExcelColors

LeftBorderStyle

public LineStyleType LeftBorderStyle { get; set; }

Property Value

LineStyleType

NumberFormat

public string NumberFormat { get; set; }

Property Value

string

OColor

public OColor OColor { get; }

Property Value

OColor

Operator

public ComparisonOperatorType Operator { get; set; }

Property Value

ComparisonOperatorType

Parent

public object Parent { get; }

Property Value

object

Priority

public int Priority { get; set; }

Property Value

int

RightBorderColor

public Color RightBorderColor { get; set; }

Property Value

Color

RightBorderColorObject

public OColor RightBorderColorObject { get; }

Property Value

OColor

RightBorderKnownColor

public ExcelColors RightBorderKnownColor { get; set; }

Property Value

ExcelColors

RightBorderStyle

public LineStyleType RightBorderStyle { get; set; }

Property Value

LineStyleType

SecondFormula

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

public OColor TopBorderColorObject { get; }

Property Value

OColor

TopBorderKnownColor

public ExcelColors TopBorderKnownColor { get; set; }

Property Value

ExcelColors

TopBorderStyle

public LineStyleType TopBorderStyle { get; set; }

Property Value

LineStyleType

TopBottom

public TopBottom TopBottom { get; }

Property Value

TopBottom

Underline

public FontUnderlineType Underline { get; set; }

Property Value

FontUnderlineType

Methods

BeginUpdate()

public override void BeginUpdate()

EndUpdate()

public override void EndUpdate()

MakeFormula()

public string MakeFormula()

Returns

string

MakeFormula(string)

public string MakeFormula(string para)

Parameters

para string

Returns

string

SetTimePeriod(TimePeriodType)

public void SetTimePeriod(TimePeriodType timePeriod)

Parameters

timePeriod TimePeriodType