Hi, a have a problem with IgnorePaging="true" is not exporting all the pages to excel.
This is my code
This is my code
<telerik:RadSlidingPane ID="RadSlidingPane2" runat="server" Title="Elementos Georeferenciados" Width="600px" EnableDock="false"> <telerik:RadAjaxPanel ID="RadAjaxPanel2" runat="server" ClientEvents-OnRequestStart="pnlRequestStarted"> <telerik:RadGrid ID="gridTematico" runat="server" AllowSorting="True" GridLines="None" Skin="Office2007" AllowFilteringByColumn="True" AllowPaging="True" PageSize="50" OnItemDataBound="gridTematico_ItemDataBound" OnColumnCreated="gridTematico_ColumnCreated" OnCancelCommand="gridTematico_CancelCommand" OnEditCommand="gridTematico_EditCommand" OnSelectedIndexChanged="gridTematico_SelectedIndexChanged" OnUpdateCommand="gridTematico_UpdateCommand"> <HeaderContextMenu CssClass="GridContextMenu GridContextMenu_Default"></HeaderContextMenu> <MasterTableView CommandItemDisplay="Bottom" ShowFooter="True" ShowGroupFooter="True" UseAllDataFields="True"> <Columns> <telerik:GridTemplateColumn UniqueName="TemplateColumn" HeaderText="NÂș" AllowFiltering="False" FilterControlAltText="Filter TemplateColumn column"> <ItemTemplate> <asp:Label ID="fila" runat="server" Width="30px" /> </ItemTemplate> <HeaderStyle Width="30px" Font-Size="X-Small" Font-Bold="True" /> </telerik:GridTemplateColumn> <telerik:GridEditCommandColumn ButtonType="ImageButton" FilterControlAltText="Filter EditCommandColumn column"></telerik:GridEditCommandColumn> </Columns> <CommandItemSettings RefreshText="Actualizar" ShowAddNewRecordButton="False" /> <RowIndicatorColumn FilterControlAltText="Filter RowIndicator column"></RowIndicatorColumn> <ExpandCollapseColumn FilterControlAltText="Filter ExpandColumn column"></ExpandCollapseColumn> <EditFormSettings> <EditColumn ButtonType="ImageButton" FilterControlAltText="Filter EditCommandColumn column" UniqueName="EditCommandColumn1"></EditColumn> </EditFormSettings> </MasterTableView> <ClientSettings EnablePostBackOnRowClick="True"> <Selecting AllowRowSelect="True" /> </ClientSettings> <FilterMenu EnableImageSprites="False"></FilterMenu> <ExportSettings ExportOnlyData="True" FileName="ElementosGeoreferenciados" IgnorePaging="True" OpenInNewWindow="True"> <Csv ColumnDelimiter="Semicolon" /> </ExportSettings> </telerik:RadGrid> <table> <tr> <td style="width: 32px;"> <asp:ImageButton ID="btnExcel" runat="server" ImageUrl="~/images/iconos/File_Excel.png" ToolTip="Exportar a Excel" Visible="False" OnClick="btnExcel_Click" Width="32px" Height="32px" /> </td> <td style="width: 32px;"> <asp:ImageButton ID="btnCsv" runat="server" ImageUrl="~/images/iconos/File_Csv.png" ToolTip="Exportar a csv" Visible="False" OnClick="btnCsv_Click" Width="32px" Height="32px" /> </td> <td style="width: 32px;"> <asp:ImageButton ID="btnWord" runat="server" ImageUrl="~/images/iconos/File_Word.png" ToolTip="Exportar a Word" Visible="False" OnClick="btnWord_Click" Width="32px" Height="32px" /> </td> </tr> </table> </telerik:RadAjaxPanel></telerik:RadSlidingPane>
<telerik:RadScriptBlock ID="RadScriptBlock1" runat="server">
<script type="text/javascript">
function pnlRequestStarted(ajaxPanel, eventArgs)
{
if((eventArgs.EventTarget.indexOf("btnExcel")!=-1)||(eventArgs.EventTarget.indexOf("btnCsv")!=-1)||(eventArgs.EventTarget.indexOf("btnWord")!=-1))
eventArgs.EnableAjax = false;
}
</script>
</telerik:RadScriptBlock>
protected void btnExcel_Click(object sender, ImageClickEventArgs e){ gridTematico.ExportSettings.IgnorePaging = true; gridTematico.ExportSettings.ExportOnlyData = true; gridTematico.ExportSettings.OpenInNewWindow = true; gridTematico.MasterTableView.ExportToExcel();}