https://bugs.freedesktop.org/show_bug.cgi?id=63274
Priority: medium
Bug ID: 63274
Assignee: [email protected]
Summary: Help for HEX2DEC is misleading
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 3.5.3 release
Component: Spreadsheet
Product: LibreOffice
The help for HEX2DEC says this:
HEX2DEC(Number)
Number is a hexadecimal number. The number can have a maximum of 10 places. The
most significant bit is the sign bit, the following bits return the value.
Negative numbers are entered as two's complement.
Example
=HEX2DEC(64) returns 100.
However, if you try to input a hexidecimal number that contains digits outside
of 0-9, then it does not work:
=HEX2DEC(a) returns #NAME
=HEX2DEC("a") returns 10, as expected.
Please clarify that a string argument is taken, not a numeric one.
The help was taken from online,
https://help.libreoffice.org/Calc/Add-in_Functions,_List_of_Analysis_Functions_Part_One#HEX2DEC
So should be up-to-date
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
