# C1.WPF.Excel.C1XLBook.KeepFormulas

## Content

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



<h1 id="C1_WPF_Excel_C1XLBook_KeepFormulas_" data-uid="C1.WPF.Excel.C1XLBook.KeepFormulas*">KeepFormulas Property
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="C1_WPF_Excel_C1XLBook_KeepFormulas_" data-uid="C1.WPF.Excel.C1XLBook.KeepFormulas*"></a>
<h4 id="C1_WPF_Excel_C1XLBook_KeepFormulas" data-uid="C1.WPF.Excel.C1XLBook.KeepFormulas">KeepFormulas</h4>
<div class="markdown level1 summary"><p>Specifies whether the component should store formulas read from XLS/XLSX files
and write them back when saving the file.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">public bool KeepFormulas { get; set; }</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Public Property KeepFormulas As Boolean</code></pre>
</div>
<h5 id="C1_WPF_Excel_C1XLBook_KeepFormulas_remarks">Remarks</h5>
<div class="markdown level1 remarks"><pre><code>&lt;p&gt;Setting this property to true allows you to load existing XLS/XLSX files, modify the values 
</code></pre>
<p>in some cells, and save the file preserving the formulas. This is the default setting.</p>
<p>Setting this property to false causes the component to remove the formulas in the book
when it is loaded. Saving the file in this case will retain the last calculated values but
will remove the formulas.</p>
<p>Assigning any value to a cell will clear the formula in the cell.</p>
</div>
</div>