Setting sfSpreadsheet to readonly

[Michael Topf]

Hi,

I need to customize the spreadsheetControl, so that it is readonly (not disabled). 

I have turned off formula bar, and all context menus. I cancel the adding of worksheets via plus sign in the event handler.

What's left is to prevent the renaming of the worksheets via F2 or double click and that the value of the cells can be changed. 

It's required that the user can select cells or ranges, so I can't disable the control.

Any help is appreciated.

Thanks,

Michael

 

[Pannir Selvam S]

Hi Michael, 

Thanks for contacting Syncfusion support. 

You can achieve your requirements by protecting the workbook and worksheets in a workbook. Refer the below help documentation for more information. 

Documentation: http://help.syncfusion.com/wpf/sfspreadsheet/worksheet-management#protection  

And you can disable the context menu in Spreadsheet by setting the AllowCellContextMenu and AllowTabItemContextMenu property of SfSpreadsheet as false. 

Documentation: http://help.syncfusion.com/wpf/sfspreadsheet/interactive-features#context-menu  

Regards, 

Pannir 

[Michael Topf]

Hi,

thanks for your help. Protecting the workbook doesn't seems to have any effect. After protecting I can still change cells and renaming worksheets (double click on worksheet tab).

Iterating through the Worksheet collection of the workbook and protecting each worksheet works, I can't change the content of the worksheet anymore. 

So I still need a way to prevent the renaming of the worksheet tabs. All contextmenus are already disabled.

Thanks,

Michael

[Kanimozhi Bharathi]

Hi Michael,   

  

We were able to reproduce the issue "Renaming of Sheets" in Workbook Protection mode and logged a defect report on this. A support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates.

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents   

   

Regards   

Kanimozhi B