https://bugs.documentfoundation.org/show_bug.cgi?id=162609

            Bug ID: 162609
           Summary: AutoFilter cannot hide N/A errors while showing all
                    digits
           Product: LibreOffice
           Version: 24.2.5.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Description:
Please see title and steps to reproduce.

Steps to Reproduce:
1. Copy this to a new Calc spreadsheet:

Number
0
1
2
3
4
5
6
7
8
9
=NA()

2. Make sure =NA() was evaluated as a formula to produce #N/A
3. Using AutoFilter, deselect #N/A from the allowed values in "Number", but
keep everything else selected

Actual Results:
The #N/A line remains visible

Expected Results:
The #N/A line should be hidden by the filter


Reproducible: Always


User Profile Reset: No

Additional Info:
Happened on Linux Mint 22

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to