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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
