# IDataBar

## Content

<div class="docapp-java-api-doc-main"><style>:not(h1, h2, h3, h4, h5, h6)>code,
:not(h1, h2, h3, h4, h5, h6)>tt {
    font-size: 14px;
    padding-top: 4px;
    margin-top: 8px;
    line-height: 1.4em;
}

.summary-table dt code {
    font-size: 14px;
    vertical-align: top;
    padding-top: 4px;
}

.tab {
    background-color: #0066FF;
    color: #ffffff;
    padding: 8px;
    width: 5em;
    font-weight: bold;
}

/*
 * Styles for page header and footer.
 */
.title {
    color: #2c4557;
    margin: 10px 0;
}

.sub-title {
    margin: 5px 0 0 0;
}

.header ul {
    margin: 0 0 15px 0;
    padding: 0;
}

.header ul li,
.footer ul li {
    list-style: none;
}

/*
 * Styles for headings.
 */
.summary h2,
.details h2,
h2,
.block-list h2 {
    padding: 0;
    margin: 15px 0;
}

.summary h3,
.details h3,
.summary .inherited-list h2 {
    background-color: var(--ds-product-color);
    color: #fff;
    border: 1px solid #d0d9e0;
    padding: 7px 5px;
}

.summary h3 a,
.details h3 a,
.summary .inherited-list h2 a {
    color: #fff !important;
}
/*
 * Styles for page layout containers.
 */
dl.notes>dt {
    font-size: 12px;
    font-weight: bold;
    margin: 10px 0 0 0;
    color: #4E4E4E;
}

dl.notes>dd {
    margin: 5px 10px 10px 0;
    font-size: 14px;
}

dl.name-value>dt {
    margin-left: 1px;
    font-size: 1.1em;
    display: inline;
    font-weight: bold;
}

dl.name-value>dd {
    margin: 0 0 0 1px;
    font-size: 1.1em;
    display: inline;
}

/*
 * Styles for lists.
 */
li.circle {
    list-style: circle;
}

ul.horizontal li {
    display: inline;
    font-size: 0.9em;
}

div.inheritance {
    margin: 0;
    padding: 0;
}

div.inheritance div.inheritance {
    margin-left: 2em;
}

ul.block-list,
ul.details-list,
ul.member-list,
ul.summary-list {
    margin: 10px 0 10px 0;
    padding: 0;
}

ul.block-list>li,
ul.details-list>li,
ul.member-list>li,
ul.summary-list>li {
    list-style: none;
    margin-bottom: 15px;
    line-height: 1.4;
}

.summary-table dl,
.summary-table dl dt,
.summary-table dl dd {
    margin-top: 0;
    margin-bottom: 1px;
}

ul.see-list,
ul.see-list-long {
    padding-left: 0;
    list-style: none;
}

ul.see-list li {
    display: inline;
}

ul.see-list li:not(:last-child):after,
ul.see-list-long li:not(:last-child):after {
    content: ", ";
    white-space: pre-wrap;
}

/*
 * Styles for tables.
 */
.summary-table,
.details-table {
    width: 100%;
    border-spacing: 0;
    border-left: 1px solid #EEE;
    border-right: 1px solid #EEE;
    border-bottom: 1px solid #EEE;
    padding: 0;
}

.caption {
    position: relative;
    text-align: left;
    background-repeat: no-repeat;
    color: #253441;
    font-weight: bold;
    clear: none;
    overflow: hidden;
    padding: 0;
    padding-top: 10px;
    padding-left: 1px;
    margin: 0;
    white-space: pre;
}

.caption a:link,
.caption a:visited {
    color: #1f389c;
}

.caption a:hover,
.caption a:active {
    color: #FFFFFF;
}

.caption span {
    white-space: nowrap;
    padding-top: 5px;
    padding-left: 12px;
    padding-right: 12px;
    padding-bottom: 7px;
    display: inline-block;
    background-color: var(--ds-product-color);
    color: #fff;
    border: none;
}

div.table-tabs {
    padding: 10px 0 0 1px;
    margin: 0;
}

div.table-tabs>button {
    border: none;
    cursor: pointer;
    padding: 5px 12px 7px 12px;
    font-weight: bold;
    margin-right: 3px;
}

div.table-tabs>button.active-table-tab {
    background: var(--ds-product-color);
    color: #fff;
}

div.table-tabs>button.table-tab {
    background: var(--ds-product-color);
    color: #FFFFFF;
    border-bottom: 1px solid #eee;
}

.two-column-summary {
    display: grid;
    grid-template-columns: minmax(15%, max-content) minmax(15%, auto);
}

.three-column-summary {
    display: grid;
    grid-template-columns: minmax(10%, max-content) minmax(15%, max-content) minmax(15%, auto);
}

.four-column-summary {
    display: grid;
    grid-template-columns: minmax(10%, max-content) minmax(10%, max-content) minmax(10%, max-content) minmax(10%, auto);
}

@media screen and (max-width: 600px) {
    .two-column-summary {
        display: grid;
        grid-template-columns: 1fr;
    }
}

@media screen and (max-width: 800px) {
    .three-column-summary {
        display: grid;
        grid-template-columns: minmax(10%, max-content) minmax(25%, auto);
    }

    .three-column-summary .col-last {
        grid-column-end: span 2;
    }
}

