Exposes properties which displays data bars in a based on the cell's value as relative to the associated range.
Inheritance
Properties
Section titled "Properties"Formula
Section titled "Formula"Inherited from: ThresholdConditionBase
Returns the which determines the values to which this condition applies.
public Formula Formula { get; }Worksheet
Section titled "Worksheet"Inherited from: ConditionBase
Returns a reference to the associated worksheet.
public Worksheet Worksheet { get; }Workbook
Section titled "Workbook"Inherited from: ConditionBase
Returns a reference to the associated workbook.
public Workbook Workbook { get; }Regions
Section titled "Regions"Inherited from: ConditionBase
Returns the which identifies the cell range with which this condition is associated.
public ReadOnlyCollection<WorksheetRegion> Regions { get; }ConditionType
Section titled "ConditionType"Inherited from: ConditionBase
Returns a value which identifies the type of condition for this instance.
public FormatConditionType ConditionType { get; }Priority
Section titled "Priority"Inherited from: ConditionBase
Returns or sets a value which determines the order of evaluation when multiple conditional formatting rules exist.
public int Priority { get; set; }StopIfTrue
Section titled "StopIfTrue"Inherited from: ConditionBase
Returns or sets a boolean indicating whether additional formatting rules are evaluated if this rule evaluates to true. Applicable only in the case where the containing contains more than one element.
public bool StopIfTrue { get; set; }AxisColor
Section titled "AxisColor"Returns or sets a object which defines the color of the axis.
public WorkbookColorInfo AxisColor { get; set; }AxisPosition
Section titled "AxisPosition"Returns or sets a value which determines whether an axis is displayed.
public DataBarAxisPosition AxisPosition { get; set; }BarBorderColor
Section titled "BarBorderColor"Returns or sets a object which defines the border color of the data bar.
public WorkbookColorInfo BarBorderColor { get; set; }BarColor
Section titled "BarColor"Returns or sets a object which defines the fill color of the data bar.
public WorkbookColorInfo BarColor { get; set; }BarFillType
Section titled "BarFillType"Returns or sets a value which determines whether the data bar is filled with a solid color or a gradient.
public DataBarFillType BarFillType { get; set; }Direction
Section titled "Direction"Returns or sets a value which determines the direction in which the data bar extends.
public DataBarDirection Direction { get; set; }FillPercentMax
Section titled "FillPercentMax"Returns or sets an integer value which determines the length of the longest data bar, expressed as a percentage of the cell's width.
public int FillPercentMax { get; set; }FillPercentMin
Section titled "FillPercentMin"Returns or sets an integer value which determines the length of the shortest data bar, expressed as a percentage of the cell's width.
public int FillPercentMin { get; set; }MaxPoint
Section titled "MaxPoint"Returns or sets a value which determines the manner in which the longest bar is evaluated for this condition.
public ConditionValue MaxPoint { get; }MinPoint
Section titled "MinPoint"Returns or sets a value which determines the manner in which the shortest bar is evaluated for this condition.
public ConditionValue MinPoint { get; }NegativeBarFormat
Section titled "NegativeBarFormat"Returns a object which defines the visual attributes of negative-value data bars.
public NegativeBarFormat NegativeBarFormat { get; }ShowBorder
Section titled "ShowBorder"Returns or sets a boolean value indicating whether borders are displayed for both negative-value and positive-value databars.
public bool ShowBorder { get; set; }ShowValue
Section titled "ShowValue"Returns or sets a boolean value indicating whether the cell value is shown along with the data bar.
public bool ShowValue { get; set; }Methods
Section titled "Methods"SetFormula(string, CellReferenceMode?)
Section titled "SetFormula(string, CellReferenceMode?)"Inherited from: ThresholdConditionBase
Assigns a new to the property.
public void SetFormula(string formula, CellReferenceMode? cellReferenceMode = null)Parameters
- formula:
string - cellReferenceMode:
CellReferenceMode?
Returns any
SetFirstPriority()
Section titled "SetFirstPriority()"Inherited from: ConditionBase
Sets the value for this rule such that it is the first condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated .
public void SetFirstPriority()Returns any
SetLastPriority()
Section titled "SetLastPriority()"Inherited from: ConditionBase
Sets the value for this rule such that it is the last condition to be evaluated. Applicable only in the case where there is more than one element contained within the associated .
public void SetLastPriority()Returns any
SetRegions(string, CellReferenceMode?)
Section titled "SetRegions(string, CellReferenceMode?)"Inherited from: ConditionBase
Replaces the existing regions with new ones
public void SetRegions(string regionAddress, CellReferenceMode? cellReferenceMode)Parameters
- regionAddress:
string - cellReferenceMode:
CellReferenceMode?