https://bugs.documentfoundation.org/show_bug.cgi?id=123353
Bug ID: 123353
Summary: FILESAVE XLSX AutoFilter button lost when exporting MS
Excel created XLSX files if only empty cells are set
to visible
Product: LibreOffice
Version: 6.3.0.0.alpha0+ Master
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: libreoff...@nisz.hu
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:
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs