I'm using OpenOffice 1.1 (french) under Windows 2000 SP4 for one major reason : In Excel, DDE link or NOT working properly with some of my server software. With OO, it works fine. But I'd like to point out what I found to be a weird thing (a bug I think).

Here is the procedure to reproduce the problem :

1.Create or open a new spreadsheet (excel-like document) (« Classeur » in french)
2.In any cell, add the following formula : =DDE("GAPCS";"Measure1";"IB_magnitude_009";1)
3.Save the document under OO format (i.e. XXX.SXC) and close it.
4.Open it, you get an error message saying there is a problem in CONTENT.XML. See below for message. OO then close.
5.To get rid of the problem, create a new document.
6.In any cell, enter the following formula : =DDE("GAPCS";"Measure1";"IB_magnitude_009")
7.Save and close (see enclosed OK.SXC file).
8.Open it : no problem.

The « 1 » parameter at the end of the DDE function is necessary in my application as it not always recognize the DDE information as number (but sometimes, for unknown reason, the value red is either TEXT or NUMBER and shows sometimes in TEXT (but not showing the good information) and couple of seconds after is showing in NUMBER (and then the value shown is ok). Adding this « 1 » parameter is helpful as it then ALWAYS recognize the value as a number and therefore ALWAYS showing the good value.

Setting this parameter to « 2 » shows the good « value » but as text format. And never crash. This is not what I want as I need to do calculation with these kind of cell.

Setting this value to "0" shows the TEXT format value that is a wrong value. And never crash.

I figure out I can use it by traslating the TEXT to NUMBER using a TEXTTONUMBER command or similar name.

To explain a little bit more (if it's usefull) GAPCS is my server, the software I read information from. MEASURE1 is the topic I want to read the valu from and IA_MAGNITUDE_009 is the current wich is coming from my device @9.

The NUMBER value (parameter "1") shows "11.39" Amps wich is correct.
The TEXT value (parameter "0") shows "14550". I don't know how is calculated this value that correspond to 11.39 Amps.
The TEXT value (parameter "2") shows "11.39" Amps wich is correct BUT in text format.

Sorry for all the details but it may be useful for you.

Now, the error message. First in french, next in english translation :

French : 
-----------------------------
Titre de la fenêtre : OpenOffice.org 1.1.0
"Erreur lors du chargement du document file:///C:/Documents%20and%20Settings/sav_on.PCL/Mes%20documents/ko.sxc:
Erreur de lecture.
Erreur de format dans le sous-document content.xml du fichier, position 2,3444 (ligne,colonne).. [Note from me : TWO "." instead of 1]
-----------------------------


English translated :
-----------------------------
Window title : OpenOffice.org 1.1.0
Error during loading of the file document file:///C:/Documents%20and%20Settings/sav_on.PCL/Mes%20documents/ko.sxc:
Reading error.
Format error in the file sub-document content.xml, location 2,3444 (line,column)..
-----------------------------

Of course, the file IS present and NOT hidden, read-only or similar thing. I can still open it using Winzip, I can read the content, etc.

Last thing, I use CRASHREP to send similar information but didn't know at that time I can create an issue here. So you may have this information somewhere else.

That's it for now. Please carry on the GREAT job you've done with OO.

L.