https://bz.apache.org/ooo/show_bug.cgi?id=127776
Issue ID: 127776
Issue Type: DEFECT
Summary: Incorrect return when using Text() with Dec2Hex()
Product: Calc
Version: 4.1.4
Hardware: PC
OS: Windows 10
Status: UNCONFIRMED
Severity: Normal
Priority: P5 (lowest)
Component: code
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
Put the value 3E in a cell (A1)
Put text(A1;"00") in an adjacent cell
You get a return of "03". All other hex number return the correct value.
Note I found this when using Dec2Hex
DEC2HEX(TEXT(A8;"00");2) - Works - Returns 3E
but
TEXT(DEC2HEX(A8;2);"00") - Does not work - Returns 03
In both cases A8 was 62. It worked if A8 was 61 or 63
--
You are receiving this mail because:
You are the assignee for the issue.
