[Libreoffice-bugs] [Bug 122111] Hex2DEC not converting right

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=122111

--- Comment #10 from Drew Jensen <drewjensen.inbox at gmail.com> ---
(In reply to GerardF from comment #9)
> Hexadecimal "d5caef682d" if not signed is 918232721453 in decimal and
> 1101010111001010111011110110100000101101 in binary.
> 
> Which is a 40 bit number, and the 1st bit is 1.
> So this is a negative number as per specification :
> http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.
> html#__RefHeading__1018822_715980110
> 
> All 10 digits hexadecimal beginning with 8-F are negative. (1-7 are positive)

Some good news on this - I was mislead, kind of, in that I went to the
currently available Calc Guide from TDF for details on this function and in the
guide there is no mention of the constraint on the high bit (only that it was
max 10 characters and my calculator results of course didn't match the software
results) 

- but, the good news is that, in the current help system this is explicitly
explained, and language is now in the draft for the next release of the Guide
explaining it in detail also.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20181217/2e5720e2/attachment.html>