We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

CalcQuick variable list

Thread ID:





64257 Jul 17,2007 03:23 PM UTC Jul 17,2007 05:12 PM UTC WinForms 1
Tags: Calculate
Shannon Broskie
Asked On July 17, 2007 03:23 PM UTC

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 [Syncfusion]
Replied On July 17, 2007 05:12 PM UTC

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


This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon