Bug 125659 - HEX2DEC should be expanded to 64 bit support.
Summary: HEX2DEC should be expanded to 64 bit support.
Status: CLOSED WONTFIX
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.1.6.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-06-03 14:38 UTC by briankt43
Modified: 2019-06-04 11:18 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description briankt43 2019-06-03 14:38:05 UTC 
Description:
HEX2DEC is limited to 10 hex characters. In today's world that is not enough.  It should be expanded to 64 bit.

Steps to Reproduce:
1. =HEX2DEC("30000000000")

Actual Results:
Err:502

Expected Results:
3298534883328


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Comment 1 Xisco Faulí 2019-06-04 10:13:25 UTC 
@Eike, @Winfried, I thought you might be interested in this issue...
Comment 2 Eike Rathke 2019-06-04 11:17:54 UTC 
HEX2DEC() and other binary conversion functions are defined to work on 40-bit values where the 40th bit is the sign bit. This for interoperability reasons. See https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#HEX2DEC
Won't change.

Use the BASE() and DECIMAL() functions if you need larger ranges.