Created attachment 170800 [details]
Example file from Excel
Attached file contains some time values that were autofiltered in Excel.
When opened in Calc the autofilter dropdown shows all values as hidden, while only some were hidden in Excel.
Steps to reproduce:
1. Open attached file
The autofilter displays all values as unchecked.
The main sheet however displays the filtering results correctly.
Only values from 12:xx hours should be unchecked in the filter.
Version: 126.96.36.199.alpha0+ (x64) / LibreOffice Community
Build ID: bdbb5d0389642c0d445b5779fe2a18fda3e4a4d4
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: en-US (hu_HU); UI: en-US
Also happens in 6.0, 5.0, 4.0
Created attachment 170801 [details]
Screenshot of the original document side by side in Excel and Calc
Note: this seems to be locale-dependent too:
- happens with en-US
- does not happen with hu-HU
Version: 188.8.131.52.alpha0+ / LibreOffice Community
Build ID: 3e4eb070787d4d44b3bdc95046e5b231dbbef42b
CPU threads: 4; OS: Linux 5.7; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Balazs Varga committed a patch related to this issue.
It has been pushed to "master":
tdf#141309 tdf#142215 OOXML import: fix double conversion in autofilter
It will be available in 7.2.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:
Affected users are encouraged to test the fix and report feedback.
It's fixed now. Thanks for your work.
Version: 184.108.40.206.alpha1+ / LibreOffice Community
Build ID: f49e5902a3737c02fabf5bec23243ccb126426c4
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US