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.