[Solved] EXCEL Export Problem - RegisterRequiresViewStateEncryption()

[Shawn]

I am not sure why this is happening, but it ONLY happens when exporting to Excel.  I have this same export functionality on other pages that work fine, for some reason this page doesn't like it and I am not sure why.

I specify the file name and format on the grid itself and then simply have these buttons:

<asp:ImageButton ID="btn_ExportCSV" runat="server"
                OnClick="btn_ExportCSV_Click" BorderColor="#F0A54E"
                BorderStyle="Ridge"
                ImageUrl="~/images/export_csv.jpg" />&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:ImageButton ID="btn_ExportEXCEL" runat="server"
                OnClick="btn_ExportEXCEL_Click" BorderColor="#F0A54E"
                BorderStyle="Ridge"
                ImageUrl="~/images/export_excel.jpg" />&nbsp;&nbsp;&nbsp;&nbsp;
            <asp:ImageButton ID="btn_ExportWORD" runat="server"
                OnClick="btn_ExportWORD_Click" BorderColor="#F0A54E"
                BorderStyle="Ridge"
                ImageUrl="~/images/export_word.jpg" />

 Protected Sub btn_ExportEXCEL_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_ExportEXCEL.Click
        ConfigureExport()
        grid_applications.MasterTableView.ExportToExcel()
    End Sub

    Protected Sub btn_ExportWORD_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_ExportWORD.Click
        ConfigureExport()
        grid_applications.MasterTableView.ExportToWord()
    End Sub

    Protected Sub btn_ExportCSV_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btn_ExportCSV.Click
        ConfigureExport()
        grid_applications.MasterTableView.ExportToCSV()
    End Sub


    Public Sub ConfigureExport()

        For x = 2 To 22 'display only columns I want

            grid_applications.MasterTableView.Columns(x).Visible = True

        Next

    End Sub

When I click CSV or WORD it works fine. When i click Excel Export I get:

The RegisterRequiresViewStateEncryption() method needs to be called before or during Page_PreRender.

Line 131:                BorderStyle="Ridge" 
Line 132:                ImageUrl="~/images/export_word.jpg" />        
Line 133:<telerik:RadGrid ID="grid_applications" runat="server" DataSourceID="sqlds_Applications" 
Line 134:        GridLines="None" Width="1100px" AllowFilteringByColumn="True" 
Line 135:        AllowPaging="True" AllowSorting="True" PageSize="30" ShowGroupPanel="True">

[Yavor]

Hi Shawn,

Attached to this message is a small runnable application with the implementation request by you.
Give it a try and see if it works for you.

For additional information about The RegisterRequiresViewStateEncryption() method needs to be called before or during Page_PreRender error, please refer to this forum.

Best wishes,
Yavor
the Telerik team

Instantly find answers to your questions on the new Telerik Support Portal.
Check out the tips for optimizing your support resource searches.

[Majid Darab]

i exactly have the same problem (just for csv - not word or excel)
but the upper answer did not help to get a solution...
i have many radgrids in my pages and they are working perfectly , but i do not know what's the matter about this one ->
i really really do not want to replace it beacause of many works on it
how can i fix this problem?
i am using vs 2008 asp.net web app with c#
thanks a lot

my codes(for export) and my radgrid configuration are correct ...i test them and i finally found the reason of this pro ...
in my radgrid i have three TabStribs (in NestedTemplateView) and in one of them i have a little default vs gridview...
when i remove this gridview problem disappears...
how cani fix this?

[Majid Darab]

is any body home?

[Yavor]

Hi Majid,

The best option in this case would be for you to open a formal support ticket, and send us a small working project, demonstrating your setup, and showing the exception, for additional review and testing.

Kind regards,
Yavor
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.

[Majid Darab]

i do that ....

[Bruno]

Hi

this is Bruno

if youre remove the datakeynames in gridview the error is gone -

http://www.telerik.com/automated-testing-tools/community/forums/aspnet/grid/grid-export-feature-problem.aspx