Ask Your Question
0

Hyperlink to Yahoo charts error following close and open of file - Calc v5.2

asked 2016-11-10 13:12:46 +0100

jamesb gravatar image

updated 2016-11-10 13:15:27 +0100

Hi

Has anyone come across this behaviour in Calc?

  • Ensure macros are enabled
  • Create cell entry to a Yahoo thus:

=HYPERLINK(CONCATENATE("http://finance.yahoo.com/chart/",T(C18),"#eyjtdwx0aunvbg9ytgluzsi6zmfsc2usimjvbgxpbmdlclvwcgvyq29sb3iioiijztiwmdgxiiwiym9sbgluz2vytg93zxjdb2xvcii6iim5ntuyzmyilcjzag93u21hijp0cnvllcjzbwfdb2xvcnmioiijzjaxmjzmiiwic21hugvyaw9kcyi6ijuwiiwic21hv2lkdghzijoimsisinntyudob3n0aw5nijoimcisinnob3dfbweionrydwusimvtyunvbg9ycyi6iimxywm1njcilcjlbwfqzxjpb2rzijointailcjlbwfxawr0ahmioiixiiwizw1hr2hvc3rpbmcioiiwiiwibwzptgluzunvbg9yijoiizq1ztnmziisim1hy2reaxzlcmdlbmnlq29sb3iioiijzmy3yjeyiiwibwfjze1hy2rdb2xvcii6iim3oddkodiilcjtywnku2lnbmfsq29sb3iioiijmdawmdawiiwicnnptgluzunvbg9yijoii2zmyjcwmcisinn0b2nos0xpbmvdb2xvcii6iinmzmi3mdailcjzdg9jaermaw5lq29sb3iioiijndvlm2zmiiwicmfuz2uioii1esj9"),"Yahoo")

...where cell C18 contains the value "TCM.L" or any other stock ticker/code.

  • Check the hyperlink works - it does!
  • Save the file and open it again
  • Check the hyperlink again - it fails with

"Yahoo" is not an absolute URL that can be passed to an external application to open it.

Is there some limit to the hyperlink statement length? There seem to be 705 characters in it. What else might be going on?

I'm running CentOS7, Gnome desktop and LibreOffice 5.2.

Thanks! :-)

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
0

answered 2016-11-16 18:12:15 +0100

jamesb gravatar image

Hi Ratslinger

Thanks for taking the time to look at this. Oddly, even using your suggestion, the link fails to remain working between saves of the file.

Simply by removing the last bracket in the statement, and hitting enter (allowing Calc to correct the entry) the link then works fine.

I just can't fathom this out. I'm totally stumped!! I feel it's going to be something simple, but I can't find it...

:-)

edit flag offensive delete link more
0

answered 2016-11-10 17:10:41 +0100

Ratslinger gravatar image

Been trying for an hour different ways to reproduce on Mint 17.3 Cinnamon w/LO 5.2.0.4 and can't get it to fail.

Also, I get same exact results with:

=HYPERLINK(CONCATENATE("http://finance.yahoo.com/chart/",T(C18)),"Yahoo")

May want to try.

edit flag offensive delete link more

Comments

Unfortunately, even with some obscure settings I can't reproduce. The only suggestion I can offer is reset the user profile - click here. Please post if you find answer no matter what it may be.

Ratslinger gravatar imageRatslinger ( 2016-11-16 20:04:24 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-11-10 13:12:46 +0100

Seen: 24 times

Last updated: Nov 16 '16