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

auto enlarge filtering range

    XMLWordPrintable

    Details

    • Type: New Feature
    • Status: Closed
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.2.0
    • Component/s: None
    • Labels:
      None

      Description

      Steps to Reproduce

      1. import autofilter.xlsx
      2. filter the first column AA with 1

      Current Result

      it doesn't work

      Expected Result

      only the row with 1 in the first column show, others are hidden

      Debug Information

      • check /xl/worksheets/sheet1.xml
        The range of auto filer is B2:E2
         <autoFilter ref="B2:E2" xr:uid="{00000000-0009-0000-0000-000002000000}"/>
        

        That's the root cause that a filter doesn't work as expected.

      • But the auto filter can work as expected in Excel. I assume Excel automatically detects and adjusts the filter range at some point.
      • Keikai also determines the filtering range automatically when enabling the filter. Maybe keikai can also dynamically detect range at the proper timing to make auto filter work in such file. But how do we differentiate the case that a user really want to filter a smaller range?

      Workaround

      1. select a cell in the table
      2. disable the filter
      3. enable it again.
      4. save the file.

        Attachments

        1. autofilter.xlsx
          10 kB
          hawk
        2. current.png
          28 kB
          hawk
        3. expected.png
          29 kB
          hawk

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved: