[Libreoffice-bugs] [Bug 97805] Hyperlinks fail after file save to .xlsx format

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=97805

--- Comment #6 from Richard Harrowell <rh at harrowell.com> ---
The bug is still present in 6.0.1.1 and 6.0.2.1

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:

=HYPERLINK("http://google.com","Google")

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 6.0.1.1 and 6.0.2.1. 

Windows 8.1 Pro 64 bit
Version: 6.0.2.1 (x64)  (and 6.0.1.1 x64)
Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89
CPU threads: 6; OS: Windows 6.3; UI render: default; 
Locale: en-AU (en_AU); Calc: group

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180315/d68d2220/attachment.html>