Table of Contents

Class ColorScale

Namespace
Spire.Xls
Assembly
Spire.XLS.dll

The color scale condition in the conditional format

public class ColorScale
Inheritance
ColorScale
Inherited Members

Properties

Criteria

Indicates the type, value, and the color of threshold criteria used in the color scale conditional format.

public IList<ColorConditionValue> Criteria { get; }

Property Value

IList<ColorConditionValue>

MaxColor

Get or set the max value object's corresponding color.

public Color MaxColor { get; set; }

Property Value

Color

MaxValue

Get or set this ColorScale's max value object.

public IConditionValue MaxValue { get; }

Property Value

IConditionValue

MidColor

Get or set the mid value object's corresponding color.

public Color MidColor { get; set; }

Property Value

Color

MidValue

Get or set this ColorScale's mid value object.

public IConditionValue MidValue { get; }

Property Value

IConditionValue

MinColor

Get or set the min value object's corresponding color.

public Color MinColor { get; set; }

Property Value

Color

MinValue

Get or set this ColorScale's min value object.

public IConditionValue MinValue { get; }

Property Value

IConditionValue

Methods

AddCriteria(ConditionValueType, object, Color)

public void AddCriteria(ConditionValueType type, object value, Color color)

Parameters

type ConditionValueType
value object
color Color

AddCriteria(ColorConditionValue)

[Obsolete("please use AddCriteria(ConditionValueType type, object value, Color color)")]
public void AddCriteria(ColorConditionValue item)

Parameters

item ColorConditionValue

SetConditionCount(int)

Sets number of objects in the collection.

public void SetConditionCount(int count)

Parameters

count int