Bug 106870 - filter on dates not working
Summary: filter on dates not working
Status: RESOLVED DUPLICATE of bug 106214
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.2.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-03-30 12:04 UTC by marco.tettamanti
Modified: 2017-07-24 14:34 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
bug example (513.95 KB, application/pdf)
2017-03-30 12:06 UTC, marco.tettamanti 		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 marco.tettamanti 2017-03-30 12:04:27 UTC 
Description:
activating auto filter then picking a column of dates and selecting a month the result is an empty list

Steps to Reproduce:
1. get a spreadsheet with some columns, names, dates, etc.
2. activate automatic filter on columns
3. pick the column of dates and select a month


Actual Results:  
the result is an empty list

Expected Results:
a list of items with dates corresponding to the month selected


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:52.0) Gecko/20100101 Firefox/52.0
Comment 1 marco.tettamanti 2017-03-30 12:06:26 UTC 
Created attachment 132281 [details]
bug example
Comment 2 Jacques Guilleron 2017-03-30 14:27:10 UTC 
Hello marco,

I reproduce with:
LO 5.3.1.1 Build ID: 72fee18f394a980128dc111963f2eefb05998eeb
Threads CPU : 2; Version de l'OS :Windows 6.1; UI Render : par défaut; Moteur de mise en page : nouveau; Locale : fr-FR (fr_FR); Calc: CL
LO 5.3.1.2 Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2

but not with:
LO 5.3.0.3 Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1

Works for me with:
LO 5.4.0.0.alpha0+ Build ID: 1cd7edadfedc8bf55b979449cbb084082a888e89
CPU threads: 2; OS: Windows 6.1; UI render: default; 
TinderBox: Win-x86@42, Branch:master, Time: 2017-03-30_03:06:30
Locale: fr-FR (fr_FR); Calc: CL
Set status to Duplicate of:
Bug 106214 - Filtering on date columns doesn't work with autofilter

*** This bug has been marked as a duplicate of bug 106214 ***
Comment 3 Xisco Faulí 2017-07-24 14:34:57 UTC 

*** This bug has been marked as a duplicate of bug 106214 ***