Bug 150938

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