incubator-ooo-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Manuel Andres Ramirez <manuelandr...@aim.com>
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
>

Dave,

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.

Regards.

-- 

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

<<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: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org


Mime
View raw message