Issue 123056 - After/during execution of particular Basic macros, hyperlinks to cells will not work
Summary: After/during execution of particular Basic macros, hyperlinks to cells will n...
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: 3.4.0
Hardware: All Windows 7
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needmoreinfo
Depends on:
Reported: 2013-08-18 13:20 UTC by sevalav
Modified: 2013-10-08 07:17 UTC (History)
4 users (show)

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

Open this document, inside are instructions (484.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-08-18 13:20 UTC, sevalav
no flags Details
Test2 (8.77 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-09-08 23:53 UTC, sevalav
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sevalav 2013-08-18 13:20:49 UTC
Created attachment 81351 [details]
Open this document, inside are instructions

Button has URL RAČUNI.A1. When selected cell is RAČUNI.A1, and we with scroll bar look another part of the same sheet (the cell RAČUNI.A1 is now unvisible), and we want to press button with URL RAČUNI.A1, as the result nothing will be happens. It should do that the cell RAČUNI.A1 is again visible.
In LO it works good.

I am using AOO400m3(Build:9702)  -  Rev. 1514218, Win 7 x64.
Comment 1 Rainer Bielefeld 2013-08-18 14:37:23 UTC
Reported effect is Reproducible with  "AOO 4.0.0 – German UI / German locale  [AOO400m3(Build:9702)  -  Rev. 1503704 2013-07-16 14:54:56 (Di, 16 Jul 2013)]" on German German WIN7 Home Premium (64bit)", Common 4.0-dev User Profile

But is that an AOO bug? Problem has nothing to do with buttons or similar.

Steps how to reporduce:

1. Open sample document
2. Click big green button as requested in document
   > Cell cursor appears at cell A1 in same sheet
3. Click button "PREGLED" as requested in document
   > view jumps back so that big green button becomes visible again
4. Click big green button
   Expected: Jumps again
   Actual: nothing

What happens:
{2}: A hyperlink moves cell cursor to RAČUNI.A1
{3}: A macro "MAKROI.RACUNI.POzicionirajRacunPregled" does something
{4}: Hyperlink now will not work

Additional information
a) In reporter's sample in cell AI1 I added a new text hyperlink "#RAČUNI.A1",
   what should do the same job as the big green button.
   Same test result: in Step 4 the hyperlink will not work.
b) same problem with server installations of AOO 3.4.1, OOo 3.3.0
c) Same problem with LibO 4.0.3
d) OOo 3.1.1 finds syntax error in Macros, I can't tell whether related
e) Workaround: click any cell before you proceed step 4
f) BTW, with AOO 3.3.0 I have to click on any cell before I proceed step 
   2, otherwise link will not work at all
g) so my current suspect is that the problem might be "somehow" macro related.
   After I had removed Document-Open-Event-Macro-Execution, at least the
   AOO 3.3.0 problem in step 2 disappeared
   So Component "programming" for now.
h) Only Hyperlinks leading to cells seem to be affected, Hyperlins to Cell 
   range with name or internet page work fine in step 4
i) Wrong macro code or wrong macro execution? I can't tell

Can you please do some investigation concerning macros in document and tell us your results?
Comment 2 sevalav 2013-08-18 18:59:31 UTC
Problem has nothing to do with buttons or similar.
Maybe you are in right. The important thing is that there is some problem.
I tested on Win7 x64 LO  ver. .4.2 . There I can not reproduce this problem.
Comment 3 Oliver-Rainer Wittmann 2013-08-21 11:00:14 UTC
according comment 1 the observed behavior also occurs in former versions
--> adjusting field Version accordingly.
Comment 4 Oliver-Rainer Wittmann 2013-08-21 11:14:15 UTC
Confirming on Windows 7 in AOO 4.0.0.
--> status CONFIRMED, remove keyword 'needmoreinfo'

Works fine in AOO 3.4.1
--> add keyword 'regression'
Comment 5 Oliver-Rainer Wittmann 2013-08-21 11:16:44 UTC
(In reply to Oliver-Rainer Wittmann from comment #4)
> Confirming on Windows 7 in AOO 4.0.0.
> --> status CONFIRMED, remove keyword 'needmoreinfo'
> Works fine in AOO 3.4.1
> --> add keyword 'regression'

I am very sorry. I made these changes to the wrong issue.
--> reverting.
Comment 6 sevalav 2013-09-08 23:52:31 UTC
In file "test2" are two buttons with URL. 
button 1 has URL #Sheet1.AD1
button 2 has URL #Sheet1.A1

Select cell #Sheet1.A1
When cell A1 is selected go to button 2 with using scroll bar (button 2 is in AE2).
Push button 2 (Url is #Sheet1.A1)
Nothing happens.
This happens only when URL targget is already selected.
Comment 7 sevalav 2013-09-08 23:53:10 UTC
Created attachment 81483 [details]
Comment 8 sevalav 2013-09-09 00:13:01 UTC
Conclusion: hiperlink (jumping to the URL cell target) do not working if URL target (some cell in spreadsheet) is already selected. 
That occurs when:
1 Button and his URL cell target are in the same sheet 
2 URL cell target is already selected
3 Button is visible on screen and cell-target is not visible
Comment 9 Edwin Sharp 2013-10-08 07:17:52 UTC
As given in comment 6.

AOO410m1(Build:9750)  -  Rev. 1525015
Win 7