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

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! :slight_smile:

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.

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.

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…

:slight_smile: