DirtyAllFormulas Method

Dirties all the formulas so they get recalculated.

Syntax

Visual Basic

'Declaration
 
Public Sub DirtyAllFormulas() 

C#

public void DirtyAllFormulas()

Remarks

This method will cause the UltraCalcManager to mark all existing formulas as dirty. This means that the next time a calculation operation is performed, all formula will be recalculated. When the calculation occurs depends on the CalcFrequency property.

Example

Following code forces recalculation of all the formulas in the calc network.

Visual Basic

Imports Infragistics.Shared
Imports Infragistics.Win
Imports Infragistics.Win.UltraWinGrid
Imports Infragistics.Win.CalcEngine
Imports Infragistics.Win.UltraWinCalcManager


    Private Sub Button1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles button1.Click
        ' Typically there is no need to call DirtyAllFormulas method. It's purpose
        ' is to cause all the formulas in the calc network to be recalculated.
        Me.ultraCalcManager1.DirtyAllFormulas()

        ' You have to call ReCalc if you want the formulas to be synchronously calcualted.
        ' By default they are calculated on a timer.
        Me.ultraCalcManager1.ReCalc(-1)
    End Sub

C#

using Infragistics.Shared;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System.Diagnostics;
using Infragistics.Win.CalcEngine;
using Infragistics.Win.UltraWinCalcManager;


		private void button1_Click(object sender, System.EventArgs e)
		{
			// Typically there is no need to call DirtyAllFormulas method. It's purpose
			// is to cause all the formulas in the calc network to be recalculated.
			this.ultraCalcManager1.DirtyAllFormulas( );

			// You have to call ReCalc if you want the formulas to be synchronously calcualted.
			// By default they are calculated on a timer.
			this.ultraCalcManager1.ReCalc( -1 );
		}

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2