I am having an issue exporting data from a Radgrid when using a Radbutton. Even though I disable the AjaxManager from the code behind the Radgrid wound't export the data. However if I click the button a second time the export window opens, but the file doesn't contain any data. Is there some easy work around in order to fix this issue. If I completely remove the AjaxManager the problem is solved, but makes the usage and layout of the site bad.
Here is my code...
ASPX:
<telerik:RadAjaxManager ID="RadAjaxManager1" runat="server" >
<ClientEvents OnRequestStart="RequestStart" OnResponseEnd="ResponseEnd" />
<AjaxSettings>
<telerik:AjaxSetting AjaxControlID="btn_Search">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="RG_DataList" LoadingPanelID="ContentLoadingPanel" />
<telerik:AjaxUpdatedControl ControlID="datePickersBar" />
<telerik:AjaxUpdatedControl ControlID="btn_Export" UpdatePanelRenderMode="Inline" />
</UpdatedControls>
</telerik:AjaxSetting>
<telerik:AjaxSetting AjaxControlID="btn_Export">
<UpdatedControls>
<telerik:AjaxUpdatedControl ControlID="" />
</UpdatedControls>
</telerik:AjaxSetting>
</AjaxSettings>
</telerik:RadAjaxManager>
<div class="datePickers" id="datePickersBar">
<span class="sText">Select period from: </span>
<telerik:RadDatePicker ID="RDP_StartDate" runat="server" Culture="da-DK"
HiddenInputTitleAttibute="Visually hidden input created for functionality purposes."
WrapperTableSummary="Table holding date picker control for selection of dates." >
<Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x" runat="server"></Calendar>
<DateInput DateFormat="dd-MM-yyyy" DisplayDateFormat="dd-MM-yyyy" AutoPostBack="false" LabelWidth="40%" runat="server" ></DateInput>
<DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
</telerik:RadDatePicker>
<span class="sText">to: </span>
<telerik:RadDatePicker ID="RDP_FinishDate" runat="server"
Culture="da-DK"
HiddenInputTitleAttibute="Visually hidden input created for functionality purposes."
WrapperTableSummary="Table holding date picker control for selection of dates." >
<Calendar UseRowHeadersAsSelectors="False" UseColumnHeadersAsSelectors="False" ViewSelectorText="x"></Calendar>
<DateInput DisplayDateFormat="dd-MM-yyyy" DateFormat="dd-MM-yyyy" LabelWidth="40%" ></DateInput>
<DatePopupButton ImageUrl="" HoverImageUrl=""></DatePopupButton>
</telerik:RadDatePicker>
<telerik:RadButton ID="btn_Search" runat="server" Text="Search"
onclick="btn_Search_Click" Skin="Black" >
</telerik:RadButton>
<telerik:RadButton ID="btn_Export" runat="server" Text="Export" Skin="Black"
Enabled="false" Visible="true" onclick="btn_Export_Click"
AutoPostBack="true" >
</telerik:RadButton>
</div>
<div class="content">
<asp:Panel runat="server" ID="Content">
<telerik:RadAjaxLoadingPanel runat="server" ID="ContentLoadingPanel"
IsSticky="True" CssClass="ajaxLoader" MinDisplayTime="500"
EnableSkinTransparency="False" Skin="Black" />
<telerik:RadGrid ID="RG_DataList" runat="server" Skin="Default"
onprerender="RG_DataList_PreRender" >
<MasterTableView >
<CommandItemSettings ShowExportToExcelButton="true"></CommandItemSettings>
</MasterTableView>
<ExportSettings HideStructureColumns="true" ExportOnlyData="true" IgnorePaging="true" OpenInNewWindow="true">
<Excel Format="Biff"></Excel>
</ExportSettings>
<FilterMenu EnableImageSprites="False"></FilterMenu>
</telerik:RadGrid>
</asp:Panel>
</div>
CS:
protected void btn_Search_Click(object sender, EventArgs e)
{
mergeDataTable();
btn_Export.Enabled = true;
}
rotected void btn_Export_Click(object sender, EventArgs e)
{
RadAjaxManager1.EnableAJAX = false;
RG_DataList.ExportSettings.ExportOnlyData = true;
RG_DataList.ExportSettings.IgnorePaging = true;
// RG_DataList.ExportSettings.OpenInNewWindow = true;
RG_DataList.MasterTableView.ExportToExcel();
}
Hallo Collegue, It is possible to export only some columns of RadGrid to excel? thanks, J.Matouš
Hallo Collegue, I wan to create fixex columns in RadGrid, it is possible? It should be similar like excel functionality anchor of traverse. thanks, J.Matouš
HotFix Build: Telerik.Web.UI_2013_1_227_Dev_hotfix RadButton is not responding as the DefaultButton property of a Panel
If a RadWindow contains a RadComboBox, and the RadWindow allows the "Move" behavior, there exists a rendering problem with all major browsers: If the dropdown area of the RadComboBox is expanded during a move operation of the RadWindow, the dropdown area stays behind while the RadComboBox and the RadWindow are moved. Steps to reproduce: 1.) Create a new Telerik C# Web Application 2.) Use the code of the attached Default.aspx file 3.) Run the project and follow the instructions of the Default.aspx page
Since upgrading to Q1 2013, any export to csv file type from RadGrid displays an empty space when a column is empty. It should just be blank.
Provide a RadDateTime control that allows you to only pick the Day of the Week (Sunday - Saturday) rather than simply picking a Date or a Time.
Currently, the RadGrid exports files to Excel using the legacy .xls format/extension. However, all Office documents starting with Office 2007 and later support the .xlsx format. Therefore, the RadGrid should support the ability to export data to either the legacy .xls format or the newer .xlsx format through attribute settings in the RadGrid control.
Provide the ability to clone or duplicate entire rows in the RadGrid control that can then be subsequently used in Insertion operations. This would be particularly useful when bulk editing records in a RadGrid that are very similar to existing records and only differ by a few values.
I'd like to use the Navigation widget in "Horizontal with drop down menus" mode but the "mouse over" mode doesn't work with touch devices (iPad) and the click option is OK but I still want the "Hover" option for non touch devices.
When i set the TextBox width to a percentage value i.e. 100% inside a table cell that has colspan > 1, the TextBox does not expand to fill the table cell. This problem occurs in IE 9 with Telerik ASP.NET AJAX Controls v2013.1.220.40. It works fine in FireFox and Chrome. Attached are the screenshots and a clean sample project (no browser specific code/css).
Steps to reproduce: 1) Create a vertical RadMenu with one item only 2) Hover the item Result: slight displacement
This happens after the first postback. Initially it works correct, but after postback, if you select part of the entered text, and start typing, the caret begins to the begining, and the newly typed char goes at first position.
Column width can be manually set via ExportInfrastructure.Column.Width, however, the width cannot be set to be based on the width of the column's cells' content. An auto-size property on the columns would be very useful for properly formatting the Excel file.
If an image occurs after some text and it is floated, then in Chrome the image properties dialog will have empty field values and no updates can be made to the image. Use the HTML below on the demo page and the issue can be seen. http://demos.telerik.com/aspnet-ajax/editor/examples/overview/defaultcs.aspx Sample content This is some text<img alt="" style="float: right;" src="/aspnet-ajax/Editor/Img/UserDir/Marketing/telerik_125x125_asp.gif" />