Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-366

A filter dropdown shows available items filtered by other enabled filters


    • Icon: New Feature New Feature
    • Resolution: Done
    • Icon: Normal Normal
    • 5.8.0
    • None
    • None
    • Security Level: Jimmy
    • None

      Steps to Reproduce

      1. load the attached file
      2. select the first 4 items in the 1st column
      3. select 3 items in the 2nd column
      3. select 2 items in the 3rd column
      4. check the first 3 column filter available items in the dropdown

      Current Result

      Check the 1st column, keikai lists all values in the column (not filtered). The other 2 columns (2nd and 3rd) have the same behavior.

      Expected Result

      In Excel, each filter only lists the available items filtered by other enabled filters.

      Both Excel 2007 and Excel for Mac have the same behavior.

      Debug Information

      1. For the column that doesn't apply any criteria, keikai will list only available items (remove those items filtered by other filters), for example, check 4th column

      2. List all items is not wrong, but those items filtered by other filters can't affect the final result. Even you select those filtered items, they will not be visible because other filters' criteria make them hidden.
      For example, in the above test case, if I select 15-May, that row won't be visible. Because 15-May is still hidden by the other 2 filters' criteria. So I still have to change other filters' criteria to make 15-May visible. But if a user changes another filter criteria, then combing the previous change, it might change the final result.
      3. Showing available items only (instead of all items) makes users directly know which items can change the current result.

      Google sheet

      It behaves similarly. It also lists filtered items but the filtering rule is a bit different. For the 1st column that applies the criteria,
      Google sheet still lists some not filtered items.
      Test file

        1. 1st.jpg
          8 kB
        2. 2nd.jpg
          5 kB
        3. 3rd.jpg
          7 kB
        4. 4th.jpg
          21 kB
        5. filters.xlsx
          11 kB
        6. kk-filter.jpg
          16 kB

            RaymondChao RaymondChao
            hawk hawk
            0 Vote for this issue
            2 Start watching this issue