Bug 169363 - FILEOPEN XLSX Autofilter in row with merged cells partially disappears
Summary: FILEOPEN XLSX Autofilter in row with merged cells partially disappears
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.5.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks: XLSX-Autofilter
  Show dependency tree / graph
 
Reported: 2025-11-10 08:25 UTC by Gabor Kelemen (Collabora)
Modified: 2025-11-10 17:51 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Example file from Excel 2016 with merged cells + autofilter (8.17 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2025-11-10 08:25 UTC, Gabor Kelemen (Collabora) 		Details
Screenshot of the example file in Excel and Calc (37.60 KB, image/png)
2025-11-10 08:26 UTC, Gabor Kelemen (Collabora) 		Details
View All Add an attachment (proposed patch, testcase, etc.)

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:25:36 UTC 
Created attachment 203844 [details]
Example file from Excel 2016 with merged cells + autofilter

When an XLSX file with autofilter applied on a row with merged cells is opened in Calc, some columns don't show the autofilter dropdowns.

1. Open attached file
-> There are no autofilter dropdowns displayed in columns A-F, unlike in Excel.

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 started in 7.5 with:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=2942fdc8dbda375622d0add8c36df2d6679e321a

author	offtkp <parisoplop@gmail.com>	2022-11-25 15:16:53 +0200
committer	Tomaž Vajngerl <quikee@gmail.com>	2022-12-01 13:05:54 +0100
commit 2942fdc8dbda375622d0add8c36df2d6679e321a (patch)

tdf#144786 Implement XML_hiddenButton functionality
Comment 1 Gabor Kelemen (Collabora) 2025-11-10 08:26:03 UTC 
Created attachment 203845 [details]
Screenshot of the example file in Excel and Calc
Comment 2 raal 2025-11-10 17:51:49 UTC 
Confirm Version: 26.2.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: c7b3ea692f293346fbbdf2a391d9d971c34fa1f2
CPU threads: 4; OS: Linux 6.8; UI render: default; VCL: gtk3
Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US
Calc: threaded