incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Babcock <ol...@rochester.rr.com>
Subject DDE linked cells fool the "=0" test, and dismay paintbrush
Date Mon, 12 Dec 2011 02:33:40 GMT
OO 3.3.0, on Vista.
I have an array A1:Z55, populated by link from a different spreadsheet. 
The cells there are all formatted to not show 0 in empty cells (# format 
code).
Entries transfer correctly, etc, and math, text, all work well.
Except that if I do:
         IF(A3=0;this;that)

it always does the "that", /even if /the originating cell is empty or 
has a value of zero. Thus,
        IF(A3=0;"";57/A3)
will return a divide-by-zero error if A3=0, instead of giving a blank cell.

I have two workarounds:
-don't use the # in number format.  Not acceptable for various reasons.
-add a transparent operation, viz:    IF(A3=0;"";57/(A3*1))    This 
works, but is hokey.

Am I missing something?

AND, this same block of linked data makes the format paintbrush go a 
little crazy.  Maybe it has to, by some odd quirt of the DDE process. 
Cells can be formatted individually, but not by using the paintbrush.


Ol' Bab

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message