This is a migrated thread and some comments may be shown as answers.

Inconsistent Behaviour of Spreadsheet

1 Answer 42 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Shridhar
Top achievements
Rank 1
Shridhar asked on 09 Sep 2016, 05:32 AM

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>

 

1 Answer, 1 is accepted

Sort by
0
Ivan Danchev
Telerik team
answered on 13 Sep 2016, 12:32 PM
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
Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Tags
Spreadsheet
Asked by
Shridhar
Top achievements
Rank 1
Answers by
Ivan Danchev
Telerik team
Share this question
or