Need Help with TELERIK radgrid export to excel issue. Anyone who can help with the below mentioned issue please reply. 

So In the application we are using Telerik radGrid to display data table in a dynamic grid view. We are trying to export radgrid item to the excel sheet. 
the below mentioned code snippet is working fine when the function is getting call from a single web page. 



protected void RadCxtMenu_ItemClick(object sender, Telerik.Web.UI.RadMenuEventArgs e)
{

if (e.Item.Text == "Export to Word")
{


radGridItem.ExportSettings.ExportOnlyData = true;
radGridItem.ExportSettings.IgnorePaging = true;
radGridItem.ExportSettings.OpenInNewWindow = true;
radGridItem.MasterTableView.ExportToWord();

}
else if (e.Item.Text == "Export to Excel")
{

ExportClick();
radGridItem.ExportSettings.ExportOnlyData = true;
radGridItem.ExportSettings.IgnorePaging = true;
radGridItem.ExportSettings.OpenInNewWindow = true;
radGridItem.MasterTableView.ExportToExcel();



}

but the above code is not working when it is reffered from a rad multi page and rad tab.
The issue that we are facing is, the parent page where the rad multi page redirection is used to redirect to a different page where the grid view is used to display the data .we could not download the data to a excel file with the export to excel rad manu item click. The popup which should be displayed in the browser for the user to select and save the excel file is not getting displayed and the excel can not be saved. We are not sure if this is a telerik related constrain can any one advise. the code snippet or the rad multi page is given below.


protected System.Web.UI.WebControls.Label lblPageHeader;
protected Telerik.Web.UI.RadTabStrip uwtConsolidation;
protected Telerik.Web.UI.RadMultiPage RadMultiPage1;
public const string SELECTED_CONSOLIDATION_TAB = "SelectedConsolidationTab";
public static readonly string QUERY_FLAG = "FLAG";
public static readonly string QUERY_SERVICE ="NodeType";


if (!Page.IsPostBack)
{
RadPageView ConsolidatedEquipmentItemTab = new RadPageView();
RadPageView PlantHistoryTab = new RadPageView();
RadPageView IssueRegisterTab = new RadPageView();
ConsolidatedEquipmentItemTab.ContentUrl = "ConsolidatedEquipmentItem.aspx";
PlantHistoryTab.ContentUrl = "PlantHistory.aspx";
IssueRegisterTab.ContentUrl = "IssueRegister.aspx"; // This is the page that contains the grid where export is not working
//ConsolidatedEquipmentItemTab.Selected = true;

RadMultiPage1.PageViews.Add(ConsolidatedEquipmentItemTab);
RadMultiPage1.PageViews.Add(PlantHistoryTab);
RadMultiPage1.PageViews.Add(IssueRegisterTab);



switch (selectedTab)
{

case 0: ConsolidatedEquipmentItemTab.Selected = true; break;
case 1: PlantHistoryTab.Selected = true; break;
case 2: IssueRegisterTab.Selected = true; break;
default: ConsolidatedEquipmentItemTab.Selected = true; break;


}
}

if (Session[SELECTED_CONSOLIDATION_TAB] != null)
uwtConsolidation.SelectedIndex = selectedTab;


}

Please advise. We appreciate your help.

Hi

I am working with Radgrid which has columns like -

-->Name            Unit/Currency            Jan 11        Feb 11    Mar 11    Apr 11    .....     Dec 11        Total_of _12_months

Now I want horizontal scroll but columns; Name , Unit/Currency and Total_of _12_months to be fixed. So i am looking for 2 columns on left of grid and one column on right side of grid to be fixed. is there a way to achieve in Radgrid with existing features? How to achieve tht?

Thanks,
Pradip

Team Telerik,

I've encountered what appears to be a bug with the RadMaskedTextBox.set_value() method in ASPNet UI 2015.1.401.45

When called, the RadMaskedTextbox doesn't reflect the new value until you mouse click into the field.

Work Around:

Call RadMaskedTextbox.focus() immediately after RadMaskedTextbox.set_value(). It's a little tacky, but it works.

Can you guys fix this for 2015 Q2? That'd be great. Thanks.

- Jonathan

I tried the following client-side code without success. If the node has no image, you can successfully set  the node to point to an image but you cannot remove the image after that. In other words, the following does not change anything, the current image remains assigned:

node.set_imageUrl(null);
node.set_expandedImageUrl(null);

Setting the value to an empty string (instead of null) does not work either. Any suggestions?

Thanks,
Nuri

Hi There,

I am using the Bootstrap skin and want a 'pure' white background for the menu (and other controls).

