[LO Calc] Sorting protected cells with autofilter?
I have a simple sheet, with cells (and sheet) protected, and with autofilter on the first row. While trying to sort the results in ascending/descending order, I receive the warning "Protected cells cannot be modified" .
What I understand from that is Calc considers changing row order a conflict with cells protection. However, that operation does not change the contents of the cells...
So, my question might actually be: is it possible to reorder protected rows ? (I know I can "unprotect - reorder - protect again", but I am looking for a more simple and elegant solution, that doesn't weight when doing this hundreds of times.)
Where did you take that conclusion from? If cell
A1
has a valueB
and cellA2
has a valueA
and you alpha-sort, thenA1
has valueA
and cellA2
has valueB
after the sort. From my perspective this is a change.Sort doesn't reorder rows but reorders content to new rows according your sort criteria.
And in that sense you put the title of your question wrong. You are asking about Sorting protected cells and not about Autofilter protected cells (which isn't a problem at all)
Ah, you're right! I was considering a column as index for my rows... Now it makes sense. Thank you!
About the title of the question, it is not just a matter of sorting, but sorting while using autofilter.
No - it is only a matter of sorting. Autofilter on protected cells works as usual and it does not matter if you use sort while being in autofilter or if you just sort (the sort causes the protected cells not being reordered since this action would change cell content, while filtering only hides rows [i.e. sets row width to zero], but doesn't change content)
Sorry, maybe I haven't expressed myself well: the autofilter tool, when applied to a cell, adds a dropdown menu, where you can actually filter, but also sort rows. I didn't realize those sorting options do the same operations as the sorting tools (in the toolbars). I thought the autofilter menu ones were different tools, somewhat visual only...