# GrapeCity.Documents.Excel.IFormulaOptions.CalculationMode

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="GrapeCity_Documents_Excel_IFormulaOptions_CalculationMode_" data-uid="GrapeCity.Documents.Excel.IFormulaOptions.CalculationMode*">CalculationMode Property
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="GrapeCity_Documents_Excel_IFormulaOptions_CalculationMode_" data-uid="GrapeCity.Documents.Excel.IFormulaOptions.CalculationMode*"></a>
<h4 id="GrapeCity_Documents_Excel_IFormulaOptions_CalculationMode" data-uid="GrapeCity.Documents.Excel.IFormulaOptions.CalculationMode">CalculationMode</h4>
<div 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>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">CalculationMode CalculationMode { get; set; }</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Property CalculationMode As CalculationMode</code></pre>
</div>
</div>
