# IPivotTable

## 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 IPivotTable</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">IPivotTable</span></div>
<div class="block">Represents a PivotTable report on a worksheet. The PivotTable object is a member of the PivotTables collection. The PivotTables collection contains all the PivotTable objects on a single worksheet.</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 class="table-tabs" role="tablist" aria-orientation="horizontal"><button id="method-summary-table-tab0" role="tab" aria-selected="true" aria-controls="method-summary-table.tabpanel" tabindex="0" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table', 3)" class="active-table-tab">All Methods</button><button id="method-summary-table-tab2" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" class="table-tab">Instance Methods</button><button id="method-summary-table-tab3" role="tab" aria-selected="false" aria-controls="method-summary-table.tabpanel" tabindex="-1" onkeydown="switchTab(event)" onclick="show('method-summary-table', 'method-summary-table-tab3', 3)" class="table-tab">Abstract Methods</button></div>
<div id="method-summary-table.tabpanel" role="tabpanel">
<div class="summary-table three-column-summary" aria-labelledby="method-summary-table-tab0">
<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><a href="IPivotField.html" title="interface in com.grapecity.documents.excel">IPivotField</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#addDataField(com.grapecity.documents.excel.IPivotField,java.lang.String,com.grapecity.documents.excel.ConsolidationFunction)" class="member-name-link">addDataField</a><wbr>(<a href="IPivotField.html" title="interface in com.grapecity.documents.excel">IPivotField</a>&nbsp;field,
 <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;caption,
 <a href="ConsolidationFunction.html" title="enum class in com.grapecity.documents.excel">ConsolidationFunction</a>&nbsp;function)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Adds a data field to a PivotTable report.</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 href="#clearAllFilters()" class="member-name-link">clearAllFilters</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Deletes all filters currently applied to the PivotTable.</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 href="#clearTable()" class="member-name-link">clearTable</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Clears a PivotTable.</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 href="#getAllowMultipleFilters()" class="member-name-link">getAllowMultipleFilters</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 a value that indicates whether a PivotField can have multiple filters applied to it at the same time.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="ICalculatedFields.html" title="interface in com.grapecity.documents.excel">ICalculatedFields</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getCalculatedFields()" class="member-name-link">getCalculatedFields</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a CalculatedFields collection that represents all the calculated fields in the specified PivotTable report.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getColumnFields()" class="member-name-link">getColumnFields</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns an object that represents a collection of all the fields that are currently shown as column fields.</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 href="#getColumnGrand()" class="member-name-link">getColumnGrand</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 the PivotTable report shows grand totals for columns.</div>
