Re: [libreoffice-users] Error in Calc logical functions

Dear Regina

The way LO explains (you mention), its not a bug, but that does not mean 
that it is correct either and can be classed as a false positive.

It is not until you have practical use.

For example if a box ="" (say in  B1 which means empty) then box stays blank
but if box A1 = a number,  then a set amount appears in B1 (in business 
most people do not like a page full of zero's and unused amounts 
appearing for no good reason)

What you _don't_ want to happen is as per LO, if you place any Letter in 
A1 then the amount shows

eg (a very common formula)

in B1   =IF(A1=0,"",4.5)  - which happens if you put any non number (a 
space) in A1 even by accident, B1 will show 4.5 (a false positive).

Also if you now add up the row B with false positives, that would  give 
the wrong answer as well.

As mentioned before in Lotus 123 this does not happen.

However, I suppose it depends on your point of view and the software you 
are used too. But it does mean that in the case Alejo showed, it is a 
false positive, which has to be manually  formula-ed out.

I cannot see any case where the reverse would be of practical use, if a 
box is expecting a number and you enter in a letter then "nothing" 
should be the result - In which case its a bug - unless - you know better?

regards

John B

---------------------------------------------------------------------------------------


On 12/07/2011 22:08, Regina Henschel wrote:
> Hi Tom,
>
> Tom Davies schrieb:
> > Hi :)
> > It might e worth posting a bug-report
> > http://wiki.documentfoundation.org/BugReport
> > The advice in the guide might be useful but far more useful is the 
> > link to post
> > a bug-report.
>
> Where do you see a bug? For me the behavior is correct.
>
> Kind regards
> Regina


--
Unsubscribe instructions: E-mail to users+help@global.libreoffice.org
In case of problems unsubscribing, write to postmaster@documentfoundation.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted