https://bugs.documentfoundation.org/show_bug.cgi?id=150938
Bug ID: 150938
Summary: CALC creating an auto FILTER produces an illogical
response when the first row label offer is rejected
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When an auto filter is created from the button on the standard ribbon it
advises that the range does not contain column headers and asks whether the
first line should be used as column headers.
If the response is "NO" it still places the selection button with the forst
entry but then it will be sorted and moved with the subsequent sort. Ascending
and descending move the filter button up and down the column but choosing "top
ten" with only ten rows populated disappears everything.
Getting it all back and drag filling a few more rows then pushes the filter
button to the top of the column but attaches it to a different cell.
It's possible to get it back by selecting the entire sheet and invoking the
"show rows" function by right-clicking the row header.
Steps to Reproduce:
in a fresh sheet, Enter something you can autofill at say D1.
Try ONE or JAN as these produce in "chronological" order but will sort
alphabetically.
Drag fill to populate D1:D10
Select D1 and then the autofilter button.
It advises "no label" and suggests the first row.
Say NO and observe that it selects D1 for the filter button
Sort ascending and observe that the button is still attached to the original D1
entry but now in its sorted location.
Sort Descending nd it remains with the original entry
Filter top 10 and observe that the entire array has disappeared
Type address A1 in the address box - No Chance
Select the top left corner "everything", right-click the row header and show
rows.
It returns in order and still with the button attached to the original entry
Drag fill a few more rows and observe that the button has now immediately
changed its allegiance to what was originally the second entry, jumped to the
top of the column, sorted the original 10 entries descending, and left the four
new entries in their dragged locations.
Sort ascending - correct
Select top ten and now fourteen lines have gone on the missing list.
Bring them all back and they are now sorted ascending with the filter button
still on the original D2 which naturally alpha sorts to the bottom of the list
Actual Results:
Defined in the "steps to reproduce" - Scrambled egg is the first thing I could
think of.
Expected Results:
In all honesty I thought it would tell me to stop dicking around and pick a
label as a header but as it selected the top entry I figured that would be
locked in stone in cell D1 and my list would just be the next nine entries.
I never expected it to move the button up and down.
I never expected it to sort only part of the list.
I never expected it to disappear the list of ten
I was amazed when it disappeared the list of 14 as I anticipated that four of
them should have been outside the functioning selection.
I'm still trying to figure out who asked for the sort ascending as it wasn't
me.
I can't imagine how is managed to relocate the filter button to the D2 entry in
the first place
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:
Version: 7.3.5.2 (x64) / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
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.