But the skin is semi transparent.  I've tried a plain hack of the css to remove the transparency settings but that seems to have little effect.

Any pointers on how to get rid of the transparency would be appreciated.

 

Thanks

Craig

I try to import dynamic import of a excel into the spreadsheet for the droopdown selected index changed but i could not able to upload this one successfully

here my code

<script>

    $("#spreadsheet").kendoSpreadsheet({
        excel: {
            // Required to enable Excel Export in some browsers
            proxyURL: "https://demos.telerik.com/kendo-ui/service/export"
        }
    });
    var data = [
                       { text: "Spreed sheet 1", value: "1" },
                       { text: "Spreed sheet 2", value: "2" },
                       { text: "Spreed sheet 3", value: "3" }
    ];
    function onOpen() {
        //kendoConsole.log("event: open");
    };

    function onClose() {
        //  kendoConsole.log("event: close");
    };

    function onChange() {
        //kendoConsole.log("event: change");
    };
    function onDataBound(e) {
        //if ("kendoConsole" in window) {
        //   kendoConsole.log("event :: dataBound");
        //}
    };

    function onFiltering(e) {
        // if ("kendoConsole" in window) {
        //  kendoConsole.log("event :: filtering");
        //}
    }
    var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
    
    //var sheet = spreadsheet.activeSheet();
    //sheet.setDataSource(data1);
    function onSelect(e) {
        //if ("kendoConsole" in window) {
        if (e.item) {
            alert();
                return $.ajax({
                    method: "GET",
                    url: "ExcelToJson",// the return json will be var data1 = [
  {
      "a": 1.0,
      "b": 2.0,
      "c": 3.0
  }
    ]
                }).then(function (data) {
                    if (data.success == false) {
                        //ConfirmMessage.showErrorMessage(data.messages[0]);
                        return new $.Deferred().reject().promise();
                    } else {
                        console.log(data);
                       //$("#spreadsheet").html("");
                       //$("#spreadsheet").kendoSpreadsheet();
                       //var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
                       //var sheet = spreadsheet.activeSheet();
                       var data_new = data;
                        // alert(data_new);
                       spreadsheet.fromJSON(data_new);
                      //  sheet.setDataSource(data_new);
                    }
                });
           
            //$.ajax({
            //    url: "ExcelToJson",
            //    cache: false,
            //    type: "POST",
            //    success: function (html) {
            //        $("#spreadsheet").kendoSpreadsheet();
            //        var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
            //        var sheet = spreadsheet.activeSheet();
            //        sheet.setDataSource(data);
            //    }
            //});
        }
    };

    $("#dropdownlist").kendoDropDownList({
        dataTextField: "text",
        dataValueField: "value",
        dataSource: data,
        filter: "startswith",
        select: onSelect,
        //change: onChange,
        //close: onClose,
        open: onOpen,
        filtering: onFiltering,
        dataBound: onDataBound
    });


    
</script>

Hi...

I have problem.

TimeFormat am / pm is not showing up.

Correto seria 12:00 pm

I have a RadCombobox on my page as follows:

  <telerik:RadComboBox ID="cboBenchmarkCompanies" runat="server" 
                                                     CheckBoxes="true" 
                                                     DataTextField="Value"
                                                     DataValueField="Key"
                                                     EnableLoadOnDemand="False"
                                                     OnClientItemChecking="CheckMaxBenchmarkCompanies"
                                                     meta:resourcekey="cboBenchmarkCompanies" />

I load the list in the onload with:
            if (!this.IsPostBack) {
                var allCompanies = _applicationUserRepository.GetAllSurveyUsers();
                cboBenchmarkCompanies.DataSource = allCompanies;
                cboBenchmarkCompanies.DataBind(); }

If i then try to retrieve the checked items after pressing a save button, i always get back an empty collection instead of my checked items:
foreach (var checkedItem in cboBenchmarkCompanies.CheckedItems ){

What am I doing wrong?

I know I can move / re-order a column around on a grid.  I have a requirement where I need to be able to move a GridColumnGroup as well.  I don't see this is possible out of the box.  Has anybody had any luck with a work-around to allow a GridColumnGroup to be moved / re-ordered?

 

Thanks!

I have a RadGrid bound to a ClientDataSource, but when no records are returned, the grid's NoRecordsTemplate does not display (it's just an empty grid).  I've tried various workarounds without any success.  I've tried setting the grid's datasource to an empty array in the RadClientDataSource OnDataParse event.  I've tried explicitly setting EnableNoRecordsTemplate = "true", and I've tried setting NoMasterRecordsText in the MasterTableView, but nothing seems to work.

Any idea what I could be missing?