Hide rows from exported table which have flag NoMasterRecords or NoDetailRecordsText

[Vasssek]

Hello,

Could somebody help me to solve my issue ? I've exported data from hierarched grid to Excel. Export is done properly, but in the result .xls file there are some rows which have text No child records to display. These rows I don't want to include in the export...

RadGrid export declaration is:

<ExportSettings Excel-Format="Html" ExportOnlyData="true" IgnorePaging="true"
                OpenInNewWindow="true">
            </ExportSettings>

I've tried to hide them in server code methods, e.g. RadGrid1_ItemCreated or RadGrid1_ExportCellFormatting, empty row text is still there :(.

Please help me to solve my issue.

For further information, please check the attachment.
The question is, how to remove rows 9 and 22 from exported xls...

Best regards

Vasssek

[Milena]

Hello,

Please find the attached project, where it is demonstrated how the desired functionality could be achieved.

Greetings,
Milena
the Telerik team

[Vasssek]

Hello,

I've tried your example, but it doesn't work as expected.

1. Even though radgrid has declared ExportOnlyData = "true" it exports whole controls (buttons, images), not just data.
2. I've added into radgrid declaration AllowFilteringByColumn = "true" because of getting text No child records to display. After applying filter, there are still all rows in the exported xls file instead of just filtered rows.

Please help me to solve this issue...

Thank you.

P.S. My dll version is 2012.1.411.40

Vasssek

[Milena]

Hello,

I would suggest you to continue this discussion in the opened support ticket, where you are facing the same issue.

Greetings,
Milena
the Telerik team