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

Disable editing in spreadsheet

3 Answers 95 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Ishita
Top achievements
Rank 1
Ishita asked on 01 May 2014, 11:39 AM
Hi,
      I want to disable editing in my spreadsheet but it should allow to change sheets.(If i set IsEnable = false, it does not allow me to change the sheet.).

Thanks in advance :)

3 Answers, 1 is accepted

Sort by
0
Accepted
Svetoslav
Telerik team
answered on 06 May 2014, 07:03 AM
Hello Ishita,

Thank you for contacting us.

If you would like to prevent the user from modifying the contents of sheets, you can use worksheet protection. You will be able to find information about the feature in the Worksheet Protection article in our online documentation. Additionally, if you do not want to allow the user to add, remove and rename sheets, you can use workbook protection.

When the user attempts to change the value of a protected cell, a warning message pops up. If you would like to get rid of that message, you need to download the latest LIB where the RadSpreadsheet class contains a MessageShowing event. This event allows you to modify or suppress all messages displayed to the user. The following snippet hides only alerts related to protection:
01.private void RadSpreadsheet_MessageShowing(object sender, MessageShowingEventArgs e)
02.{
03.    string protectionError = LocalizationManager.GetString("Spreadsheet_ProtectedWorksheet_Error");
04.  
05.    if (e.Content.Equals(protectionError, StringComparison.CurrentCulture))
06.    {
07.        e.IsHandled = true;
08.    }
09.}

I hope you find my answer useful. Let me know if you have further questions.

Regards,
Svetoslav
Telerik
 
Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
 
0
vinutha
Top achievements
Rank 1
answered on 29 Dec 2016, 05:40 AM

hi,

the above link what u have given for workbook and worksheet protection are not working

0
Boby
Telerik team
answered on 29 Dec 2016, 07:06 AM
Hi vinutha,

Thanks for letting us know. The new links are the following:
Worksheet Protection
Workbook Protection

Regards,
Boby
Telerik by Progress
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.
Tags
Spreadsheet
Asked by
Ishita
Top achievements
Rank 1
Answers by
Svetoslav
Telerik team
vinutha
Top achievements
Rank 1
Boby
Telerik team
Share this question
or