@media screen and (max-width: 1000px) {
    .four-column-summary {
        display: grid;
        grid-template-columns: minmax(15%, max-content) minmax(15%, auto);
    }
}

.summary-table>div,
.details-table>div {
    text-align: left;
    padding: 8px 3px 3px 7px;
}

.col-first,
.col-second,
.col-last,
.col-constructor-name,
.col-summary-item-name {
    vertical-align: top;
    padding-right: 0;
    padding-top: 8px;
    padding-bottom: 3px;
}

.table-header {
    background: var(--ds-product-color);
    color: #fff;
    font-weight: bold;
}

.col-first,
.col-first {
    font-size: 13px;
}

.col-second,
.col-second,
.col-last,
.col-constructor-name,
.col-summary-item-name,
.col-last {
    font-size: 13px;
}

.col-first,
.col-second,
.col-constructor-name {
    vertical-align: top;
    overflow: auto;
}

.col-last {
    white-space: normal;
}

.col-first a:link,
.col-first a:visited,
.col-second a:link,
.col-second a:visited,
.col-first a:link,
.col-first a:visited,
.col-second a:link,
.col-second a:visited,
.col-constructor-name a:link,
.col-constructor-name a:visited,
.col-summary-item-name a:link,
.col-summary-item-name a:visited,
.constant-values-container a:link,
.constant-values-container a:visited,
.all-classes-container a:link,
.all-classes-container a:visited,
.all-packages-container a:link,
.all-packages-container a:visited {
    font-weight: bold;
}

.table-sub-heading-color {
    background-color: #EEEEFF;
}

.even-row-color,
.even-row-color .table-header {
    background-color: #FFFFFF;
}

.odd-row-color,
.odd-row-color .table-header {
    background-color: #EEEEEF;
}

/*
 * Styles for contents.
 */
.deprecated-content {
    margin: 0;
    padding: 10px 0;
}

div.block {
    font-size: 14px;
}

.col-last div {
    padding-top: 0;
}

.col-last a {
    padding-bottom: 3px;
}

.module-signature,
.package-signature,
.type-signature,
.member-signature {
    font-size: 14px;
    margin: 14px 0;
    white-space: pre-wrap;
}

.module-signature,
.package-signature,
.type-signature {
    margin-top: 0;
}

.member-signature .type-parameters-long,
.member-signature .parameters,
.member-signature .exceptions {
    display: inline-block;
    vertical-align: top;
    white-space: pre;
}

.member-signature .type-parameters {
    white-space: normal;
}

/*
 * Styles for formatting effect.
 */
.source-line-no {
    color: green;
    padding: 0 30px 0 0;
}

h1.hidden {
    visibility: hidden;
    overflow: hidden;
    font-size: 10px;
}

.block {
    display: block;
    margin: 0 10px 5px 0;
    color: #474747;
}

.deprecated-label,
.descfrm-type-label,
.implementation-label,
.member-name-label,
.member-name-link,
.module-label-in-package,
.module-label-in-type,
.override-specify-label,
.package-label-in-type,
.package-hierarchy-label,
.type-name-label,
.type-name-link,
.search-tag-link,
.preview-label {
    font-weight: bold;
}

.deprecation-block {
    font-size: 14px;
    border-style: solid;
    border-width: thin;
    border-radius: 10px;
    padding: 10px;
    margin-bottom: 10px;
    margin-right: 10px;
    display: inline-block;
}

.preview-block {
    font-size: 14px;
    border-style: solid;
    border-width: thin;
    border-radius: 10px;
    padding: 10px;
    margin-bottom: 10px;
    margin-right: 10px;
    display: inline-block;
}

/*
 * Styles for user-provided tables.
 *
 * borderless:
 *      No borders, vertical margins, styled caption.
 *      This style is provided for use with existing doc comments.
 *      In general, borderless tables should not be used for layout purposes.
 *
 * plain:
 *      Plain borders around table and cells, vertical margins, styled caption.
 *      Best for small tables or for complex tables for tables with cells that span
 *      rows and columns, when the "striped" style does not work well.
 *
 * striped:
 *      Borders around the table and vertical borders between cells, striped rows,
 *      vertical margins, styled caption.
 *      Best for tables that have a header row, and a body containing a series of simple rows.
 */

table.borderless,
table.plain,
table.striped {
    margin-top: 10px;
    margin-bottom: 10px;
}

table.borderless>caption,
table.plain>caption,
table.striped>caption {
    font-weight: bold;
    font-size: smaller;
}

table.borderless th,
table.borderless td,
table.plain th,
table.plain td,
table.striped th,
table.striped td {
    padding: 2px 5px;
}

table.borderless,
table.borderless>thead>tr>th,
table.borderless>tbody>tr>th,
table.borderless>tr>th,
table.borderless>thead>tr>td,
table.borderless>tbody>tr>td,
table.borderless>tr>td {
    border: none;
}

table.borderless>thead>tr,
table.borderless>tbody>tr,
table.borderless>tr {
    background-color: transparent;
}

table.plain {
    border-collapse: collapse;
    border: 1px solid black;
}

table.plain>thead>tr,
table.plain>tbody tr,
table.plain>tr {
    background-color: transparent;
}

table.plain>thead>tr>th,
table.plain>tbody>tr>th,
table.plain>tr>th,
table.plain>thead>tr>td,
table.plain>tbody>tr>td,
table.plain>tr>td {
    border: 1px solid black;
}

