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.