Telerik Spreadsheet - Access History Feature

3 posts, 0 answers
  1. Karthik
    Karthik avatar
    10 posts
    Member since:
    Nov 2011

    Posted 06 Sep 2017 Link to this post

    I have embed a telerik spreadsheet control in one of my classic asp.net page. The spreadsheet is being loaded with contents of a xlsx spreadsheet. I am using a custom data provider to load the data from the spreadsheet into the Telerik Spreadsheet Control. Below is my code for custom data provider.

    namespace SpreadsheetDemo
        {
            public partial class Spreadsheet : Page
            {
                private const string ProviderSessionKey = "Demo";
         
                protected void Page_Load(object sender, EventArgs e)
                {
                    SpreadsheetDocumentProvider provider;
                    if (Session[ProviderSessionKey] == null || !IsPostBack)
                    {
                        provider = new SpreadsheetDocumentProvider(Server.MapPath("~/App_Data/Visit_Tracker.xlsx"));
                        Session[ProviderSessionKey] = provider;
                    }
                    else
                    {
                        provider = (SpreadsheetDocumentProvider) Session[ProviderSessionKey];
                    }
         
                    rdSpreadsheet1.Provider = provider;
                     
                }
            }
        }

     

    I am able to perform all the operations how ever I want to enable the "History" feature that is available for the workbook class.

    I have added the namespace

    using Telerik.Windows.Documents.Spreadsheet.History;

    in my solution however I am not able to access the History object for the spreadsheet control "rdSpreadsheet1"

    Can anyone please let me know how to access the history feature for the spreadsheet control.

  2. Marin Bratanov
    Admin
    Marin Bratanov avatar
    4231 posts

    Posted 12 Sep 2017 Link to this post

    Hi Karthik,

    RadSpreadSheet offers undo/redo features only in the browser (you can see how this works in our demos).

    The History feature of a Workbook is implemented for the underlying class in the Telerik Document Processing: http://docs.telerik.com/devtools/document-processing/libraries/radspreadprocessing/features/history. This is a separate context from the user interface and the Workbook classes are different.

    The class exposed by the Document Processing Library is used in the server code to generate documents, while RadSpreadSheet uses its own Workbooks class in its providers that resides in the Telerik.Web.Spreadsheet assembly, and this class does not implement the History feature.

    For such an integration to exist, the users actions must be sent to the server immediately where History is to be used, the workbook object stored in memory and then further requests from the browser would need to request this state. So far such integration is available in RadSpreadsheet for UI WPF/Silverlight.

    If you would like to see such integration in the UI for ASP.NET AJAX suite I encourage you to add your featuire request in our portal, together with a detailed description of how you expect this to be exposed for use: https://feedback.telerik.com/project/108/Feedback/List/Feature%20Request. This will allow the community to vote and comment on the idea, and, in turn, our management to evaluate its popularity and impact.

    Regards,

    Marin Bratanov
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Karthik
    Karthik avatar
    10 posts
    Member since:
    Nov 2011

    Posted 12 Sep 2017 in reply to Marin Bratanov Link to this post

    Hi Marin,

    Thanks for the reply. I will add my requirement in the feature request as mentioned by you.

Back to Top