https://bugs.documentfoundation.org/show_bug.cgi?id=150923
Bug ID: 150923
Summary: FORMATTING: For some ranges of numbers, the TEXT
(DEC2HEX (<number>) function gives strange results
Product: LibreOffice
Version: 7.4.0.3 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
I have the formula '=TEXT(DEC2HEX(<number>);"#")'. For numbers "1" to "479" the
result is "1"-"1DF". For 480 it is "1", 481 - "10", 482 - "100", and so on.
Starting with 490, "1EA" is correct again. The next strange range is from 736
to 745 ("2" - "2,000,000,000").
Try numbers between 11776 and 11929: you will find following groups of 10 wrong
formatting and 6 correct.
Try to use '=TEXT(DEC2HEX(11929);"#")'. The result is "2" and 99 zeros.
Because this behaviour is cyclic I believe that fix of this should be quite
simple.
Steps to Reproduce:
1.Enter formula '=TEXT(DEC2HEX(11929);"#")' into a cell
Actual Results:
2000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000
Expected Results:
2E99
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Version: 7.4.0.3 (x64) / LibreOffice Community
Build ID: f85e47c08ddd19c015c0114a68350214f7066f5a
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: pl-PL
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
