# FarPoint.Web.Spread.DatabarConditionalFormattingRule

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="FarPoint_Web_Spread_DatabarConditionalFormattingRule" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule" class="text-break">DatabarConditionalFormattingRule Class
</h1>
  <div class="markdown level0 summary"><p>Represents the data bar conditional formatting rule.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <div class="inheritance">
    <h5>Inheritance</h5>
    <div class="level0"><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.object">object</a></div>
    <div class="level1"><a class="xref" href="FarPoint.Web.Spread.ConditionalFormattingRule.html">ConditionalFormattingRule</a></div>
    <div class="level2"><a class="xref" href="FarPoint.Web.Spread.PrePaintTextConditionalFormattingRule.html">PrePaintTextConditionalFormattingRule</a></div>
    <div class="level3"><span class="xref">DatabarConditionalFormattingRule</span></div>
  </div>
  <div class="implements">
    <h5>Implements</h5>
    <div><a class="xref" href="FarPoint.Web.Spread.Model.ICanSerializeXml.html">ICanSerializeXml</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.Model.ISerializeSupport.html">ISerializeSupport</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.runtime.serialization.iserializable">ISerializable</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.IPrePaintTextConditionalFormattingRule.html">IPrePaintTextConditionalFormattingRule</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.IPdfPrintableRule.html">IPdfPrintableRule</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.IExcelExporter.html">IExcelExporter</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.IConditionalFormattingDataRule.html">IConditionalFormattingDataRule</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.Model.IExpressionConsumer.html">IExpressionConsumer</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.IFilterSupportConditionalFormattingRule.html">IFilterSupportConditionalFormattingRule</a></div>
    <div><a class="xref" href="FarPoint.Web.Spread.IConditionalFormattingRule.html">IConditionalFormattingRule</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.componentmodel.inotifypropertychanged">INotifyPropertyChanged</a></div>
    <div><a class="xref" href="https://learn.microsoft.com/dotnet/api/system.icloneable">ICloneable</a></div>
  </div>
  <h6><strong>Namespace</strong>: <a class="xref" href="FarPoint.Web.Spread.html">FarPoint.Web.Spread</a></h6>
  <h6><strong>Assembly</strong>: FarPoint.Web.Spread.dll</h6>
  <h5 id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public class DatabarConditionalFormattingRule : PrePaintTextConditionalFormattingRule, ICanSerializeXml, ISerializeSupport, ISerializable, IPrePaintTextConditionalFormattingRule, IPdfPrintableRule, IExcelExporter, IConditionalFormattingDataRule, IExpressionConsumer, IFilterSupportConditionalFormattingRule, IConditionalFormattingRule, INotifyPropertyChanged, ICloneable</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Class DatabarConditionalFormattingRule
    Inherits PrePaintTextConditionalFormattingRule
    Implements ICanSerializeXml, ISerializeSupport, ISerializable, IPrePaintTextConditionalFormattingRule, IPdfPrintableRule, IExcelExporter, IConditionalFormattingDataRule, IExpressionConsumer, IFilterSupportConditionalFormattingRule, IConditionalFormattingRule, INotifyPropertyChanged, ICloneable</code></pre>
  </div>
  <h3 id="constructors">Constructors
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule__ctor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.#ctor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.-ctor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule__ctor">DatabarConditionalFormattingRule()</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.html">DatabarConditionalFormattingRule</a> class.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule__ctor_System_Runtime_Serialization_SerializationInfo_System_Runtime_Serialization_StreamingContext_" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.#ctor(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext)">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.-ctor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule__ctor_System_Runtime_Serialization_SerializationInfo_System_Runtime_Serialization_StreamingContext_">DatabarConditionalFormattingRule(SerializationInfo, StreamingContext)</a>
        </td>
        <td class="markdown level1 summary"><p>Initializes a new instance of the <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.html">DatabarConditionalFormattingRule</a> class from serialization.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_AxisColor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.AxisColor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.AxisColor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_AxisColor">AxisColor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the color of the axis.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_AxisPosition" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.AxisPosition">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.AxisPosition.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_AxisPosition">AxisPosition</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the axis position.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_BorderColor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.BorderColor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.BorderColor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_BorderColor">BorderColor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the color of the border.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_Direction" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Direction">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Direction.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_Direction">Direction</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the direction.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_FillColor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.FillColor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.FillColor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_FillColor">FillColor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the color of the fill.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_Gradient" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Gradient">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Gradient.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_Gradient">Gradient</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether this <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.html">DatabarConditionalFormattingRule</a> is a gradient.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_Maximum" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Maximum">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Maximum.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_Maximum">Maximum</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the maximum value. Note: The maximum value only accepts the ConditionalFormattingValue object which has a Type property of Max, AutoMax, Number, Percent, Formula, or Pecentile.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_Minimum" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Minimum">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.Minimum.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_Minimum">Minimum</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the minimum value. Note: The minimum value only accepts the ConditionalFormattingValue object which has a Type property such as Min, AutoMin, Number, Percent, Formula, or Pecentile.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_NegativeBorderColor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.NegativeBorderColor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.NegativeBorderColor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_NegativeBorderColor">NegativeBorderColor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the color of the negative border.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_NegativeFillColor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.NegativeFillColor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.NegativeFillColor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_NegativeFillColor">NegativeFillColor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the color of the negative fill.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_ShowBorder" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.ShowBorder">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.ShowBorder.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_ShowBorder">ShowBorder</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the border should be painted.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_UseNegativeBorderColor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.UseNegativeBorderColor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.UseNegativeBorderColor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_UseNegativeBorderColor">UseNegativeBorderColor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the negative border color is used to paint the border for the negative value.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_UseNegativeFillColor" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.UseNegativeFillColor">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.UseNegativeFillColor.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_UseNegativeFillColor">UseNegativeFillColor</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the negative fill color is used to paint the negative value.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_DeserializeEntry_System_Runtime_Serialization_SerializationEntry_" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.DeserializeEntry(System.Runtime.Serialization.SerializationEntry)">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.DeserializeEntry.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_DeserializeEntry_System_Runtime_Serialization_SerializationEntry_">DeserializeEntry(SerializationEntry)</a>
        </td>
        <td class="markdown level1 summary"></td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_GetObjectData_System_Runtime_Serialization_SerializationInfo_System_Runtime_Serialization_StreamingContext_" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.GetObjectData(System.Runtime.Serialization.SerializationInfo,System.Runtime.Serialization.StreamingContext)">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.GetObjectData.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_GetObjectData_System_Runtime_Serialization_SerializationInfo_System_Runtime_Serialization_StreamingContext_">GetObjectData(SerializationInfo, StreamingContext)</a>
        </td>
        <td class="markdown level1 summary"><p>Populates a System.Runtime.Serialization.SerializationInfo with the data needed to serialize the target object.</p>
</td>
      </tr>
      <tr>
        <td id="FarPoint_Web_Spread_DatabarConditionalFormattingRule_PaintCell_System_String_System_Web_UI_Control_FarPoint_Web_Spread_Appearance_FarPoint_Web_Spread_Inset_System_Object_System_Boolean_System_Boolean_" data-uid="FarPoint.Web.Spread.DatabarConditionalFormattingRule.PaintCell(System.String,System.Web.UI.Control,FarPoint.Web.Spread.Appearance,FarPoint.Web.Spread.Inset,System.Object,System.Boolean,System.Boolean)">
          <a class="xref" href="FarPoint.Web.Spread.DatabarConditionalFormattingRule.PaintCell.html#FarPoint_Web_Spread_DatabarConditionalFormattingRule_PaintCell_System_String_System_Web_UI_Control_FarPoint_Web_Spread_Appearance_FarPoint_Web_Spread_Inset_System_Object_System_Boolean_System_Boolean_">PaintCell(string, Control, Appearance, Inset, object, bool, bool)</a>
        </td>
        <td class="markdown level1 summary"><p>Paints the cell.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>