table.striped {
    border-collapse: collapse;
    border: 1px solid black;
}

table.striped>thead {
    background-color: #E3E3E3;
}

table.striped>thead>tr>th,
table.striped>thead>tr>td {
    border: 1px solid black;
}

table.striped>tbody>tr:nth-child(even) {
    background-color: #EEE
}

table.striped>tbody>tr:nth-child(odd) {
    background-color: #FFF
}

table.striped>tbody>tr>th,
table.striped>tbody>tr>td {
    border-left: 1px solid black;
    border-right: 1px solid black;
}

table.striped>tbody>tr>th {
    font-weight: normal;
}
</style><h1>Interface IDataBar</h1>
<!-- ======== START OF CLASS DATA ======== -->

<section class="class-description" id="class-description">
<hr>
<div class="type-signature"><span class="modifiers">public interface </span><span class="element-name type-name-label">IDataBar</span></div>
<div class="block">Represents a data bar conditional formatting rule. <p>Applying a data bar to a range helps visualize each cell value relative to  the other values in the same range. Use this interface to configure the  appearance and behavior of a data bar rule, such as its fill, color, axis,  direction, and value display.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A5").setValue(new Object[][] {
     {1}, {2}, {3}, {4}, {5}
 });
 IDataBar dataBar = worksheet.getRange("A1:A5").getFormatConditions().addDatabar();
 dataBar.setBarFillType(DataBarFillType.Solid);
 dataBar.getBarColor().setColor(Color.GetGreen());
 dataBar.setShowValue(false);
 </code></pre></div>
