Created attachment 132457 [details]
The problematic document
Attached XLSX file from Excel 2013 has some Date type cells with autofilter set to filter out the value in row 3.
When opened in LO 5.4 alpha the row is hidden, but in the autofilter list the value appears as still enabled.
Saving the document in ODS, filtering out the 3rd row and reopening shows correctly the value as filtered out.
Created attachment 132458 [details]
Same document in ODS
Created attachment 132459 [details]
Screenshot of the problem 2016 shown as enabled
Created attachment 132460 [details]
Correct in ODS
Created attachment 132461 [details]
Screenshot in Excel, the value of 2016... is disabled
Version: 188.8.131.52 (x64)
Build ID: 6cd4f1ef626f15116896b1d8e1398b56da0d0ee1
CPU Threads: 4; OS Version: Windows 6.19; UI Render: GL; Layout Engine: new;
Locale: es-ES (es_ES); Calc: group
Seems the OOXLM filter doesn't import/handle the <dateGroupItem> elements yet, of <autoFilter><filterColumn><filters>. See sc/source/filter/oox/autofilterbuffer.cxx DiscreteFilter context created from sc/source/filter/oox/autofiltercontext.cxx FilterColumnContext::onCreateContext()