GNOME Bugzilla – Bug 637509
Provide complete protection interface
Last modified: 2018-05-22 13:41:14 UTC
xls and xlsx files do not just carry a "protected" flag for each sheet but also much more fine grained flags that allow what can or cannot be done with protected sheets: PROP_PROTECTED, PROP_PROTECTED_ALLOW_EDIT_OBJECTS, PROP_PROTECTED_ALLOW_EDIT_SCENARIOS, PROP_PROTECTED_ALLOW_CELL_FORMATTING, PROP_PROTECTED_ALLOW_COLUMN_FORMATTING, PROP_PROTECTED_ALLOW_ROW_FORMATTING, PROP_PROTECTED_ALLOW_INSERT_COLUMNS, PROP_PROTECTED_ALLOW_INSERT_ROWS, PROP_PROTECTED_ALLOW_INSERT_HYPERLINKS, PROP_PROTECTED_ALLOW_DELETE_COLUMNS, PROP_PROTECTED_ALLOW_DELETE_ROWS, PROP_PROTECTED_ALLOW_SELECT_LOCKED_CELLS, PROP_PROTECTED_ALLOW_SORT_RANGES, PROP_PROTECTED_ALLOW_EDIT_AUTO_FILTERS, PROP_PROTECTED_ALLOW_EDIT_PIVOTTABLE, PROP_PROTECTED_ALLOW_SELECT_UNLOCKED_CELLS, Gnumeric imports these flags from those files (and exports them to those files.) Gnumeric also obeys some (or all?) of those flags. We need an interface to clear or set those flags.
Note that this was inspired by bug 637451. That bug report also contains a sample xls file with some of those flags set differently from Gnumeric default.
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/GNOME/gnumeric/issues/151.