Bug 127206 - Calc: Sorting via Autofilter doesn't work if headline row is protected.
Summary: Calc: Sorting via Autofilter doesn't work if headline row is protected.
Status: RESOLVED DUPLICATE of bug 119804
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.6.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-08-28 17:43 UTC by Rene.Thol
Modified: 2019-08-28 18:24 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Testfile reproducing the impossible sorting if headers are protected (9.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-08-28 17:45 UTC, Rene.Thol
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rene.Thol 2019-08-28 17:43:45 UTC
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
Comment 1 Rene.Thol 2019-08-28 17:45:45 UTC
Created attachment 153716 [details]
Testfile reproducing the impossible sorting if headers are protected

Testfile for reproducing the sorting problem. Filtering works BTW.
Comment 2 Mike Kaganski 2019-08-28 18:24:38 UTC

*** This bug has been marked as a duplicate of bug 119804 ***