RadGrid1.ExportSettings.IgnorePaging = True but I still only get the first page in the Excel file

[Karl Wilkens]

Hi, 

I have a radgrid within a multiPage interface. The grid populates fine. Here is the Aspx definition on this

<telerik:RadGrid ID="RadGrid1" runat="server" AllowCustomPaging="True" 

                    AllowFilteringByColumn="True" AllowPaging="True" AllowSorting="True" 

                   GridLines="None" Skin="WebBlue">

I have an imagebutton that when clicked does this 

 Dim filename As String =  "whatever.xls"

        RadGrid1.ExportSettings.OpenInNewWindow = True

        RadGrid1.ExportSettings.FileName = filename

        RadGrid1.ExportSettings.ExportOnlyData = True

        RadGrid1.ExportSettings.IgnorePaging = True

        RadGrid1.ExportSettings.OpenInNewWindow = True

No matter what, the resulting excel only contains the first 25 rows. I have also tried forcing the above code by adding the following

  RadGrid1.MasterTableView.AllowPaging = false

        RadGrid1.Rebind()

'... the above code here and then..

 RadGrid1.MasterTableView.AllowPaging = true

        RadGrid1.Rebind()

No approach seems to work. There is no AjaxManager involved, and the grid itself is not ajaxified. Anyone out there have any ideas? The only complication in all of this is that the grid resides in a multipage / tabbed interface, but the export to Excel button resides outside of the multipiage. Also, I am using MasterPages - pretty simple there - no AjaxManager there either. Any thoughts appreciated.

      

[Andrey]

Hello,

The problem you are facing is mostly caused by the custom paging you are using. When you say IgnorePaging you need to provide the full datasource to RadGrid in order to receive the expected behavior. You could check this online demo application for more information about the custom paging functionality of RadGrid.

Regards,
Andrey
the Telerik team