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
- Re: [libreoffice-users] Error in Calc logical functions (continued)
- (message not available)
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.