https://bugs.documentfoundation.org/show_bug.cgi?id=167148
Bug ID: 167148
Summary: UNO API of sheet protection XProtectable must consider
loext:table-protection attributes
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The introduction of new loext:table-protection attributes to the ODS format in:
https://bugs.documentfoundation.org/show_bug.cgi?id=147034 1
Does not seem to have considered also modifying the oSheet.protect() method to
pass additional parameters.
The attributes are set in context.xml:
<table:table table:name=“Sheet1” table:style-name=“ta1”
table:protected=“true”><loext:table-protection
loext:select-protected-cells=“true” loext:select-unprotected-cells=“true”
loext:insert-rows=“true” loext:use-autofilter=“true”/>
The new attributes are causing a serious regression of functionality since now
the default behavior of sheets with autofilter is to disable the use of filters
when the sheet is protected.
In our case, we have dozens of spreadsheets that rely in autofilter that are
now suddenly disabled because we protect them prior to passing to users.
The UNO API of sheet protection (com.sun.star.util.XProtectable interface)
should consider passing the new loext attributes to restore functionality.
--
You are receiving this mail because:
You are the assignee for the bug.