https://bugs.documentfoundation.org/show_bug.cgi?id=157689
Bug ID: 157689
Summary: XLSX Autofilter bug; all sheets contain autoFilter XML
specs, but only the last sheet presents the filters
Product: LibreOffice
Version: 7.3.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
FOSS software 'openxlsx' produces an XLSX workbook with non-table filters. The
XML within the output file defines the autoFilter XML tag correctly in each
spreadsheet, e.g. <autoFilter ref="A1:E11"/>. However, when the file is opened
with Libreoffice Calc, only the last sheet presents the filters. (The filters
present correctly when opened with Excel.)
Steps to Reproduce:
1. Open the attachment.
2. Click "Sheet 1", to observe that it contains no filters.
3. Click "Sheet 2", to observe that it contains filters.
4. Review the XML in "/xl/worksheets/" for "Sheet1" and "Sheet2", and note that
the files are nearly identical.
Actual Results:
Sheet 1 has no filters, but Sheet 2 has filters. (See the uploaded workbook.)
Expected Results:
Both Sheet 1 and Sheet 2 should have filters. (See the uploaded workbook.)
Reproducible: Always
User Profile Reset: No
Additional Info:
Tested on Ubuntu running Libreoffice 7.3, and on Windows running Libreoffice
7.6. I've also opened the file with MS Office Excel, which shows both sheets
with auto filters. This bug occurs when there is more than one sheet. If 4
sheets, the first 3 will have no filters. (Also, it does not matter if the
files contain identical data. The corresponding workbook contains identical
data in each sheet for clarity.) Also, I love LibreOffice; thank you for making
a great product.
--
You are receiving this mail because:
You are the assignee for the bug.
