Description:
LibreOffice Calc doesn't export well Excel made spreadsheets with AutoFilters and empty cells:
– The AutoFilter button is lost when only the rows with empty cells are visible and everything else is hidden – the filter itself is still active, and the settings can be still checked or changed from the Standard Filter window (Data – Standard filter), but the button itself is gone.
– The blue marking from the AutoFilter button is lost when only rows empty cells are hidden – but the button itself is still visible. Clicking on the button tells that all values are shown (including empty values), which is not true – turning off and on again the filtering of empty cells fixes the issue.

Note, that there are two different symptoms, depending on whether only empty values are shown or hidden, they are most likely caused by the same bug related to the handling of empty values in filters.

Additional details regarding the issue:
The issue only arises as described above if the filter was added in Microsoft Excel and the spreadsheet was saved as XLSX and reloaded with LibreOffice Calc. Calc made filters work better with empty values, even when saved as XLSX and reloaded multiple times, but still aren't perfect: while the button and the blue marking are preserved, clicking on the button shows everything – including the (empty) value – unchecked. So, handling of empty values in filters in XLSX files are broken in general.

Steps to Reproduce:
    1. Create a new spreadsheet in Microsoft Excel;
    2. Add some well filterable values to the first columns of the first 10 rows – make sure that you leave some cells empty;
    3. Turn on the autofilter for the first column, and hide everything except the empty cells;
    4. Save the file as XLSX and close MS Excel;
    5. Open the XLSX file in LibreOffice Calc, then save and reload it;

Actual Results:
The button for the AutoFilter is lost;

Expected Results:
The button for the AutoFilter should be preserved;


Reproducible: Always


User Profile Reset: No



Additional Info: