<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Hex2DEC not converting right" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122111#c10">Comment # 10</a> on <a class="bz_bug_link bz_status_RESOLVED bz_closed" title="RESOLVED NOTABUG - Hex2DEC not converting right" href="https://bugs.documentfoundation.org/show_bug.cgi?id=122111">bug 122111</a> from <a class="email" href="mailto:drewjensen.inbox@gmail.com" title="Drew Jensen <drewjensen.inbox@gmail.com>"> Drew Jensen</a> <pre>(In reply to GerardF from <a href="show_bug.cgi?id=122111#c9">comment #9</a>) > 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 : > <a href="http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2">http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2</a>. > 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.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>