Ask Your Question
0

[LO Calc] Sorting protected cells with autofilter?

asked 2020-07-15 22:35:24 +0200

Phoinx gravatar image

updated 2020-07-20 10:01:37 +0200

Alex Kemp gravatar image

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.)

image description

edit retag flag offensive close merge delete

Comments

While trying to sort the results in ascending/descending order, I receive the warning "Protected cells cannot be modified" ... However, that operation does not change the contents of the cells...

Where did you take that conclusion from? If cell A1 has a value B and cell A2 has a value A and you alpha-sort, then A1 has value A and cell A2 has value B after the sort. From my perspective this is a change.


is it possible to reorder protected rows ?

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)

Opaque gravatar imageOpaque ( 2020-07-15 22:51:39 +0200 )edit

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.

Phoinx gravatar imagePhoinx ( 2020-07-15 23:14:18 +0200 )edit

it is not just a matter of sorting, but sorting while using autofilte

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)

Opaque gravatar imageOpaque ( 2020-07-15 23:24:11 +0200 )edit

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...

Phoinx gravatar imagePhoinx ( 2020-07-16 14:17:58 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2020-07-16 14:22:47 +0200

Phoinx gravatar image

updated 2020-07-16 14:24:00 +0200

It is not possible to sort / reorder protected rows, because by doing that the cells would change their contents (example: the value at cell A1 - that is, column A, row 1 - would be moved to another row).

(Also, the sorting options in the autofilter menu do the same that the sorting tools in the toolbars.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2020-07-15 22:35:24 +0200

Seen: 30 times

Last updated: Jul 16