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
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:
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.