</div>
<div class="col-first odd-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 odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getColumnRange()" class="member-name-link">getColumnRange</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a Range object that represents the range that contains the column area in the PivotTable report.</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 href="#getCompactRowIndent()" class="member-name-link">getCompactRowIndent</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns the indent increment for PivotItems when compact row layout form is turned on.</div>
</div>
<div class="col-first odd-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 odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getDataBodyRange()" class="member-name-link">getDataBodyRange</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getDataFields()" class="member-name-link">getDataFields</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns an object that represents a collection of all the fields that are currently shown as data fields.</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 href="#getDeferLayoutUpdate()" class="member-name-link">getDeferLayoutUpdate</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns whether the pivotTable defer layout update.</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 href="#getDisplayContextTooltips()" class="member-name-link">getDisplayContextTooltips</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 tooltips are displayed for PivotTable cells.</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 href="#getDisplayErrorString()" class="member-name-link">getDisplayErrorString</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 if the PivotTable report displays a custom error string in cells that contain errors.</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 href="#getDisplayFieldCaptions()" class="member-name-link">getDisplayFieldCaptions</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 a value indicating whether filter buttons and PivotField captions for rows and columns are displayed in the grid.</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 href="#getDisplayMemberPropertyTooltips()" class="member-name-link">getDisplayMemberPropertyTooltips</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 to display member properties in tooltips.</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 href="#getDisplayNullString()" class="member-name-link">getDisplayNullString</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 if the PivotTable report displays a custom string in cells that contain null values.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getErrorString()" class="member-name-link">getErrorString</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns the string displayed in cells that contain errors when the PivotTable.getDisplayErrorString() is True.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getGrandTotalName()" class="member-name-link">getGrandTotalName</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 text string label that is displayed in the grand total column or row heading in the specified PivotTable report.</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 href="#getHasAutoFormat()" class="member-name-link">getHasAutoFormat</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 a value indicating whether the PivotTable report automatically adjusts column width when refreshed.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="LayoutRowType.html" title="enum class in com.grapecity.documents.excel">LayoutRowType</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getLayoutRowDefault()" class="member-name-link">getLayoutRowDefault</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 default layout settings for PivotFields when they are added to the PivotTable for the first time.</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 href="#getMergeLabels()" class="member-name-link">getMergeLabels</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 if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getName()" class="member-name-link">getName</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 name of the object.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getNullString()" class="member-name-link">getNullString</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns the string displayed in cells that contain null values when the PivotTable.DisplayNullString property is True.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="Order.html" title="enum class in com.grapecity.documents.excel">Order</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPageFieldOrder()" class="member-name-link">getPageFieldOrder</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns the order in which page fields are added to the PivotTable report’s layout.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPageFields()" class="member-name-link">getPageFields</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns an object that represents a collection of all the fields that are currently showing as page fields.</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 href="#getPageFieldWrapCount()" class="member-name-link">getPageFieldWrapCount</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns the number of page fields in each column or row in the PivotTable report.</div>
</div>
<div class="col-first odd-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 odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPageRange()" class="member-name-link">getPageRange</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a Range object that represents the range that contains the page area in the PivotTable report.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotCache.html" title="interface in com.grapecity.documents.excel">IPivotCache</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPivotCache()" class="member-name-link">getPivotCache</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a PivotCache object that represents the cache for the specified PivotTable report.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotAxis.html" title="interface in com.grapecity.documents.excel">IPivotAxis</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPivotColumnAxis()" class="member-name-link">getPivotColumnAxis</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a PivotAxis object representing the entire column axis.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPivotFields()" class="member-name-link">getPivotFields</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of both the visible and hidden fields (a PivotFields object) in the PivotTable report.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotFormulas.html" title="interface in com.grapecity.documents.excel">IPivotFormulas</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPivotFormulas()" class="member-name-link">getPivotFormulas</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 a PivotFormulas object that represents the collection of formulas for the specified PivotTable report.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotAxis.html" title="interface in com.grapecity.documents.excel">IPivotAxis</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPivotRowAxis()" class="member-name-link">getPivotRowAxis</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a PivotAxis object representing the entire row axis.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getRowFields()" class="member-name-link">getRowFields</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns an object that represents either a collection of all the fields that are currently showing as row fields.</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 href="#getRowGrand()" class="member-name-link">getRowGrand</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 the PivotTable report shows grand totals for rows.</div>
</div>
<div class="col-first odd-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 odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getRowRange()" class="member-name-link">getRowRange</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a Range object that represents the range including the row area on the PivotTable report.</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 href="#getShowTableStyleColumnHeaders()" class="member-name-link">getShowTableStyleColumnHeaders</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 boolean value if the column headers should be displayed in the PivotTable.</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 href="#getShowTableStyleColumnStripes()" class="member-name-link">getShowTableStyleColumnStripes</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 boolean value displays banded columns in which even columns are formatted differently from odd columns.</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 href="#getShowTableStyleLastColumn()" class="member-name-link">getShowTableStyleLastColumn</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 boolean value if displays grand total columns style.</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 href="#getShowTableStyleRowHeaders()" class="member-name-link">getShowTableStyleRowHeaders</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 boolean value if the row headers should be displayed in the PivotTable.</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 href="#getShowTableStyleRowStripes()" class="member-name-link">getShowTableStyleRowStripes</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 boolean value displays banded rows in which even rows are formatted differently from odd rows.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="ITableStyle.html" title="interface in com.grapecity.documents.excel">ITableStyle</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getStyle()" class="member-name-link">getStyle</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 style currently applied to the specified pivot table.</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 href="#getTableRange1()" class="member-name-link">getTableRange1</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a Range object that represents the range containing the entire PivotTable report, but doesn’t include page fields.</div>
</div>
<div class="col-first odd-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 odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getTableRange2()" class="member-name-link">getTableRange2</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns a Range object that represents the range containing the entire PivotTable report, including page fields.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getTableStyle()" class="member-name-link">getTableStyle</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 style used in the body of the PivotTable report.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getTag()" class="member-name-link">getTag</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 a string saved with the PivotTable report.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotValueCell.html" title="interface in com.grapecity.documents.excel">IPivotValueCell</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#pivotValueCell(int,int)" class="member-name-link">pivotValueCell</a><wbr>(int&nbsp;rowline,
 int&nbsp;columnline)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Retrieve the PivotValueCell object for a given PivotTable provided certain row and column indices.</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 href="#refresh()" class="member-name-link">refresh</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Refreshes the PivotTable report from the source data.</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 href="#repeatAllLabels(com.grapecity.documents.excel.PivotFieldRepeatLabels)" class="member-name-link">repeatAllLabels</a><wbr>(<a href="PivotFieldRepeatLabels.html" title="enum class in com.grapecity.documents.excel">PivotFieldRepeatLabels</a>&nbsp;repeat)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets whether to repeat item labels for all PivotFields in the specified PivotTable.</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 href="#setAllowMultipleFilters(boolean)" class="member-name-link">setAllowMultipleFilters</a><wbr>(boolean&nbsp;allowMultipleFilters)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets a value that indicates whether a PivotField can have multiple filters applied to it at the same time.</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 href="#setColumnGrand(boolean)" class="member-name-link">setColumnGrand</a><wbr>(boolean&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 whether the PivotTable report shows grand totals for columns.</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 href="#setCompactRowIndent(int)" class="member-name-link">setCompactRowIndent</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 the indent increment for PivotItems when compact row layout form is turned on.</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 href="#setDeferLayoutUpdate(boolean)" class="member-name-link">setDeferLayoutUpdate</a><wbr>(boolean&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 whether the pivotTable defer layout update.</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 href="#setDisplayContextTooltips(boolean)" class="member-name-link">setDisplayContextTooltips</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 tooltips are displayed for PivotTable cells.</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 href="#setDisplayErrorString(boolean)" class="member-name-link">setDisplayErrorString</a><wbr>(boolean&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 if the PivotTable report displays a custom error string in cells that contain errors.</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 href="#setDisplayFieldCaptions(boolean)" class="member-name-link">setDisplayFieldCaptions</a><wbr>(boolean&nbsp;displayFieldCaptions)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets a value indicating whether filter buttons and PivotField captions for rows and columns are displayed in the grid.</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 href="#setDisplayMemberPropertyTooltips(boolean)" class="member-name-link">setDisplayMemberPropertyTooltips</a><wbr>(boolean&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 whether to display member properties in tooltips.</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 href="#setDisplayNullString(boolean)" class="member-name-link">setDisplayNullString</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 if the PivotTable report displays a custom string in cells that contain null values.</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 href="#setErrorString(java.lang.String)" class="member-name-link">setErrorString</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</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 string displayed in cells that contain errors when the PivotTable.getDisplayErrorString() is True.</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 href="#setGrandTotalName(java.lang.String)" class="member-name-link">setGrandTotalName</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</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 text string label that is displayed in the grand total column or row heading in the specified PivotTable report.</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 href="#setHasAutoFormat(boolean)" class="member-name-link">setHasAutoFormat</a><wbr>(boolean&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 a value indicating whether the PivotTable report automatically adjusts column width when refreshed.</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 href="#setLayoutRowDefault(com.grapecity.documents.excel.LayoutRowType)" class="member-name-link">setLayoutRowDefault</a><wbr>(<a href="LayoutRowType.html" title="enum class in com.grapecity.documents.excel">LayoutRowType</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 default layout settings for PivotFields when they are added to the PivotTable for the first time.</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 href="#setMergeLabels(boolean)" class="member-name-link">setMergeLabels</a><wbr>(boolean&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 if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells.</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 href="#setName(java.lang.String)" class="member-name-link">setName</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</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 name of the object.</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 href="#setNullString(java.lang.String)" class="member-name-link">setNullString</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</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 string displayed in cells that contain null values when the PivotTable.DisplayNullString property is True.</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 href="#setPageFieldOrder(com.grapecity.documents.excel.Order)" class="member-name-link">setPageFieldOrder</a><wbr>(<a href="Order.html" title="enum class in com.grapecity.documents.excel">Order</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 order in which page fields are added to the PivotTable report’s layout.</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 href="#setPageFieldWrapCount(int)" class="member-name-link">setPageFieldWrapCount</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 number of page fields in each column or row in the PivotTable report.</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 href="#setRowAxisLayout(com.grapecity.documents.excel.LayoutRowType)" class="member-name-link">setRowAxisLayout</a><wbr>(<a href="LayoutRowType.html" title="enum class in com.grapecity.documents.excel">LayoutRowType</a>&nbsp;rowLayout)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">This method is used for simultaneously setting layout options for all existing PivotFields.</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 href="#setRowGrand(boolean)" class="member-name-link">setRowGrand</a><wbr>(boolean&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 whether the PivotTable report shows grand totals for rows.</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 href="#setShowTableStyleColumnHeaders(boolean)" class="member-name-link">setShowTableStyleColumnHeaders</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 if the column headers should be displayed in the PivotTable.</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 href="#setShowTableStyleColumnStripes(boolean)" class="member-name-link">setShowTableStyleColumnStripes</a><wbr>(boolean&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 boolean value displays banded columns in which even columns are formatted differently from odd columns.</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 href="#setShowTableStyleLastColumn(boolean)" class="member-name-link">setShowTableStyleLastColumn</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 the boolean value if displays grand total columns style.</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 href="#setShowTableStyleRowHeaders(boolean)" class="member-name-link">setShowTableStyleRowHeaders</a><wbr>(boolean&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 boolean value if the row headers should be displayed in the PivotTable.</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 href="#setShowTableStyleRowStripes(boolean)" class="member-name-link">setShowTableStyleRowStripes</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 the boolean value displays banded rows in which even rows are formatted differently from odd rows.</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 href="#setStyle(com.grapecity.documents.excel.ITableStyle)" class="member-name-link">setStyle</a><wbr>(<a href="ITableStyle.html" title="interface in com.grapecity.documents.excel">ITableStyle</a>&nbsp;style)</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 style currently applied to the specified pivot table.</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 href="#setTableStyle(java.lang.String)" class="member-name-link">setTableStyle</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</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 style used in the body of the PivotTable report.</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 href="#setTag(java.lang.String)" class="member-name-link">setTag</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</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 a string saved with the PivotTable report.</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 href="#subtotalLocation(com.grapecity.documents.excel.SubtotalLocationType)" class="member-name-link">subtotalLocation</a><wbr>(<a href="SubtotalLocationType.html" title="enum class in com.grapecity.documents.excel">SubtotalLocationType</a>&nbsp;location)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Changes the subtotal location for all existing PivotFields.</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 href="#update()" class="member-name-link">update</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Updates the link or PivotTable report.</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="getColumnGrand()">
<h3>getColumnGrand</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getColumnGrand</span>()</div>
<div class="block">Gets whether the PivotTable report shows grand totals for columns.</div>
</section>
</li>
<li>
<section class="detail" id="setColumnGrand(boolean)">
<h3>setColumnGrand</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setColumnGrand</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the PivotTable report shows grand totals for columns.</div>
</section>
</li>
<li>
<section class="detail" id="getColumnFields()">
<h3>getColumnFields</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></span>&nbsp;<span class="element-name">getColumnFields</span>()</div>
<div class="block">Returns an object that represents a collection of all the fields that are currently shown as column fields. Read-only.</div>
</section>
</li>
<li>
<section class="detail" id="getColumnRange()">
<h3>getColumnRange</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">getColumnRange</span>()</div>
<div class="block">Returns a Range object that represents the range that contains the column area in the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getCompactRowIndent()">
<h3>getCompactRowIndent</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getCompactRowIndent</span>()</div>
<div class="block">Returns the indent increment for PivotItems when compact row layout form is turned on.</div>
</section>
</li>
<li>
<section class="detail" id="setCompactRowIndent(int)">
<h3>setCompactRowIndent</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setCompactRowIndent</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the indent increment for PivotItems when compact row layout form is turned on.</div>
</section>
</li>
<li>
<section class="detail" id="getDataBodyRange()">
<h3>getDataBodyRange</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">getDataBodyRange</span>()</div>
<div class="block">Returns a Range object that represents the range that contains the data area in the list between the header row and the insert row.</div>
</section>
</li>
<li>
<section class="detail" id="getDataFields()">
<h3>getDataFields</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></span>&nbsp;<span class="element-name">getDataFields</span>()</div>
<div class="block">Returns an object that represents a collection of all the fields that are currently shown as data fields. Read-only.</div>
</section>
</li>
<li>
<section class="detail" id="getDeferLayoutUpdate()">
<h3>getDeferLayoutUpdate</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDeferLayoutUpdate</span>()</div>
<div class="block">Returns whether the pivotTable defer layout update.</div>
</section>
</li>
<li>
<section class="detail" id="setDeferLayoutUpdate(boolean)">
<h3>setDeferLayoutUpdate</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDeferLayoutUpdate</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the pivotTable defer layout update.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayContextTooltips()">
<h3>getDisplayContextTooltips</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayContextTooltips</span>()</div>
<div class="block">Gets whether tooltips are displayed for PivotTable cells.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayContextTooltips(boolean)">
<h3>setDisplayContextTooltips</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayContextTooltips</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether tooltips are displayed for PivotTable cells.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayErrorString()">
<h3>getDisplayErrorString</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayErrorString</span>()</div>
<div class="block">Gets if the PivotTable report displays a custom error string in cells that contain errors. The default value is False.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayErrorString(boolean)">
<h3>setDisplayErrorString</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayErrorString</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets if the PivotTable report displays a custom error string in cells that contain errors.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayMemberPropertyTooltips()">
<h3>getDisplayMemberPropertyTooltips</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayMemberPropertyTooltips</span>()</div>
<div class="block">Gets whether to display member properties in tooltips.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayMemberPropertyTooltips(boolean)">
<h3>setDisplayMemberPropertyTooltips</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayMemberPropertyTooltips</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether to display member properties in tooltips.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayNullString()">
<h3>getDisplayNullString</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayNullString</span>()</div>
<div class="block">Gets if the PivotTable report displays a custom string in cells that contain null values. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayNullString(boolean)">
<h3>setDisplayNullString</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayNullString</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets if the PivotTable report displays a custom string in cells that contain null values.</div>
</section>
</li>
<li>
<section class="detail" id="getErrorString()">
<h3>getErrorString</h3>
<div class="member-signature"><span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></span>&nbsp;<span class="element-name">getErrorString</span>()</div>
<div class="block">Returns the string displayed in cells that contain errors when the PivotTable.getDisplayErrorString() is True. The default value is an empty string ("").</div>
</section>
</li>
<li>
<section class="detail" id="setErrorString(java.lang.String)">
<h3>setErrorString</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setErrorString</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;value)</span></div>
<div class="block">Sets the string displayed in cells that contain errors when the PivotTable.getDisplayErrorString() is True.</div>
</section>
</li>
<li>
<section class="detail" id="getGrandTotalName()">
<h3>getGrandTotalName</h3>
<div class="member-signature"><span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></span>&nbsp;<span class="element-name">getGrandTotalName</span>()</div>
<div class="block">Gets the text string label that is displayed in the grand total column or row heading in the specified PivotTable report. The default value is the string "Grand Total".</div>
</section>
</li>
<li>
<section class="detail" id="setGrandTotalName(java.lang.String)">
<h3>setGrandTotalName</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setGrandTotalName</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;value)</span></div>
<div class="block">Sets the text string label that is displayed in the grand total column or row heading in the specified PivotTable report. The default value is the string "Grand Total".</div>
</section>
</li>
<li>
<section class="detail" id="getLayoutRowDefault()">
<h3>getLayoutRowDefault</h3>
<div class="member-signature"><span class="return-type"><a href="LayoutRowType.html" title="enum class in com.grapecity.documents.excel">LayoutRowType</a></span>&nbsp;<span class="element-name">getLayoutRowDefault</span>()</div>
<div class="block">Gets the default layout settings for PivotFields when they are added to the PivotTable for the first time.</div>
</section>
</li>
<li>
<section class="detail" id="setLayoutRowDefault(com.grapecity.documents.excel.LayoutRowType)">
<h3>setLayoutRowDefault</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setLayoutRowDefault</span><wbr><span class="parameters">(<a href="LayoutRowType.html" title="enum class in com.grapecity.documents.excel">LayoutRowType</a>&nbsp;value)</span></div>
<div class="block">Sets the default layout settings for PivotFields when they are added to the PivotTable for the first time.</div>
</section>
</li>
<li>
<section class="detail" id="getMergeLabels()">
<h3>getMergeLabels</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getMergeLabels</span>()</div>
<div class="block">Gets if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells.</div>
</section>
</li>
<li>
<section class="detail" id="setMergeLabels(boolean)">
<h3>setMergeLabels</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setMergeLabels</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets if the specified PivotTable report’s outer-row item, column item, subtotal, and grand total labels use merged cells.</div>
</section>
</li>
<li>
<section class="detail" id="getName()">
<h3>getName</h3>
<div class="member-signature"><span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></span>&nbsp;<span class="element-name">getName</span>()</div>
<div class="block">Gets the name of the object.</div>
</section>
</li>
<li>
<section class="detail" id="setName(java.lang.String)">
<h3>setName</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setName</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;value)</span></div>
<div class="block">Sets the name of the object.</div>
</section>
</li>
<li>
<section class="detail" id="getNullString()">
<h3>getNullString</h3>
<div class="member-signature"><span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></span>&nbsp;<span class="element-name">getNullString</span>()</div>
<div class="block">Returns the string displayed in cells that contain null values when the PivotTable.DisplayNullString property is True. The default value is an empty string ("").</div>
</section>
</li>
<li>
<section class="detail" id="setNullString(java.lang.String)">
<h3>setNullString</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setNullString</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;value)</span></div>
<div class="block">Sets the string displayed in cells that contain null values when the PivotTable.DisplayNullString property is True.</div>
</section>
</li>
<li>
<section class="detail" id="getPageFieldOrder()">
<h3>getPageFieldOrder</h3>
<div class="member-signature"><span class="return-type"><a href="Order.html" title="enum class in com.grapecity.documents.excel">Order</a></span>&nbsp;<span class="element-name">getPageFieldOrder</span>()</div>
<div class="block">Returns the order in which page fields are added to the PivotTable report’s layout. Can be one of the following Order constants: DownThenOver or OverThenDown. The default constant is DownThenOver.</div>
</section>
</li>
<li>
<section class="detail" id="setPageFieldOrder(com.grapecity.documents.excel.Order)">
<h3>setPageFieldOrder</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setPageFieldOrder</span><wbr><span class="parameters">(<a href="Order.html" title="enum class in com.grapecity.documents.excel">Order</a>&nbsp;value)</span></div>
<div class="block">Sets the order in which page fields are added to the PivotTable report’s layout. Can be one of the following Order constants: DownThenOver or OverThenDown. The default constant is DownThenOver.</div>
</section>
</li>
<li>
<section class="detail" id="getPageFields()">
<h3>getPageFields</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></span>&nbsp;<span class="element-name">getPageFields</span>()</div>
<div class="block">Returns an object that represents a collection of all the fields that are currently showing as page fields. Read-only.</div>
</section>
</li>
<li>
<section class="detail" id="getPageFieldWrapCount()">
<h3>getPageFieldWrapCount</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getPageFieldWrapCount</span>()</div>
<div class="block">Returns the number of page fields in each column or row in the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="setPageFieldWrapCount(int)">
<h3>setPageFieldWrapCount</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setPageFieldWrapCount</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the number of page fields in each column or row in the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getPageRange()">
<h3>getPageRange</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">getPageRange</span>()</div>
<div class="block">Returns a Range object that represents the range that contains the page area in the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getPivotColumnAxis()">
<h3>getPivotColumnAxis</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotAxis.html" title="interface in com.grapecity.documents.excel">IPivotAxis</a></span>&nbsp;<span class="element-name">getPivotColumnAxis</span>()</div>
<div class="block">Returns a PivotAxis object representing the entire column axis.</div>
</section>
</li>
<li>
<section class="detail" id="getPivotRowAxis()">
<h3>getPivotRowAxis</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotAxis.html" title="interface in com.grapecity.documents.excel">IPivotAxis</a></span>&nbsp;<span class="element-name">getPivotRowAxis</span>()</div>
<div class="block">Returns a PivotAxis object representing the entire row axis.</div>
</section>
</li>
<li>
<section class="detail" id="getRowFields()">
<h3>getRowFields</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></span>&nbsp;<span class="element-name">getRowFields</span>()</div>
<div class="block">Returns an object that represents either a collection of all the fields that are currently showing as row fields. Read-only.</div>
</section>
</li>
<li>
<section class="detail" id="getRowGrand()">
<h3>getRowGrand</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getRowGrand</span>()</div>
<div class="block">Gets whether the PivotTable report shows grand totals for rows.</div>
</section>
</li>
<li>
<section class="detail" id="setRowGrand(boolean)">
<h3>setRowGrand</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setRowGrand</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the PivotTable report shows grand totals for rows.</div>
</section>
</li>
<li>
<section class="detail" id="getRowRange()">
<h3>getRowRange</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">getRowRange</span>()</div>
<div class="block">Returns a Range object that represents the range including the row area on the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getShowTableStyleColumnHeaders()">
<h3>getShowTableStyleColumnHeaders</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getShowTableStyleColumnHeaders</span>()</div>
<div class="block">Gets the boolean value if the column headers should be displayed in the PivotTable.</div>
</section>
</li>
<li>
<section class="detail" id="setShowTableStyleColumnHeaders(boolean)">
<h3>setShowTableStyleColumnHeaders</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setShowTableStyleColumnHeaders</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets if the column headers should be displayed in the PivotTable.</div>
</section>
</li>
<li>
<section class="detail" id="getShowTableStyleColumnStripes()">
<h3>getShowTableStyleColumnStripes</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getShowTableStyleColumnStripes</span>()</div>
<div class="block">Gets the boolean value displays banded columns in which even columns are formatted differently from odd columns. This makes PivotTableseasier to read.</div>
</section>
</li>
<li>
<section class="detail" id="setShowTableStyleColumnStripes(boolean)">
<h3>setShowTableStyleColumnStripes</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setShowTableStyleColumnStripes</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets the boolean value displays banded columns in which even columns are formatted differently from odd columns. This makes PivotTableseasier to read.</div>
</section>
</li>
<li>
<section class="detail" id="getShowTableStyleLastColumn()">
<h3>getShowTableStyleLastColumn</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getShowTableStyleLastColumn</span>()</div>
<div class="block">Gets the boolean value if displays grand total columns style.</div>
</section>
</li>
<li>
<section class="detail" id="setShowTableStyleLastColumn(boolean)">
<h3>setShowTableStyleLastColumn</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setShowTableStyleLastColumn</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets the boolean value if displays grand total columns style.</div>
</section>
</li>
<li>
<section class="detail" id="getShowTableStyleRowHeaders()">
<h3>getShowTableStyleRowHeaders</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getShowTableStyleRowHeaders</span>()</div>
<div class="block">Gets the boolean value if the row headers should be displayed in the PivotTable.</div>
</section>
</li>
<li>
<section class="detail" id="setShowTableStyleRowHeaders(boolean)">
<h3>setShowTableStyleRowHeaders</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setShowTableStyleRowHeaders</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets the boolean value if the row headers should be displayed in the PivotTable.</div>
</section>
</li>
<li>
<section class="detail" id="getShowTableStyleRowStripes()">
<h3>getShowTableStyleRowStripes</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getShowTableStyleRowStripes</span>()</div>
<div class="block">Gets the boolean value displays banded rows in which even rows are formatted differently from odd rows. This makes PivotTables easier to read.</div>
</section>
</li>
<li>
<section class="detail" id="setShowTableStyleRowStripes(boolean)">
<h3>setShowTableStyleRowStripes</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setShowTableStyleRowStripes</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets the boolean value displays banded rows in which even rows are formatted differently from odd rows. This makes PivotTables easier to read.</div>
</section>
</li>
<li>
<section class="detail" id="getTableRange1()">
<h3>getTableRange1</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">getTableRange1</span>()</div>
<div class="block">Returns a Range object that represents the range containing the entire PivotTable report, but doesn’t include page fields.</div>
</section>
</li>
<li>
<section class="detail" id="getTableRange2()">
<h3>getTableRange2</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">getTableRange2</span>()</div>
<div class="block">Returns a Range object that represents the range containing the entire PivotTable report, including page fields.</div>
</section>
</li>
<li>
<section class="detail" id="getTableStyle()">
<h3>getTableStyle</h3>
<div class="member-signature"><span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></span>&nbsp;<span class="element-name">getTableStyle</span>()</div>
<div class="block">Gets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default).</div>
</section>
</li>
<li>
<section class="detail" id="setTableStyle(java.lang.String)">
<h3>setTableStyle</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setTableStyle</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;value)</span></div>
<div class="block">Sets the style used in the body of the PivotTable report. The default value is a null string (no style is applied by default).</div>
</section>
</li>
<li>
<section class="detail" id="getTag()">
<h3>getTag</h3>
<div class="member-signature"><span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a></span>&nbsp;<span class="element-name">getTag</span>()</div>
<div class="block">Gets a string saved with the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="setTag(java.lang.String)">
<h3>setTag</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setTag</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;value)</span></div>
<div class="block">Sets a string saved with the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="addDataField(com.grapecity.documents.excel.IPivotField,java.lang.String,com.grapecity.documents.excel.ConsolidationFunction)">
<h3>addDataField</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotField.html" title="interface in com.grapecity.documents.excel">IPivotField</a></span>&nbsp;<span class="element-name">addDataField</span><wbr><span class="parameters">(<a href="IPivotField.html" title="interface in com.grapecity.documents.excel">IPivotField</a>&nbsp;field,
 <a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/String.html" title="class or interface in java.lang" class="external-link">String</a>&nbsp;caption,
 <a href="ConsolidationFunction.html" title="enum class in com.grapecity.documents.excel">ConsolidationFunction</a>&nbsp;function)</span></div>
<div class="block">Adds a data field to a PivotTable report. Returns a PivotField object that represents the new data field.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>field</code> - The unique field on the server. If the source data is Online AnalyticalProcessing (OLAP), the unique field is a cube field. If the source data is non-OLAP (non-OLAP source data), the unique field is a PivotTable field.</dd>
<dd><code>caption</code> - The label used in the PivotTable report to identify this data field.</dd>
<dd><code>function</code> - The function performed in the added data field.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getCalculatedFields()">
<h3>getCalculatedFields</h3>
<div class="member-signature"><span class="return-type"><a href="ICalculatedFields.html" title="interface in com.grapecity.documents.excel">ICalculatedFields</a></span>&nbsp;<span class="element-name">getCalculatedFields</span>()</div>
<div class="block">Returns a CalculatedFields collection that represents all the calculated fields in the specified PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="clearAllFilters()">
<h3>clearAllFilters</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">clearAllFilters</span>()</div>
<div class="block">Deletes all filters currently applied to the PivotTable. This includes deleting all filters in the PivotFilters collection of the PivotTable object, removing any manual filtering applied, and setting all PivotFields in the Report Filter area to the default item.</div>
</section>
</li>
<li>
<section class="detail" id="clearTable()">
<h3>clearTable</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">clearTable</span>()</div>
<div class="block">Clears a PivotTable. Clearing PivotTables includes removing all the fields and deleting all filtering and sorting applied to the PivotTables. This method resets the PivotTable to the state it had right after it was created, before any fields were added to it.</div>
</section>
</li>
<li>
<section class="detail" id="getPivotCache()">
<h3>getPivotCache</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotCache.html" title="interface in com.grapecity.documents.excel">IPivotCache</a></span>&nbsp;<span class="element-name">getPivotCache</span>()</div>
<div class="block">Returns a PivotCache object that represents the cache for the specified PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getPivotFields()">
<h3>getPivotFields</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotFields.html" title="interface in com.grapecity.documents.excel">IPivotFields</a></span>&nbsp;<span class="element-name">getPivotFields</span>()</div>
<div class="block">Returns an object that represents either a single PivotTable field (a PivotField object) or a collection of both the visible and hidden fields (a PivotFields object) in the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="pivotValueCell(int,int)">
<h3>pivotValueCell</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotValueCell.html" title="interface in com.grapecity.documents.excel">IPivotValueCell</a></span>&nbsp;<span class="element-name">pivotValueCell</span><wbr><span class="parameters">(int&nbsp;rowline,
 int&nbsp;columnline)</span></div>
