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?
Hi David,
Here is a help topic that shows you how you can programmatically create a Formula Condition and assign it to a specific column. Your formula syntax would then reference [CellY] .
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
Hey guys,
This is where you can get a list of all the Excel like functions as well as examples of each:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2009.1/CLR2.0/html/WinCalcManager_Excel_Style_Functions.html
Also, what I did when learning Calc Manager was to use the design-time Formula Builder:
http://help.infragistics.com/Help/NetAdvantage/WinForms/2009.1/CLR2.0/html/WinCalcManager_About_WinCalcManager.html
Every Object.Formula property will have the ellipse [...] button that will launch the Formula Builder. Create your formulas in this fashion by dragging and dropping the functions, operators, references, and anything else that you wish to participate in the calc-network. Then you just observe the syntax that is used to create the formula. Once you know how this works, you can just simply create your formula string and assign it to the respective Formula property.
Hi,
I thought there was a page somewhere that discusses the syntax for CalcManager, but I can't seem to find it, so maybe I am wrong.
I'm going to forward this thread over to our Docs department so they can read your comments.
Mike, thank you for your response.
I had looked at this documentation, but it is focused on using the designers. I really just want an overview of the grammar, since I am setting stuff up at run time, but not using the formula builder. I figured out enough to be able to do what I need to do, but in general the infragistics documentation focuses too much on designers, and not enough on coding.