Copy Cells Text Display to Excel

May 2, 2009 at 2:25 AM
I have read a few posts talking about using the CopyToClipboard.  The problem with that is that if you have datagridcombocolumns, you copy the value rather than the text, which doesn't help much.

I was thinking of writing a routine to loop through all cells, grab the displayed text, and then write that out to an exporting piece.

Could you tell if it is possible to do this?  If so, what would be the syntax of the loop and getting the displayed text value?