Table of Contents

Interface IXLConditionalFormat

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll
public interface IXLConditionalFormat
Extension Methods

Properties

Bottom 

bool Bottom { get; }

Property Value

bool

Colors 

XLDictionary<XLColor> Colors { get; }

Property Value

XLDictionary<XLColor>

ConditionalFormatType 

XLConditionalFormatType ConditionalFormatType { get; }

Property Value

XLConditionalFormatType

ContentTypes 

XLDictionary<XLCFContentType> ContentTypes { get; }

Property Value

XLDictionary<XLCFContentType>

IconSetOperators 

XLDictionary<XLCFIconSetOperator> IconSetOperators { get; }

Property Value

XLDictionary<XLCFIconSetOperator>

IconSetStyle 

XLIconSetStyle IconSetStyle { get; }

Property Value

XLIconSetStyle

Operator 

XLCFOperator Operator { get; }

Property Value

XLCFOperator

Percent 

bool Percent { get; }

Property Value

bool

Range

The first of the Ranges.

IXLRange Range { get; set; }

Property Value

IXLRange

Ranges 

IXLRanges Ranges { get; }

Property Value

IXLRanges

ReverseIconOrder 

bool ReverseIconOrder { get; }

Property Value

bool

ShowBarOnly 

bool ShowBarOnly { get; }

Property Value

bool

ShowIconOnly 

bool ShowIconOnly { get; }

Property Value

bool

StopIfTrue 

bool StopIfTrue { get; }

Property Value

bool

Style 

IXLStyle Style { get; set; }

Property Value

IXLStyle

TimePeriod 

XLTimePeriod TimePeriod { get; }

Property Value

XLTimePeriod

Values 

XLDictionary<XLFormula> Values { get; }

Property Value

XLDictionary<XLFormula>

Methods

ColorScale() 

IXLCFColorScaleMin ColorScale()

Returns

IXLCFColorScaleMin

CopyTo(IXLWorksheet) 

IXLConditionalFormat CopyTo(IXLWorksheet targetSheet)

Parameters

targetSheet IXLWorksheet

Returns

IXLConditionalFormat

DataBar(XLColor, XLColor, bool) 

IXLCFDataBarMin DataBar(XLColor positiveColor, XLColor negativeColor, bool showBarOnly = false)

Parameters

positiveColor XLColor
negativeColor XLColor
showBarOnly bool

Returns

IXLCFDataBarMin

DataBar(XLColor, bool) 

IXLCFDataBarMin DataBar(XLColor color, bool showBarOnly = false)

Parameters

color XLColor
showBarOnly bool

Returns

IXLCFDataBarMin

IconSet(XLIconSetStyle, bool, bool) 

IXLCFIconSet IconSet(XLIconSetStyle iconSetStyle, bool reverseIconOrder = false, bool showIconOnly = false)

Parameters

iconSetStyle XLIconSetStyle
reverseIconOrder bool
showIconOnly bool

Returns

IXLCFIconSet

SetStopIfTrue() 

IXLConditionalFormat SetStopIfTrue()

Returns

IXLConditionalFormat

SetStopIfTrue(bool) 

IXLConditionalFormat SetStopIfTrue(bool value)

Parameters

value bool

Returns

IXLConditionalFormat

WhenBetween(double, double) 

IXLStyle WhenBetween(double minValue, double maxValue)

Parameters

minValue double
maxValue double

Returns

IXLStyle

WhenBetween(string, string) 

IXLStyle WhenBetween(string minValue, string maxValue)

Parameters

minValue string
maxValue string

Returns

IXLStyle

WhenContains(string) 

IXLStyle WhenContains(string value)

Parameters

value string

Returns

IXLStyle

WhenDateIs(XLTimePeriod) 

IXLStyle WhenDateIs(XLTimePeriod timePeriod)

Parameters

timePeriod XLTimePeriod

Returns

IXLStyle

WhenEndsWith(string) 

IXLStyle WhenEndsWith(string value)

Parameters

value string

Returns

IXLStyle

WhenEqualOrGreaterThan(double) 

IXLStyle WhenEqualOrGreaterThan(double value)

Parameters

value double

Returns

IXLStyle

WhenEqualOrGreaterThan(string) 

IXLStyle WhenEqualOrGreaterThan(string value)

Parameters

value string

Returns

IXLStyle

WhenEqualOrLessThan(double) 

IXLStyle WhenEqualOrLessThan(double value)

Parameters

value double

Returns

IXLStyle

WhenEqualOrLessThan(string) 

IXLStyle WhenEqualOrLessThan(string value)

Parameters

value string

Returns

IXLStyle

WhenEquals(double) 

IXLStyle WhenEquals(double value)

Parameters

value double

Returns

IXLStyle

WhenEquals(string) 

IXLStyle WhenEquals(string value)

Parameters

value string

Returns

IXLStyle

WhenGreaterThan(double) 

IXLStyle WhenGreaterThan(double value)

Parameters

value double

Returns

IXLStyle

WhenGreaterThan(string) 

IXLStyle WhenGreaterThan(string value)

Parameters

value string

Returns

IXLStyle

WhenIsBlank() 

IXLStyle WhenIsBlank()

Returns

IXLStyle

WhenIsBottom(int, XLTopBottomType) 

IXLStyle WhenIsBottom(int value, XLTopBottomType topBottomType)

Parameters

value int
topBottomType XLTopBottomType

Returns

IXLStyle

WhenIsDuplicate() 

IXLStyle WhenIsDuplicate()

Returns

IXLStyle

WhenIsError() 

IXLStyle WhenIsError()

Returns

IXLStyle

WhenIsTop(int, XLTopBottomType) 

IXLStyle WhenIsTop(int value, XLTopBottomType topBottomType = XLTopBottomType.Items)

Parameters

value int
topBottomType XLTopBottomType

Returns

IXLStyle

WhenIsTrue(string) 

IXLStyle WhenIsTrue(string formula)

Parameters

formula string

Returns

IXLStyle

WhenIsUnique() 

IXLStyle WhenIsUnique()

Returns

IXLStyle

WhenLessThan(double) 

IXLStyle WhenLessThan(double value)

Parameters

value double

Returns

IXLStyle

WhenLessThan(string) 

IXLStyle WhenLessThan(string value)

Parameters

value string

Returns

IXLStyle

WhenNotBetween(double, double) 

IXLStyle WhenNotBetween(double minValue, double maxValue)

Parameters

minValue double
maxValue double

Returns

IXLStyle

WhenNotBetween(string, string) 

IXLStyle WhenNotBetween(string minValue, string maxValue)

Parameters

minValue string
maxValue string

Returns

IXLStyle

WhenNotBlank() 

IXLStyle WhenNotBlank()

Returns

IXLStyle

WhenNotContains(string) 

IXLStyle WhenNotContains(string value)

Parameters

value string

Returns

IXLStyle

WhenNotEquals(double) 

IXLStyle WhenNotEquals(double value)

Parameters

value double

Returns

IXLStyle

WhenNotEquals(string) 

IXLStyle WhenNotEquals(string value)

Parameters

value string

Returns

IXLStyle

WhenNotError() 

IXLStyle WhenNotError()

Returns

IXLStyle

WhenStartsWith(string) 

IXLStyle WhenStartsWith(string value)

Parameters

value string

Returns

IXLStyle