Click or drag to resize

XlsConditionValue Class

Represents implementation of single condition value for iconset, databar, colorscale conditions.
Inheritance Hierarchy
System Object
Spire.Xls XlsConditionValue
Spire.Xls.Core.Spreadsheet ColorConditionValue

Namespace: Spire.Xls
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)
Syntax
public class XlsConditionValue : IConditionValue

The XlsConditionValue type exposes the following members.

Constructors
Name Description
Public method XlsConditionValue(XlsConditionalFormat, ConditionValueType, Object)
Initializes new instance of the class.
Public method XlsConditionValue(XlsConditionalFormat, ConditionValueType, Object, Boolean)
Initializes a new instance of the XlsConditionValue class with the specified conditional format, condition value type, value, and a flag indicating if the comparison is greater than or equal.
Top
Properties
Name Description
Public property IsGTE
Returns or sets whether this threshold value uses the greater than or equal to operator. false indicate 'greater than' is used instead of 'greater than or equal to'.
Public property Type
Gets/sets one of the constants of the ConditionValueTypes enumeration, which specifies how the threshold values for a data bar, color scale, or icon set conditional format are determined.
Public property Value
Returns or sets the shortest bar or longest bar threshold value for a data bar conditional format.
Top
Methods
Name Description
Public method Equals
Determines whether the specified Object is equal to the current Object.
(Overrides Object Equals(Object) .)
Protected method Finalize
Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection.
(Inherited from Object .)
Public method GetHashCode
Returns the hash code for this instance.
(Overrides Object GetHashCode .)
Public method GetType
Gets the Type of the current instance.
(Inherited from Object .)
Protected method MemberwiseClone
Creates a shallow copy of the current Object .
(Inherited from Object .)
Public method ToString
Returns a string that represents the current object.
(Inherited from Object .)
Top
Operators
Name Description
Public operator Static member Equality
Equality comparison.
Public operator Static member Inequality
Checks whether conditions are not equal.
Top
See Also