empty field

[ASJ Botenga]

Although we are practically working together, I wasn't aware of the fact
that Sylvia answered your response and also did not see your (second and
third) answer. With my loop I tried to approach the problem (make it text,
so you can recognize the bits) but did not reach the essence. Would the
logical - supplementary - explanation you gave in your (second) answer be
something for the handbook ?

Allard

op 07-05-2008 04:48 schreef David Thompson op dthmpsn1 at uiuc.edu:
> 
> No, what she was trying to do was to find a
> simple way to tell the difference between an
> empty cell, and a cell that contained the number
> 0. Both have a value of 0, so testing them for
> numerical value doesn't work. The procedure she
> was using actually works. It's just complex and
> slow. She was looking for something that would be
> simpler and quicker.
> 
> If you had simply used
> 
> FieldName NotEqual  (nothing in the value box)
> 
> or if you had just used
> 
> FieldName NotEqual 0
> 
> you would have gotten exactly the same result
> that you did when you used them both together,
> because they are the same condition. They are
> either both true or they are both false. If,
> immediately after doing the Find/Select, you
> choose Formula Find/Select...,  you will see the
> formula that was used. In this case it would read
> 
> FieldName <> 0 AND FieldName <> 0
> 
> The problem she was trying to solve is one that
> has come up numerous times on this list. The
> solutions are to use either the sizeof( function
> to see if the cell has content, or to use the
> exportcell( function to see if it displays as a
> blank in a data cell. My preference is to use
> sizeof( because I think there is probably less
> overhead involved for Panorama.
> 
> Dave

You are quite right
Allard
> _______________________________________________
> Qna mailing list
> Qna at provue.com
> http://provue.com/mailman/listinfo/qna