# IPivotField

## 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 IPivotField</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">IPivotField</span></div>
<div class="block">Represents a field in a PivotTable report. The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.</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>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#autoSort(com.grapecity.documents.excel.SortOrder)" class="member-name-link">autoSort</a><wbr>(<a href="SortOrder.html" title="enum class in com.grapecity.documents.excel">SortOrder</a>&nbsp;Order)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Establishes automatic field-sorting rules for PivotTable reports.</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="#autoSort(com.grapecity.documents.excel.SortOrder,java.lang.String)" class="member-name-link">autoSort</a><wbr>(<a href="SortOrder.html" title="enum class in com.grapecity.documents.excel">SortOrder</a>&nbsp;Order,
 <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;Field)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Establishes automatic field-sorting rules for PivotTable reports.</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="#clearAllFilters()" class="member-name-link">clearAllFilters</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Deletes all filters currently applied to the PivotField.</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="#clearLabelFilter()" class="member-name-link">clearLabelFilter</a>()</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 deletes all label filters or all date filters in the PivotFilters collection of the PivotField.</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="#clearManualFilter()" class="member-name-link">clearManualFilter</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList and VisibleItemsList collections in OLAP PivotTables.</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="#clearValueFilter()" class="member-name-link">clearValueFilter</a>()</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 deletes all value filters in the PivotFilters collection of the PivotField.</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="#getAllItemsVisible()" class="member-name-link">getAllItemsVisible</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Retrieves a value that indicates whether any manual filtering is applied to Pivotfield.</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="#getAutoSortField()" class="member-name-link">getAutoSortField</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 name of the data field used to sort the specified PivotTable field automatically.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="SortOrder.html" title="enum class in com.grapecity.documents.excel">SortOrder</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getAutoSortOrder()" class="member-name-link">getAutoSortOrder</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 used to sort the specified PivotTable field automatically.</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="#getBaseField()" class="member-name-link">getBaseField</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 base field for a custom calculation.</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="#getBaseItem()" class="member-name-link">getBaseItem</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 item in the base field for a custom calculation.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="ICalculatedItems.html" title="interface in com.grapecity.documents.excel">ICalculatedItems</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getCalculatedItems()" class="member-name-link">getCalculatedItems</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  <code>ICalculatedItems</code> collection that represents all the calculated items 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><a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel">PivotFieldCalculation</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getCalculation()" class="member-name-link">getCalculation</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  <a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel"><code>PivotFieldCalculation</code></a> value that represents the type of calculation performed by the specified field.This property is valid only for data fields.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>int</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getCurrentPage()" class="member-name-link">getCurrentPage</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 current page's index showing for the page field (valid only for page 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="#getDragToColumn()" class="member-name-link">getDragToColumn</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 specified field can be dragged to the column position.</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="#getDragToData()" class="member-name-link">getDragToData</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 the specified field can be dragged to the data position.</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="#getDragToHide()" class="member-name-link">getDragToHide</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 field can be hidden by being dragged off the 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="#getDragToPage()" class="member-name-link">getDragToPage</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 the field can be dragged to the page position.</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="#getDragToRow()" class="member-name-link">getDragToRow</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 field can be dragged to the row position.</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="#getEnableMultiplePageItems()" class="member-name-link">getEnableMultiplePageItems</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 the field can have multiple items selected in the page field.</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="#getFormula()" class="member-name-link">getFormula</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 String value that represents the object's formula in A1-style notation and in the language of the macro.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="ConsolidationFunction.html" title="enum class in com.grapecity.documents.excel">ConsolidationFunction</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getFunction()" class="member-name-link">getFunction</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 function used to summarize the PivotTable field (data fields only).</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="#getLayoutBlankLine()" class="member-name-link">getLayoutBlankLine</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 a blank row is inserted after the specified row field in a 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="#getLayoutCompactRow()" class="member-name-link">getLayoutCompactRow</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 or not a PivotField is compacted(items of multiple PivotFields are displayed in a single column) when rows are selected.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="LayoutFormType.html" title="enum class in com.grapecity.documents.excel">LayoutFormType</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getLayoutForm()" class="member-name-link">getLayoutForm</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 way the specified PivotTable items appear — in table format or in outline format.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="SubtotalLocationType.html" title="enum class in com.grapecity.documents.excel">SubtotalLocationType</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getLayoutSubtotalLocation()" class="member-name-link">getLayoutSubtotalLocation</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 position of the PivotTable field subtotals in relation to (either above or below) the specified field.</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="#getNumberFormat()" class="member-name-link">getNumberFormat</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 format code for the object.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="PivotFieldOrientation.html" title="enum class in com.grapecity.documents.excel">PivotFieldOrientation</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getOrientation()" class="member-name-link">getOrientation</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 location of the field 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="IPivotFilters.html" title="interface in com.grapecity.documents.excel">IPivotFilters</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPivotFilters()" class="member-name-link">getPivotFilters</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Get the filter set of the current  <a href="IPivotField.html" title="interface in com.grapecity.documents.excel"><code>IPivotField</code></a>.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="IPivotItems.html" title="interface in com.grapecity.documents.excel">IPivotItems</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPivotItems()" class="member-name-link">getPivotItems</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 collection of all the visible and hidden items in the specified field.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>int</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getPosition()" class="member-name-link">getPosition</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 position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, Data).</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="#getRepeatLabels()" class="member-name-link">getRepeatLabels</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 item labels are repeated in the PivotTable for the specified PivotField.</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="#getShowAllItems()" class="member-name-link">getShowAllItems</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 all items in the PivotTable report are displayed, even if they don’t contain summary data.</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="#getSourceName()" class="member-name-link">getSourceName</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 specified object’s name as it appears in the original source data 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="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a>&lt;<a href="SubtotalType.html" title="enum class in com.grapecity.documents.excel">SubtotalType</a>&gt;</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getSubtotals()" class="member-name-link">getSubtotals</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 combination of all the showing subtotal types in the specified PivotField.</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="#setBaseField(java.lang.String)" class="member-name-link">setBaseField</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 base field for a custom calculation.</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="#setBaseItem(java.lang.String)" class="member-name-link">setBaseItem</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 item in the base field for a custom calculation.</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="#setCalculation(com.grapecity.documents.excel.PivotFieldCalculation)" class="member-name-link">setCalculation</a><wbr>(<a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel">PivotFieldCalculation</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  <a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel"><code>PivotFieldCalculation</code></a> value that represents the type of calculation performed by the specified field.This property is valid only for data fields.</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="#setCurrentPage(int)" class="member-name-link">setCurrentPage</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 current page's index showing for the page field (valid only for page fields).</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="#setDragToColumn(boolean)" class="member-name-link">setDragToColumn</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 specified field can be dragged to the column position.</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="#setDragToData(boolean)" class="member-name-link">setDragToData</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 the specified field can be dragged to the data position.</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="#setDragToHide(boolean)" class="member-name-link">setDragToHide</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 field can be hidden by being dragged off 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="#setDragToPage(boolean)" class="member-name-link">setDragToPage</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 the field can be dragged to the page position.</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="#setDragToRow(boolean)" class="member-name-link">setDragToRow</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 field can be dragged to the row position.</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="#setEnableMultiplePageItems(boolean)" class="member-name-link">setEnableMultiplePageItems</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 the field can have multiple items selected in the page field.</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="#setFormula(java.lang.String)" class="member-name-link">setFormula</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 value that represents the object's formula in A1-style notation and in the language of the macro.</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="#setFunction(com.grapecity.documents.excel.ConsolidationFunction)" class="member-name-link">setFunction</a><wbr>(<a href="ConsolidationFunction.html" title="enum class in com.grapecity.documents.excel">ConsolidationFunction</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 function used to summarize the PivotTable field (data fields only).</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="#setLayoutBlankLine(boolean)" class="member-name-link">setLayoutBlankLine</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 a blank row is inserted after the specified row field in 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="#setLayoutCompactRow(boolean)" class="member-name-link">setLayoutCompactRow</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 or not a PivotField is compacted(items of multiple PivotFields are displayed in a single column) when rows are selected.</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="#setLayoutForm(com.grapecity.documents.excel.LayoutFormType)" class="member-name-link">setLayoutForm</a><wbr>(<a href="LayoutFormType.html" title="enum class in com.grapecity.documents.excel">LayoutFormType</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 way the specified PivotTable items appear — in table format or in outline format.</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="#setLayoutSubtotalLocation(com.grapecity.documents.excel.SubtotalLocationType)" class="member-name-link">setLayoutSubtotalLocation</a><wbr>(<a href="SubtotalLocationType.html" title="enum class in com.grapecity.documents.excel">SubtotalLocationType</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 position of the PivotTable field subtotals in relation to (either above or below) the specified field.</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="#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 even-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 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="#setNumberFormat(java.lang.String)" class="member-name-link">setNumberFormat</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 format code for 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="#setOrientation(com.grapecity.documents.excel.PivotFieldOrientation)" class="member-name-link">setOrientation</a><wbr>(<a href="PivotFieldOrientation.html" title="enum class in com.grapecity.documents.excel">PivotFieldOrientation</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 location of the field 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>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#setPosition(int)" class="member-name-link">setPosition</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 position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, 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="#setRepeatLabels(boolean)" class="member-name-link">setRepeatLabels</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 item labels are repeated in the PivotTable for the specified PivotField.</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="#setShowAllItems(boolean)" class="member-name-link">setShowAllItems</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 all items in the PivotTable report are displayed, even if they don’t contain summary 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="#setSubtotals(java.util.EnumSet)" class="member-name-link">setSubtotals</a><wbr>(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a>&lt;<a href="SubtotalType.html" title="enum class in com.grapecity.documents.excel">SubtotalType</a>&gt;&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 combination of all the showing subtotal types in the specified PivotField.</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="getAllItemsVisible()">
