Insert a column inside a filter range makes a filter works incorrectly

XMLWordPrintable

    • Type: Bug
    • Resolution: Fixed
    • Priority: Normal
    • 3.9.0
    • Affects Version/s: 3.9.0
    • Component/s: None
    • Security Level: Jimmy
    • None
    • Sprint 5

      steps to reproduce

      1. load the attached file
      2. insert a column at column "B"
      3. check the filter dropdown at column "B"

      actual result

      all filter dropdowns display only visible value instead of all candidate values.

      expected

      debug info

      delete column B in the filtering range also causes this issue.

        1. 1230.xlsx
          29 kB
        2. inserted.png
          inserted.png
          20 kB
        3. original.png
          original.png
          18 kB

            Assignee:
            henrichen
            Reporter:
            hawk
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: