# GrapeCity.Documents.Excel.IFormulaOptions

## Content

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



  <h1 id="GrapeCity_Documents_Excel_IFormulaOptions" data-uid="GrapeCity.Documents.Excel.IFormulaOptions" class="text-break">IFormulaOptions Interface
</h1>
  <div class="markdown level0 summary"><p>Represents the options related to formula caculation, performance, and error handing.</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_IFormulaOptions_syntax">Syntax</h5>
  <div class="codewrapper">
    <pre><code class="lang-csharp hljs">public interface IFormulaOptions</code></pre>
  </div>
  <div class="codewrapper">
    <pre><code class="lang-vbnet hljs">Public Interface IFormulaOptions</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_IFormulaOptions_CalculationMode" data-uid="GrapeCity.Documents.Excel.IFormulaOptions.CalculationMode">
          <a class="xref" href="GrapeCity.Documents.Excel.IFormulaOptions.CalculationMode.html#GrapeCity_Documents_Excel_IFormulaOptions_CalculationMode">CalculationMode</a>
        </td>
        <td class="markdown level1 summary"><p>Gets or sets the calculation mode, this setting will only affect I/O of MS Excel/SSJSON/SJS files.
Setting CalculationMode as <a class="xref" href="GrapeCity.Documents.Excel.CalculationMode.html#GrapeCity_Documents_Excel_CalculationMode_Manual">Manual</a> will prevent MS Excel or SpreadJS from automatically calculating formulas on opening the workbook.
Additionally, <a class="xref" href="GrapeCity.Documents.Excel.CalculationMode.html#GrapeCity_Documents_Excel_CalculationMode_Manual">Manual</a> improves the speed of opening workbooks that contain a large number of formulas in MSExcel and SpreadJS.
If you want to disable the calculation for the current workbook, please use <a class="xref" href="GrapeCity.Documents.Excel.Workbook.EnableCalculation.html#GrapeCity_Documents_Excel_Workbook_EnableCalculation">EnableCalculation</a>.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IFormulaOptions_EnableIterativeCalculation" data-uid="GrapeCity.Documents.Excel.IFormulaOptions.EnableIterativeCalculation">
          <a class="xref" href="GrapeCity.Documents.Excel.IFormulaOptions.EnableIterativeCalculation.html#GrapeCity_Documents_Excel_IFormulaOptions_EnableIterativeCalculation">EnableIterativeCalculation</a>
        </td>
        <td class="markdown level1 summary"><p>Enable iterative calculation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IFormulaOptions_MaximumChange" data-uid="GrapeCity.Documents.Excel.IFormulaOptions.MaximumChange">
          <a class="xref" href="GrapeCity.Documents.Excel.IFormulaOptions.MaximumChange.html#GrapeCity_Documents_Excel_IFormulaOptions_MaximumChange">MaximumChange</a>
        </td>
        <td class="markdown level1 summary"><p>Maximum change for iterative calculation.</p>
</td>
      </tr>
      <tr>
        <td id="GrapeCity_Documents_Excel_IFormulaOptions_MaximumIterations" data-uid="GrapeCity.Documents.Excel.IFormulaOptions.MaximumIterations">
          <a class="xref" href="GrapeCity.Documents.Excel.IFormulaOptions.MaximumIterations.html#GrapeCity_Documents_Excel_IFormulaOptions_MaximumIterations">MaximumIterations</a>
        </td>
        <td class="markdown level1 summary"><p>Maximum iterations for iterative calculation.</p>
</td>
      </tr>
    </tbody>
  </table>

</div>