</section>
<section class="summary">
<ul class="summary-list">
<!-- ========== METHOD SUMMARY =========== -->
<li>
<section class="method-summary" id="method-summary">
<h2>Method Summary</h2>
<div id="method-summary-table">
<div aria-orientation="horizontal" class="table-tabs" role="tablist"><button aria-controls="method-summary-table.tabpanel" aria-selected="true" class="active-table-tab" id="method-summary-table-tab0" onclick="show('method-summary-table', 'method-summary-table', 3)" onkeydown="switchTab(event)" role="tab" tabindex="0">All Methods</button><button aria-controls="method-summary-table.tabpanel" aria-selected="false" class="table-tab" id="method-summary-table-tab2" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" onkeydown="switchTab(event)" role="tab" tabindex="-1">Instance Methods</button><button aria-controls="method-summary-table.tabpanel" aria-selected="false" class="table-tab" id="method-summary-table-tab3" onclick="show('method-summary-table', 'method-summary-table-tab3', 3)" onkeydown="switchTab(event)" role="tab" tabindex="-1">Abstract Methods</button></div>
<div id="method-summary-table.tabpanel" role="tabpanel">
<div aria-labelledby="method-summary-table-tab0" class="summary-table three-column-summary">
<div class="table-header col-first">Modifier and Type</div>
<div class="table-header col-second">Method</div>
<div class="table-header col-last">Description</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#delete()">delete</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Deletes this data bar conditional formatting rule.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#fromJson(java.lang.String)">fromJson</a><wbr>(<a class="external-link" href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang">String</a>&nbsp;json)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Loads the data bar conditional format from a JSON string.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IRange.html" title="interface in com.grapecity.documents.excel">IRange</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getAppliesTo()">getAppliesTo</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the cell range to which this data bar conditional formatting rule is applied.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IFormatColor.html" title="interface in com.grapecity.documents.excel">IFormatColor</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getAxisColor()">getAxisColor</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the color of the axis for cells with conditional formatting as data bars.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="DataBarAxisPosition.html" title="enum class in com.grapecity.documents.excel">DataBarAxisPosition</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getAxisPosition()">getAxisPosition</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the axis position of the data bars in this conditional formatting rule.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IDataBarBorder.html" title="interface in com.grapecity.documents.excel">IDataBarBorder</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getBarBorder()">getBarBorder</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets an object that specifies the border of a data bar.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IFormatColor.html" title="interface in com.grapecity.documents.excel">IFormatColor</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getBarColor()">getBarColor</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the color of the bars in this data bar conditional formatting rule.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="DataBarFillType.html" title="enum class in com.grapecity.documents.excel">DataBarFillType</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getBarFillType()">getBarFillType</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets how a data bar is filled with color.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="DataBarDirection.html" title="enum class in com.grapecity.documents.excel">DataBarDirection</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getDirection()">getDirection</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the display direction of the data bar.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IConditionValue.html" title="interface in com.grapecity.documents.excel">IConditionValue</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getMaxPoint()">getMaxPoint</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the  <a href="IConditionValue.html" title="interface in com.grapecity.documents.excel"><code>IConditionValue</code></a> that specifies how the longest bar is evaluated for a data bar conditional format.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IConditionValue.html" title="interface in com.grapecity.documents.excel">IConditionValue</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getMinPoint()">getMinPoint</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the  <a href="IConditionValue.html" title="interface in com.grapecity.documents.excel"><code>IConditionValue</code></a> that specifies how the shortest bar is evaluated for a data bar conditional format.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="INegativeBarFormat.html" title="interface in com.grapecity.documents.excel">INegativeBarFormat</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getNegativeBarFormat()">getNegativeBarFormat</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the negative bar format settings for this data bar conditional formatting rule.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>int</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getPercentMax()">getPercentMax</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the length of the longest data bar as a percentage of the cell width.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>int</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getPercentMin()">getPercentMin</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the length of the shortest data bar as a percentage of the cell width.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>int</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getPriority()">getPriority</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the priority value of the conditional formatting rule.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>boolean</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getShowValue()">getShowValue</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets whether cell values are displayed when the data bar conditional format is applied.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>boolean</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getStopIfTrue()">getStopIfTrue</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets whether additional conditional formatting rules on the cell are evaluated  after this data bar rule evaluates to  <code>true</code>.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="FormatConditionType.html" title="enum class in com.grapecity.documents.excel">FormatConditionType</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getType()">getType</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the type of this conditional format.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setAppliesTo(com.grapecity.documents.excel.IRange)">setAppliesTo</a><wbr>(<a href="IRange.html" title="interface in com.grapecity.documents.excel">IRange</a>&nbsp;value)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the cell range to which this data bar conditional formatting rule is applied.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setAxisPosition(com.grapecity.documents.excel.DataBarAxisPosition)">setAxisPosition</a><wbr>(<a href="DataBarAxisPosition.html" title="enum class in com.grapecity.documents.excel">DataBarAxisPosition</a>&nbsp;value)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the axis position of the data bars in this conditional formatting rule.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setBarFillType(com.grapecity.documents.excel.DataBarFillType)">setBarFillType</a><wbr>(<a href="DataBarFillType.html" title="enum class in com.grapecity.documents.excel">DataBarFillType</a>&nbsp;value)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets how a data bar is filled with color.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setDirection(com.grapecity.documents.excel.DataBarDirection)">setDirection</a><wbr>(<a href="DataBarDirection.html" title="enum class in com.grapecity.documents.excel">DataBarDirection</a>&nbsp;value)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the display direction of the data bar.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setFirstPriority()">setFirstPriority</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the priority value for this conditional formatting rule to  <code>1</code> so that it is evaluated before all other rules on the worksheet.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setLastPriority()">setLastPriority</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the evaluation order for this data bar rule so it is  evaluated after all other rules on the worksheet.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setPercentMax(int)">setPercentMax</a><wbr>(int&nbsp;value)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets an Integer value that specifies the length of the longest data bar as a percentage of cell width.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setPercentMin(int)">setPercentMin</a><wbr>(int&nbsp;value)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets an Integer value that specifies the length of the shortest data bar as a percentage of cell width.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setPriority(int)">setPriority</a><wbr>(int&nbsp;value)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the priority value of the conditional formatting rule.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setShowValue(boolean)">setShowValue</a><wbr>(boolean&nbsp;value)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets whether cell values are displayed when the data bar conditional format is applied.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="external-link" href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang">String</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#toJson()">toJson</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Generates a JSON string from the data bar rule.</div>
</div>
</div>
</div>
</div>
</section>
</li>
</ul>
</section>
<section class="details">
<ul class="details-list">
<!-- ============ METHOD DETAIL ========== -->
<li>
<section class="method-details" id="method-detail">
<h2>Method Details</h2>
<ul class="member-list">
<li>
<section class="detail" id="getAppliesTo()">
<h3>getAppliesTo</h3>
<div class="member-signature"><span class="return-type"><a href="IRange.html" title="interface in com.grapecity.documents.excel">IRange</a></span>&nbsp;<span class="element-name">getAppliesTo</span>()</div>
<div class="block">Gets the cell range to which this data bar conditional formatting rule is applied. <p>Use this method to retrieve the  <a href="IRange.html" title="interface in com.grapecity.documents.excel"><code>IRange</code></a> associated with the current data bar rule.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IRange appliesTo = dataBar.getAppliesTo();
 String address = appliesTo.getAddress();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The <a href="IRange.html" title="interface in com.grapecity.documents.excel"><code>IRange</code></a> to which this data bar rule is applied.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setAppliesTo(com.grapecity.documents.excel.IRange)">
