Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||AutoFilter criteria corrupted by formula error results|
|Component:||editing||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Issue Type:||DEFECT||Latest Confirmation in:||---|
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.