[]
        
(Showing Draft Content)

GrapeCity.Spreadsheet.CfValue

CfValue Struct

Represents a conditional formatting value.

Implements
Namespace: GrapeCity.Spreadsheet
Assembly: GrapeCity.Spreadsheet.dll
Syntax
public struct CfValue : IEquatable<CfValue>
Public Structure CfValue
    Implements IEquatable(Of CfValue)

Fields

Name Description
AutoMax

Represents a min, max, autoMin, autoMax, average, stdev CfValue value.

AutoMin

Represents a min, max, autoMin, autoMax, average, stdev CfValue value.

Average

Represents a min, max, autoMin, autoMax, average, stdev CfValue value.

Max

Represents a min, max, autoMin, autoMax, average, stdev CfValue value.

Min

Represents a min, max, autoMin, autoMax, average, stdev CfValue value.

Stdev

Represents a min, max, autoMin, autoMax, average, stdev CfValue value.

Undefined

Represents an undefined CfValue value.

Properties

Name Description
GreaterThanOrEquals

Gets a boolean value indicates whether this CfValue will be compared using greater than or equals operator.

Value

Gets an IReadonlyPrimitiveValue object represent the primitive value of this CfValue.

ValueType

Gets the type of this conditional formatting value.

Methods

Name Description
Equals(CfValue)

Indicates whether the current object is equal to another object of the same type.

Equals(object)

Determines whether the specified object is equal to this instance.

FromFormula(string, CfValueType, FormulaEngine)

Create a conditional formatting value using the specified formula.

FromPercent(double)

Create a percentage conditional formatting value.

FromPercent(string, FormulaEngine)

Create a percentage conditional formatting value.

FromPercentile(double)

Create a percentile conditional formatting value.

FromPrimitiveValue(double, CfValueType)

Create a conditional formatting value using the specified numeric value.

FromPrimitiveValue(string)

Create a conditional formatting value using the specified string value.

GetFormula(FormulaEngine)

Gets the formula text of this CfValue.

GetHashCode()

Returns a hash code for this instance.

IsUndefined()

Gets a boolean value indicating whether this CfValue is undefined.

ToGreaterThanOnly(ref CfValue)

Ensures that the CfValue will use greater-than when applying conditional formatting rules.