https://bugs.documentfoundation.org/show_bug.cgi?id=122921
--- Comment #7 from Benjamin Foreman <[email protected]> --- Version: 26.2.5.2 (X86_64) Build ID: 620(Build:2) CPU threads: 6; OS: Linux 7.1; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US 26.2.5-2 Calc: threaded Attribute name Default if not present Observed behaviour Expected behaviour (Microsoft 365) (LibreOffice) sheet 0 objects inherits from sheet Charts cannot be inserted when sheet is protected. Charts can be inserted when objects is zero. formatCells inherits from sheet Cells can be formated regardless of protections. Cells can only be formated if sheet is unprotected or formatCells is zero. formatColumns inherits from sheet Columns cannot be resized when sheet is protected. Columns can be resized when formatCoumns is zero. formatRows inherits from sheet Rows cannot be resized when sheet is protected. Rows can be resized when formatRows is zero. insertColumns inherits from sheet working Colums can be inserted if insertColumns is zero. insertRows inherits from sheet working Rows can be inserted if insertRows is zero. insertHyperlinks inherits from sheet Hyperlinks can be inserted regardless of protections. Hyperlinks can only be inserted if sheet is unprotected or insertHyperlinks is zero. deleteColumns inherits from sheet Columns cannot be deletedoubled when the sheet is protected. Comumns can be deleted when deleteColumns is zero. deleteRows inherits from sheet Rows cannot be deleted when the sheet is protected. Rows can be deleted when deleteColumns is zero. selectLockedCells 0 working Locked cells cannot be sellected when selectLockedCells is one. selectUnlockedCells 0 working Unlocked cells cannot be sellected when selectUnlockedCells is one. pivotTables I don't yet know how to use pivotTables. double sort and autoFilter can be used to disable the Sort and AutoFilter tools. Why? Please don't add them unless they have a real use. -- You are receiving this mail because: You are the assignee for the bug.
