https://bugs.freedesktop.org/show_bug.cgi?id=87534
--- Comment #6 from Winfried Donkers <[email protected]> --- (In reply to Robinson Tryon (qubit) from comment #5) > Winfried: Thoughts? Well, here are some of my thoughts: I may fail to see the problem, so correct me if I'm wrong. IMO the function HYPERLINK works as it should be (see http://docs.oasis-open.org/office/v1.2/cos01/OpenDocument-v1.2-cos01-part2.html#__RefHeading__1018226_715980110). References to cells containing HYPERLINK function do not work as expected. It has not to do with named cells. With the attachment, enter =C1 in cell A2 and the cell seems to contain a link, but it doesn't work as such. The cells A1 and A2 show the result of the cell being referred to, but do not have the functionality the a cell containing a HYPERLINK function has. I suggest that the title of this bug report be changed if you agree with my conclusion. I haven't found out (yet) whether the ODF standard says that references like this are supposed to take over the behaviour as well as the result of the cell being referred to. I agree that taking over the behaviour of the cell being referred to is more intuitive than the current situation. At a first glance, changing this seems complicated: the formula compiler gives special functionality (act as hyperlink, see http://opengrok.libreoffice.org/xref/core/formula/source/core/api/FormulaCompiler.cxx#1207) to the cell containing the formula HYPERLINK. Cell A1 and A2 do not contain this function and to make the formula compiler give this special functionality to cells A1 and A2, it needs to interpret every reference first, with the result that cells with references are interpreted twice (first to check if the reference contains a cell with hyperlink functionality, secondly to calculate the result.). As the reference can be indirect (e.g. cell A2 referring to cell B2 which refers to cell C1), it is not a simple first interpret action. Before I dig deeper, does my rambling seem correct/logical? -- 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
