Sorting does not work inside hidden rows

[vic]

steps to reproduce:
1. In range A1:A10, create list 1..10
2. Hide rows 3-5 (context menu, Hide)
3. Select the range and sort Descending
4. Unhide the rows

Result: the hidden rows ' content is original,not sorted.

expected: to change the content, per sorting order

[SuperTech]

Result: the hidden rows ' content is original,not sorted.

Since these cells were hidden, they should not be affected by the sort operation. This is the expected behavior in this scenario.

The sorting function is designed to only rearrange visible cells while maintaining the position and integrity of any hidden rows or columns.

[vic]

Hello SuperTech,
thanks for the reply.
How about allowing sorting inside Grouped (outline) rows and collapsed (hidden details)?

The motivation is that sometimes you have too many rows (or columns) of same kind and it's more convenient to work with them in grouped form, for example sort them, and thus you do want sorting to work inside the collapsed group.

[SuperTech]

In that case, it will be wrong to sort hidden values.