Version

DataBarConditionalFormat Class Members

The following tables list the members exposed by DataBarConditionalFormat.

Public Properties
 NameDescription
Public PropertyAxisColorReturns or sets a Infragistics.Documents.Excel.WorkbookColorInfo object which defines the color of the axis.  
Public PropertyAxisPositionReturns or sets a DataBarAxisPosition value which determines whether an axis is displayed.  
Public PropertyBarBorderColorReturns or sets a Infragistics.Documents.Excel.WorkbookColorInfo object which defines the border color of the data bar.  
Public PropertyBarColorReturns or sets a Infragistics.Documents.Excel.WorkbookColorInfo object which defines the fill color of the data bar.  
Public PropertyBarFillTypeReturns or sets a DataBarFillType value which determines whether the data bar is filled with a solid color or a gradient.  
Public PropertyConditionTypeReturns a FormatConditionType value which identifies the type of condition for this instance. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyDirectionReturns or sets a DataBarDirection value which determines the direction in which the data bar extends.  
Public PropertyFillPercentMaxReturns or sets an integer value which determines the length of the longest data bar, expressed as a percentage of the cell's width.  
Public PropertyFillPercentMinReturns or sets an integer value which determines the length of the shortest data bar, expressed as a percentage of the cell's width.  
Public PropertyFormulaReturns the formula which determines the values to which this condition applies. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ThresholdConditionBase)
Public PropertyMaxPointReturns or sets a value which determines the manner in which the longest bar is evaluated for this condition.  
Public PropertyMinPointReturns or sets a value which determines the manner in which the shortest bar is evaluated for this condition.  
Public PropertyNegativeBarFormatReturns a NegativeBarFormat object which defines the visual attributes of negative-value data bars.  
Public PropertyPriorityReturns or sets a value which determines the order of evaluation when multiple conditional formatting rules exist. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyRegionsReturns the Infragistics.Documents.Excel.WorksheetRegion which identifies the cell range with which this condition is associated. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyShowBorderReturns or sets a boolean value indicating whether borders are displayed for both negative-value and positive-value databars.  
Public PropertyShowValueReturns or sets a boolean value indicating whether the cell value is shown along with the data bar.  
Public PropertyStopIfTrueReturns 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 collection contains more than one element. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyWorkbookReturns a reference to the associated workbook. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public PropertyWorksheetReturns a reference to the associated worksheet. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public Methods
 NameDescription
Public MethodSetFirstPrioritySets the Priority 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 collection. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public MethodSetFormulaAssigns a new Infragistics.Documents.Excel.Formula to the ThresholdConditionBase.Formula property. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ThresholdConditionBase)
Public MethodSetLastPrioritySets the Priority 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 ConditionalFormatCollection. (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
Public MethodSetRegionsReplaces the existing regions with new ones (Inherited from Infragistics.Documents.Excel.ConditionalFormatting.ConditionBase)
See Also