Bug 112516 - Autofilter adds a filter automatically
Summary: Autofilter adds a filter automatically
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.4.1.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: AutoFilter
  Show dependency treegraph
 
Reported: 2017-09-20 09:50 UTC by Giovanni
Modified: 2017-10-03 12:18 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example (10.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-09-20 09:50 UTC, Giovanni
Details
Video (185.17 KB, video/avi)
2017-09-20 14:44 UTC, Giovanni
Details

Note You need to log in before you can comment on or make changes to this bug.
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!