incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dave Babcock <>
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 
Entries transfer correctly, etc, and math, text, all work well.
Except that if I do:

it always does the "that", /even if /the originating cell is empty or 
has a value of zero. Thus,
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

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