Bug 123998 - hyperlinks to target sheets stopped working in Calc 6.2.0.3
Summary: hyperlinks to target sheets stopped working in Calc 6.2.0.3
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2019-03-11 13:00 UTC by kalakai
Modified: 2019-08-14 12:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
xlsx file (6.95 KB, application/zip)
2019-03-25 18:20 UTC, kalakai
Details
new .ods file (10.51 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-08-13 13:27 UTC, kalakai
Details
Working XLSX file (6.60 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2019-08-14 05:05 UTC, Buovjaga
Details

Note You need to log in before you can comment on or make changes to this bug.
Description kalakai 2019-03-11 13:00:07 UTC
Description:
hyperlinks to external web pages work fine
hyperlinks to local files works fine
hyperlinks to specific sheets in a file do not work.  the file is opened, but not the the 'target' sheet
hyperlinks to different sheets in same worksheet no longer work

I've tried abling/disabling the 'ctrl click' security feature, deleting and recreating the hyperlink, creating new hyperlinks all without success

Steps to Reproduce:
1.insert hyperlink/document/target in document
2.ok
3.click on hyperlink

Actual Results:
local file opens, but not to target sheet or will no go to target sheet in current worksheet

Expected Results:
open new file at target sheet or go to target sheet in current file


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 raal 2019-03-12 07:30:57 UTC
works for me in Version: 6.3.0.0.alpha0+
Build ID: 732d630c3d2a168c725c18e4dd8df7a0a4f85566
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Tested: hyperlinks to different sheets in same worksheet

Seems to be fixed with dev version. Please could you test it with
dev version?  You can download it here:
http://dev-builds.libreoffice.org/daily/master/
Thank you
Comment 2 kalakai 2019-03-12 11:01:46 UTC
(In reply to raal from comment #1)
> works for me in Version: 6.3.0.0.alpha0+
> Build ID: 732d630c3d2a168c725c18e4dd8df7a0a4f85566
> CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
> Tested: hyperlinks to different sheets in same worksheet
> 
> Seems to be fixed with dev version. Please could you test it with
> dev version?  You can download it here:
> http://dev-builds.libreoffice.org/daily/master/
> Thank you

Sorry, I'm not an 'expert' at this sort of this.  I tried to download what I thought was the correct file (https://dev-builds.libreoffice.org/daily/master/Win-x86@42/2019-03-10_23.54.40/libo-master~2019-03-10_23.54.40_LibreOfficeDev_6.3.0.0.alpha0_Win_x86.msi), but Windows Defender would not let me run the file. I understand I may have to 'allow' it to run, but wanted to confirm I have the correct link.

would you post direct link to the update you are referring to?
Comment 3 kalakai 2019-03-12 14:03:14 UTC
I installed 6.3, but the problem is still there.  I'm going to just go back to 6.1.5 and leave this to the experts ;)

Thanks!
Comment 4 kalakai 2019-03-12 14:36:33 UTC
Well I uninstalled both 6.3 and 6.2, went back to 6.1.5 and it still didn't work.

It worked fine before my last upgrade....

I just installed 6.2.1 and still doesn't work...

I give up ;)
Comment 5 kalakai 2019-03-12 18:01:09 UTC
Also, every time I close and re-open the file, it adds another '#targetsheetname' to the address on the hyperlink as well as a random prefix on the last one....


file:///C:/users/name/documents/filename.xlsx#targetsheet#targetsheet%23targetsheet
Comment 6 raal 2019-03-24 22:27:47 UTC
Please attach test file. Tried again with .xlsx and target in document works for me in LO 6.3.
Comment 7 kalakai 2019-03-25 12:26:18 UTC
Since I went back to 6.2.1.2, I don't think it has a test file.  6.3 didn't work for me either.  Is there some other log file I could send? 

If I save as ODS, it works fine.
If I save as current xlsx, it doesn't work on target in same file, but will open a different file to the target.
If I save as xls, it opens up a new worksheet of the same file and goes to the target sheet.
Comment 8 raal 2019-03-25 17:55:43 UTC
(In reply to kalakai from comment #7)
> Since I went back to 6.2.1.2, I don't think it has a test file.  6.3 didn't
> work for me either.  Is there some other log file I could send? 
> 
> If I save as ODS, it works fine.
> If I save as current xlsx, it doesn't work on target in same file, but will
> open a different file to the target.
> If I save as xls, it opens up a new worksheet of the same file and goes to
> the target sheet.

Then attach .ods file. If I understand correctly, then resave as .xlsx will show the bug?
Comment 9 kalakai 2019-03-25 18:20:01 UTC
Created attachment 150280 [details]
xlsx file

note the additional characters Calc has added to the target sheet name...I entered nothing, only selected '2' on the drop down menu.
Comment 10 Buovjaga 2019-08-13 10:59:53 UTC
(In reply to kalakai from comment #9)
> Created attachment 150280 [details]
> xlsx file
> 
> note the additional characters Calc has added to the target sheet name...I
> entered nothing, only selected '2' on the drop down menu.

Please attach the original ODS file
Comment 11 kalakai 2019-08-13 13:27:53 UTC
Created attachment 153340 [details]
new .ods file

I have since updated to Version: 6.2.5.2 (x64).  Before, nothing happened, now I get an error.

* links to web or other local files work fine
* link to specific sheet in an xlsx or ods file generates following error

"file:///C:/Users/Guy/Desktop/link%20to%20sheet%20problem.xlsx#Sheet2" is not an absolute URL that can be passed to an external application to open it.
Comment 12 kalakai 2019-08-13 13:30:10 UTC
(In reply to Buovjaga from comment #10)
> (In reply to kalakai from comment #9)
> > Created attachment 150280 [details]
> > xlsx file
> > 
> > note the additional characters Calc has added to the target sheet name...I
> > entered nothing, only selected '2' on the drop down menu.
> 
> Please attach the original ODS file

updated file uploaded.
comments above this reply

thx
Comment 13 Buovjaga 2019-08-14 05:05:55 UTC
Created attachment 153370 [details]
Working XLSX file

Thanks for the file. It seems there was something weird in your file: I was able to reproduce the problem, when saving it to XLSX and modifying the link. Yet, when I did the linking in a completely new file, there was no problem.

See the attached file and test it.

Version: 6.4.0.0.alpha0+ (x64)
Build ID: ed882d693f37779e3a09641e7cd43b7a925d2312
CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2019-07-25_00:58:18
Locale: fi-FI (fi_FI); UI-Language: en-US
Calc: threaded
Comment 14 kalakai 2019-08-14 10:24:03 UTC
(In reply to Buovjaga from comment #13)
> Created attachment 153370 [details]
> Working XLSX file
> 
> Thanks for the file. It seems there was something weird in your file: I was
> able to reproduce the problem, when saving it to XLSX and modifying the
> link. Yet, when I did the linking in a completely new file, there was no
> problem.
> 
> See the attached file and test it.
> 
> Version: 6.4.0.0.alpha0+ (x64)
> Build ID: ed882d693f37779e3a09641e7cd43b7a925d2312
> CPU threads: 4; OS: Windows 10.0; UI render: default; VCL: win; 
> TinderBox: Win-x86_64@42, Branch:master, Time: 2019-07-25_00:58:18
> Locale: fi-FI (fi_FI); UI-Language: en-US
> Calc: threaded

* The file you created works fine for me.
* I see you are creating the link without file name/location.  I tried this on your sheet and it works fine.  
* I tried same on my original sheet and works fine

seems it was user error ;)

thanks so much for helping out!
Comment 15 Buovjaga 2019-08-14 12:02:26 UTC
(In reply to kalakai from comment #14)
> * The file you created works fine for me.
> * I see you are creating the link without file name/location.  I tried this
> on your sheet and it works fine.  
> * I tried same on my original sheet and works fine
> 
> seems it was user error ;)
> 
> thanks so much for helping out!

I actually created it by picking it from the dropdown menu, but then the name disappeared later.

I guess we should close and be happy