← Prev in month ← Prev in thread
Next in thread → Next in month →

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

From
[email protected] <>
Date
2010-11-26T14:31:17+00:00
ID
1942230.549601290781867657.JavaMail.defaultUser@defaultHost
Thread
Re: [office-comment] BASE(): support two's complement negativebinary numbers
From: 

>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
← Prev in month ← Prev in thread
Next in thread → Next in month →