Bug 144786 - FILEOPEN XLSX Hidden status of Table/Data range filter button not imported
Summary: FILEOPEN XLSX Hidden status of Table/Data range filter button not imported
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: target:7.5.0
Keywords: filter:xlsx
Depends on:
Blocks: XLSX-DataRange
  Show dependency treegraph
 
Reported: 2021-09-29 08:59 UTC by NISZ LibreOffice Team
Modified: 2023-06-10 18:44 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:


Attachments
Example file from Excel (11.19 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2021-09-29 08:59 UTC, NISZ LibreOffice Team
Details
Screenshot of the original document side by side in Excel and Calc (66.76 KB, image/png)
2021-09-29 09:00 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
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