Issue 59451

Summary: DDE link corrupts number depending on source format language
Product: Calc Reporter: jamescrompton <james>
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P3 CC: alwynwellington, issues, lars_o_hansen, rainerbielefeld_ooo_qa
Version: OOo 1.0.0Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
Source file for links
none
sample of corruption at destination
none
Corruption by format in DDE link, single file source and destination none

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
formatting.
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.

frank
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