Bug 144786

Summary:	FILEOPEN XLSX Hidden status of Table/Data range filter button not imported
Product:	LibreOffice	Reporter:	NISZ LibreOffice Team <libreoffice>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED FIXED
Severity:	enhancement	CC:	aron.budea, ilmari.lauhakangas, nemeth, varga.balazs3, xiscofauli
Priority:	medium	Keywords:	filter:xlsx
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=132780
Whiteboard:	target:7.5.0
Crash report or crash signature:		Regression By:
Bug Depends on:
Bug Blocks:	137805
Attachments:	Example file from Excel Screenshot of the original document side by side in Excel and Calc

Description NISZ LibreOffice Team 2021-09-29 08:59:52 UTC

Created attachment 175341 [details]
Example file from Excel

Attached Excel-made example file contains two tables, the orange one has the Filter button shown, while the blue one has it turned off in Excel.
When opened in Calc, the blue tables Filter button is also turned on.

Steps to reproduce:
1.	Open attached file in Calc

Actual results:
The table in E1:F4 has the autofilter button visible.

Expected results:
The table in E1:F4 should have the autofilter button hidden.
This is one tiny import aspect of bug 132780

LibreOffice details:
Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: b60b6bfaafa1315e07108dba50f016975b619c59
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL

Comment 1 NISZ LibreOffice Team 2021-09-29 09:00:12 UTC

Created attachment 175342 [details]
Screenshot of the original document side by side in Excel and Calc

Comment 2 Xisco Faulí 2021-09-29 10:39:50 UTC

Reproduced in

Version: 7.3.0.0.alpha0+ / LibreOffice Community
Build ID: ac34bafb6cad056f843ff3ff0dee293bf1e18c56
CPU threads: 4; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded

Comment 3 Commit Notification 2022-12-01 12:06:27 UTC

offtkp committed a patch related to this issue.
It has been pushed to "master":

https://git.libreoffice.org/core/commit/2942fdc8dbda375622d0add8c36df2d6679e321a

tdf#144786 Implement XML_hiddenButton functionality

It will be available in 7.5.0.

The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
https://wiki.documentfoundation.org/Testing_Daily_Builds

Affected users are encouraged to test the fix and report feedback.

Comment 4 Buovjaga 2023-01-01 18:06:44 UTC

Can this be closed as fixed?

Comment 5 Paris Oplopoios 2023-06-10 18:44:22 UTC

Seems fixed to me