# GrapeCity.Documents.Excel.IProtectionSettings

## Content

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



  <h1 id="GrapeCity_Documents_Excel_IProtectionSettings" data-uid="GrapeCity.Documents.Excel.IProtectionSettings" class="text-break">IProtectionSettings Interface
</h1>
  <div class="markdown level0 summary"><p>Represents the various types of protection options available for a worksheet.
The setting action will take effect only if the worksheet is under protection.</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_IProtectionSettings_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IProtectionSettings</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IProtectionSettings</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_IProtectionSettings_AllowDeletingColumns" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowDeletingColumns">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowDeletingColumns.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowDeletingColumns">AllowDeletingColumns</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the deletion of columns is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowDeletingRows" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowDeletingRows">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowDeletingRows.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowDeletingRows">AllowDeletingRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the deletion of rows is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowEditingScenarios" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowEditingScenarios">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowEditingScenarios.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowEditingScenarios">AllowEditingScenarios</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the user is allowed to edit scenarios on a protected worksheet. The default value is false.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowFiltering" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowFiltering">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowFiltering.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowFiltering">AllowFiltering</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the user is allowed to make use of an AutoFilter that was created before the sheet was protected.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowFormattingCells" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowFormattingCells">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowFormattingCells.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowFormattingCells">AllowFormattingCells</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the formatting of cells is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowFormattingColumns" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowFormattingColumns">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowFormattingColumns.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowFormattingColumns">AllowFormattingColumns</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the formatting of columns is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowFormattingRows" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowFormattingRows">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowFormattingRows.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowFormattingRows">AllowFormattingRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the formatting of rows is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowInsertingColumns" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowInsertingColumns">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowInsertingColumns.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowInsertingColumns">AllowInsertingColumns</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the insertion of columns is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowInsertingHyperlinks" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowInsertingHyperlinks">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowInsertingHyperlinks.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowInsertingHyperlinks">AllowInsertingHyperlinks</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the insertion of hyperlinks is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowInsertingRows" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowInsertingRows">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowInsertingRows.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowInsertingRows">AllowInsertingRows</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the insertion of rows is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowSorting" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowSorting">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowSorting.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowSorting">AllowSorting</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the sorting option is allowed on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowUsingObjects" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowUsingObjects">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowUsingObjects.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowUsingObjects">AllowUsingObjects</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the user is allowed to use objects on a protected worksheet.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_AllowUsingPivotTables" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.AllowUsingPivotTables">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.AllowUsingPivotTables.html#GrapeCity_Documents_Excel_IProtectionSettings_AllowUsingPivotTables">AllowUsingPivotTables</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets whether the user is allowed to use pivot tables on a protected worksheet.</p>
</td>
      </tr>
    </tbody>
  </table>
  <h3 id="methods">Methods
</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_IProtectionSettings_FromJson_System_String_" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.FromJson(System.String)">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.FromJson.html#GrapeCity_Documents_Excel_IProtectionSettings_FromJson_System_String_">FromJson(string)</a>
        </td>
        <td class="markdown level1 summary"><p>Generate protectionSettings from the JSON string.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IProtectionSettings_ToJson" data-uid="GrapeCity.Documents.Excel.IProtectionSettings.ToJson">
          <a class="xref" href="GrapeCity.Documents.Excel.IProtectionSettings.ToJson.html#GrapeCity_Documents_Excel_IProtectionSettings_ToJson">ToJson()</a>
        </td>
        <td class="markdown level1 summary"><p>Generate the JSON string from the protectionSettings.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>