Apache OpenOffice (AOO) Bugzilla – Issue 34070
oocalc crash when use dec2bin() function
Last modified: 2013-07-30 02:20:57 UTC
calc crashes, when you call function to transform decimal number in binary number
Hi, I'm sorry to tell you that I was not able to reproduce your Issue. This may be the case because OOo1.0.2 is at least 3 generations old. Please try it again using OOo1.1.2 which can be downloaded from the OOo site. If the problem still persist, please feel free to re-open this Issue. Frank
closed wfm
reopened because user seems to have set the wrong value in the version field.
Hi Kevin, can you check this Issue please ? Frank
I've checked this issue on my Laptop platform, and I was unable to reproduce the error. I'm running an Alienware 3.0ghz P4 with HT with 512MB of RAM, running WinXP pro if that helps any. Java runtime environment is also not enabled on version OOo1.1.2. --Stephen
I've found this issue ONLY in my powerpc, (powermac G4 450 Mhz with Debian GNU/linux). I can reproduce the issue every time. In all my x86 dec2bin work.I've checked in PII, P3, P4, athon, thundertbird, athlon xp. -- Andrea
I can't reproduce the error. I type in "=DEC2BIN(100;8)" no quotes to test it and doesn't crash. The numbers you are trying to convert my be to large for the program to handle or maybe you processor. System Specs: English 1.1.2 XP Home SP1 P4 2.0 GHz 512 MB RAM 280 Total GB Harddrive NVidia GeForce FX 5200 128MB Open Office v1.1.2 Alex
I've found this problem in APPLE/MACINTOSH POWERMAC with a G4 powerpc cpu, running with linux. In "normal" pc with a pentium family cpu the problem doesn't exist. -- Andrea
Mike Cardillo 9/23/04 I was unable to replicate this bug using Linux and openoffice 1.1.0. Here are the steps I used: 1: opened a new spreadsheet 2: entered "=dec2bin(23)" into one of the cells 3: got the result 10111 I then continued testing with several other random numbers and it never crashed.
Hi Mike, In what platform you have tested issue? in a "normal" pc (i386) or in a mac (ppc) running linux? The problem is only in linux-ppc version of openoffice. bye -- Andrea
Siranish Sarkizova, 09/25/04 I was following the same idea trying to reproduce the bug. I am using OpenOfiice 1.1.3 and the misbehavior of the program I encountered was a little different. Instead of the resulting Pocket Excel file being 0 bytes, only the formulae field has lost its formulae description and only contained the result of the formula as evaluated before the conversion of the file. In fact i noticed that the same behavior occurs with any formulae results and not only the once that evaluate to null. Here are my suggested steps for replicating the problem: 1. Open a new OpenOffice spreadsheet document 2. Let A1 = B1+B2 (this is the formulae) 3. Let B1=1 and B2=2 for example 4. Go to File -> Save as 5. Choose the Data Interchange Format as a file type (a Dif Export window pops up) 6. Choose a character set (Western European for example) 7. Click OK 8. Close the initial spreadsheet file 9. An error msg pops up saying there might be loss of information due to converting the file format 10. Click OK Now in the converted file the A1 field is no longer a formulae but rather just a value. Of course, this might be due to the error message but nevertheless wouldn't the expected behaviour of the program be for the converted file to exactly resemble the initial file.. Configuration: Windows XP Pro 1.2 GHz AMD Athlon 376 MB
I have seen that there was no entry since the end of September. Does this issue also happen with a newer version of OOo (1.1.3 or 1.9.xx? If not, could the original reporter close this issue, please?
The issue is not resolved in OOo 1.1.3. I've changed the disk of my powermac g4, (because it crashed), I've installed linux, and OOo 1.1.3. The problem are not changed.
while checking this issue i encountered another problem(Win XP,p4,1.8Ghz,512MB RAM, OOo_1.9.m65_native_Win32Intel).I used the formulae A3 =B1+B2 , After closing the file , i reopened the same file and changed the values of B1 nad B2 , the new change is not reflecting in A3's value. Steps ----- 1. Open a new OpenOffice spreadsheet document 2. Let A3 = B1+B2 (this is the formulae) 3. Let B1=10 and B2=12 for example 4. Go to File -> Save as 5. Choose the Data Interchange Format as a file type (a Dif Export window pops up) 6. Choose a character set (Western European for example) 7. Click OK 8. Close the initial spreadsheet file 9. Re open the same file 10. Change the value of B1 and B2 11. A3 is not reflecting the change
Same Steps i executed in Linux Also (NLD, P4,IGB RAM oo.o 1.1.3) "Warning: saving the Document 'test.dif': only the active sheet was saved" Here also the same thing is happening
oocalc crash when use dec2bin() function - This is work for me..
Cinfirming the issue reported by Siranish Sarkizova,on 09/25/04 1. Open a new OpenOffice spreadsheet document 2. Let A1 = B1+B2 (this is the formulae) 3. Let B1=1 and B2=2 for example 4. Go to File -> Save as 5. Choose the Data Interchange Format as a file type (a Dif Export window pops up) 6. Choose a character set (Western European for example) 7. Click OK 8. Close the initial spreadsheet file 9. An error msg pops up saying there might be loss of information due to converting the file format 10. Click OK
Reset assignee on issues not touched by assignee in more than 2000 days.