DevExpress Spreadsheet - Option to suppress exception message The cell that you are trying to change is protected and therefore read-only.

[Fons N 17]

DevExpress Spreadsheet. Is there an option to suppress the exception message "The cell that you are trying to change is protected and therefore read-only." ?

 

Or even better, that it does not occur at all. I can "catch" the exception, but I prefer that is does not occur at all. 

 

In WinForms there is the SpreadsheetControl.ProtectionWarning event, but this does not exist in de VCL version.

 

I have a central exception handler in my application using the ApplicationEvents component. I can detect this exception there, but - again - it would be better it does not occur at all. As far as I can tell, there is no way I can catch the exception locally in code because the exception is triggered by the user.

 

Hope someone has a solution.

 

 

[Anders Melander 1815]

The DevExpress support groups would be a good place to search for/ask this question.

https://supportcenter.devexpress.com/ticket/details/t545652/error-editing-protected-spreadsheet

https://supportcenter.devexpress.com/ticket/details/t745921/what-is-the-best-way-for-have-a-spreadsheet-in-readonly-mode

 

FWIW, I think the response given by DevExpress is BS; IMO using an exception to display a message to the end user is an extremely poor solution. This behavior should at least be optional - But good luck getting them to change it.

Edited November 20, 2022 by Anders Melander