Version

Using Formula Builder at Run Time

The WinCalcManager™ FormulaBuilder can be shown to the user at run-time.

To Show the FomulaBuilder.

  1. Before you start writing any code, you should place using/imports directives in your code-behind so you don’t need to always type out a member’s fully qualified name.

In Visual Basic:

Imports Infragistics.Win.UltraWinCalcManager
Imports Infragistics.Win.UltraWinCalcManager.FormulaBuilder
Imports Infragistics.Win.CalcEngine

In C#:

using Infragistics.Win.UltraWinCalcManager;
using Infragistics.Win.UltraWinCalcManager.FormulaBuilder;
using Infragistics.Win.CalcEngine;

  1. Place a UltraCalcManager, three UltraTextEditors, and UltraButton on the form.

  2. Rename the editors to "txtBox1", "txtBox2", and "txtSumBox". In addition, set off each editor’s CalcSettings the PropertyName to Text. If you forget to set the PropertyName to Text your end user will not be able to see any controls in the FormulaBuilderDialog.

  3. Change the UltraButton’s name to be "btnShowFormulaBuilderDialog". Set the Button’s Text property to "Show Formula Builder Dialog".

  4. Add a reference to Infragistics.Win.UltraWinCalcManager.v20.2.FormulaBuilder

  5. In the code behind create a method called ShowFormulaBuilderDialog that passes in a IFormulaProvider.

  6. Inside the ShowFormulaBuilderDialog method declare a new FormulaBuilderDialog, passing in the IForumlaProvider variable that was passed into the ShowFormulaBuilderDialog.

  7. Inside the ShowFormulaBuilderDialog method after you have declared your FormulaBuilderDialog, you’ll need to show the dialog.

  8. Once the dialog is shown we need to test to see if the end user cancels the dialog, and if they do just return from the ShowFormulaBuilderDialog method. If the dialog isn’t cancelled, then we need to take the FormulaBuildDialog’s Formula property and assign it to the passed in IFormulaProvider’s Formula property.

The following example code shows what the previous couple of steps combined code looks like.

In Visual Basic:

Private Sub ShowFormulaBuilderDialog(ByVal formulaProvider As IFormulaProvider)
	' Declare a new FormulaBuilderDialog
	Dim formulaBuilderDialog As New FormulaBuilderDialog(formulaProvider)
	' Show the dialog
	Dim dResult As DialogResult = formulaBuilderDialog.ShowDialog(Me)
	' If the user cancelled, do nothing
	If dResult = System.Windows.Forms.DialogResult.Cancel Then
		Return
	End If
	' Apply the formula
	formulaProvider.Formula = formulaBuilderDialog.Formula
End Sub

In C#:

private void ShowFormulaBuilderDialog(IFormulaProvider formulaProvider)
{
	// Declare a new FormulaBuilderDialog
	FormulaBuilderDialog formulaBuilderDialog =
	  new FormulaBuilderDialog(formulaProvider);
	// Show the dialog
	DialogResult dResult = formulaBuilderDialog.ShowDialog(this);
	// If the user cancelled, do nothing
	if (dResult == System.Windows.Forms.DialogResult.Cancel)
		return;
	// Apply the formula
	formulaProvider.Formula = formulaBuilderDialog.Formula;
}

  1. In the designer double click the button to create the button’s click event. Inside the event call the ShowFormulaBuilderDialog method that we created above, passing in the CalcSettings of the txtSumBox control using the GetCalcSettings method of the UltraCalcManager to get the CalcSettings of a control at run-time.

In Visual Basic:

Private Sub btnShowFormulaBuilderDialog_Click(ByVal sender As System.Object, _
  ByVal e As System.EventArgs) Handles btnShowFormulaBuilderDialog.Click
	Me.ShowFormulaBuilderDialog(Me.UltraCalcManager1.GetCalcSettings(Me.txtSumBox))
End Sub

In C#:

private void btnShowFormulaBuilderDialog_Click(object sender, System.EventArgs e)
{
	this.ShowFormulaBuilderDialog(this.ultraCalcManager1.GetCalcSettings(
	  this.txtSumBox));
}

  1. Build and run the project. Type numbers into the first two editors, and press the "Show Formula Builder Dialog" button. You should see something similar to the following appear. Put in the calculation you want, and when you click OK, the resulting value will be shown in the third editor.

shows formula builder for wincalcmanager at run time to allow custom calculations at run time.