Bug 112516

Summary: Autofilter adds a filter automatically
Product: LibreOffice Reporter: Giovanni <g.volpe>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED WORKSFORME    
Severity: normal CC: raal
Priority: medium    
Version: 5.4.1.2 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Bug Depends on:    
Bug Blocks: 103512    
Attachments: Example
Video

Description Giovanni 2017-09-20 09:50:13 UTC
Created attachment 136392 [details]
Example

When in a sheet with date cells autofilter is set, the filter results do not correspand the selected filter criteria.
The filter criteria entered by the user are "automatically" changed.

Example file attached.

With 2008 year selected it show 2008 and 2022 years (If you delete the 2022 it works).

The same with 2013 and 2015.
Comment 1 Xavier Van Wijmeersch 2017-09-20 14:26:49 UTC
Did you uncheck the all button, before you select a year??
I cannot reproduce the behavior

Version: 5.4.2.0.0+
Build ID: 61d85c4e7c30ea0f5242d927b7456190020b4fbe
CPU threads: 8; OS: Linux 4.9; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group
Comment 2 Giovanni 2017-09-20 14:44:11 UTC
Created attachment 136401 [details]
Video
Comment 3 Giovanni 2017-09-20 14:44:23 UTC
Of course...(see attached video). It works with attached file?
Comment 4 Xavier Van Wijmeersch 2017-09-20 15:33:46 UTC
Yes it works with the attachment, i have seen the video, and its weird what happening

Wish OS you have, maybe resetting your user profile may help

Best regards
Comment 5 raal 2017-09-20 21:48:27 UTC
I can not confirm with Version: 6.0.0.0.alpha0+
Build ID: afeff9102c2935139de4efd40fd2286dce396706
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2017-09-17_23:32:41
Comment 6 Giovanni 2017-09-21 08:44:29 UTC
I have traied:
on four different computers, profile reset, libreoffice reinstall, user interface and locale language switching to English....nothing.

It's like: Bug: 112258
Comment 7 raal 2017-09-27 15:16:55 UTC
(In reply to Giovanni from comment #6)
> I have traied:
> on four different computers, profile reset, libreoffice reinstall, user
> interface and locale language switching to English....nothing.
> 
> It's like: Bug: 112258

Hello, bug 112258 is fixed week ago. Could you test it with developer versionif your bug is fixed too?
You can download it here: http://dev-builds.libreoffice.org/daily/master/
Thank you
Comment 8 Giovanni 2017-10-03 11:59:55 UTC
libo-master~2017-10-03_03.54.36_LibreOfficeDev_6.0.0.0.alpha0_Win_x86 works!