# 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. <p>Provides access to the display settings of a worksheet, such as formula visibility,  gridline visibility, reading direction, scroll position, zoom, and view type.  Use  <a href="IWorksheet.html#getSheetView()"><code>IWorksheet.getSheetView()</code></a> to retrieve the view settings for a worksheet.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayFormulas(true);
 sheetView.setDisplayRightToLeft(true);
 sheetView.setZoom(150);
 </code></pre></div>
</section>
<section class="summary">
<ul class="summary-list">
<!-- ========== METHOD SUMMARY =========== -->
<li>
<section class="method-summary" id="method-summary">
<h2>Method Summary</h2>
<div id="method-summary-table">
<div aria-orientation="horizontal" class="table-tabs" role="tablist"><button aria-controls="method-summary-table.tabpanel" aria-selected="true" class="active-table-tab" id="method-summary-table-tab0" onclick="show('method-summary-table', 'method-summary-table', 3)" onkeydown="switchTab(event)" role="tab" tabindex="0">All Methods</button><button aria-controls="method-summary-table.tabpanel" aria-selected="false" class="table-tab" id="method-summary-table-tab2" onclick="show('method-summary-table', 'method-summary-table-tab2', 3)" onkeydown="switchTab(event)" role="tab" tabindex="-1">Instance Methods</button><button aria-controls="method-summary-table.tabpanel" aria-selected="false" class="table-tab" id="method-summary-table-tab3" onclick="show('method-summary-table', 'method-summary-table-tab3', 3)" onkeydown="switchTab(event)" role="tab" tabindex="-1">Abstract Methods</button></div>
<div id="method-summary-table.tabpanel" role="tabpanel">
<div aria-labelledby="method-summary-table-tab0" class="summary-table three-column-summary">
<div class="table-header col-first">Modifier and Type</div>
<div class="table-header col-second">Method</div>
<div class="table-header col-last">Description</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>boolean</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getDisplayFormulas()">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 class="member-name-link" href="#getDisplayGridlines()">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 in the worksheet view.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>boolean</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getDisplayHeadings()">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 row and column headings 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 class="member-name-link" href="#getDisplayHorizontalGridlines()">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 class="member-name-link" href="#getDisplayOutline()">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 class="member-name-link" href="#getDisplayRightToLeft()">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 worksheet is displayed from right to left instead of 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 class="member-name-link" href="#getDisplayRuler()">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 class="member-name-link" href="#getDisplayVerticalGridlines()">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 class="member-name-link" href="#getDisplayWhitespace()">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 class="member-name-link" href="#getDisplayZeros()">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 in the worksheet view.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>boolean</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#getFitSelection()">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 class="member-name-link" href="#getGridlineColor()">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 class="member-name-link" href="#getScrollColumn()">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 class="member-name-link" href="#getScrollRow()">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 class="member-name-link" href="#getViewType()">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 current worksheet 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 class="member-name-link" href="#getZoom()">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 the display size of the worksheet as a percentage.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setDisplayFormulas(boolean)">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 class="member-name-link" href="#setDisplayGridlines(boolean)">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 in the worksheet view.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setDisplayHeadings(boolean)">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 row and column headings 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 class="member-name-link" href="#setDisplayHorizontalGridlines(boolean)">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 class="member-name-link" href="#setDisplayOutline(boolean)">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 class="member-name-link" href="#setDisplayRightToLeft(boolean)">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 worksheet is displayed from right to left instead of 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 class="member-name-link" href="#setDisplayRuler(boolean)">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 class="member-name-link" href="#setDisplayVerticalGridlines(boolean)">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 class="member-name-link" href="#setDisplayWhitespace(boolean)">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 class="member-name-link" href="#setDisplayZeros(boolean)">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 in the worksheet view.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a class="member-name-link" href="#setFitSelection(boolean)">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 class="member-name-link" href="#setGridlineColor(com.grapecity.documents.excel.Color)">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 class="member-name-link" href="#setScrollColumn(int)">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 class="member-name-link" href="#setScrollRow(int)">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 class="member-name-link" href="#setViewType(com.grapecity.documents.excel.ViewType)">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 class="member-name-link" href="#setZoom(int)">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 the display size of the worksheet as a percentage.</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 worksheet is displayed from right to left instead of from left to right. <p>Returns whether the worksheet view uses right-to-left display.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayRightToLeft(true);
 boolean displayRightToLeft = sheetView.getDisplayRightToLeft();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if the worksheet is displayed from right to left instead of from left to right; otherwise, <code>false</code>.</dd>
