[Libreoffice-bugs] [Bug 127206] New: Calc: Sorting via Autofilter doesn't work if headline row is protected.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=127206

            Bug ID: 127206
           Summary: Calc: Sorting via Autofilter doesn't work if headline
                    row is protected.
           Product: LibreOffice
           Version: 6.2.6.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Rene.Thol at gmx.de

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190828/e2f153b8/attachment.html>