<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Calc: Sorting via Autofilter doesn't work if headline row is protected."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=127206">127206</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc: Sorting via Autofilter doesn't work if headline row is protected.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.6.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>Rene.Thol@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>