Inconsistent Behaviour of Spreadsheet

[Shridhar]

Hi,

 

I am currently evaluating Telerik Controls for our next project.

I wish to use spreadsheet for holding data before i paste it into telerik grid.

I have observed that it does not behave as it does in the demo. The keyboard movement is not very smooth and pasting data from excel into it either does not happen at all or happens very late.

Below is the code I have used in aspx file and nothing in cs file. Let me know if i am doing something wrong.

 <telerik:RadScriptManager ID="RadScriptManager1" runat="server"></telerik:RadScriptManager>

             <div id="divSheet">
           
                <telerik:RadSpreadsheet ID="RadSpreadsheet1" runat="server"></telerik:RadSpreadsheet>
           

        </div>

 

[Ivan Danchev]

Hello Shridhar,

This is a known issue that we logged last month. Until an official fix is available you can avoid the Spreadsheet becoming irresponsive by using a provider as shown in our demos.

public partial class Default : System.Web.UI.Page
{
    private const string ProviderSessionKey = "Telerik.Web.Examples.SpreadSheet.Overview.DefaultCS";

    protected void Page_Init(object sender, EventArgs e)
    {
        SpreadsheetDocumentProvider provider;

        if ((Session[ProviderSessionKey] == null) || (!IsPostBack))
        {
            provider = new SpreadsheetDocumentProvider(Server.MapPath("~/App_Data/Spreadsheet-OverviewDemo.xlsx"));
            Session[ProviderSessionKey] = provider;
        }
        else
        {
            provider = (SpreadsheetDocumentProvider)Session[ProviderSessionKey];
        }

        RadSpreadsheet1.Provider = provider;
    }
}

Regards,
Ivan Danchev
Telerik by Progress