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