https://bugs.freedesktop.org/show_bug.cgi?id=45950
Bug #: 45950
Summary: DEC2BIN() and HEX2BIN(): support of more than 10
binary digits
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.4 release
Platform: All
OS/Version: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
DEC2BIN() and HEX2BIN(): support of more than 10 binary digits, like BASE() do.
While 10 digit are enough for decimal and hex numbers, 10 bit are very few for
a binary number. Consider that as two's complement representation, the range is
restricted to -512 / +511 only.
On the other side, as now BASE() do not support negative numbers, so there is
no solution to represent high negative numbers. Binary numbers should be
supported up to 32 or 64 bit for DEC2BIN() and HEX2BIN(), while BASE() should
support
negative binary numbers.
I saw that OpenDocument Formula require 10 digit, but let implement more than
10 digit (say "implementation-defined"):
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05-part2.html#a_6_19_7_DEC2BIN
http://docs.oasis-open.org/office/v1.2/cd05/OpenDocument-v1.2-cd05-part2.html#a_6_19_11_HEX2BIN
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- 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
