https://bz.apache.org/ooo/show_bug.cgi?id=123703
orcmid <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #12 from orcmid <[email protected]> --- (In reply to j.nitschke from comment #10) > seems this option was only implemented for excel compatibility > > can't find anything in the opendocument specs > > http://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part1. > html#element-table_table > > maybe it's possible to show this option only for excel files > at least put a note in the help The OpenDocument specification does not address user-interface provisions. The implementation of such features would be by entries in a package's settings.xml <office:document-settings> element. This provides implementation-settings that apply to a document. One problem with using settings.xml in this case is that such protection is set at the sheet level, not the document level. The convenient way to handle that would be with an extension that defines a couple of attributes about sheet-level selections in the <table:table> element of the sheet that the options apply to. 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 same is apparently true for LibreOffice. There is no indication about protection in the settings.xml file and the <table:table> element for a protected sheet does have a table:protected="true" attribute but nothing else. 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 .ods. It would be very strange to have this be effective only when saving the document in .xls format. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
