Bug 38940

Summary: format cell. number length bug
Product: LibreOffice Reporter: Changsoo Kim <naljebii>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: CLOSED INVALID    
Severity: normal CC: jeffdchang, yfjiang
Priority: medium    
Version: 3.3.2 release   
Hardware: x86 (IA32)   
OS: Linux (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description Changsoo Kim 2011-07-04 01:32:59 UTC 
format cell. number length bug

use function dec2bin;
type of cell a1 "5"
type of cell b1 "=dec2bin(a1)"
cell format is "0000"

correctly result is "0123" however
it can view "123"
Comment 1 Jeffrey 2011-07-04 07:30:33 UTC 
Not reproducible on LibreOffice 3.4  340m1(Build:12) for OpenSuse Linux. Perhaps fixed in a new release.
Comment 2 Jeffrey 2011-07-04 07:33:59 UTC 
Here is how I reproduced this:

1. Use the f(x) symbol near the Sigma in the toolbar
2. Select DEC2BIN under all. Input B1.
3. Type 5 into B1, A1 displays as 101, the proper result.

Tried this with other cells and numbers. Works fine.
Comment 3 Changsoo Kim 2011-07-05 18:07:29 UTC 
ah...
i misstaken for type of numbers or character.
type of binary is character.

i think that binary is numbers.
sorry. reported massage
Comment 4 Eike Rathke 2011-08-05 12:47:25 UTC 
Closing invalid.