Description: Hi everybody, first of all thanks to all of you contributing to LibreOffice! It is a really great piece of software, even more if considered that it is available for free! Now my problem: When I protect some cells/rows, including headers where autofilters are set only leaving all cells/rows below unprotected I cannot use the sorting provided by autofilters and get a message "Protected cells cannot be changed." IMO this is strange since the headers which include the autofilfters won't be included into the sorting anyway. So why can't I use the autofilter sorting while leaving according header cells protected (filtering works BTW)? Thank you for some insights - would be great if this could be changed! Bye Steps to Reproduce: 1. Protect cells including headers with autofilters set but nothing below them 2. Enter some values within the rows below 3. Try sorting these values using the sort capability of autofilters Actual Results: Message occurs telling that protected cells cannot be changed. Expected Results: all lines below headers (with autofilters set) get sorted Reproducible: Always User Profile Reset: Yes Additional Info: Version: 6.2.6.2 (x64) Build-ID: 684e730861356e74889dfe6dbddd3562aae2e6ad CPU-Threads: 8; BS: Windows 10.0; UI-Render: GL; VCL: win; Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE Calc: threaded
Created attachment 153716 [details] Testfile reproducing the impossible sorting if headers are protected Testfile for reproducing the sorting problem. Filtering works BTW.
*** This bug has been marked as a duplicate of bug 119804 ***