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

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


    • 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


      sample file attached


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


      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

            jumperchen jumperchen
            MDuchemin MDuchemin
            0 Vote for this issue
            1 Start watching this issue