Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.