<h3>setAppliesTo</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setAppliesTo</span><wbr><span class="parameters">(<a href="IRange.html" title="interface in com.grapecity.documents.excel">IRange</a>&nbsp;value)</span></div>
<div class="block">Sets the cell range to which this data bar conditional formatting rule is applied. <p>Use this method to change the  <a href="IRange.html" title="interface in com.grapecity.documents.excel"><code>IRange</code></a> associated with the current data bar rule.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setAppliesTo(worksheet.getRange("B1:B3"));
 IRange appliesTo = dataBar.getAppliesTo();
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The <a href="IRange.html" title="interface in com.grapecity.documents.excel"><code>IRange</code></a> to which this data bar rule is applied. Must not be <code>null</code>.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getAxisColor()">
<h3>getAxisColor</h3>
<div class="member-signature"><span class="return-type"><a href="IFormatColor.html" title="interface in com.grapecity.documents.excel">IFormatColor</a></span>&nbsp;<span class="element-name">getAxisColor</span>()</div>
<div class="block">Gets the color of the axis for cells with conditional formatting as data bars. <p>Returns an  <a href="IFormatColor.html" title="interface in com.grapecity.documents.excel"><code>IFormatColor</code></a> object that you can use to read or modify the axis color of the data bar rule.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{-10}, {0}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setAxisPosition(DataBarAxisPosition.Automatic);
 IFormatColor axisColor = dataBar.getAxisColor();
 axisColor.setColor(Color.GetBlue());
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>An <a href="IFormatColor.html" title="interface in com.grapecity.documents.excel"><code>IFormatColor</code></a> object that represents the axis color of the data bar rule.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getAxisPosition()">
<h3>getAxisPosition</h3>
<div class="member-signature"><span class="return-type"><a href="DataBarAxisPosition.html" title="enum class in com.grapecity.documents.excel">DataBarAxisPosition</a></span>&nbsp;<span class="element-name">getAxisPosition</span>()</div>
<div class="block">Gets the axis position of the data bars in this conditional formatting rule. <p>The axis position controls how positive and negative data bars are separated  within each cell. Use  <a href="DataBarAxisPosition.html#Automatic"><code>DataBarAxisPosition.Automatic</code></a> to place the axis based on the values in the range,  <a href="DataBarAxisPosition.html#Midpoint"><code>DataBarAxisPosition.Midpoint</code></a> to keep the axis centered, or  <a href="DataBarAxisPosition.html#None"><code>DataBarAxisPosition.None</code></a> to hide the axis.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{-10}, {0}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setAxisPosition(DataBarAxisPosition.Automatic);
 DataBarAxisPosition axisPosition = dataBar.getAxisPosition();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>A <a href="DataBarAxisPosition.html" title="enum class in com.grapecity.documents.excel"><code>DataBarAxisPosition</code></a> value that indicates where the data bar axis is displayed.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setAxisPosition(com.grapecity.documents.excel.DataBarAxisPosition)">
<h3>setAxisPosition</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setAxisPosition</span><wbr><span class="parameters">(<a href="DataBarAxisPosition.html" title="enum class in com.grapecity.documents.excel">DataBarAxisPosition</a>&nbsp;value)</span></div>
<div class="block">Sets the axis position of the data bars in this conditional formatting rule. <p>The axis position controls how positive and negative data bars are separated  within each cell. Use  <a href="DataBarAxisPosition.html#Automatic"><code>DataBarAxisPosition.Automatic</code></a> to place the axis based on the values in the range,  <a href="DataBarAxisPosition.html#Midpoint"><code>DataBarAxisPosition.Midpoint</code></a> to keep the axis centered, or  <a href="DataBarAxisPosition.html#None"><code>DataBarAxisPosition.None</code></a> to hide the axis.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{-10}, {0}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setAxisPosition(DataBarAxisPosition.Midpoint);
 DataBarAxisPosition axisPosition = dataBar.getAxisPosition();
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The <a href="DataBarAxisPosition.html" title="enum class in com.grapecity.documents.excel"><code>DataBarAxisPosition</code></a> value that specifies where the data bar axis is displayed.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getBarBorder()">
<h3>getBarBorder</h3>
<div class="member-signature"><span class="return-type"><a href="IDataBarBorder.html" title="interface in com.grapecity.documents.excel">IDataBarBorder</a></span>&nbsp;<span class="element-name">getBarBorder</span>()</div>
<div class="block">Gets an object that specifies the border of a data bar. <p>Use the returned  <a href="IDataBarBorder.html" title="interface in com.grapecity.documents.excel"><code>IDataBarBorder</code></a> object to configure the border appearance of the current data bar, such as its border type and color.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A5").setValue(new Object[][] {{1}, {2}, {3}, {4}, {5}});
 IDataBar dataBar = worksheet.getRange("A1:A5").getFormatConditions().addDatabar();
 IDataBarBorder border = dataBar.getBarBorder();
 border.setType(DataBarBorderType.Solid);
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The <a href="IDataBarBorder.html" title="interface in com.grapecity.documents.excel"><code>IDataBarBorder</code></a> object that specifies the border of a data bar.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getBarColor()">
<h3>getBarColor</h3>
<div class="member-signature"><span class="return-type"><a href="IFormatColor.html" title="interface in com.grapecity.documents.excel">IFormatColor</a></span>&nbsp;<span class="element-name">getBarColor</span>()</div>
<div class="block">Gets the color of the bars in this data bar conditional formatting rule. <p>Returns an  <a href="IFormatColor.html" title="interface in com.grapecity.documents.excel"><code>IFormatColor</code></a> object that you can use to read or modify the fill color applied to the data bars.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IFormatColor barColor = dataBar.getBarColor();
 barColor.setColor(Color.GetRed());
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The color of the bars in this data bar conditional formatting rule.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getBarFillType()">
<h3>getBarFillType</h3>
<div class="member-signature"><span class="return-type"><a href="DataBarFillType.html" title="enum class in com.grapecity.documents.excel">DataBarFillType</a></span>&nbsp;<span class="element-name">getBarFillType</span>()</div>
<div class="block">Gets how a data bar is filled with color. <p>Returns a  <a href="DataBarFillType.html" title="enum class in com.grapecity.documents.excel"><code>DataBarFillType</code></a> value that indicates whether the data bar uses a solid fill or a gradient fill.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setBarFillType(DataBarFillType.Gradient);
 DataBarFillType fillType = dataBar.getBarFillType();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>A <a href="DataBarFillType.html" title="enum class in com.grapecity.documents.excel"><code>DataBarFillType</code></a> value that specifies how a data bar is filled with color.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setBarFillType(com.grapecity.documents.excel.DataBarFillType)">
