Issue 82576 - Double blank in sheet name causes DDE link to default to first sheet
Summary: Double blank in sheet name causes DDE link to default to first sheet
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.3.0 RC1
Hardware: PC Windows, all
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2007-10-13 00:33 UTC by arasaka
Modified: 2017-05-20 11:11 UTC (History)
2 users (show)

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

Attachments
Foreign character in name of second sheet prevents DDE link in Writer (8.23 KB, application/vnd.sun.xml.calc)
2007-10-13 00:35 UTC, arasaka 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description arasaka 2007-10-13 00:33:31 UTC 
The document I will attach is a strip down to the one factor I was able to 
isolate that would cause this.

To see the issue:

Open the attached ODS file.
Open a new Writer document.
Copy a section from the second sheet labeled "Sommaire  par secteur" (Say A1 to 
B16)
Paste Special -> DDE link in the Writer document.
Marvel as data from the first sheet (Sheet1) is displayed in Writer.

To "fix" the issue:

Rename the second sheet lebeled "Sommaire  par secteur" to "Original", save, 
close, re-open. Copy and Paste Special -> DDE link in a new Writer document.

My guess is that a foreign character could have slipped in there as the 
original was written in French (some accent maybe).
Comment 1 arasaka 2007-10-13 00:35:41 UTC 
Created attachment 48869 [details]
Foreign character in name of second sheet prevents DDE link in Writer
Comment 2 Rainer Bielefeld 2007-10-14 10:49:36 UTC 
I checked with "2.3.0 RC3  Multilingual German version WIN XP:
[680m5(Build9221)]"  and can confirm the reported problem.

The problem seems to be the double blank in the sheet name. If I delete one of
the blanks between "Sommaire" and  "par" in the sheet name "Sommaire  par
secteur" DDE will work fine.

An other "workaround" is to "repair" the dde link in menu 'edit -> links' in the
WRITER document. You will see that there is only 1 blank between "Sommaire" and
 "par" in the "range" pane. If you add the second blank manually, the link will
work.

Framework issue?
Comment 3 frank 2007-10-15 14:45:19 UTC 
Hi Eike,

please have a look at this one. Re-target as needed.

Frank
Comment 4 arasaka 2008-09-16 15:06:49 UTC 
Tested in 2.4.1, still present.
Comment 5 ooo 2008-09-16 16:03:22 UTC 
Sure, it isn't fixed, so..
Comment 6 arasaka 2009-02-04 20:54:18 UTC 
Just a note to confirm that behaviour is identical in OOo version 3.0.1
Comment 7 Marcus 2017-05-20 11:11:40 UTC 
Reset assigne to the default "issues@openoffice.apache.org".