RadGrid Excel Export Adding Extra Spaces

0 Answers 14 Views
Grid
Matt
Top achievements
Rank 1
Matt asked on 09 Dec 2021, 02:23 PM | edited on 09 Dec 2021, 02:24 PM

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!

 

Attila Antal
Telerik team
commented on 14 Dec 2021, 08:45 AM

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. 

No answers yet. Maybe you can help?

Tags
Grid
Asked by
Matt
Top achievements
Rank 1
Share this question
or