[Libreoffice-bugs] [Bug 112258] New: UI Autofilter on date cells: Filter result doesn' t correspond to user input, user input is modified automatically

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112258

            Bug ID: 112258
           Summary: UI Autofilter on date cells: Filter result doesn't
                    correspond to user input, user input is modified
                    automatically
           Product: LibreOffice
           Version: 5.4.0.3 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: Stefan_Lange_KA at T-Online.de

Created attachment 136074
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136074&action=edit
spreadsheet to demonstrate the behavior

When in a sheet with date cells autofilter is set, the filter results do not
correspand the selected filter criteria.
Furthermore the filter function needs quite many time and - very bad - the
filter criteria entered by the user are "automatically" changed while filter
works.

Steps to reproduce:
- open the attached small spreadsheet "Test_Autofilter_Date.ods"
Step 1:
- click on the autofilter arrow in column A ("Datum"), unselect "All" and
select one or more years -> presss OK
Result: 
- expected: only rows with date in selected years are filtered
- actually: Not only the selectd years are filtered, but all rows except the
empty rows
Remark: In other cases not all rows are selected 
Step 2: 
- click on the autofilter arrow in column a again
Result:
- expected: only the years selected in Step 1 are selected in the filter list
- actually: all years except "empty" are selected in the filter list (this
corresponds to the filter result from Step 1) 

Remark: In other cases (most of my own spreadsheets) not all years are
automatically selected in the filter list by filter function, but nearly never
the selection entered by the user is kept.

The bug was reproduced with LO 5.4.0, LO 5.4.1 and LO 6.0.0.0.alpha0. In LO
5.3.5 the autofilter on date cells works properly.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170906/55f75705/attachment.html>