Get formatted cell text (value)

[Brendan]

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

[Dess | Tech Support Engineer, Principal]

Hello Brendan, 

Thank you for writing.  

You can extract the formatted text from the visual cell element. It is necessary to subscribe to the MouseDown event and get the GridDataCellElement under the mouse. Here is demonstrated a sample code snippet:

private void radGridView1_MouseDown(object sender, MouseEventArgs e)
{
    GridDataCellElement cellElement = this.radGridView1.ElementTree.GetElementAtPoint(e.Location) as GridDataCellElement;
    if (cellElement != null)
    {
        RadMessageBox.Show(cellElement.Text);
    }
}

I hope this information helps. Should you have further questions I would be glad to help.

Regards,
Dess
Progress Telerik

[MORDECHAI]

Given the `Cell` object without any location data how can I do it?

[MORDECHAI]

I mean 

GridViewCellInfo

[Dess | Tech Support Engineer, Principal]

Hello, 

If you have the data cell object (GridViewCellInfo), you can find the visual cell element and get its Text property:

        private void radGridView1_CurrentCellChanged(object sender, CurrentCellChangedEventArgs e)
        {
            GridViewCellInfo dataCell = e.NewCell;
            GridRowElement visualRowElement = this.radGridView1.TableElement.GetRowElement(dataCell.RowInfo);
            if (visualRowElement != null && visualRowElement.VisualCells.Count > 0)
            {
                string formattedText = visualRowElement.VisualCells[dataCell.ColumnInfo.Index].Text;
                RadMessageBox.Show(formattedText);
            }
        }

I hope this information helps. 

Regards,
Dess | Tech Support Engineer, Sr.
Progress Telerik