Issue 59451 - DDE link corrupts number depending on source format language
Summary: DDE link corrupts number depending on source format language
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2005-12-16 15:52 UTC by jamescrompton
Modified: 2014-03-19 02:42 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Source file for links (7.16 KB, application/vnd.sun.xml.calc)
2005-12-16 15:52 UTC, jamescrompton
no flags Details
sample of corruption at destination (7.02 KB, application/vnd.sun.xml.calc)
2005-12-16 15:54 UTC, jamescrompton
no flags Details
Corruption by format in DDE link, single file source and destination (7.96 KB, application/vnd.sun.xml.calc)
2005-12-19 10:12 UTC, jamescrompton
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description jamescrompton 2005-12-16 15:52:06 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
Comment 1 jamescrompton 2005-12-16 15:52:55 UTC
Created attachment 32493 [details]
Source file for links
Comment 2 jamescrompton 2005-12-16 15:54:30 UTC
Created attachment 32494 [details]
sample of corruption at destination
Comment 3 lars 2005-12-16 17:57:33 UTC
for me the destination file shows the correct numbers with OOo 2.0.1 RC5 on 
Windows XP Pro SP2
Comment 4 jamescrompton 2005-12-19 10:08:33 UTC
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.
Comment 5 jamescrompton 2005-12-19 10:12:02 UTC
Created attachment 32555 [details]
Corruption by format in DDE link, single file source and destination
Comment 6 lars 2005-12-19 17:50:02 UTC
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
Comment 7 frank 2006-02-01 11:19:45 UTC
Hi Eike,

please have a look at this Issue.

Comment 8 ooo 2008-05-30 16:03:36 UTC
Propably not doable in time frame for 3.0, retargeting to 3.x
Comment 9 Rainer Bielefeld 2014-03-17 15:43:10 UTC
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