https://bugs.freedesktop.org/show_bug.cgi?id=58149
Priority: medium
Bug ID: 58149
Keywords: regression
Assignee: [email protected]
Summary: FILEOPEN: HYPERLINK formula functions set wrong URL
upon loading
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.0.0.beta1
Component: Spreadsheet
Product: LibreOffice
Since we now cache formula results in 4.0 and later, formula cells with
HYPERLINK function don't work properly unless the cells get re-calculated.
To reproduce, set in a cell
=HYPERLINK("http://google.com";, "Google!")
This shows "Google!" in that cell, and when you click on it, the browser gets
launched and you go to Google website.
Now, save that file and reload, and click that cell again. Now, you get an
error dialog indicating that "Google!" is not a valid URL etc.
This is due to the fact that HYPERLINK relies on the formula cell to contain
formula tokens, which it doesn't right after load, because we cache the result.
Operating System: All
Last worked in: 3.6.4.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
