GrapeCity.Documents.Excel.IConditionValue

IConditionValue Interface

Represents how the shortest bar or longest bar is evaluated for a data bar conditional formatting rule.

An IConditionValue object defines the threshold type and threshold value used by a conditional formatting rule. It is typically used with data bars to describe how the minimum or maximum point is determined.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface IConditionValue

Public Interface IConditionValue

Examples

worksheet.Range["A1:A3"].Value = new object[,] {{10}, {40}, {90}};
IDataBar dataBar = worksheet.Range["A1:A3"].FormatConditions.AddDatabar();
IConditionValue minPoint = dataBar.MinPoint;
minPoint.Type = ConditionValueTypes.Number;
minPoint.Value = 10;

Properties

Name	Description
Type	Returns 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. Use this property to inspect whether the threshold is based on a number, percentage, percentile, formula, or an automatic minimum or maximum value.
Value	Gets or sets the shortest bar or longest bar threshold value for a data bar conditional format.

Name

Description

Type

Returns 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.

Use this property to inspect whether the threshold is based on a number, percentage, percentile, formula, or an automatic minimum or maximum value.

Value

Gets or sets the shortest bar or longest bar threshold value for a data bar conditional format.