is this a bug ?


Posted by Chris D on February 07, 2002 7:14 AM

Hi all,

Column A contains the following :

amount
2.00
4.00
5.00
7.00
-
9.00
8.00
-
7.00
6.00
-
8.00
-
8.00
-
7.00
6.00
4.00

where "-"s are zero values, formatted via the comma style icon in the format toolbar: the "," icon.

There's a simple autofilter button in A1.

Filtering on anything equal to zero returns nothing.

Filtering on anything not equal to "-" returns all rows.


Don't these two filter answers contradict each other ?
If it's recognising there are no zero values per se, wouldn't it then recognise that some cells *are* equal to what zero's been replaced with?

cheers
Chris

Posted by Mark W. on February 07, 2002 7:27 AM

Custom criteria use the internal rather than the displayed value [nt]

Posted by Chris D on February 07, 2002 7:32 AM

Re: Custom criteria use the internal rather than the displayed value [nt]

Yup, thanks Mark, that makes sense, but why would I get no rows returned when filtering on anything equal to zero ?

Posted by Mark W. on February 07, 2002 7:37 AM

Ahh!! I'm wrong...

I forgot that the Custom criteria has a drop down
value selection box also... that box lists "-". Yup, thanks Mark, that makes sense, but why would I get no rows returned when filtering on anything equal to zero ?



Posted by Chris D on February 07, 2002 1:54 PM

any other thoughts still welcomed ! (nt)