https://bugs.documentfoundation.org/show_bug.cgi?id=145995
Bug ID: 145995
Summary: Defined DATA ranges merge destructively if cells
seperating them are inadvertantly filled.
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When two (or more) arrays are converted to Database ranges and those ranges are
indexed with autofilters, then; if the user inadvertently enters data into the
unbounded rows between the db ranges - thereby bridging the gap between the two
ranges - those ranges become merged and any autofilter action will prove
destructive to the entire structure.
Even such an insignificant action as selecting the autofilter button will cause
the destruction.
The range definitions will be amended to show the first range encompassing the
area for both ranges and the second range "appears" to have its own boundaries.
This is however an illusion. Any attempts to redefine the boundaries of the
first range may appear to have been successful but the damage has already been
done. The amendment will have zero impact and further inspection will
demonstrate that the second range is still subsumed by the first range with the
definitions showing the erroneous structure, not the amendments.
The test file attached will even demonstrate that undoing all the actions that
created the bond, doesn't revert the file to two ranges.
It is possible to remediate by manually selecting the second range and moving
it to a location outside the "global range". At this point, the definition for
the second range will probably disappear. The first range can be redefined to
the original parameters and the second range can be moved back to the original
location. The surplus lines in the first range can simply be deleted or the
definition can be amended as there is no data in the extension.
In my experience, the ranges may lose their integrity so it's wise to actually
delete the definitions and start afresh.
The symptoms I have observed when the ranges are first separated are:-
One range definition may actually disappear
The autofilter buttons may still be present but inoperative
Steps to Reproduce:
With the attached file
Observe the db range definitions MENU>Data>Define Range - select each range and
confirm
Select the autofilter at B3 and observe it only indicates the first range
Repeat at B12
Enter data at B10 and select the autofilter at B3 to verify
Enter data at B11 and select the autofilter at B3 to verify
Observe the data now includes all of the second array
Try deleting the data in B10:B11
Observe that autofilter B3 still includes the second array
Try editing the definitions to repair the array and observe the futility.
Try saving, closing, opening and then autofilter B3 - still corrupt.
Select B12:E18 and relocate the array to H25
verify the extent of the first array and either edit the definition or simply
delete the rows until the definition only encompasses B3:E9
Select the second array and relocate to its original location.
The probability is that you will need to redefine the autofilter for at least
one array
Both ranges should now perform as expected
Actual Results:
Two arrays destructively merged into one
Expected Results:
Discrete arrays
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
Version: 7.2.2.2 (x64) / LibreOffice Community
Build ID: 02b2acce88a210515b4a5bb2e46cbfb63fe97d56
CPU threads: 4; OS: Windows 10.0 Build 19043; 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.
