Hi John,
John B schrieb:
[..]
** Who is / are OASIS?
OASIS is the organization, which prepared the ODF1.0 specification,
which then became ISO standard. Now OASIS works on ODF1.2. This is
currently in puplic review. For details and download links see
: [libreoffice-users] Error in Calc logical
functions
Send reply to: users@global.libreoffice.org
Alejo C.S. schrieb:
Hi all, this is a little example to show what is going on.
In A column I have a numeric list from 1 to 21, in the middle I have a
letter, lets put A.
If a run
Hi John,
John B schrieb:
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.
LO follows the standard ODF and acts the same as main competitors.
There
] Error in Calc logical functions
Hi John,
snip /
If you want a cell to only expect a number, you have to set up the cell
accordingly before entering something, otherwise a cell expects all input.
kind regards
Regina
--
Unsubscribe instructions: E-mail to users+h...@global.libreoffice.org
+1
-Original Message-
From: Regina Henschel [mailto:rb.hensc...@t-online.de]
Sent: Wednesday, July 13, 2011 06:14
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Error in Calc logical functions
Hi John,
John B schrieb:
Dear Regina
The way LO explains (you mention
Hi :)
In ascii code the alphabetic characters are 'higher' than the numbers. So A is
calculated as being higher than any number. Remember that the machine doesn't
really understand letter or numbers as we read them. They are all just binary
digits. the binary digit that represents the
Alejo C.S. schrieb:
Hi all, this is a little example to show what is going on.
In A column I have a numeric list from 1 to 21, in the middle I have a
letter, lets put A.
If a run this function in the next column =IF(A110), this function
evaluate the letter A like TRUE, why?
1FALSE
2
Alejo
The strange thing is is that if you reverse the logic such as =IF(A111
and then reverse the True False
You get the same results table and but with A still being TRUE
I am convinced this is a bug, which stops you writing an IF within an
IF such as =IF(A111,False,IF(A110,True,False))
Got it
Regina is correct, so:-
=IF(A150,False,IF(A110,True,False))
Where 50 (or 1000) is higher than any number in your table
regards
John B
On 12/07/2011 19:28, John B wrote:
Alejo
The strange
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
--
Hello Brian
Its none of those, they are not comparable, Ones a text the other is an
amount. Therefore A logically is not greater than 10 stands (I hope)!
As stated, I used Lotus 123 as my Judge and Jury.
John B
Ps who is John Bonly?
-
From: John B [mailto:jo...@email2.me]
Sent: Tuesday, July 12, 2011 16:02
To: users@global.libreoffice.org
Subject: Re: [libreoffice-users] Error in Calc logical functions
Hello Brian
Its none of those, they are not comparable, Ones a text the other is an
amount. Therefore A logically
-online.de
To: users@global.libreoffice.org
Sent: Tue, 12 July, 2011 22:08:54
Subject: Re: [libreoffice-users] Error in Calc logical functions
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
13 matches
Mail list logo
