Hi ,
I was working with FormulaCondtion. But i havn't found any help to write formula.
Is there any doc available that tell us which are the valid functions in formulastring?
And how to use different properties of ultragridrow in formula?
like i want to use Tag in formula instead of ConditionValue ?
It would be great if i'll get positive inputs from your side.
Thanks
Yashpal Sharma
Yashpal,
The formulas here are the same formulas that are used by the UltraCalcManager, so you can use the FormulaBuilder dialog to design the formula that you need; you can do this by ensuring that you have an UltraCalcManager on your form and opening the grid designer and click the '...' button for the ValueBasedAppearance property. You can then click "Add Formula Condition", where you should see the dialog appear.
From what you're describing, however, I'm not sure that a FormulaCondition is what you're looking for. For one thing, it sounds like you're trying to write the FormulaCondition in code, which isn't really what this feature was designed for. The Conditional Formatting feature was designed to allow you to setup conditions, at design-time, for the various columns in a grid. If you need to access properties of the rows, or cells, in order to make your formatting decisions, your best option is to use the InitializeRow event and set the formatting here. In many cases, when formatting at run-time, it is less code to handle the InitializeRow event than it is to manually create all of the conditions.
-Matt
Matt ,
Your inputs were great . Your suggestion helped me to get the formula list which was requested to resolve the issues i was getting earlier.
Thanks to show me the way. :)