<h3>getAllItemsVisible</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getAllItemsVisible</span>()</div>
<div class="block">Retrieves a value that indicates whether any manual filtering is applied to Pivotfield.</div>
</section>
</li>
<li>
<section class="detail" id="getAutoSortField()">
<h3>getAutoSortField</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">getAutoSortField</span>()</div>
<div class="block">Returns the name of the data field used to sort the specified PivotTable field automatically.</div>
</section>
</li>
<li>
<section class="detail" id="getAutoSortOrder()">
<h3>getAutoSortOrder</h3>
<div class="member-signature"><span class="return-type"><a href="SortOrder.html" title="enum class in com.grapecity.documents.excel">SortOrder</a></span>&nbsp;<span class="element-name">getAutoSortOrder</span>()</div>
<div class="block">Returns the order used to sort the specified PivotTable field automatically.</div>
</section>
</li>
<li>
<section class="detail" id="getBaseField()">
<h3>getBaseField</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">getBaseField</span>()</div>
<div class="block">Gets the base field for a custom calculation. This property is valid only for data fields.</div>
</section>
</li>
<li>
<section class="detail" id="setBaseField(java.lang.String)">
<h3>setBaseField</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setBaseField</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 base field for a custom calculation. This property is valid only for data fields.</div>
</section>
</li>
<li>
<section class="detail" id="getBaseItem()">
<h3>getBaseItem</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">getBaseItem</span>()</div>
<div class="block">Gets the item in the base field for a custom calculation. Valid only for data fields.</div>
</section>
</li>
<li>
<section class="detail" id="setBaseItem(java.lang.String)">
<h3>setBaseItem</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setBaseItem</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 item in the base field for a custom calculation. Valid only for data fields.</div>
</section>
</li>
<li>
<section class="detail" id="getCalculation()">
<h3>getCalculation</h3>
<div class="member-signature"><span class="return-type"><a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel">PivotFieldCalculation</a></span>&nbsp;<span class="element-name">getCalculation</span>()</div>
<div class="block">Gets a  <a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel"><code>PivotFieldCalculation</code></a> value that represents the type of calculation performed by the specified field.This property is valid only for data fields.</div>
</section>
</li>
<li>
<section class="detail" id="setCalculation(com.grapecity.documents.excel.PivotFieldCalculation)">
<h3>setCalculation</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setCalculation</span><wbr><span class="parameters">(<a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel">PivotFieldCalculation</a>&nbsp;value)</span></div>
<div class="block">Sets a  <a href="PivotFieldCalculation.html" title="enum class in com.grapecity.documents.excel"><code>PivotFieldCalculation</code></a> value that represents the type of calculation performed by the specified field.This property is valid only for data fields.</div>
</section>
</li>
<li>
<section class="detail" id="getCurrentPage()">
<h3>getCurrentPage</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getCurrentPage</span>()</div>
<div class="block">Gets the current page's index showing for the page field (valid only for page fields). The valid value is based on zero. "-1" indicates "All" or "Multiple Items".</div>
</section>
</li>
<li>
<section class="detail" id="setCurrentPage(int)">
<h3>setCurrentPage</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setCurrentPage</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the current page's index showing for the page field (valid only for page fields). The valid value is based on zero. "-1" indicates "All" or "Multiple Items".</div>
</section>
</li>
<li>
<section class="detail" id="getDragToColumn()">
<h3>getDragToColumn</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDragToColumn</span>()</div>
<div class="block">Gets whether the specified field can be dragged to the column position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="setDragToColumn(boolean)">
<h3>setDragToColumn</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDragToColumn</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the specified field can be dragged to the column position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="getDragToData()">
<h3>getDragToData</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDragToData</span>()</div>
<div class="block">Gets whether the specified field can be dragged to the data position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="setDragToData(boolean)">
<h3>setDragToData</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDragToData</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the specified field can be dragged to the data position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="getDragToHide()">
<h3>getDragToHide</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDragToHide</span>()</div>
<div class="block">Gets whether the field can be hidden by being dragged off the PivotTable report. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="setDragToHide(boolean)">
<h3>setDragToHide</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDragToHide</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the field can be hidden by being dragged off the PivotTable report. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="getDragToPage()">
<h3>getDragToPage</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDragToPage</span>()</div>
<div class="block">Gets whether the field can be dragged to the page position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="setDragToPage(boolean)">
<h3>setDragToPage</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDragToPage</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the field can be dragged to the page position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="getDragToRow()">
<h3>getDragToRow</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDragToRow</span>()</div>
<div class="block">Gets whether the field can be dragged to the row position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="setDragToRow(boolean)">
<h3>setDragToRow</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDragToRow</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the field can be dragged to the row position. The default value is True.</div>
</section>
</li>
<li>
<section class="detail" id="getEnableMultiplePageItems()">
<h3>getEnableMultiplePageItems</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getEnableMultiplePageItems</span>()</div>
<div class="block">Gets whether the field can have multiple items selected in the page field. The default value is false.</div>
</section>
</li>
<li>
<section class="detail" id="setEnableMultiplePageItems(boolean)">
<h3>setEnableMultiplePageItems</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setEnableMultiplePageItems</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the field can have multiple items selected in the page field. The default value is false.</div>
</section>
</li>
<li>
<section class="detail" id="getFormula()">
<h3>getFormula</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">getFormula</span>()</div>
<div class="block">Gets a String value that represents the object's formula in A1-style notation and in the language of the macro.</div>
</section>
</li>
<li>
<section class="detail" id="setFormula(java.lang.String)">
<h3>setFormula</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setFormula</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 value that represents the object's formula in A1-style notation and in the language of the macro.</div>
</section>
</li>
<li>
<section class="detail" id="getFunction()">
<h3>getFunction</h3>
<div class="member-signature"><span class="return-type"><a href="ConsolidationFunction.html" title="enum class in com.grapecity.documents.excel">ConsolidationFunction</a></span>&nbsp;<span class="element-name">getFunction</span>()</div>
<div class="block">Gets the function used to summarize the PivotTable field (data fields only).</div>
</section>
</li>
<li>
<section class="detail" id="setFunction(com.grapecity.documents.excel.ConsolidationFunction)">
<h3>setFunction</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setFunction</span><wbr><span class="parameters">(<a href="ConsolidationFunction.html" title="enum class in com.grapecity.documents.excel">ConsolidationFunction</a>&nbsp;value)</span></div>
<div class="block">Sets the function used to summarize the PivotTable field (data fields only).</div>
</section>
</li>
<li>
<section class="detail" id="getLayoutBlankLine()">
<h3>getLayoutBlankLine</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getLayoutBlankLine</span>()</div>
<div class="block">Gets if a blank row is inserted after the specified row field in a PivotTable report. The default value is False.</div>
</section>
</li>
<li>
<section class="detail" id="setLayoutBlankLine(boolean)">
<h3>setLayoutBlankLine</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setLayoutBlankLine</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets if a blank row is inserted after the specified row field in a PivotTable report. The default value is False.</div>
</section>
</li>
<li>
<section class="detail" id="getLayoutCompactRow()">
<h3>getLayoutCompactRow</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getLayoutCompactRow</span>()</div>
<div class="block">Gets whether or not a PivotField is compacted(items of multiple PivotFields are displayed in a single column) when rows are selected.</div>
</section>
</li>
<li>
<section class="detail" id="setLayoutCompactRow(boolean)">
<h3>setLayoutCompactRow</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setLayoutCompactRow</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether or not a PivotField is compacted(items of multiple PivotFields are displayed in a single column) when rows are selected.</div>
</section>
</li>
<li>
<section class="detail" id="getLayoutForm()">
<h3>getLayoutForm</h3>
<div class="member-signature"><span class="return-type"><a href="LayoutFormType.html" title="enum class in com.grapecity.documents.excel">LayoutFormType</a></span>&nbsp;<span class="element-name">getLayoutForm</span>()</div>
<div class="block">Returns the way the specified PivotTable items appear — in table format or in outline format.</div>
</section>
</li>
<li>
<section class="detail" id="setLayoutForm(com.grapecity.documents.excel.LayoutFormType)">
<h3>setLayoutForm</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setLayoutForm</span><wbr><span class="parameters">(<a href="LayoutFormType.html" title="enum class in com.grapecity.documents.excel">LayoutFormType</a>&nbsp;value)</span></div>
<div class="block">Sets the way the specified PivotTable items appear — in table format or in outline format.</div>
</section>
</li>
<li>
<section class="detail" id="getLayoutSubtotalLocation()">
<h3>getLayoutSubtotalLocation</h3>
<div class="member-signature"><span class="return-type"><a href="SubtotalLocationType.html" title="enum class in com.grapecity.documents.excel">SubtotalLocationType</a></span>&nbsp;<span class="element-name">getLayoutSubtotalLocation</span>()</div>
<div class="block">Gets the position of the PivotTable field subtotals in relation to (either above or below) the specified field.</div>
</section>
</li>
<li>
<section class="detail" id="setLayoutSubtotalLocation(com.grapecity.documents.excel.SubtotalLocationType)">
<h3>setLayoutSubtotalLocation</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setLayoutSubtotalLocation</span><wbr><span class="parameters">(<a href="SubtotalLocationType.html" title="enum class in com.grapecity.documents.excel">SubtotalLocationType</a>&nbsp;value)</span></div>
<div class="block">Sets the position of the PivotTable field subtotals in relation to (either above or below) the specified field.</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="getNumberFormat()">
<h3>getNumberFormat</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">getNumberFormat</span>()</div>
<div class="block">Gets the format code for the object.</div>
</section>
</li>
<li>
<section class="detail" id="setNumberFormat(java.lang.String)">
<h3>setNumberFormat</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setNumberFormat</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 format code for the object.</div>
</section>
</li>
<li>
<section class="detail" id="getOrientation()">
<h3>getOrientation</h3>
<div class="member-signature"><span class="return-type"><a href="PivotFieldOrientation.html" title="enum class in com.grapecity.documents.excel">PivotFieldOrientation</a></span>&nbsp;<span class="element-name">getOrientation</span>()</div>
<div class="block">Gets the location of the field in the specified PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="setOrientation(com.grapecity.documents.excel.PivotFieldOrientation)">
<h3>setOrientation</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setOrientation</span><wbr><span class="parameters">(<a href="PivotFieldOrientation.html" title="enum class in com.grapecity.documents.excel">PivotFieldOrientation</a>&nbsp;value)</span></div>
<div class="block">Sets the location of the field in the specified PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getPosition()">
<h3>getPosition</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getPosition</span>()</div>
<div class="block">Gets the position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, Data).</div>
</section>
</li>
<li>
<section class="detail" id="setPosition(int)">
<h3>setPosition</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setPosition</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, Data).</div>
</section>
</li>
<li>
<section class="detail" id="getRepeatLabels()">
<h3>getRepeatLabels</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getRepeatLabels</span>()</div>
<div class="block">Gets whether item labels are repeated in the PivotTable for the specified PivotField.</div>
<dl class="notes">
<dt>Returns:</dt>
<dd>True if labels are repeated, false otherwise.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setRepeatLabels(boolean)">
<h3>setRepeatLabels</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setRepeatLabels</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether item labels are repeated in the PivotTable for the specified PivotField.</div>
</section>
</li>
<li>
<section class="detail" id="getShowAllItems()">
<h3>getShowAllItems</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getShowAllItems</span>()</div>
<div class="block">Gets if all items in the PivotTable report are displayed, even if they don’t contain summary data. The default value is False.</div>
</section>
</li>
<li>
<section class="detail" id="setShowAllItems(boolean)">
<h3>setShowAllItems</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setShowAllItems</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets if all items in the PivotTable report are displayed, even if they don’t contain summary data. The default value is False.</div>
</section>
</li>
<li>
<section class="detail" id="getSourceName()">
<h3>getSourceName</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">getSourceName</span>()</div>
<div class="block">Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. This might be different from the current item name if the user renamed the item after creating the PivotTable report.</div>
</section>
</li>
<li>
<section class="detail" id="getSubtotals()">
<h3>getSubtotals</h3>
<div class="member-signature"><span class="return-type"><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a>&lt;<a href="SubtotalType.html" title="enum class in com.grapecity.documents.excel">SubtotalType</a>&gt;</span>&nbsp;<span class="element-name">getSubtotals</span>()</div>
<div class="block">Gets a combination of all the showing subtotal types in the specified PivotField. Valid only for nondata fields.</div>
</section>
</li>
<li>
<section class="detail" id="setSubtotals(java.util.EnumSet)">
<h3>setSubtotals</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setSubtotals</span><wbr><span class="parameters">(<a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/util/EnumSet.html" title="class or interface in java.util" class="external-link">EnumSet</a>&lt;<a href="SubtotalType.html" title="enum class in com.grapecity.documents.excel">SubtotalType</a>&gt;&nbsp;value)</span></div>
<div class="block">Sets a combination of all the showing subtotal types in the specified PivotField. Valid only for nondata fields.</div>
</section>
</li>
<li>
<section class="detail" id="autoSort(com.grapecity.documents.excel.SortOrder,java.lang.String)">
<h3>autoSort</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">autoSort</span><wbr><span class="parameters">(<a href="SortOrder.html" title="enum class in com.grapecity.documents.excel">SortOrder</a>&nbsp;Order,
 <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;Field)</span></div>
