Issue 94764 - hyperlink to wrong sheet, wrong cell
Summary: hyperlink to wrong sheet, wrong cell
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 2.4.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: oooqa
Depends on:
Reported: 2008-10-08 04:05 UTC by tab
Modified: 2013-01-29 21:52 UTC (History)
2 users (show)

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

File with hyperlinks (11.15 KB, text/plain)
2008-10-09 02:48 UTC, tab
no flags Details
file with hyperlink targets (8.84 KB, text/plain)
2008-10-09 02:49 UTC, tab
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tab 2008-10-08 04:05:42 UTC
I set a hyperlink to a spreadsheet SS with sheets '2002', '2003', ... one for
each year. I specified sheet '2007' as target within the document.
When I click on the hyperlink (The address is ...SS#2007), spreadsheet SS is
opened at the first sheet (2002) at cell A2007, which is way down the existing data.
Comment 1 Rainer Bielefeld 2008-10-08 16:09:00 UTC
Please attach a sample document!
Comment 2 tab 2008-10-09 02:48:46 UTC
Created attachment 57074 [details]
File with hyperlinks
Comment 3 tab 2008-10-09 02:49:46 UTC
Created attachment 57075 [details]
file with hyperlink targets
Comment 4 Rainer Bielefeld 2008-10-09 06:14:27 UTC
I checked with "Ooo 3.0.0 RC3 Multilingual version English  UI WIN XP: [OOO300m8
(Build9357)]" and can confirm the reported effect.
Same bad result with 2.4.1

Steps to reproduce:
1. Download "LinkSS.ods" and save it on HDD
2. Open new text document and save in same folder as "LinkSS.ods"
3. Type "Testlink"
4. Doubleclick on word "Testlink"
5. Menu 'Insert -> Hyperlink -> Document -> Open File -> Browse for "LinkSS.ods" 
   and select -> Target in Document -> Sheets -> Select "2005" and <apply>
6.   Close Target dialogue
7. <apply> and <close> Hyperlink dialogue
8. <cntrl>+click on word "Testlink"
   expected: "LinkSS.ods" should eb opened with active sheet "2005" 
   actual: "LinkSS.ods" should eb opened with active sheet "2002"

Hyperlink to Name Range 2005 (in sheet 2005) will work fine

You will get the same result with links from a CALC document

I believe that I already saw a report for this problem, but I can't find that
other issue.
Comment 5 michael.ruess 2008-10-16 14:04:19 UTC
This does not look like a typical "Framework" issue, it is more located in
Writer or Calc handling the hyperlink.
MRU->ES: could you please have a look whether this is more a problem in Writer
handling the link or if perhaps Calc is interpreting this incorrectly. Thanks!
Comment 6 eric.savary 2008-10-16 14:39:19 UTC
As Rainer said, the same happens with hyperlinks inside of Calc. So the problem
is how to reference correctly to File-Sheet-Area in Calc = Calc problem.
Bug or user error? I don't know.

@OC: please take over.
Comment 7 Rainer Bielefeld 2008-10-16 15:28:12 UTC
Definitively a bug, the hyperlink dialogue offers to select a sheet from the
selection, but the hyperlink will not work.
Comment 8 hosseini 2009-03-31 09:37:13 UTC
I carried out exactly the same steps that "rainerbielefeld" has mentioned and it
worked in the second time as in the first time the hyper text was not on the
word "Testlink" so I had to do it all over again, thin it was fine. So the point
is just to reference the link correctly.