CALCULATION MANAGER

Add Excel-Like Formula Support to Any Control on the Form

The xamCalculationManager adds Microsoft Excel-like formula support to any control on the form, including native WPF & Silverlight controls and Infragistics XAML controls. It manages all formulas as well as getting values from sources and setting values on targets of those formulas. The Calculation Manager has many pre-defined functions that emulate Excel functions as well as allowing developers to register custom functions. In addition, the Calculation Manager automatically determines the order in which to solve formulas based on the dependencies of sources and targets. In addition to the calculation engine it includes the following features:

  • An attached property that can be set on any content control (e.g. a TextBox, TextBlock, Editor etc.) to allow the control to participate in the calculation network as a source of a value, a target of a formula or both.
  • A NamedReferences collection is exposed to allow global constants or formulas to be easily included in the calculation network.

Key Features at a Glance

  • Item Calculator – Exposes an Item property and a collection of Item Calculations which each identify a property on the specified item that can be the source and/or target of a formula.
  • List Calculator – Exposes Items Source and Items Properties as well as two collections. One collection contains Item Calculations which will be applied separately to each item in the list. The other is a collection of List Calculations which will be applied across all items in the list.
  • Formula Editor - Provides a fully fledged formula editing experience for the end user. In addition, the Formula Editor contains a button that allows the user to display the Formula Editor Dialog. The Formula Editor Dialog has a fully fledged formula editing experience, adding more assistance in the form of operand and function lists, buttons to insert commonly used operators, and syntax errors that always display and can bring the user to the place in the formula that needs to be corrected. Both the Formula Editor and its Formula Editor Dialog provide a Help experience that assists users and updates dynamically as they type. This contextual Help provides suggestions as well as descriptions of what is currently being edited.
  • Grid Integration - Define forumlas that use and set values in cells of grids.