Hello,
The data I have coming back from the database is TRIM'ed up and when inspecting the RadGrid the cells do not have extra spacing:
However, when I use the built in export functionality to export the grid to an Excel document some of the cells suddenly take on "Blank" values. They become identified when enabling the Excel filter and selecting just "Blank" values:
When copying/pasting into Notepad++ the referenced cell that clearly has "Open" in the value is pasted as a 4 blank rows with no "Open" value to be found. This leads me to believe that somewhere along the export process the value is either lost or so many blank filler spaces are added that they conflict with the Excel filter. Has anyone run into something similar to this? Any suggestions appreciated. Thanks!
Hi Matt,
Can you please share the Grid markup definitions and the backend code (C#, VB) related to it? We will need to see how it was configured, which export extension is used and try replicate the problem locally.