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?
The formulas use the UltraWinCalcManager component, so you can find out more about formulas and functions by checking out the CalcManager documentation.
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
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?