<div class="block">Establishes automatic field-sorting rules for PivotTable reports.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>Order</code> - Required SortOrder. The sort order.</dd>
<dd><code>Field</code> - The name of the sort key field. You must specify the unique name (as returned from the IPivotField.getSourceName()) and not the displayed name.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="autoSort(com.grapecity.documents.excel.SortOrder)">
<h3>autoSort</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">autoSort</span><wbr><span class="parameters">(<a href="SortOrder.html" title="enum class in com.grapecity.documents.excel">SortOrder</a>&nbsp;Order)</span></div>
<div class="block">Establishes automatic field-sorting rules for PivotTable reports.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>Order</code> - Required SortOrder. The sort order.</dd>
</dl>
</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 PivotField. This includes deleting all filters from the PivotFilters collection of the PivotField and removing any manual filtering applied to the PivotField as well. If the PivotField is in the Report Filter area, the item selected will be set to the default item.</div>
</section>
</li>
<li>
<section class="detail" id="clearManualFilter()">
<h3>clearManualFilter</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">clearManualFilter</span>()</div>
<div class="block">Provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList and VisibleItemsList collections in OLAP PivotTables.</div>
</section>
</li>
<li>
<section class="detail" id="getPivotItems()">
<h3>getPivotItems</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotItems.html" title="interface in com.grapecity.documents.excel">IPivotItems</a></span>&nbsp;<span class="element-name">getPivotItems</span>()</div>
<div class="block">Returns a collection of all the visible and hidden items in the specified field.</div>
</section>
</li>
<li>
<section class="detail" id="getCalculatedItems()">
<h3>getCalculatedItems</h3>
<div class="member-signature"><span class="return-type"><a href="ICalculatedItems.html" title="interface in com.grapecity.documents.excel">ICalculatedItems</a></span>&nbsp;<span class="element-name">getCalculatedItems</span>()</div>
<div class="block">Returns a  <code>ICalculatedItems</code> collection that represents all the calculated items in the specified PivotTable report.</div>
<dl class="notes">
<dt>Returns:</dt>
<dd>CalculatedItems collection</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getPivotFilters()">
<h3>getPivotFilters</h3>
<div class="member-signature"><span class="return-type"><a href="IPivotFilters.html" title="interface in com.grapecity.documents.excel">IPivotFilters</a></span>&nbsp;<span class="element-name">getPivotFilters</span>()</div>
<div class="block">Get the filter set of the current  <a href="IPivotField.html" title="interface in com.grapecity.documents.excel"><code>IPivotField</code></a>.</div>
</section>
</li>
<li>
<section class="detail" id="clearLabelFilter()">
<h3>clearLabelFilter</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">clearLabelFilter</span>()</div>
<div class="block">This method deletes all label filters or all date filters in the PivotFilters collection of the PivotField.</div>
</section>
</li>
<li>
<section class="detail" id="clearValueFilter()">
<h3>clearValueFilter</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">clearValueFilter</span>()</div>
<div class="block">This method deletes all value filters in the PivotFilters collection of the PivotField.</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>