<h3>setBarFillType</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setBarFillType</span><wbr><span class="parameters">(<a href="DataBarFillType.html" title="enum class in com.grapecity.documents.excel">DataBarFillType</a>&nbsp;value)</span></div>
<div class="block">Sets how a data bar is filled with color. <p>Use a  <a href="DataBarFillType.html" title="enum class in com.grapecity.documents.excel"><code>DataBarFillType</code></a> value to specify whether the data bar uses a solid fill or a gradient fill.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setBarFillType(DataBarFillType.Gradient);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The data bar fill type.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getDirection()">
<h3>getDirection</h3>
<div class="member-signature"><span class="return-type"><a href="DataBarDirection.html" title="enum class in com.grapecity.documents.excel">DataBarDirection</a></span>&nbsp;<span class="element-name">getDirection</span>()</div>
<div class="block">Gets the display direction of the data bar. <p>The returned  <a href="DataBarDirection.html" title="enum class in com.grapecity.documents.excel"><code>DataBarDirection</code></a> value determines whether the data bar follows the current context, is displayed from left to right, or is displayed  from right to left.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {20}, {30}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setDirection(DataBarDirection.RightToLeft);
 DataBarDirection direction = dataBar.getDirection();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>A <a href="DataBarDirection.html" title="enum class in com.grapecity.documents.excel"><code>DataBarDirection</code></a> value that specifies the display direction of the data bar.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setDirection(com.grapecity.documents.excel.DataBarDirection)">
<h3>setDirection</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDirection</span><wbr><span class="parameters">(<a href="DataBarDirection.html" title="enum class in com.grapecity.documents.excel">DataBarDirection</a>&nbsp;value)</span></div>
<div class="block">Sets the display direction of the data bar. <p>Use this method to control whether the data bar is rendered from left to right,  from right to left, or according to the worksheet context.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setDirection(DataBarDirection.RightToLeft);
 DataBarDirection direction = dataBar.getDirection();
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The data bar direction to apply. Must be a valid <a href="DataBarDirection.html" title="enum class in com.grapecity.documents.excel"><code>DataBarDirection</code></a> value.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getMaxPoint()">
<h3>getMaxPoint</h3>
<div class="member-signature"><span class="return-type"><a href="IConditionValue.html" title="interface in com.grapecity.documents.excel">IConditionValue</a></span>&nbsp;<span class="element-name">getMaxPoint</span>()</div>
<div class="block">Gets the  <a href="IConditionValue.html" title="interface in com.grapecity.documents.excel"><code>IConditionValue</code></a> that specifies how the longest bar is evaluated for a data bar conditional format. <p>Use the returned object to configure the maximum threshold for the data  bar, such as a numeric limit or another supported condition value type.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {20}, {30}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IConditionValue maxPoint = dataBar.getMaxPoint();
 maxPoint.setType(ConditionValueTypes.Number);
 maxPoint.setValue(30);
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The <a href="IConditionValue.html" title="interface in com.grapecity.documents.excel"><code>IConditionValue</code></a> object that specifies how the longest bar is evaluated for a data bar conditional format.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getMinPoint()">
<h3>getMinPoint</h3>
<div class="member-signature"><span class="return-type"><a href="IConditionValue.html" title="interface in com.grapecity.documents.excel">IConditionValue</a></span>&nbsp;<span class="element-name">getMinPoint</span>()</div>
<div class="block">Gets the  <a href="IConditionValue.html" title="interface in com.grapecity.documents.excel"><code>IConditionValue</code></a> that specifies how the shortest bar is evaluated for a data bar conditional format.<p>Use the returned object to configure the minimum threshold for the data bar, such as a numeric limit or another supported condition value type.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {20}, {30}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IConditionValue minPoint = dataBar.getMinPoint();
 minPoint.setType(ConditionValueTypes.Number);
 minPoint.setValue(10);
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The <a href="IConditionValue.html" title="interface in com.grapecity.documents.excel"><code>IConditionValue</code></a> object that specifies how the shortest bar is evaluated for a data bar conditional format.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getNegativeBarFormat()">
<h3>getNegativeBarFormat</h3>
<div class="member-signature"><span class="return-type"><a href="INegativeBarFormat.html" title="interface in com.grapecity.documents.excel">INegativeBarFormat</a></span>&nbsp;<span class="element-name">getNegativeBarFormat</span>()</div>
<div class="block">Gets the negative bar format settings for this data bar conditional formatting rule. <p>Use the returned  <a href="INegativeBarFormat.html" title="interface in com.grapecity.documents.excel"><code>INegativeBarFormat</code></a> object to configure the fill color and border color behavior for negative values in the data bar.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A4").setValue(new Object[][] {{-10}, {-5}, {0}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A4").getFormatConditions().addDatabar();
 INegativeBarFormat negativeBarFormat = dataBar.getNegativeBarFormat();
 negativeBarFormat.setColorType(DataBarNegativeColorType.Color);
 negativeBarFormat.getColor().setColor(Color.GetRed());
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The INegativeBarFormat settings for this data bar conditional formatting rule; see <a href="INegativeBarFormat.html" title="interface in com.grapecity.documents.excel"><code>INegativeBarFormat</code></a>.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getPercentMax()">
<h3>getPercentMax</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getPercentMax</span>()</div>
<div class="block">Gets the length of the longest data bar as a percentage of the cell width. <p>Use this property to determine the maximum visual length applied to data bars  in the conditional formatting rule.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setPercentMax(80);
 int percentMax = dataBar.getPercentMax();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The length of the longest data bar as a percentage of the cell width.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setPercentMax(int)">
