# IWorkbookView

## 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 IWorkbookView</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">IWorkbookView</span></div>
<div class="block">Represents the view settings of this workbook.</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="#getAllowSheetReorder()" class="member-name-link">getAllowSheetReorder</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 to allow reordering of worksheet tabs.</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="#getBackColor()" class="member-name-link">getBackColor</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Get background color of all worksheets.</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="#getDisplayHorizontalScrollBar()" class="member-name-link">getDisplayHorizontalScrollBar</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">True if the horizontal scroll bar 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="#getDisplayVerticalScrollBar()" class="member-name-link">getDisplayVerticalScrollBar</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">True if the vertical scroll bar is 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="#getDisplayWorkbookTabs()" class="member-name-link">getDisplayWorkbookTabs</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">True if the workbook tabs are displayed.</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="#getGrayAreaBackColor()" class="member-name-link">getGrayAreaBackColor</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Get background color of workbook gray area.</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="#getNewTabVisible()" class="member-name-link">getNewTabVisible</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 to show the New Tab button.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="NumbersFitMode.html" title="enum class in com.grapecity.documents.excel">NumbersFitMode</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getNumbersFitMode()" class="member-name-link">getNumbersFitMode</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 mode when date/number data width longer than column width.</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="#getTabEditable()" class="member-name-link">getTabEditable</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 to allow editing of the worksheet name.</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="#getTabNavigationVisible()" class="member-name-link">getTabNavigationVisible</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets whether to display navigation buttons in the workbook.</div>
</div>
<div class="col-first even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>double</code></div>
<div class="col-second even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getTabRatio()" class="member-name-link">getTabRatio</a>()</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Returns or sets the ratio of the width of the workbook's tab area to the width of the window's horizontal scroll bar (as a number between 0 (zero) and 1; The default value is 0.6).</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="SpreadJSTabStripPosition.html" title="enum class in com.grapecity.documents.excel">SpreadJSTabStripPosition</a></code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#getTabStripPosition()" class="member-name-link">getTabStripPosition</a>()</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Gets the position of tab strip relative to the workbook.</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="#getTabStripWidth()" class="member-name-link">getTabStripWidth</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 width of tab strip.</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="#setAllowSheetReorder(boolean)" class="member-name-link">setAllowSheetReorder</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 to allow reordering of worksheet tabs.</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="#setBackColor(com.grapecity.documents.excel.Color)" class="member-name-link">setBackColor</a><wbr>(<a href="Color.html" title="class in com.grapecity.documents.excel">Color</a>&nbsp;color)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Set background color of all worksheets.</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="#setDisplayHorizontalScrollBar(boolean)" class="member-name-link">setDisplayHorizontalScrollBar</a><wbr>(boolean&nbsp;value)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the horizontal scroll bar is 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="#setDisplayVerticalScrollBar(boolean)" class="member-name-link">setDisplayVerticalScrollBar</a><wbr>(boolean&nbsp;value)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets the vertical scroll bar 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="#setDisplayWorkbookTabs(boolean)" class="member-name-link">setDisplayWorkbookTabs</a><wbr>(boolean&nbsp;value)</code></div>
<div class="col-last odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets if display the workbook tabs.</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="#setGrayAreaBackColor(com.grapecity.documents.excel.Color)" class="member-name-link">setGrayAreaBackColor</a><wbr>(<a href="Color.html" title="class in com.grapecity.documents.excel">Color</a>&nbsp;color)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Set background color of workbook gray area.</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="#setNewTabVisible(boolean)" class="member-name-link">setNewTabVisible</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 to show the New Tab button.</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="#setNumbersFitMode(com.grapecity.documents.excel.NumbersFitMode)" class="member-name-link">setNumbersFitMode</a><wbr>(<a href="NumbersFitMode.html" title="enum class in com.grapecity.documents.excel">NumbersFitMode</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 display mode when date/number data width longer than column width.</div>
</div>
<div class="col-first odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code>void</code></div>
<div class="col-second odd-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3"><code><a href="#setTabEditable(boolean)" class="member-name-link">setTabEditable</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 to allow editing of the worksheet name.</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="#setTabNavigationVisible(boolean)" class="member-name-link">setTabNavigationVisible</a><wbr>(boolean&nbsp;value)</code></div>
<div class="col-last even-row-color method-summary-table method-summary-table-tab2 method-summary-table-tab3">
<div class="block">Sets whether to display navigation buttons in the workbook.</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="#setTabRatio(double)" class="member-name-link">setTabRatio</a><wbr>(double&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 ratio of the width of the workbook's tab area to the width of the window's horizontal scroll bar (as a number between 0 (zero) and 1; the default value is 0.6).</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="#setTabStripPosition(com.grapecity.documents.excel.SpreadJSTabStripPosition)" class="member-name-link">setTabStripPosition</a><wbr>(<a href="SpreadJSTabStripPosition.html" title="enum class in com.grapecity.documents.excel">SpreadJSTabStripPosition</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 position of tab strip relative to the workbook.</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="#setTabStripWidth(int)" class="member-name-link">setTabStripWidth</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 width of tab strip.</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="getDisplayHorizontalScrollBar()">
<h3>getDisplayHorizontalScrollBar</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayHorizontalScrollBar</span>()</div>
<div class="block">True if the horizontal scroll bar is displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayHorizontalScrollBar(boolean)">
<h3>setDisplayHorizontalScrollBar</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayHorizontalScrollBar</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets the horizontal scroll bar is displayed. Read/write Boolean.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayVerticalScrollBar()">
<h3>getDisplayVerticalScrollBar</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayVerticalScrollBar</span>()</div>
<div class="block">True if the vertical scroll bar is displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayVerticalScrollBar(boolean)">
<h3>setDisplayVerticalScrollBar</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayVerticalScrollBar</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets the vertical scroll bar is displayed. Read/write Boolean.</div>
</section>
</li>
<li>
<section class="detail" id="getTabRatio()">
<h3>getTabRatio</h3>
<div class="member-signature"><span class="return-type">double</span>&nbsp;<span class="element-name">getTabRatio</span>()</div>
<div class="block">Returns or sets the ratio of the width of the workbook's tab area to the width of the window's horizontal scroll bar (as a number between 0 (zero) and 1; The default value is 0.6).</div>
</section>
</li>
<li>
<section class="detail" id="setTabRatio(double)">
<h3>setTabRatio</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setTabRatio</span><wbr><span class="parameters">(double&nbsp;value)</span></div>
<div class="block">Sets the ratio of the width of the workbook's tab area to the width of the window's horizontal scroll bar (as a number between 0 (zero) and 1; the default value is 0.6). Read/write Double.</div>
</section>
</li>
<li>
<section class="detail" id="getDisplayWorkbookTabs()">
<h3>getDisplayWorkbookTabs</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getDisplayWorkbookTabs</span>()</div>
<div class="block">True if the workbook tabs are displayed.</div>
</section>
</li>
<li>
<section class="detail" id="setDisplayWorkbookTabs(boolean)">
<h3>setDisplayWorkbookTabs</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setDisplayWorkbookTabs</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets if display the workbook tabs.</div>
</section>
</li>
<li>
<section class="detail" id="getBackColor()">
<h3>getBackColor</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">getBackColor</span>()</div>
<div class="block">Get background color of all worksheets. SpreadJS only.</div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The background color of all worksheets.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setBackColor(com.grapecity.documents.excel.Color)">
<h3>setBackColor</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setBackColor</span><wbr><span class="parameters">(<a href="Color.html" title="class in com.grapecity.documents.excel">Color</a>&nbsp;color)</span></div>
<div class="block">Set background color of all worksheets. SpreadJS only.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>color</code> - The background color to set for all worksheets.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getGrayAreaBackColor()">
<h3>getGrayAreaBackColor</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">getGrayAreaBackColor</span>()</div>
<div class="block">Get background color of workbook gray area. SpreadJS only.</div>
<dl class="notes">
<dt>Returns:</dt>
<dd>The background color of the workbook's gray area.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="setGrayAreaBackColor(com.grapecity.documents.excel.Color)">
<h3>setGrayAreaBackColor</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setGrayAreaBackColor</span><wbr><span class="parameters">(<a href="Color.html" title="class in com.grapecity.documents.excel">Color</a>&nbsp;color)</span></div>
<div class="block">Set background color of workbook gray area. SpreadJS only.</div>
<dl class="notes">
<dt>Parameters:</dt>
<dd><code>color</code> - The background color to set for the workbook's gray area.</dd>
</dl>
</section>
</li>
<li>
<section class="detail" id="getTabNavigationVisible()">
<h3>getTabNavigationVisible</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getTabNavigationVisible</span>()</div>
<div class="block">Gets whether to display navigation buttons in the workbook. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="setTabNavigationVisible(boolean)">
<h3>setTabNavigationVisible</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setTabNavigationVisible</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether to display navigation buttons in the workbook. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="getTabEditable()">
<h3>getTabEditable</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getTabEditable</span>()</div>
<div class="block">Gets whether to allow editing of the worksheet name. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="setTabEditable(boolean)">
<h3>setTabEditable</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setTabEditable</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether to allow editing of the worksheet name. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="getAllowSheetReorder()">
<h3>getAllowSheetReorder</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getAllowSheetReorder</span>()</div>
<div class="block">Gets whether to allow reordering of worksheet tabs. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="setAllowSheetReorder(boolean)">
<h3>setAllowSheetReorder</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setAllowSheetReorder</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether to allow reordering of worksheet tabs. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="getNewTabVisible()">
<h3>getNewTabVisible</h3>
<div class="member-signature"><span class="return-type">boolean</span>&nbsp;<span class="element-name">getNewTabVisible</span>()</div>
<div class="block">Gets whether to show the New Tab button. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="setNewTabVisible(boolean)">
<h3>setNewTabVisible</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setNewTabVisible</span><wbr><span class="parameters">(boolean&nbsp;value)</span></div>
<div class="block">Sets whether to show the New Tab button. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="getTabStripPosition()">
<h3>getTabStripPosition</h3>
<div class="member-signature"><span class="return-type"><a href="SpreadJSTabStripPosition.html" title="enum class in com.grapecity.documents.excel">SpreadJSTabStripPosition</a></span>&nbsp;<span class="element-name">getTabStripPosition</span>()</div>
<div class="block">Gets the position of tab strip relative to the workbook. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="setTabStripPosition(com.grapecity.documents.excel.SpreadJSTabStripPosition)">
<h3>setTabStripPosition</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setTabStripPosition</span><wbr><span class="parameters">(<a href="SpreadJSTabStripPosition.html" title="enum class in com.grapecity.documents.excel">SpreadJSTabStripPosition</a>&nbsp;value)</span></div>
<div class="block">Sets the position of tab strip relative to the workbook. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="getTabStripWidth()">
<h3>getTabStripWidth</h3>
<div class="member-signature"><span class="return-type">int</span>&nbsp;<span class="element-name">getTabStripWidth</span>()</div>
<div class="block">Gets the width of tab strip. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="setTabStripWidth(int)">
<h3>setTabStripWidth</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setTabStripWidth</span><wbr><span class="parameters">(int&nbsp;value)</span></div>
<div class="block">Sets the width of tab strip. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="getNumbersFitMode()">
<h3>getNumbersFitMode</h3>
<div class="member-signature"><span class="return-type"><a href="NumbersFitMode.html" title="enum class in com.grapecity.documents.excel">NumbersFitMode</a></span>&nbsp;<span class="element-name">getNumbersFitMode</span>()</div>
<div class="block">Gets the display mode when date/number data width longer than column width. SpreadJS only.</div>
</section>
</li>
<li>
<section class="detail" id="setNumbersFitMode(com.grapecity.documents.excel.NumbersFitMode)">
<h3>setNumbersFitMode</h3>
<div class="member-signature"><span class="return-type">void</span>&nbsp;<span class="element-name">setNumbersFitMode</span><wbr><span class="parameters">(<a href="NumbersFitMode.html" title="enum class in com.grapecity.documents.excel">NumbersFitMode</a>&nbsp;value)</span></div>
<div class="block">Sets the display mode when date/number data width longer than column width. SpreadJS only.</div>
</section>
</li>
</ul>
</section>
</li>
</ul>
</section>
<!-- ========= END OF CLASS DATA ========= -->
<script>var evenRowColor = "even-row-color";
var oddRowColor = "odd-row-color";
var tableTab = "table-tab";
var activeTableTab = "active-table-tab";

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

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

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