https://bugs.documentfoundation.org/show_bug.cgi?id=160018
Bug ID: 160018
Summary: Defined Ranges in a single column with delimiting row
corrupted by 7.6.5
Product: LibreOffice
Version: 7.6.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Defined ranges with auto filters and a delimiting "Blank Row" between the
ranges has been corrupted by 7.6.5
Instead of the previous practice which permitted each individual range to sort
independantly of the ranges below, it now just consolidates everything in the
first column's filter and produces a "shotgun sort"
Steps to Reproduce:
You will need the attached sheet to be OPENED in 7.6.5 and then experiment with
hiding and revealing the data groups to experience the correct operation
Then open it in 7.5.9.2 and just try to sort the first Defined Range on the
first column's sort.
note: THE PINK FILLED CELL DEFINES THE ROW THAT IS NOT INCLUDED IN THE DEFINED
RANGE DEFINITION AND HAS ALSO BEEN PROTECTED. THIS WAS THE ONLY WORKAROUND FROM
A PREVIOUSLY REPORTED BUG WHERE DEFINED RANGES WOULD OVERFLOW INTO EACH OTHER.
Then "undo" the damage and try sorting on any of the other columns.
If you enjoy the same experience as I did the corruption will only occur with
the first column's sort.
Confession: I didn't experiment with opening any of the other defined ranges to
see if it was only impacted on the first "group" because it was so destructive
I needed to uninstall 7.6.5 and reinstal the earlier version before I could
proceed with my workload.
Actual Results:
I'm not prepared to use profanities - the impact will be obvious the moment you
sort the first group
Expected Results:
Conventional sorting of defined ranges as previously enjoyed yesterday
Reproducible: Always
User Profile Reset: No
Additional Info:
Additional Info: THIS IS THE CORRUPT VERSION
Version: 7.6.5.2 (X86_64) / LibreOffice Community
Build ID: 38d5f62f85355c192ef5f1dd47c5c0c0c6d6598b
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
AND THIS IS THE VERSION OF THE ATTACHED SAMPLE FILE
Version: 7.5.9.2 (X86_64) / LibreOffice Community
Build ID: cdeefe45c17511d326101eed8008ac4092f278a9
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: sv-SE (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