<h3>setPercentMax</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setPercentMax</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets an Integer value that specifies the length of the longest data bar as a percentage of cell width. <p>Use this property to control the maximum visual length of data bars in the conditional formatting rule.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setPercentMax(80);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The percentage of the cell width used for the longest data bar.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getPercentMin()">
<h3>getPercentMin</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getPercentMin</span>()</div>
<div class="block">Gets the length of the shortest data bar as a percentage of the cell width. <p>Use this property to determine the minimum visual length applied to data bars  in the conditional formatting rule.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setPercentMin(15);
 int percentMin = dataBar.getPercentMin();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The length of the shortest data bar as a percentage of the cell width.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setPercentMin(int)">
<h3>setPercentMin</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setPercentMin</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets an Integer value that specifies the length of the shortest data bar as a percentage of cell width. <p>Use this method to control the minimum visible length of data bars in the conditional formatting rule.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setPercentMin(15);
 int percentMin = dataBar.getPercentMin();
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The length of the shortest data bar, expressed as a percentage of the cell width.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getPriority()">
<h3>getPriority</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getPriority</span>()</div>
<div class="block">Gets the priority value of the conditional formatting rule. <p>The priority determines the order in which conditional formatting rules are  evaluated when multiple rules exist on a worksheet. Priority values are unique  within the worksheet, so changing the priority of one rule can shift the  priority values of other rules.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:B3").setValue(new Object[][] {{10, 5}, {30, 15}, {20, 25}});
 IDataBar firstDataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IDataBar secondDataBar = worksheet.getRange("B1:B3").getFormatConditions().addDatabar();
 secondDataBar.setPriority(1);
 int priority = secondDataBar.getPriority();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The priority value of the conditional formatting rule.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setPriority(int)">
<h3>setPriority</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setPriority</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the priority value of the conditional formatting rule. <p>The priority determines the evaluation order when multiple conditional  formatting rules exist on a worksheet. The value must be a positive integer  between 1 and the total number of conditional formatting rules on the  worksheet. Because each rule must have a unique priority, changing the  priority of this rule may shift the priority values of other rules on the  worksheet.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:B3").setValue(new Object[][] {{10, 5}, {30, 15}, {20, 25}});
 IDataBar firstDataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IDataBar secondDataBar = worksheet.getRange("B1:B3").getFormatConditions().addDatabar();
 secondDataBar.setPriority(1);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The priority value of the conditional formatting rule. Must be a positive integer between 1 and the total number of conditional formatting  rules on the worksheet.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getShowValue()">
<h3>getShowValue</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getShowValue</span>()</div>
<div class="block">Gets whether cell values are displayed when the data bar conditional format is applied. <p>This property indicates whether the original cell values remain visible together  with the data bars.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setShowValue(false);
 boolean showValue = dataBar.getShowValue();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>true if cell values are displayed when the data bar conditional format is applied; otherwise, false.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setShowValue(boolean)">
<h3>setShowValue</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setShowValue</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether cell values are displayed when the data bar conditional format is applied. <p>Use this property to show or hide the original cell values while keeping the data bars visible.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setShowValue(false);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - <code>true</code> to display the cell values together with the data bars; otherwise, <code>false</code>.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getStopIfTrue()">
<h3>getStopIfTrue</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getStopIfTrue</span>()</div>
<div class="block">Gets whether additional conditional formatting rules on the cell are evaluated  after this data bar rule evaluates to  <code>true</code>. <p>If this property is  <code>true</code>, lower-priority conditional formatting rules  continue to be evaluated for the cells to which this data bar applies.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 boolean stopIfTrue = dataBar.getStopIfTrue();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>true if additional conditional formatting rules on the cell are evaluated after this data bar rule evaluates to; otherwise, false.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getType()">
<h3>getType</h3>
<div class="member-signature"><span class="return-type"><a href="FormatConditionType.html" title="enum class in com.grapecity.documents.excel">FormatConditionType</a></span>&nbsp;<span class="element-name">getType</span>()</div>
<div class="block">Gets the type of this conditional format. <p>For a data bar conditional formatting rule, this method returns the  corresponding  <a href="FormatConditionType.html" title="enum class in com.grapecity.documents.excel"><code>FormatConditionType</code></a> value, such as <a href="FormatConditionType.html#Databar"><code>FormatConditionType.Databar</code></a>.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A5").setValue(new Object[][] {{10}, {30}, {20}, {40}, {25}});
 IDataBar dataBar = worksheet.getRange("A1:A5").getFormatConditions().addDatabar();
 FormatConditionType type = dataBar.getType();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The type of this conditional format.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="delete()">
<h3>delete</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">delete</span>()</div>
<div class="block">Deletes this data bar conditional formatting rule. <p>After this method is called, the data bar is removed from the range to which  it applies.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A5").setValue(new Object[][] {{1}, {2}, {3}, {4}, {5}});
 IDataBar dataBar = worksheet.getRange("A1:A5").getFormatConditions().addDatabar();
 dataBar.delete();
 </code></pre></div>
</section>
</li>
<li>
<section class="detail" id="setFirstPriority()">
<h3>setFirstPriority</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setFirstPriority</span>()</div>
<div class="block">Sets the priority value for this conditional formatting rule to  <code>1</code> so that it is evaluated before all other rules on the worksheet. <p>Use this method to move a data bar rule to the highest evaluation priority  among the conditional formatting rules on the same worksheet.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:B3").setValue(new Object[][] {{10, 5}, {30, 15}, {20, 25}});
 IDataBar firstDataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IDataBar secondDataBar = worksheet.getRange("B1:B3").getFormatConditions().addDatabar();
 firstDataBar.setFirstPriority();
 </code></pre></div>
</section>
</li>
<li>
<section class="detail" id="setLastPriority()">
<h3>setLastPriority</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setLastPriority</span>()</div>
<div class="block">Sets the evaluation order for this data bar rule so it is  evaluated after all other rules on the worksheet. <p>Use this method to move the current data bar rule to the end of the  worksheet rule priority order.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:B3").setValue(new Object[][] {{10, 5}, {30, 15}, {20, 25}});
 IDataBar firstDataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 IDataBar secondDataBar = worksheet.getRange("B1:B3").getFormatConditions().addDatabar();
 secondDataBar.setLastPriority();
 </code></pre></div>
</section>
</li>
<li>
<section class="detail" id="fromJson(java.lang.String)">
<h3>fromJson</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">fromJson</span><wbr><span class="parameters">(<a class="external-link" href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang">String</a>&nbsp;json)</span></div>
<div class="block">Loads the data bar conditional format from a JSON string. <p>This method replaces the current data bar rule with the rule defined in  the specified JSON string. The JSON content is typically generated by  <a href="#toJson()"><code>toJson()</code></a>.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {{10}, {30}, {20}});
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 dataBar.setBarFillType(DataBarFillType.Solid);
 dataBar.getBarColor().setColor(Color.GetGreen());
 dataBar.setShowValue(false);
 String json = dataBar.toJson();
 IDataBar copiedDataBar = worksheet.getRange("B1:B3").getFormatConditions().addDatabar();
 copiedDataBar.fromJson(json);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>json</code> - The JSON string that defines a data bar conditional format.</dd>
<dt>Throws:</dt>
<dd><code><a class="external-link" href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/IllegalStateException.html" title="class or interface in java.lang">IllegalStateException</a></code> - if the specified JSON string does not describe a data bar conditional format.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="toJson()">
<h3>toJson</h3>
<div class="member-signature"><span class="return-type"><a class="external-link" href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang">String</a></span>&nbsp;<span class="element-name">toJson</span>()</div>
<div class="block">Generates a JSON string from the data bar rule. <p>Use this method to serialize the current data bar settings so that they can  be reused with  <a href="#fromJson(java.lang.String)"><code>fromJson(String)</code></a> or stored for later use.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1:A3").setValue(new Object[][] {
     {10},
     {30},
     {20}
 });
 IDataBar dataBar = worksheet.getRange("A1:A3").getFormatConditions().addDatabar();
 String json = dataBar.toJson();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>A JSON string that represents the current data bar rule.</dd>
</dl>
</section>
</li>
</ul>
</section>
</li>
</ul>
</section>
<!-- ========= END OF CLASS DATA ========= -->
<script>var evenRowColor = "even-row-color";
var oddRowColor = "odd-row-color";
var tableTab = "table-tab";
var activeTableTab = "active-table-tab";

function show(tableId, selected, columns) {
    if (tableId !== selected) {
        document.querySelectorAll('div.' + tableId + ':not(.' + selected + ')')
            .forEach(function (elem) {
                elem.style.display = 'none';
            });
    }
    document.querySelectorAll('div.' + selected)
        .forEach(function (elem, index) {
            elem.style.display = '';
            var isEvenRow = index % (columns * 2) < columns;
            elem.classList.remove(isEvenRow ? oddRowColor : evenRowColor);
            elem.classList.add(isEvenRow ? evenRowColor : oddRowColor);
        });
    updateTabs(tableId, selected);
}

function updateTabs(tableId, selected) {
    document.querySelector('div#' + tableId + ' .summary-table')
        .setAttribute('aria-labelledby', selected);
    document.querySelectorAll('button[id^="' + tableId + '"]')
        .forEach(function (tab, index) {
            if (selected === tab.id || (tableId === selected && index === 0)) {
                tab.className = activeTableTab;
                tab.setAttribute('aria-selected', true);
                tab.setAttribute('tabindex', 0);
            } else {
                tab.className = tableTab;
                tab.setAttribute('aria-selected', false);
                tab.setAttribute('tabindex', -1);
            }
        });
}

function switchTab(e) {
    var selected = document.querySelector('[aria-selected=true]');
    if (selected) {
        if ((e.keyCode === 37 || e.keyCode === 38) && selected.previousSibling) {
            // left or up arrow key pressed: move focus to previous tab
            selected.previousSibling.click();
            selected.previousSibling.focus();
            e.preventDefault();
        } else if ((e.keyCode === 39 || e.keyCode === 40) && selected.nextSibling) {
            // right or down arrow key pressed: move focus to next tab
            selected.nextSibling.click();
            selected.nextSibling.focus();
            e.preventDefault();
        }
    }
}
</script></div>