CalcQuick variable list

[Shannon Broskie]

We are working on a custom calculation solution for the end user where the user defines columns in grids along with the formulas controlling those columns.

So, for example, using the front end, the user might assign a column a formula such as:
[Duration] * [MarketAndAccrued] / [-TotalMarketValue-]

When processing the requested data, we feed the column formula definition into CalcQuick. The variables in the formula represent the column names of the DataTable to be processed.

What we are trying to find is a way to enumerate the list of variables in CalcQuick, provided by the formula, and pass in the actual values for those variables. There doesn't seem to be a way to get at the non-public DataStore that contains the variable listing.

Any ideas? If not, we'll have to wind up parsing the formula anyways, finding the column names to push through for variable values.

Thanks in advance for any help.

[Administrator]

The underlying data objects used by CalcQuick are exposed as protected properties. So, the way to access these data objects is to derive CalcQuick, and use the protected properties in the derived class to do whatever work you want done with them.

I am not sure exactly what lists you need, but the main one is:

/// 

/// Maintains a collection of FormulaInfo objects.
/// 

/// 
///  This Hashtable serves as the data store for the
///  CalcQuick instance. The keys are the strings used
///  to identify formulas and the values are FormulaInfo 
///  objects that hold the information on each formula or value.
/// 
protected FormulaInfoHashtable DataStore