Bug 169364 - FILESAVE XLSX Autofilter in merged cells is shown in all columns in Excel
Summary: FILESAVE XLSX Autofilter in merged cells is shown in all columns in Excel
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: QA:needsComment
Keywords:
Depends on:
Blocks: XLSX-Autofilter
  Show dependency treegraph
 
Reported: 2025-11-10 08:38 UTC by Gabor Kelemen (Collabora)
Modified: 2025-11-25 15:50 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
The example file saved in master as XLSX (6.95 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-11-10 08:38 UTC, Gabor Kelemen (Collabora)
Details
The original and roundtripped files in Excel 2016 (49.85 KB, image/png)
2025-11-10 08:38 UTC, Gabor Kelemen (Collabora)
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Gabor Kelemen (Collabora) 2025-11-10 08:38:02 UTC
Created attachment 203846 [details]
The example file saved in master as XLSX

This is a followup to bug 169363

When the example file attachment 203844 [details] is saved as XLSX and reopened in Excel, all columns with merged cells show the autofilter dropdown, instead of just the rightmost.

1. Open attachment 203844 [details]
2. Save as XLSX
3. Reopen the file in Excel (in Calc, this issue is not visible, interestingly...)
-> The cells I1:K1 are merged and have autofilter dropdowns shown instead of just K1 having it

Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 620(Build:0)
CPU threads: 16; OS: Windows 10 X86_64 (build 19045); UI render: Skia/Raster; VCL: win
Locale: de-DE (hu_HU); UI: en-US
Calc: threaded

This seems to have been happening ever since 3.3.
Comment 1 Gabor Kelemen (Collabora) 2025-11-10 08:38:30 UTC
Created attachment 203847 [details]
The original and roundtripped files in Excel 2016