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

GridFormulaEngine.LibraryFunction information

Thread ID:





67513 Aug 21,2007 08:59 AM UTC Aug 21,2007 01:35 PM UTC WinForms 1
Tags: GridControl
Asked On August 21, 2007 08:59 AM UTC

I want to implement some function help (like excels function menu).

Spec is along the following lines:
-Simple form containing two list boxes.
-Left hand listbox contains a list of available grid functions.
-Right hand list box shows the required and optional arguments for the selected function in the left hand listbox

I can get a list of function names easily as follows:

SortedDictionary functionList = new SortedDictionary();

private void PopulateFormulaeList()
foreach (DictionaryEntry de in formulaCellModel.Engine.LibraryFunctions)
functionList.Add(de.Key as string , de.Value as GridFormulaEngine.LibraryFunction);
To get the argument names I then look at the objects of type System.Reflection.ParameterInfo in unction.Method.GetParameters(). However the only information I can get from the ParameterInfo Name and type properties is the .net parameter information (i.e. that there is a single string argument called args, argList or range in most cases).

Is it possible to get information about the individual argument that the user sees when writing the formulae types and if they are options for each argument in a GridFormulaEngine.LibraryFunction.

Many thanks,

Jeba S [Syncfusion]
Replied On August 21, 2007 01:35 PM UTC

Hi Steve,

Thank you for your details.

Currenlty there is no way to get information about the individual argument. In any formula that references the name, the string would be substituted before parsing and computing takes place.

Please refer this sample which list the formulas with arguments in dropdown list.

In the sample, custom cell is created with a static field of type datatable. In the form load this table is filled with the syntaxes of the library functions from the FormulaEngine. This datatable is used to fill the dropdown listbox with the matched function syntax.

Kindly let us know if you need any further assistance.

Best Regards,


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

or the page will be automatically redirected to 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