# FarPoint.Web.Spread.Model.IObjectExpressionSupport.UpdateFormulasWhenModelChanged

## Content

<div class="doc-site-dotnet-api-container">



<h1 id="FarPoint_Web_Spread_Model_IObjectExpressionSupport_UpdateFormulasWhenModelChanged_" data-uid="FarPoint.Web.Spread.Model.IObjectExpressionSupport.UpdateFormulasWhenModelChanged*">UpdateFormulasWhenModelChanged Method
</h1>
<div class="markdown level0 summary"></div>
<div class="markdown level0 conceptual"></div>



<a id="FarPoint_Web_Spread_Model_IObjectExpressionSupport_UpdateFormulasWhenModelChanged_" data-uid="FarPoint.Web.Spread.Model.IObjectExpressionSupport.UpdateFormulasWhenModelChanged*"></a>
<h4 id="FarPoint_Web_Spread_Model_IObjectExpressionSupport_UpdateFormulasWhenModelChanged_FarPoint_Web_Spread_Model_ISheetDataModel_FarPoint_Web_Spread_Model_ISheetDataModel_" data-uid="FarPoint.Web.Spread.Model.IObjectExpressionSupport.UpdateFormulasWhenModelChanged(FarPoint.Web.Spread.Model.ISheetDataModel,FarPoint.Web.Spread.Model.ISheetDataModel)">UpdateFormulasWhenModelChanged(ISheetDataModel, ISheetDataModel)</h4>
<div class="markdown level1 summary"><p>Updates all formulas of all the IExpressionConsumer object when changing the data model of a sheet in Spread.</p>
</div>
<div class="markdown level1 conceptual"></div>
<h5 class="declaration">Declaration</h5>
<div class="codewrapper">
  <pre><code class="lang-csharp hljs">void UpdateFormulasWhenModelChanged(ISheetDataModel newModel, ISheetDataModel oldModel)</code></pre>
</div>
<div class="codewrapper">
  <pre><code class="lang-vbnet hljs">Sub UpdateFormulasWhenModelChanged(newModel As ISheetDataModel, oldModel As ISheetDataModel)</code></pre>
</div>
<h5 class="parameters">Parameters</h5>
<table class="table table-bordered table-condensed">
  <thead>
    <tr>
      <th>Type</th>
      <th>Name</th>
      <th>Description</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td><a class="xref" href="FarPoint.Web.Spread.Model.ISheetDataModel.html">ISheetDataModel</a></td>
      <td><span class="parametername">newModel</span></td>
      <td><p>The old data model</p>
</td>
    </tr>
    <tr>
      <td><a class="xref" href="FarPoint.Web.Spread.Model.ISheetDataModel.html">ISheetDataModel</a></td>
      <td><span class="parametername">oldModel</span></td>
      <td><p>The new data model</p>
</td>
    </tr>
  </tbody>
</table>
<h5 id="FarPoint_Web_Spread_Model_IObjectExpressionSupport_UpdateFormulasWhenModelChanged_FarPoint_Web_Spread_Model_ISheetDataModel_FarPoint_Web_Spread_Model_ISheetDataModel__remarks">Remarks</h5>
<div class="markdown level1 remarks"><p>This method is intended to be used when it is necessary to update the formula at the specified index of the IExpressionConsumer.
This API supports the Spread infrastructure and is not intended to be used directly from your code</p>
</div>
</div>
