Description:
see STR below

Steps to Reproduce:
I present in parallel what happends with Grouping (F12) and Hiding (from context menu) . 

1.In range A1:A10 create list 1,2,..10. 
Also in range A12:A21 create same list.

2. In first range, Group (F12) rows 3-5. 
In second range Hide rows 14-16.

3. Select first range and sort Descending. 
Do same for 2nd range

3. Pay attention to which rows are now hidden. Try unhide/uncollapse.

Actual Results:
In first range (by Grouping):
there is a "+" sign but the rows 3-5 do not look collapsed there. Instead there is an extra range of rows hidden:6-8.
If click the "+" then the "-", rows 3-8 are hidden.

In second range (by Hiding):
now rows 17-19 are hidden, not the original 14-16

Expected Results:
For both Grouping and Hiding: sorting should not affect which rows were set to group/hide (except that properly change the content inside, as per sorting order). 


Reproducible: Always


User Profile Reset: No

Additional Info:
Version: 25.2.5.2 (X86_64) / LibreOffice Community
Build ID: 03d19516eb2e1dd5d4ccd751a0d6f35f35e08022
CPU threads: 2; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded