Telerik Spreadsheet - Access History Feature

[Karthik]

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.

[Marin Bratanov]

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

[Karthik]

Hi Marin,

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