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

Support custom auto-filter "display value" preset in popup instead of actual value

XMLWordPrintable

    • Icon: New Feature New Feature
    • Resolution: Fixed
    • Icon: Normal Normal
    • 5.12.0
    • None
    • None
    • Security Level: Jimmy
    • None

      User Story

      As a user, I use the custom number autoFilter to filter out rows in a table.

      The autoFilter popup for numbers provides a combobox to set the condition after choosing the operator.

      Ex: greater than 50%

       

      The value list is generated from the display value of the cells located in the filtered column.

      If the cell display value and the cell actual value are different (display as percentage, display with number of decimals, etc), when the popup is opened again, the preset value is the actual cell value corresponding to the previously selected value

       

      See screenshot below:

      1: actual value

      2: display value (same value, but display as percentage)

       

      Acceptance Criteria

      Spec to define

      Details

      sample file attached

       

      Excel implementation treats the display value as actual value when setting filter.

      Ex:

      If a cell has an actual value of 0.50001 displayed as percentage (50%), the presets for the custom number filters will use 50%, and will save that value as 0.5

      This will cause the field to still be visible if the "stricly greater than" operator is chosen, while both the filter value and the display value are 50.00%

      When reopening the filter popup, the value will be 0.5

        1. filter-display-value.xlsx
          11 kB
          MDuchemin
        2. image-2021-12-29-14-18-28-919.png
          17 kB
          MDuchemin
        3. image-2021-12-29-14-18-31-513.png
          17 kB
          MDuchemin
        4. image-2021-12-29-14-21-38-535.png
          23 kB
          MDuchemin

            jumperchen jumperchen
            MDuchemin MDuchemin
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: