Issue 101935 - CALC: Jump from URL to Sheet is wrong when sheet-name is of numbers
Summary: CALC: Jump from URL to Sheet is wrong when sheet-name is of numbers
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.0.1
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2009-05-14 20:21 UTC by mhatheoo
Modified: 2013-01-29 21:52 UTC (History)
2 users (show)

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

Attachments
test file - see sheet2 with hyperlinks (6.59 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-05-15 08:10 UTC, raal 		no flags Details
the sample-dbf (577 bytes, text/plain)
2009-08-20 19:04 UTC, mhatheoo 		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 mhatheoo 2009-05-14 20:21:31 UTC 
supposed you rename a sheet with numbers only - like an article-number with
12345 -and

-- you navigate to that sheet from Navigator: all functions well

-- you set a "Jump-to" URL to that sheet somewhere in another sheet 
it will not work - the number will be treater as a row-number within the actual
sheet, and you will jump there

Martin
Comment 1 Regina Henschel 2009-05-14 21:55:06 UTC 
Please describe how do you "set a Jump-to URL" and please a spreadsheet with one
working version and one not working version.

I can name a cell in such a table and insert a hyperlink to that named cell via
Insert > Hyperlink > Target in Document.
Comment 2 raal 2009-05-15 08:09:16 UTC 
DEV300m47
Creste hyperlink:
Insert -  hyperlink - Document - Target in document
Sheets - 11212 - Apply

After click on hyperlink it refers to sheet cell number 11212, no to sheet with
name 11212.
Comment 3 raal 2009-05-15 08:10:31 UTC 
Created attachment 62281 [details]
test file - see sheet2 with hyperlinks
Comment 4 Regina Henschel 2009-05-15 22:31:02 UTC 
The link works, if you set the reference '12345'.a1 manually.

The automatic should produce complete references and should set the necessary
apostrophes, if you select a sheet in the "Target in Document"-dialog.
Comment 5 mhatheoo 2009-05-17 22:45:30 UTC 
==> regina

it is exactly as RAAL described it - it should work, but it does not.
may be you can rename the the sheet-labels to text, which is not really an
option in here,
but not with a leading " ' " in the label - that is not allowed,
and not with bracketing the label in the jump-start-url with ' 
 - that does not not work either.

Martin
Comment 6 mhatheoo 2009-08-20 19:04:14 UTC 
Created attachment 64274 [details]
the sample-dbf