ADAdministrator Syncfusion Team April 16, 2003 08:13 AM
The FormulaGrid sample acttually adds a function to the library (the Min function). The 2 steps needed to do so are noted in the comments of that sample.
Here is a link to another thread that has a sample with added formulas.
As far as an IIF formula, right now there is an added complexity as currently there are no binary logical operators supported. So, with the current code library, you could not easily write a function that used a logical expression as the first argument as there is no way to let the engine compute this expression. We will remove this limitation soon. In the meantime, you could, in a straight forward manner, write a function computes sort of a 'arithmetic if' in that the second argument is returned if the first argument if zero or positive, and returns the third argument otherwise.
MSMartin SquicciariniApril 22, 2003 07:46 AM
I found the Min example and was able to crete an If() function (it's still a work in progress but it getting there). The function I developed follows what you suggested. I have a few more features to add but I now have another issue.
Some of the equations that our client uses in Excel are of the form =$A:$A +$B:$B to add the values in a single row. Will this be support in the near future.
Finally, when will these features be available? Thanks for all you help.
ADAdministrator Syncfusion Team April 22, 2003 12:38 PM
Currently, all our formulas are absolute references (like the Excel $ reference notation). We will be adding support for relative references. It is a high priority item, and should be finished soon (weeks not months), but I don't know when it will actually become available.
MSMartin SquicciariniApril 23, 2003 03:31 AM
I would be interested in obtaining that feature asap even to the point of beta testing it. Our client uses the $A:$A referencing to refer to the current row. Thanks.