Prevent selection outside of rendered cells

[Remy]

Dear Syncfusion Team,

I am trying to prevent the cell selection (with the mouse) outside of the rendered cells (or a defined range). However, I don't seem to able to achieve the desired behaviour.

Is there any way around this?

Desired behaviour :

Actual behaviour :

Here is a sample to demonstrate the issue :

https://stackblitz.com/edit/angular-jhtxqp?file=app.component.html

Thank you,

Remy

[Sangeetha Priya Murugan]

Hi Remy, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported requirement and we suspect that you need to select only the unlocked cells only from the locked range (Protected sheet) in the spreadsheet. If, yes we have already considered this as an improvement in our end. For more details, please refer the below link. 

 

https://www.syncfusion.com/feedback/21308/need-to-skip-the-selection-for-locked-cells 

 

Could you please check the above details and get back to us, if you need any further assistance on this. 

 

Regards, 

Sangeetha M