The bug mentioned in the "Summary" can be replicated as follows:
1) Paste the following hyperlink into cell A1 of a newly created spreadsheet:
2) Test to see that the hyperlink works by ctrl-clicking on it
3) Save the document as an ".xlsx" spreadsheet
4) Test to see that the hyperlink works by ctrl-clicking on it
5) Quit out of Calc
6) Re-launch Calc
7) Open the previously saved spreadsheet
8) Test to see that the hyperlink works by ctrl-clicking on it. It won't work, but a dialog box with the following will be generated:
"GOOG" is not an absolute URL that can be passed to an external application to open it.
dp: set the version to the earliest version you saw this bug in.
Note for testers: for me, it was =HYPERLINK("http://www.google.com?t=GOOG";"GOOG") with the semicolon.
Win 7 Pro 64-bit Version: 220.127.116.11.alpha0+
Build ID: a6f876d45bd4e41a7143594a6cb11b6893a0f620
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default;
TinderBox: Win-x86@39, Branch:master, Time: 2016-02-11_00:07:38
Locale: fi-FI (fi_FI)
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice
(5.2.5 or 5.3.0 https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and
your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave
a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not
appropriate in this case)
If you want to do more to help you can test to see if your issue is a REGRESSION. To do so:
1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3)
2. Test your bug
3. Leave a comment with your results.
4a. If the bug was present with 3.3 - set version to "inherited from OOo";
4b. If the bug was not present in 3.3 - add "regression" to keyword
Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa
Thank you for helping us make LibreOffice even better for everyone!
Bug is still present in Libreoffice Calc Version: 18.104.22.168 on Ubuntu 14.04 (32 bit).
*** Bug 114453 has been marked as a duplicate of this bug. ***
Created attachment 138797 [details]
Demo made with LibO V22.214.171.124Beta2
Induced by a thread in the ask.libreoffice.org/en I created the atteched file with LibO V126.96.36.199Beta2. The bug was still alive.
The same document originally saved to .ods did not show any issues.
Reloading the .xlsx version, saving it to .ods now, and loading it again resulted in:
-1- The link provided by HYPERLINK() worked again.
-2- The single link in one cell worked again but was displayed with an expanded anchor text.
-3- The two links in one cell both did not work nor were they displayed in a hyperlink format, but with light blue text color.
If somebody is interested I will aslo attach the two versions in .ods.
The bug is still present in 188.8.131.52 and 184.108.40.206
Just some more information:
Any hyperlink stored with the optional CELLTEXT argument will not work upon loading from .xlsx or xlsm formats. .xls and .ods formats work fine.
In all cases, if you left click on the cell, the tooltip shows the CELLTEXT instead of the hyperlink and a Ctrl-Click will try and jump to the CELLTEXT contents as a hyperlink.
Edit anything in the hyperlink path - for example backspace over the "h" in "http" and retype "h". Save the cell edit. It now works.
Save as .xlsx, close Calc and reopen. Bug back again.
I was using a Calc spreadsheet with one single cell containing:
Without the CELLTEXT argument, the hyperlink works fine.
As an extra note, the Help states the ';' character is the separator in the HYPERLINK arguments, but this is now automatically changed to a "," character in 220.127.116.11 and 18.104.22.168.
Windows 8.1 Pro 64 bit
Version: 22.214.171.124 (x64) (and 126.96.36.199 x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 6; OS: Windows 6.3; UI render: default;
Locale: en-AU (en_AU); Calc: group
This bug seems to be fixed in 188.8.131.52, installed from the website, running on Ubuntu 18.04. It's still present in the version that comes packaged with Ubuntu LTS: 184.108.40.206
So if any Ubuntu users come across this, you can just grab the latests release from here and you're good to go: https://www.libreoffice.org/download/download/
(In reply to Roel from comment #7)
> This bug seems to be fixed in 220.127.116.11, installed from the website, running
> on Ubuntu 18.04. It's still present in the version that comes packaged with
> Ubuntu LTS: 18.104.22.168
Thanks a lot for testing. Let's close.