Class ConditionalFormattingValue

Class ConditionalFormattingValue

Namespace: Aspose.Cells
Assembly: Aspose.Cells.dll (25.2.0)

Describes the values of the interpolation points in a gradient scale, dataBar or iconSet.

public class ConditionalFormattingValue

Inheritance

objectConditionalFormattingValue

Inherited Members

object.GetType(), object.MemberwiseClone(), object.ToString(), object.Equals(object?), object.Equals(object?, object?), object.ReferenceEquals(object?, object?), object.GetHashCode()

Properties

IsGTE

Get or set the Greater Than Or Equal flag. Use only for icon sets, determines whether this threshold value uses the greater than or equal to operator. ‘false’ indicates ‘greater than’ is used instead of ‘greater than or equal to’. Default value is true.

public bool IsGTE { get; set; }

Property Value

bool

Type

Get or set the type of this conditional formatting value object. Setting the type to FormatConditionValueType.Min or FormatConditionValueType.Max will auto set “Value” to null.

public FormatConditionValueType Type { get; set; }

Property Value

FormatConditionValueType

Value

Get or set the value of this conditional formatting value object. It should be used in conjunction with Type.

public object Value { get; set; }

Property Value

object

Remarks

If the value is string and start with “=”, it will be processed as a formula, otherwise we will process it as a simple value.