Issue 94764

Summary: hyperlink to wrong sheet, wrong cell
Product: Calc Reporter: tab <tab>
Component: codeAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, rainerbielefeld_ooo_qa
Version: OOo 2.4.1Keywords: oooqa
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
File with hyperlinks
none
file with hyperlink targets none

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
@tab:
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.