OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.

 


Help: OASIS Mailing Lists Help | MarkMail Help

office-comment message

[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]


Subject: Re: [office-comment] BASE(): support two's complement negativebinary numbers


From: jjcogliati-whatwg@yahoo.com

>Two's complement requires knowing the integer memory size.  For example, the 
8 bit two's complement number equivalent to -1 is 0xFF, but if that is a 16 bit 
number, then that is 255. 
>
>How does BASE know the integer size for determining what the two's complement 
is? 
>
>The machine size would give different results if a the spreadsheet is on a 32 
bit machine or a 64 bit machine.  

BASE() has an optional parameter:
'Integer MinimumLength'
that can be used to specify the bit size of the machine word for negative 
numbers.

Valerio



[Date Prev] | [Thread Prev] | [Thread Next] | [Date Next] -- [Date Index] | [Thread Index] | [List Home]