[Libreoffice-bugs] [Bug 33067] Hyperlink to Sheet with name like cell reference will lead to cell instead to sheet

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=33067

Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|Hyperlinks                  |Hyperlink to Sheet with
                   |                            |name like cell reference
                   |                            |will lead to cell instead
                   |                            |to sheet
             Status|RESOLVED                    |REOPENED
  Status Whiteboard|Infoprovider:kevinsjunk at tis |CONFIRMED
                   |cali.co.uk                  |
           Keywords|NEEDINFO                    |
         Resolution|WORKSFORME                  |
         AssignedTo|libreoffice-bugs at lists.free |kohei.yoshida at gmail.com
                   |desktop.org                 |
                 CC|                            |dtardon at redhat.com

--- Comment #8 from Rainer Bielefeld <LibreOffice at bielefeldundbuss.de> 2011-09-20 23:02:02 PDT ---
Can simply be reproduced Server installation of Master "LibO-dev 3.5.0 – WIN7
Home Premium (64bit) English UI [(Build ID: 81607ad-3dca5fd-da627d2)]":

1. Open new CALC document and save it as Testdocument.ods
2. Rename Sheet 2 to "BT311210"
3. Sheet1 A1: type xxx
4. <Control+a> to select a
5. Toolbar icon Hyperlink
   Hyperlink dialog opens
6. Click 'Document'
   Document related info appears in dialog
7. Click 'Target in Cocument'
8. Select 'Sheets'
9. Select sheet "BT311210"
11. <Apply>  then <Close>
12. <Apply>  then <Close>
    Now you have Text "xxx" with hyperlink in A1
14 Click hyperlink
   Expected: Jumps to Sheet "BT311210"
   Actual: Jumps to Cell "BT311210" on Sheet 1

To be honest, I never thought about necessity to distinguish between links to
cells and links to sheets, to be honest, I even did not know that it is
possible to create a link to a Cell. But When I created a link to a Sheet using
dialogs, the result should be the expected link and nothing else.

OOo Heritage, same issue with OOo 3.1.1

New / confirmed due to my results and tester8's confirmation


@kevinsjunk:
A Bug remains a bug also if it's no longer a problem for you

@David:
Would be interesting to know what the ODF definition says - you can help?
BTW, I would really like to know wht "impex" on
<http://wiki.documentfoundation.org/FindTheExpert> might mean

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.