Apache OpenOffice (AOO) Bugzilla – Issue 59451
DDE link corrupts number depending on source format language
Last modified: 2014-03-19 02:42:02 UTC
If I link a cell in one file to a cell in another file containing the result of a calculation, what arrives in the destination file may or may not be be a number and may or may not be the same as the one in the source file. Whether it is or not depends on the formatting of the number in the source file. For example, in one of my files a link to a calculation result formatted with (German) #.##0" ";#.##0- only functions correctly if the number is either positive or less than -1000. Three digit negative numbers arrive as positive numbers. It doesn't necessarily help to give the destination cells the same formatting.
Created attachment 32493 [details] Source file for links
Created attachment 32494 [details] sample of corruption at destination
for me the destination file shows the correct numbers with OOo 2.0.1 RC5 on Windows XP Pro SP2
Maybe it has something to do with the default language settings. If I make a DDE link to cells formatted in English (my default language) then the negative ones arrive correctly. The positive ones are still interpreted as string values because of the trailing space in the formatting (as can be seen from the alignment, from the value given as the SUM in the staus bar, and by peering at content.xml in the saved file). I'll upload a file with both English and Geman formatted examples.
Created attachment 32555 [details] Corruption by format in DDE link, single file source and destination
confirmed. First of all rename the '3rd attachement ddeTest.ods' source.ods. Then put it into the directory C:\Documents and Settings\James\Desktop. Then open it. You will see that the destination sheets column F shows the wrong result for the first three rows. The language format there is English (Australia). Column C shows the values correctly; language there is German (Germany) (btw. why can't I "change only part of an array"? I can't edit the formula at all!). So confirmed on Windows XP Pro SP2 with OOo 2.0.1 RC5
Hi Eike, please have a look at this Issue. frank
Propably not doable in time frame for 3.0, retargeting to 3.x
This one is not Trivial", but makes CALC DDE links useless for many applications Works fine with DDE-Links from Writer target to Calc Source Works fine with LibO 4 Back to list because Eike is active for LibreOffice only