Forums Ultimate UI for Windows Forms
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
Close
Emanuel Haisiuc
2077
Getting the text of a cell, instead of it's value
posted

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

Parents
No Data
Reply
  • 469350
    Verified Answer
    Offline posted

    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.

Children