Hi Martin, please have a look. I can't confirm this because of #i33702#

Josh Ohana, 9-21-04
OO 1.1.2 on WindowsXP

When repeating the process I encountered the same bug.

Chris Tanner, 9/24/04

I was also able to replicate your findings: any formula that equate to a null
string (i.e. =“â€) will cause a saved Pocket Excel file to be blank—0 bytes in
size.  Consequently, the saved Pocket Excel file is not open-able.  
This bug did not occur when trying to save as any other file extension that is
listed in the File->Save As dialog.  Lastly, this bug occurred on both of the
systems on which I tested:

System 1:
Tested on both Operating Systems:
a) Microsoft Windows 2000 Build 5.00.2195, Service Pack 4
b) Fedora Core Linux (kernel 2.6.7)
Intel Pentium 4 at 2.80 GHz
1 Gigabyte DDR RAM
OpenOffice.org 1.1.2 and OpenOffice.org 1.1.0

System 2:
Slackware 10.0 (Linux; kernel 2.4.2-6)
AMD K7 Duron 750 MHz
512 MB PC-133 RAM
OpenOffice.org 1.1.2

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 behavior 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

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 behavior 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

Have someone here tried it with a newer version of OOo than 1.1.2 like 1.1.3,
1.1.4 or some 1.9.xx builds? Does this problem occur there also?

Ben Collingsworth, 01/29/05
Configuration: Windows XP, OpenOffice.org 1.9.74 

I replicated this problem (zero byte pxl file created when formula evaluates 
to null string) using OpenOffice.org version 1.9.74 with the following steps:

   1) Enter the formula =IF(A2>0;A2;"") in cell A1
   2) In the file menu select the 'save as' entry
   3) In the "Save as type" selection window, select 'Pocket Excel (.pxl)'
   4) Enter any file name in the file name box
   5) Select the save button

Examination of the file with Windows Explorer shows the file created contains 
zero bytes.

I went a step further. I have reopened it afterwards after closing Calc and your
formula, which I have inserted in A1 was vanished ... So I can confirm this
issue under SuSE Linux 9.1 ... :(

Confirming as a new issue.

adding myself to CC.

mmaher->flr: Your's methinks

Considering the effort, the priority, the risk and our resource planning I've to
target this issue to OOo Later.

Reset assignee on issues not touched by assignee in more than 1000 days.