incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manuel Andres Ramirez <>
Subject Re: DDE linked cells fool the "=0" test, and dismay paintbrush
Date Tue, 13 Dec 2011 14:38:13 GMT
El 11/12/11 21:33, Dave Babcock escribió:
> 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


Try use the function value(), like this IF(VALUE(A3)=0;"";57/A3).

Maybe the if function don't recognize the value in A3, because it is 
inside a matriz DDE.



Manuel Andrés Ramírez P.
Administrador Informático
GNU/Linux Registered User:412887

<<Yo Tengo mi Office Legal y no pagué por su licencia>>

"El placer más noble es el júbilo de comprender"
(Leonardo Da Vinci)

To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message