Issue 90658 - AutoFilter criteria corrupted by formula error results
Summary: AutoFilter criteria corrupted by formula error results
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-06-12 12:58 UTC by villeroy
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
A list of values and filter criteria (15.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2008-06-12 13:00 UTC, villeroy 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
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".