<div class="block">Retrieve the PivotValueCell object for a given PivotTable provided certain row and column indices.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>rowline</code> - The row position in the data area.</dd>
<dd><code>columnline</code> - The column position in the data area.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="refresh()">
<h3>refresh</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">refresh</span>()</div>
<div class="block">Refreshes the PivotTable report from the source data. Returns True if it’s successful.</div>
<dl class="notes">
<dt>Throws:</dt>
<dd><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/IllegalStateException.html" title="class or interface in java.lang" class="external-link">IllegalStateException</a></code> - if the source sheet of the PivotTable can not be found.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="repeatAllLabels(com.grapecity.documents.excel.PivotFieldRepeatLabels)">
<h3>repeatAllLabels</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">repeatAllLabels</span><wbr><span class="parameters">(<a href="PivotFieldRepeatLabels.html" title="enum class in com.grapecity.documents.excel">PivotFieldRepeatLabels</a>&nbsp;repeat)</span></div>
<div class="block">Sets whether to repeat item labels for all PivotFields in the specified PivotTable.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>repeat</code> - Specifies whether to repeat item labels for all PivotFields in the specified PivotTable.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setRowAxisLayout(com.grapecity.documents.excel.LayoutRowType)">
<h3>setRowAxisLayout</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setRowAxisLayout</span><wbr><span class="parameters">(<a href="LayoutRowType.html" title="enum class in com.grapecity.documents.excel">LayoutRowType</a>&nbsp;rowLayout)</span></div>
<div class="block">This method is used for simultaneously setting layout options for all existing PivotFields.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>rowLayout</code> - Specifies the type of layout row.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="subtotalLocation(com.grapecity.documents.excel.SubtotalLocationType)">
<h3>subtotalLocation</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">subtotalLocation</span><wbr><span class="parameters">(<a href="SubtotalLocationType.html" title="enum class in com.grapecity.documents.excel">SubtotalLocationType</a>&nbsp;location)</span></div>
<div class="block">Changes the subtotal location for all existing PivotFields. Changing the subtotal location has an immediate visual effect only for fields in outline form, but it will be set for fields in tabular form as well.</div>
</section>
</li>
<li>
<section class="detail" id="update()">
<h3>update</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">update</span>()</div>
<div class="block">Updates the link or PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getStyle()">
<h3>getStyle</h3>
<div class="member-signature"><span class="return-type"><a href="ITableStyle.html" title="interface in com.grapecity.documents.excel">ITableStyle</a></span>&nbsp;<span class="element-name">getStyle</span>()</div>
<div class="block">Gets the style currently applied to the specified pivot table.</div>
</section>
</li>
<li>
<section class="detail" id="setStyle(com.grapecity.documents.excel.ITableStyle)">
<h3>setStyle</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setStyle</span><wbr><span class="parameters">(<a href="ITableStyle.html" title="interface in com.grapecity.documents.excel">ITableStyle</a>&nbsp;style)</span></div>
<div class="block">Sets the style currently applied to the specified pivot table.</div>
</section>
</li>
<li>
<section class="detail" id="getPivotFormulas()">
<h3>getPivotFormulas</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotFormulas.html" title="interface in com.grapecity.documents.excel">IPivotFormulas</a></span>&nbsp;<span class="element-name">getPivotFormulas</span>()</div>
<div class="block">Gets a PivotFormulas object that represents the collection of formulas for the specified PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getAllowMultipleFilters()">
<h3>getAllowMultipleFilters</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getAllowMultipleFilters</span>()</div>
<div class="block">Gets a value that indicates whether a PivotField can have multiple filters applied to it at the same time.</div>
</section>
</li>
<li>
<section class="detail" id="setAllowMultipleFilters(boolean)">
<h3>setAllowMultipleFilters</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setAllowMultipleFilters</span><wbr><span class="parameters">(boolean&nbsp;allowMultipleFilters)</span></div>
<div class="block">Sets a value that indicates whether a PivotField can have multiple filters applied to it at the same time.</div>
</section>
</li>
<li>
<section class="detail" id="getHasAutoFormat()">
<h3>getHasAutoFormat</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getHasAutoFormat</span>()</div>
<div class="block">Gets a value indicating whether the PivotTable report automatically adjusts column width when refreshed. Default value is true.</div>
</section>
</li>
<li>
<section class="detail" id="setHasAutoFormat(boolean)">
<h3>setHasAutoFormat</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setHasAutoFormat</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets a value indicating whether the PivotTable report automatically adjusts column width when refreshed.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayFieldCaptions()">
<h3>getDisplayFieldCaptions</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayFieldCaptions</span>()</div>
<div class="block">Gets a value indicating whether filter buttons and PivotField captions for rows and columns are displayed in the grid. Default value is true.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayFieldCaptions(boolean)">
<h3>setDisplayFieldCaptions</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayFieldCaptions</span><wbr><span class="parameters">(boolean&nbsp;displayFieldCaptions)</span></div>
<div class="block">Sets a value indicating whether filter buttons and PivotField captions for rows and columns are displayed in the grid.</div>
</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>