I have a grid with a column linked to a value list. In a different column i have set a formula in which i need to use the text displayed in cell of the first column.
The cell reference in the formula returns the value of the cell, and not the text displayed that I need. Is there a way to get the cell text in the formula?
Thanks.
Emanuel
Hi Emanuel,
No, UltraCalcManager formulas always operate on the cell's Value, never the text.
You could work around this in a number of ways, depending on what you want to do. If you really need the cell's text to use in a formula, then you could add a hidden, unbound column to the grid and then use the InitializeRow event to copy the Text of the ValueList column into the Value of this hidden column. Then you could use the hidden column in your formula.
Another option would be to simply use the InitializeRow event to perform your calculation in code, rather than using a formula.
I'm going to use the InitializeRow event as suggested. Thanks Mike!