

It would be very strange to have this be effective only when saving the document in. This is a definite defect, since there is a way to handle it with ODF although it will not be recognized by software that does not recognize OpenOffice-specific settings in an. There is no indication about protection in the settings.xml file and the element for a protected sheet does have a table:protected="true" attribute but nothing else. The same is apparently true for LibreOffice. Excel Details: Excel Online abides by the fact that its a protected worksheet, and also locks all cells unless unticked in Format Cells > Protection.

I created a sheet with selection not permitted for protected cells and it has no effect when the document is reloaded after being saved. The convenient way to handle that would be with an extension that defines a couple of attributes about sheet-level selections in the element of the sheet that the options apply to. One problem with using settings.xml in this case is that such protection is set at the sheet level, not the document level. This provides implementation-settings that apply to a document. The implementation of such features would be by entries in a package's settings.xml element. The OpenDocument specification does not address user-interface provisions. > maybe it's possible to show this option only for excel files > can't find anything in the opendocument specs > seems this option was only implemented for excel compatibility (In reply to j.nitschke from comment #10)
