[Libreoffice-bugs] [Bug 113585] New: Auto Filter Columns are Treated Separately in the Attached ODS File

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 113585
           Summary: Auto Filter Columns are Treated Separately in the
                    Attached ODS File
           Product: LibreOffice
           Version: 5.4.2.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: suokunlong at 126.com

Created attachment 137436
  --> https://bugs.documentfoundation.org/attachment.cgi?id=137436&action=edit
test ods file

The attached .ods file has two columns of data. In the most recent libreoffice
version, these two columns are treated separately when doing auto-filtering.

Steps to Reproduce:
1. Click on the drop-down list to filter-out "201607" in column B.
2. Click on the drop-down list to observe the items as shown in the filter-list
in column A.

Current Behaviour:
In step 2, all the items are shown in the filtered list.

Expected Behaviour:
Only 07-2016 is shown in step 2.



Further Information:
Apparently Calc is treating these two columns as separate data:
* If you select cell B1, click the autofilter toolbar icon to remove the
autofilter status, only autofilter for column A is removed. It should remove
both.
* If you select A1:B3692, then click the autofilter toolbar icon to remove the
autofilter, then filter on both columns are removed, but if you click the icon
to set autofilter again, then filter is set separately again.

The ods file was generated using LibreOffice, I am not sure which version was
used to create this file.

-- 
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/20171102/bd78a978/attachment.html>