</dl>
</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 worksheet is displayed from right to left instead of from left to right. <p>Sets whether the worksheet view uses right-to-left display.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayRightToLeft(true);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether the worksheet is displayed from right to left instead of from left to right.</dd>
</dl>
</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. <p>Returns  <code>true</code> if formulas are displayed instead of calculated values, or <code>false</code> if the worksheet displays values.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayFormulas(true);
 boolean displayFormulas = sheetView.getDisplayFormulas();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if the worksheet displays formulas; otherwise, <code>false</code>.</dd>
</dl>
</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. <p>Sets  <code>true</code> if formulas are displayed instead of calculated values, or <code>false</code> if the worksheet displays values.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayFormulas(true);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether the worksheet displays formulas.</dd>
</dl>
</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 in the worksheet view. <p>This property indicates whether cell gridlines are currently shown for the worksheet.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayGridlines(false);
 boolean displayGridlines = sheetView.getDisplayGridlines();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if gridlines are displayed in the worksheet view; otherwise, <code>false</code>.</dd>
</dl>
</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 in the worksheet view. <p>This property indicates whether cell gridlines are currently shown for the worksheet.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayGridlines(false);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether gridlines are displayed in the worksheet view.</dd>
</dl>
</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. <p>Returns whether vertical gridlines are visible in the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayVerticalGridlines(false);
 boolean displayVerticalGridlines = sheetView.getDisplayVerticalGridlines();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if vertical gridlines are displayed; otherwise, <code>false</code>.</dd>
</dl>
</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. <p>Sets whether vertical gridlines are visible in the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayVerticalGridlines(false);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether vertical gridlines are displayed.</dd>
</dl>
</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. <p>Returns whether horizontal gridlines are visible in the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayHorizontalGridlines(true);
 boolean displayHorizontalGridlines = sheetView.getDisplayHorizontalGridlines();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if horizontal gridlines are displayed; otherwise, <code>false</code>.</dd>
</dl>
</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. <p>Sets whether horizontal gridlines are visible in the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayHorizontalGridlines(true);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether horizontal gridlines are displayed.</dd>
</dl>
</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 row and column headings are displayed. <p>Returns whether both row and column headings are visible in the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayHeadings(false);
 boolean displayHeadings = sheetView.getDisplayHeadings();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if row and column headings are displayed; otherwise, <code>false</code>.</dd>
</dl>
</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 row and column headings are displayed. <p>Sets whether both row and column headings are visible in the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayHeadings(false);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether row and column headings are displayed.</dd>
</dl>
</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. <p>This property indicates whether the worksheet view currently shows outline  symbols for grouped rows and columns.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayOutline(false);
 boolean displayOutline = sheetView.getDisplayOutline();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if outline symbols are displayed; otherwise, <code>false</code>.</dd>
</dl>
</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. <p>This property indicates whether the worksheet view currently shows outline  symbols for grouped rows and columns.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayOutline(false);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether outline symbols are displayed.</dd>
</dl>
</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. <p>This property indicates whether the current worksheet view shows the ruler.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayRuler(false);
 boolean displayRuler = sheetView.getDisplayRuler();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if a ruler is displayed for the specified worksheet; otherwise, <code>false</code>.</dd>
</dl>
</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. <p>This property indicates whether the current worksheet view shows the ruler.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayRuler(false);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether a ruler is displayed for the specified worksheet.</dd>
</dl>
</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. <p>This property indicates whether the current worksheet view shows whitespace.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayWhitespace(true);
 boolean displayWhitespace = sheetView.getDisplayWhitespace();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if whitespace is displayed; otherwise, <code>false</code>.</dd>
</dl>
</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. <p>This property indicates whether the current worksheet view shows whitespace.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayWhitespace(true);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether whitespace is displayed.</dd>
</dl>
</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 in the worksheet view. <p>When this property is  <code>false</code>, cells whose displayed value is zero are hidden in the current worksheet view.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1").setValue(0);
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayZeros(false);
 boolean displayZeros = sheetView.getDisplayZeros();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if zero values are displayed in the worksheet view; otherwise, <code>false</code>.</dd>
</dl>
</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 in the worksheet view. <p>When this property is  <code>false</code>, cells whose displayed value is zero are hidden in the current worksheet view.</p>
<pre><code data-language="Java">
 worksheet.getRange("A1").setValue(0);
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setDisplayZeros(true);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether zero values are displayed in the worksheet view.</dd>
</dl>
</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 the display size of the worksheet as a percentage. <p>A value of  <code>100</code> represents the normal display size, <code>200</code> represents double size, and other values scale the worksheet view accordingly.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setZoom(120);
 int zoom = sheetView.getZoom();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The display size of the worksheet as a percentage. A value of <code>100</code> represents the normal display size,  <code>200</code> represents double size, and other values scale the worksheet view accordingly.</dd>
