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();
}