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 [email protected]
In case of problems unsubscribing, write to [email protected]
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