</dl>
</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 the display size of the worksheet as a percentage. <p>A value of  <code>100</code> represents the normal display size, <code>200</code> represents double size, and other values scale the worksheet view accordingly.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setZoom(120);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The display size of the worksheet as a percentage.</dd>
</dl>
</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 current worksheet view type. <p>The view type indicates how the worksheet is displayed, such as  <a href="ViewType.html#NormalView"><code>ViewType.NormalView</code></a>,  <a href="ViewType.html#PageBreakPreview"><code>ViewType.PageBreakPreview</code></a>, and  <a href="ViewType.html#PageLayoutView"><code>ViewType.PageLayoutView</code></a>.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setViewType(ViewType.PageLayoutView);
 ViewType viewType = sheetView.getViewType();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The current worksheet view type.</dd>
</dl>
</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. <p>Use this method to switch the worksheet between different display modes, such as  <a href="ViewType.html#NormalView"><code>ViewType.NormalView</code></a>,  <a href="ViewType.html#PageBreakPreview"><code>ViewType.PageBreakPreview</code></a>, and  <a href="ViewType.html#PageLayoutView"><code>ViewType.PageLayoutView</code></a>.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setViewType(ViewType.PageLayoutView);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The view type to apply to the worksheet.</dd>
</dl>
</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.
 <pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setGridlineColor(Color.GetBlue());
 Color gridlineColor = sheetView.getGridlineColor();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>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.</dd>
</dl>
</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.
 <pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setGridlineColor(Color.GetBlue());
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - 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.</dd>
</dl>
</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. <p>This value indicates which column is currently displayed at the left edge of the active worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setScrollColumn(3);
 int scrollColumn = sheetView.getScrollColumn();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The number of the leftmost column in the pane or worksheet.</dd>
</dl>
</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. <p>This value indicates which column is currently displayed at the left edge of the active worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setScrollColumn(3);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The number of the leftmost column in the pane or worksheet.</dd>
</dl>
</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. <p>Use this property to determine which row is currently shown at the top edge of the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setScrollRow(5);
 int scrollRow = sheetView.getScrollRow();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The number of the row that appears at the top of the pane or worksheet.</dd>
</dl>
</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. <p>Use this property to specify which row is currently shown at the top edge of the worksheet view.</p>
<pre><code data-language="Java">
 IWorksheetView sheetView = worksheet.getSheetView();
 sheetView.setScrollRow(5);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - The number of the row that appears at the top of the pane or worksheet.</dd>
</dl>
</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. <p>This option is only supported for  <a href="SheetType.html#Chart"><code>SheetType.Chart</code></a>.</p>
<pre><code data-language="Java">
 IWorksheet chartSheet = workbook.getWorksheets().add(SheetType.Chart);
 chartSheet.getShapes().addChart(ChartType.Area, 0, 0, 100, 100);
 IWorksheetView sheetView = chartSheet.getSheetView();
 sheetView.setFitSelection(true);
 boolean fitSelection = sheetView.getFitSelection();
 </code></pre></div>
<dl class="notes">
<dt>Returns:</dt>
<dd><code>true</code> if the zoom is set to fit the selection; otherwise, <code>false</code>.</dd>
<dt>Throws:</dt>
<dd><code><a class="external-link" href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang">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. <p>This option is only supported for  <a href="SheetType.html#Chart"><code>SheetType.Chart</code></a>.</p>
<pre><code data-language="Java">
 IWorksheet chartSheet = workbook.getWorksheets().add(SheetType.Chart);
 chartSheet.getShapes().addChart(com.grapecity.documents.excel.drawing.ChartType.Area, 0, 0, 100, 100);
 IWorksheetView sheetView = chartSheet.getSheetView();
 sheetView.setFitSelection(true);
 </code></pre></div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>value</code> - Whether to fit the selection. Unlike Microsoft Excel, this option does not change the return value of <a href="#getZoom()"><code>getZoom()</code></a>. This feature is supported only for worksheets of type  <a href="SheetType.html#Chart"><code>SheetType.Chart</code></a>.</dd>
<dt>Throws:</dt>
<dd><code><a class="external-link" href="https://docs.oracle.com/en/java/javase/17/docs/api/java.base/java/lang/UnsupportedOperationException.html" title="class or interface in java.lang">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>