Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
284
How to write Formula in FormulaCondition
posted

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

 

Parents
  • 37774
    Verified Answer
    posted

    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

Reply Children
No Data