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 Re: DDE linked cells fool the "=0" test, and dismay paintbrush -correction
Date Tue, 20 Dec 2011 01:28:23 GMT
On 12/15/2011 12:58 PM, Dave Babcock wrote:
> On 12/13/2011 9:38 AM, Manuel Andres Ramirez wrote:
>> 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.
>>
> VALUE() returns error code 502, invalid argument.
>
> I realize that what I'm really asking is SHOULDn't this be flagged (or 
> entered or whatever) as a bug?
> Imagine a newbe trying to use DDE...
>
> Ol' Bab
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
SHOULD have said:        -add a transparent operation, viz:    
IF((A3*1)=0;"";57/A3)

---------------------------------------------------------------------
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