# GrapeCity.Documents.Excel.IWorksheetView

## Content

<div class="doc-site-dotnet-api-container">



  <h1 id="GrapeCity_Documents_Excel_IWorksheetView" data-uid="GrapeCity.Documents.Excel.IWorksheetView" class="text-break">IWorksheetView Interface
</h1>
  <div class="markdown level0 summary"><p>Represents worksheet view options.</p>
</div>
  <div class="markdown level0 conceptual"></div>
  <h6><strong>Namespace</strong>: <a class="xref" href="GrapeCity.Documents.Excel.html">GrapeCity.Documents.Excel</a></h6>
  <h6><strong>Assembly</strong>: DS.Documents.Excel.dll</h6>
  <h5 id="GrapeCity_Documents_Excel_IWorksheetView_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IWorksheetView</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IWorksheetView</code></pre>
  </div>
  <h3 id="properties">Properties
</h3>
  <table class="table table-bordered table-condensed">
    <thead>
      <tr>
        <th>Name</th>
        <th>Description</th>
      </tr>
    </thead>
    <tbody>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayFormulas" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayFormulas">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayFormulas.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayFormulas">DisplayFormulas</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the worksheet displays formulas. True if formulas are displayed; False if the worksheet displays values.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayGridlines" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayGridlines">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayGridlines.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayGridlines">DisplayGridlines</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether gridlines are displayed.
When this is set, <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayVerticalGridlines.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayVerticalGridlines">DisplayVerticalGridlines</a> and <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayHorizontalGridlines.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayHorizontalGridlines">DisplayHorizontalGridlines</a> would be set to same value.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayHeadings" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayHeadings">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayHeadings.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayHeadings">DisplayHeadings</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether headers are displayed (True if both row and column headings are displayed; False if there are no headings displayed).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayHorizontalGridlines" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayHorizontalGridlines">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayHorizontalGridlines.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayHorizontalGridlines">DisplayHorizontalGridlines</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether horizontal gridlines are displayed.
When this is set false, <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayGridlines.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayGridlines">DisplayGridlines</a> would be false, too.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayOutline" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayOutline">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayOutline.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayOutline">DisplayOutline</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether outline symbols are displayed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayRightToLeft" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayRightToLeft">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayRightToLeft.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayRightToLeft">DisplayRightToLeft</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the specified worksheet is displayed from right to left instead of from left to right (False if the object is displayed from left to right).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayRuler" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayRuler">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayRuler.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayRuler">DisplayRuler</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether a ruler is displayed for the specified worksheet (read or write).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayVerticalGridlines" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayVerticalGridlines">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayVerticalGridlines.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayVerticalGridlines">DisplayVerticalGridlines</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether vertical gridlines are displayed.
When this is set false, <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayGridlines.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayGridlines">DisplayGridlines</a> would be false, too.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayWhitespace" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayWhitespace">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayWhitespace.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayWhitespace">DisplayWhitespace</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether whitespace is displayed (read or write).</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_DisplayZeros" data-uid="GrapeCity.Documents.Excel.IWorksheetView.DisplayZeros">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.DisplayZeros.html#GrapeCity_Documents_Excel_IWorksheetView_DisplayZeros">DisplayZeros</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether zero values are displayed.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_FitSelection" data-uid="GrapeCity.Documents.Excel.IWorksheetView.FitSelection">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.FitSelection.html#GrapeCity_Documents_Excel_IWorksheetView_FitSelection">FitSelection</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the zoom is set to fit the selection.
Unlike Microsoft Excel Application, this option does not modify the value of the <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.Zoom.html#GrapeCity_Documents_Excel_IWorksheetView_Zoom">Zoom</a> property.
This option is only supported for <a class="xref" href="GrapeCity.Documents.Excel.SheetType.html#GrapeCity_Documents_Excel_SheetType_Chart">Chart</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_GridlineColor" data-uid="GrapeCity.Documents.Excel.IWorksheetView.GridlineColor">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.GridlineColor.html#GrapeCity_Documents_Excel_IWorksheetView_GridlineColor">GridlineColor</a>
        </td>
        <td class="markdown level1 summary"><p>Returns or sets the <span class="xref">GrapeCity.Documents.Excel.RGBColor</span> object that represents the gridline color of the worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_ScrollColumn" data-uid="GrapeCity.Documents.Excel.IWorksheetView.ScrollColumn">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.ScrollColumn.html#GrapeCity_Documents_Excel_IWorksheetView_ScrollColumn">ScrollColumn</a>
        </td>
        <td class="markdown level1 summary"><p>Returns or sets the number of the leftmost column in the pane or worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_ScrollRow" data-uid="GrapeCity.Documents.Excel.IWorksheetView.ScrollRow">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.ScrollRow.html#GrapeCity_Documents_Excel_IWorksheetView_ScrollRow">ScrollRow</a>
        </td>
        <td class="markdown level1 summary"><p>Returns or sets the number of the row that appears at the top of the pane or worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_ViewType" data-uid="GrapeCity.Documents.Excel.IWorksheetView.ViewType">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.ViewType.html#GrapeCity_Documents_Excel_IWorksheetView_ViewType">ViewType</a>
        </td>
        <td class="markdown level1 summary"><p>Gets and sets the view type.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IWorksheetView_Zoom" data-uid="GrapeCity.Documents.Excel.IWorksheetView.Zoom">
          <a class="xref" href="GrapeCity.Documents.Excel.IWorksheetView.Zoom.html#GrapeCity_Documents_Excel_IWorksheetView_Zoom">Zoom</a>
        </td>
        <td class="markdown level1 summary"><p>Returns or sets a Variant value that represents the display size of the worksheet, as a percentage(100 equals normal size, 200 equals double size, and so on).</p>
</td>
      </tr>
    </tbody>
  </table>

</div>