# IWorksheetView

## 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 IWorksheetView</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">IWorksheetView</span></div>
<div class="block">Represents worksheet view options.</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>boolean</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getDisplayFormulas()" class="member-name-link">getDisplayFormulas</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 worksheet displays formulas.</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="#getDisplayGridlines()" class="member-name-link">getDisplayGridlines</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 gridlines are displayed.</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="#getDisplayHeadings()" class="member-name-link">getDisplayHeadings</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 headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed).</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="#getDisplayHorizontalGridlines()" class="member-name-link">getDisplayHorizontalGridlines</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 horizontal gridlines are displayed.</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="#getDisplayOutline()" class="member-name-link">getDisplayOutline</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 outline symbols are displayed.</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="#getDisplayRightToLeft()" class="member-name-link">getDisplayRightToLeft</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 worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right).</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="#getDisplayRuler()" class="member-name-link">getDisplayRuler</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 a ruler is displayed for the specified worksheet.</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="#getDisplayVerticalGridlines()" class="member-name-link">getDisplayVerticalGridlines</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 vertical gridlines are displayed.</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="#getDisplayWhitespace()" class="member-name-link">getDisplayWhitespace</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 whitespace is displayed.</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="#getDisplayZeros()" class="member-name-link">getDisplayZeros</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 zero values are displayed.</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="#getFitSelection()" class="member-name-link">getFitSelection</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 zoom is set to fit the selection.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="Color.html" title="class in com.grapecity.documents.excel">Color</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getGridlineColor()" class="member-name-link">getGridlineColor</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the  <a href="Color.html" title="class in com.grapecity.documents.excel"><code>Color</code></a> object that represents the gridline color of the worksheet.</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="#getScrollColumn()" class="member-name-link">getScrollColumn</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 number of the leftmost column in the pane or worksheet.</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="#getScrollRow()" class="member-name-link">getScrollRow</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 number of the row that appears at the top of the pane or worksheet.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="ViewType.html" title="enum class in com.grapecity.documents.excel">ViewType</a></code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getViewType()" class="member-name-link">getViewType</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 view type.</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="#getZoom()" class="member-name-link">getZoom</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 Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so 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="#setDisplayFormulas(boolean)" class="member-name-link">setDisplayFormulas</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 worksheet displays formulas.</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="#setDisplayGridlines(boolean)" class="member-name-link">setDisplayGridlines</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 gridlines are displayed.</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="#setDisplayHeadings(boolean)" class="member-name-link">setDisplayHeadings</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 headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed).</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="#setDisplayHorizontalGridlines(boolean)" class="member-name-link">setDisplayHorizontalGridlines</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 horizontal gridlines are displayed.</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="#setDisplayOutline(boolean)" class="member-name-link">setDisplayOutline</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 outline symbols are displayed.</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="#setDisplayRightToLeft(boolean)" class="member-name-link">setDisplayRightToLeft</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 worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right).</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="#setDisplayRuler(boolean)" class="member-name-link">setDisplayRuler</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 a ruler is displayed for the specified worksheet.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#setDisplayVerticalGridlines(boolean)" class="member-name-link">setDisplayVerticalGridlines</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 vertical gridlines are displayed.</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="#setDisplayWhitespace(boolean)" class="member-name-link">setDisplayWhitespace</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 whitespace is displayed.</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="#setDisplayZeros(boolean)" class="member-name-link">setDisplayZeros</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 zero values are displayed.</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="#setFitSelection(boolean)" class="member-name-link">setFitSelection</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 zoom is set to fit the selection.</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="#setGridlineColor(com.grapecity.documents.excel.Color)" class="member-name-link">setGridlineColor</a><wbr>(<a href="Color.html" title="class in com.grapecity.documents.excel">Color</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  <a href="Color.html" title="class in com.grapecity.documents.excel"><code>Color</code></a> object that represents the gridline color of the worksheet.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#setScrollColumn(int)" class="member-name-link">setScrollColumn</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 the leftmost column in the pane or worksheet.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#setScrollRow(int)" class="member-name-link">setScrollRow</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 number of the row that appears at the top of the pane or worksheet.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#setViewType(com.grapecity.documents.excel.ViewType)" class="member-name-link">setViewType</a><wbr>(<a href="ViewType.html" title="enum class in com.grapecity.documents.excel">ViewType</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 view type.</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="#setZoom(int)" class="member-name-link">setZoom</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 a Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so on).</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="getDisplayRightToLeft()">
<h3>getDisplayRightToLeft</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayRightToLeft</span>()</div>
<div class="block">Gets whether the specified worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right).</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayRightToLeft(boolean)">
<h3>setDisplayRightToLeft</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayRightToLeft</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the specified worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right).</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayFormulas()">
<h3>getDisplayFormulas</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayFormulas</span>()</div>
<div class="block">Gets whether the worksheet displays formulas. True if formulas are displayed; False if the worksheet displays values.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayFormulas(boolean)">
<h3>setDisplayFormulas</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayFormulas</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the worksheet displays formulas. True if formulas are displayed; False if the worksheet displays values.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayGridlines()">
<h3>getDisplayGridlines</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayGridlines</span>()</div>
<div class="block">Gets whether gridlines are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayGridlines(boolean)">
<h3>setDisplayGridlines</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayGridlines</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether gridlines are displayed. When this is set, DisplayVerticalGridlines and DisplayHorizontalGridlines would be set to same value.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayVerticalGridlines()">
<h3>getDisplayVerticalGridlines</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayVerticalGridlines</span>()</div>
<div class="block">Gets whether vertical gridlines are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayVerticalGridlines(boolean)">
<h3>setDisplayVerticalGridlines</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayVerticalGridlines</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether vertical gridlines are displayed. When this is set false, DisplayGridlines would be false, too.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayHorizontalGridlines()">
<h3>getDisplayHorizontalGridlines</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayHorizontalGridlines</span>()</div>
<div class="block">Gets whether horizontal gridlines are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayHorizontalGridlines(boolean)">
<h3>setDisplayHorizontalGridlines</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayHorizontalGridlines</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether horizontal gridlines are displayed. When this is set false, DisplayGridlines would be false, too.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayHeadings()">
<h3>getDisplayHeadings</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayHeadings</span>()</div>
<div class="block">Gets whether headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed).</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayHeadings(boolean)">
<h3>setDisplayHeadings</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayHeadings</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed).</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayOutline()">
<h3>getDisplayOutline</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayOutline</span>()</div>
<div class="block">Gets whether outline symbols are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayOutline(boolean)">
<h3>setDisplayOutline</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayOutline</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether outline symbols are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayRuler()">
<h3>getDisplayRuler</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayRuler</span>()</div>
<div class="block">Gets whether a ruler is displayed for the specified worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayRuler(boolean)">
<h3>setDisplayRuler</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayRuler</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether a ruler is displayed for the specified worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayWhitespace()">
<h3>getDisplayWhitespace</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayWhitespace</span>()</div>
<div class="block">Gets whether whitespace is displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayWhitespace(boolean)">
<h3>setDisplayWhitespace</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayWhitespace</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether whitespace is displayed.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayZeros()">
<h3>getDisplayZeros</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayZeros</span>()</div>
<div class="block">Gets whether zero values are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayZeros(boolean)">
<h3>setDisplayZeros</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayZeros</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether zero values are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="getZoom()">
<h3>getZoom</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getZoom</span>()</div>
<div class="block">Gets a Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so on).</div>
</section>
</li>
<li>
<section class="detail" id="setZoom(int)">
<h3>setZoom</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setZoom</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets a Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so on).</div>
</section>
</li>
<li>
<section class="detail" id="getViewType()">
<h3>getViewType</h3>
<div class="member-signature"><span class="return-type"><a href="ViewType.html" title="enum class in com.grapecity.documents.excel">ViewType</a></span>&nbsp;<span class="element-name">getViewType</span>()</div>
<div class="block">Gets the view type.</div>
</section>
</li>
<li>
<section class="detail" id="setViewType(com.grapecity.documents.excel.ViewType)">
<h3>setViewType</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setViewType</span><wbr><span class="parameters">(<a href="ViewType.html" title="enum class in com.grapecity.documents.excel">ViewType</a>&nbsp;value)</span></div>
<div class="block">Sets the view type.</div>
</section>
</li>
<li>
<section class="detail" id="getGridlineColor()">
<h3>getGridlineColor</h3>
<div class="member-signature"><span class="return-type"><a href="Color.html" title="class in com.grapecity.documents.excel">Color</a></span>&nbsp;<span class="element-name">getGridlineColor</span>()</div>
<div class="block">Gets the  <a href="Color.html" title="class in com.grapecity.documents.excel"><code>Color</code></a> object that represents the gridline color of the worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="setGridlineColor(com.grapecity.documents.excel.Color)">
<h3>setGridlineColor</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setGridlineColor</span><wbr><span class="parameters">(<a href="Color.html" title="class in com.grapecity.documents.excel">Color</a>&nbsp;value)</span></div>
<div class="block">Sets the  <a href="Color.html" title="class in com.grapecity.documents.excel"><code>Color</code></a> object that represents the gridline color of the worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="getScrollColumn()">
<h3>getScrollColumn</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getScrollColumn</span>()</div>
<div class="block">Gets the number of the leftmost column in the pane or worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="setScrollColumn(int)">
<h3>setScrollColumn</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setScrollColumn</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the number of the leftmost column in the pane or worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="getScrollRow()">
<h3>getScrollRow</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getScrollRow</span>()</div>
<div class="block">Gets the number of the row that appears at the top of the pane or worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="setScrollRow(int)">
<h3>setScrollRow</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setScrollRow</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the number of the row that appears at the top of the pane or worksheet.</div>
</section>
</li>
<li>
<section class="detail" id="getFitSelection()">
<h3>getFitSelection</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getFitSelection</span>()</div>
<div class="block">Gets whether the zoom is set to fit the selection. This option is only supported for  <a href="SheetType.html#Chart"><code>SheetType.Chart</code></a>.</div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if zoom is set to fit selection; <code>false</code> otherwise.</dd>
<dt>Throws:</dt>
<dd><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang" class="external-link">UnsupportedOperationException</a></code> - if called with unsupported sheet types.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setFitSelection(boolean)">
<h3>setFitSelection</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setFitSelection</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether the zoom is set to fit the selection. Unlike Microsoft Excel Application, this option does not modify the value of the  <a href="#getZoom()"><code>getZoom()</code></a>. This option is only supported for  <a href="SheetType.html#Chart"><code>SheetType.Chart</code></a>.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - <code>true</code> to fit selection; <code>false</code> otherwise.</dd>
<dt>Throws:</dt>
<dd><code><a href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang" class="external-link">UnsupportedOperationException</a></code> - if called with unsupported sheet types.</dd>
</dl>
</section>
</li>
</ul>
</section>
</li>
</ul>
</section>
<!-- ========= END OF CLASS DATA ========= -->
<script>var evenRowColor = "even-row-color";
var oddRowColor = "odd-row-color";
var tableTab = "table-tab";
var activeTableTab = "active-table-tab";

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

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

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