I wish to format an entire row based on the value of one cell in the row. Alternately I wish to format cell X based on the value of cell Y. Are either of these possible?
I figured out how to use a FormulaCondition to make the formatting of cell X depend on a value in cell Y.
Where can I find documentation about the Formula syntax?
I have a similar need to format Cell X based on the value of Cell Y.
You state that you figured out how to use the FormulaCondition to achieve this. Can you share the code on how you accomplished this?
It would be greatly appreciated.
Thank you
Typically the best way to figure this out is to check the designer code. Add a column with a formula condition then check out the code. The operator conditions are very similar.
Here's a snippet from the designer of one of my apps. Sets two different conditions, one for true the other for false. Note that the designer does this all in one shot and the code is a little messy, but you can rewrite to add your own at run-time very easily.
Infragistics.Win.
ConditionValueAppearance conditionValueAppearance28 = new Infragistics.Win.ConditionValueAppearance(new Infragistics.Win.ICondition
[] {
((Infragistics.Win.
ICondition)(new Infragistics.Win.FormulaCondition("[Encrypted?] = true()"
))),
ICondition)(new Infragistics.Win.FormulaCondition("[Encrypted?] = false()")))}, new Infragistics.Win.Appearance
Typically, the designer for the formula condition will tell you if you have entered a valid formula or not. The syntax is pretty straightforward.
Hope it helps