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

# 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 negative binary numbers

• From: jjcogliati-whatwg@yahoo.com
• To: office-comment@lists.oasis-open.org, "efa@iol.it" <efa@iol.it>
• Date: Fri, 26 Nov 2010 06:23:42 -0800 (PST)

```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.
>
> numbers as output
> of BASE().
>
> 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/