Bug 106481 - Autofilter shows wrong results with dates
Summary: Autofilter shows wrong results with dates
Status: RESOLVED DUPLICATE of bug 106214
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.2.6.1 rc
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected, regression
Depends on:
Blocks:
 
Reported: 2017-03-10 17:02 UTC by Marina Latini (SUSE)
Modified: 2017-03-10 18:36 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
test file with dates and autofilter (8.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-03-10 17:03 UTC, Marina Latini (SUSE) 		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 Marina Latini (SUSE) 2017-03-10 17:02:14 UTC 
Description:
Autofiltering columns with dates doesn't work properly. If you try to select one or more dates (not the whole list of dates), LibreOffice shows always an empty selection. 

Steps to Reproduce:
1. Open the provided file
2. Try to deselect one item in the list


Actual Results:  
The selection is always empty

Expected Results:
Calc filters the elements properly.


Reproducible: Always

User Profile Reset: yes

Additional Info:
I can reproduce the issue only with LibreOffice 5.2.6.1 and 5.2.6.2. both on 32 and 64 bit on Linux and Windows.

LibreOffice 5.1.5 works fine.
LibreOffice 5.3.0.0 beta2 works fine.


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/58.0.3026.3 Safari/537.36
Comment 1 Marina Latini (SUSE) 2017-03-10 17:03:20 UTC 
Created attachment 131802 [details]
test file with dates and autofilter

test file with dates
Comment 2 Marina Latini (SUSE) 2017-03-10 17:04:57 UTC 
added keyword regression because the issue occurs only in LibreOffice 5.2.6.1 and 5.2.6.2
Comment 3 Xisco Faulí 2017-03-10 18:36:02 UTC 
Regression introduced by 42e472b5870278058537d43d03d457dc80b16166 which is the same as in bug 106214.
Thank you for reporting the bug ;)

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