Bug 107014 - Automatic Filter doesn't work when column has multiple formats
Summary: Automatic Filter doesn't work when column has multiple formats
Status: CLOSED 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 normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-04-07 11:34 UTC by mgmartins
Modified: 2017-04-07 12:39 UTC (History)
0 users

See Also:
Crash report or crash signature:


Attachments
File with example of problem (15.76 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-04-07 11:36 UTC, mgmartins
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mgmartins 2017-04-07 11:34:38 UTC
Description:
Automatic filter doesn't work when a column has got multiple formats in its cells. 

For example, we've got a column with some dates and other texts. If you filter usings months, it doesn't filter nothing. I attach a file with an example.

I couldn't determine initial version where to reproduce the problem, but it doesn't happened in version 5.0.5. We have reproduce it with LOCalc 5.2.6 (windows 64 bits) and 5.3.1.2 (Linux 64bits)

Steps to Reproduce:
1.Select title row. Data -> Automatic filter
2.Select column where are data formats mixed. Select filter
3. Unselect all and select only one month in a year

Actual Results:  
It doesn't show nothing

Expected Results:
It has to show what you have selected (rows with that month/year)


Reproducible: Always

User Profile Reset: No

Additional Info:


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/57.0.2987.98 Safari/537.36 OPR/44.0.2510.857
Comment 1 mgmartins 2017-04-07 11:36:32 UTC
Created attachment 132395 [details]
File with example of problem
Comment 2 Eike Rathke 2017-04-07 12:39:16 UTC

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