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

Tom

That was the very 1st thing I thought,  so  I ran charmap on Arial and 
chose an accii code less than a number such as # and it still comes up TRUE.

It should either come up as False or Error

A bug I think


regards

John B

-------------------------------------------------------------------------------------------------------------
On 12/07/2011 18:20, Tom Davies wrote:
> 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 character A is 'higher' than one
> representing a number.
>
> Regards from
> Tom :)
>
>
>
>
> ________________________________
> From: Alejo C.S.<alej.c.s@gmail.com>
> To: users@global.libreoffice.org
> Sent: Tue, 12 July, 2011 18:05:29
> Subject: [libreoffice-users] Error in Calc logical functions
>
> 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(A1>10), this function
> evaluate the letter A like TRUE, why?
>
>
> 1    FALSE
> 2    FALSE
> 3    FALSE
> 4    FALSE
> 5    FALSE
> 6    FALSE
> 7    FALSE
> 8    FALSE
> 9    FALSE
> 10  FALSE
> 11  TRUE
> A   TRUE
> 13  TRUE
> 14  TRUE
> 15  TRUE
> 16  TRUE
> 17  TRUE
> 18  TRUE
> 19  TRUE
> 20  TRUE
> 21 TRUE
>
> Thanks a lot in advance
>
> C.
>
>    
>
>
>
> Internal Virus Database is out of date.
> Checked by AVG - www.avg.com
> Version: 9.0.901 / Virus Database: 271.1.1/3744 - Release Date: 07/04/11 19:35:00
>
>    


--
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