Issue 90658

Summary: AutoFilter criteria corrupted by formula error results
Product: Calc Reporter: villeroy <villeroy>
Component: editingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues
Version: OOo 2.4.1   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
A list of values and filter criteria none

Description villeroy 2008-06-12 12:58:44 UTC
A list of 
-1
#N/A
A
0
1
generates the following filter criteria in auto-filter and standard filter
-1

A
1
Zero is missing and the empty entry hides all rows.
Comment 1 villeroy 2008-06-12 13:00:05 UTC
Created attachment 54428 [details]
A list of values and filter criteria
Comment 2 amy2008 2008-07-09 09:20:50 UTC
Maybe this issue should be marked as a duplication of issue 89816.
Comment 3 clytie 2008-07-09 09:34:25 UTC
This issue is related to both 89816 and 90920: Calc's handling of null values is non-standard. Should 
we combine the information in a single issue?
Comment 4 ooo 2008-07-10 11:56:32 UTC
No, this issue is not related to issue 90920 nor issue 89816. This issue here is
about a formula's error result confusing the list of available values in
AutoFilter. Issue 90920 is about considering empty cells when searching for an
empty string respectively the empty paragraph regular expression. Issue 89816 is
about the automatic selection of the data area if none was selected.
Comment 5 Marcus 2017-05-20 11:11:52 UTC
Reset assigne to the default "issues@openoffice.apache.org".