https://bugs.documentfoundation.org/show_bug.cgi?id=167793
Bug ID: 167793
Summary: Sorting a range with hidden or grouped rows -- messes
up which rows were hidden
Product: LibreOffice
Version: 25.2.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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
--
You are receiving this mail because:
You are the assignee for the bug.
