Bug 144234

Summary:	DECBIN function limited to 511
Product:	LibreOffice	Reporter:	DoMi..... <docinfo57>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED NOTABUG
Severity:	normal
Priority:	medium
Version:	7.2.0.4 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

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.