I have gridview with string, date, and numeric columns. Once I set the data source and fill with data, I format each column to a suitable display - eg: short date, 2 decimal places for some, 4 decimals for others, etc. using the column.formatstring.
On a row click I need to get the formatted cell text, not the value and am wondering how I can do this? Eg: the underlying value of a cell is 12345.670000 but is formatted and displayed in the cell as 12,345.67. I could not find a "cell.text" property; and cell.value gives me the raw data.
How can I get the formatted cell text? Thanks, Brendan