I have a situation where I have some very long columns. In ItemDataBound I just substring the first 80 characters and put it in the item.text, and the full struing in the ToolTip. The problem is when I export to Excel I want to get the entire contents of the data item, not the truncated version that's in the cell. How can I avoid this It seems that in ItemDataBound I can't test on Exporting.
The other option I've thought of is to somehow put the entire contents of the data item in the cell and maybe not have it wrap.
What would be the recommended solution?