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

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


--- On Fri, 11/26/10, efa@iol.it <efa@iol.it> wrote:

> From: efa@iol.it <efa@iol.it>
> Subject: [office-comment] BASE(): support two's complement negative binary numbers
> To: office-comment@lists.oasis-open.org
> Date: Friday, November 26, 2010, 7:02 AM
> hi,
> I saw here:
> http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05-part2.
> html#a_6_19_3_BASE
> that BASE() require 'Integer X' >=0.
> 
> This forbid conversion of negative numbers to binary. The
> problem is ever 
> whorse when the number is lesser than -512,
> as DEC2BIN and HEX2BIN require two's complement with a max
> of 10 digit.
> 
> So please add support for two's complement negative binary
> numbers as output 
> of BASE().
> 
> thank you in advance,
> Valerio
> 
> 
> -- 
> This publicly archived list offers a means to provide input
> to the
> OASIS Open Document Format for Office Applications
> (OpenDocument) TC.
> 
> In order to verify user consent to the Feedback License
> terms and
> to minimize spam in the list archive, subscription is
> required
> before posting.
> 
> Subscribe: office-comment-subscribe@lists.oasis-open.org
> Unsubscribe: office-comment-unsubscribe@lists.oasis-open.org
> List help: office-comment-help@lists.oasis-open.org
> List archive: http://lists.oasis-open.org/archives/office-comment/
> Feedback License: http://www.oasis-open.org/who/ipr/feedback_license.pdf
> List Guidelines: http://www.oasis-open.org/maillists/guidelines.php
> Committee: http://www.oasis-open.org/committees/tc_home.php?wg_abbrev=office
> 
>