Bug 144234 - DECBIN function limited to 511
Summary: DECBIN function limited to 511
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-01 09:31 UTC by DoMi.....
Modified: 2021-09-01 09:49 UTC (History)
0 users

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 DoMi..... 2021-09-01 09:31:32 UTC 
Description:
I have a 502 error when I try to convert a value > 511 with the DECBIN function

Steps to Reproduce:
1.Type =DECBIN(512) in a cell
2.
3.

Actual Results:
Err :502


Expected Results:
1000000000


Reproducible: Always


User Profile Reset: No



Additional Info:
I have a 502 error when I try to convert a value > 511 with the DECBIN function, when I try with 511, it's OK.
Comment 1 Eike Rathke 2021-09-01 09:49:44 UTC 
Yes. As specified for interoperability. See
https://docs.oasis-open.org/office/OpenDocument/v1.3/os/part4-formula/OpenDocument-v1.3-os-part4-formula.html#DEC2BIN
(btw it's called DEC2BIN).

Use the BASE() function for conversion of larger values.