https://bugs.freedesktop.org/show_bug.cgi?id=87534
--- Comment #7 from [email protected] --- I don't agree with your conclusion, because I'm not talking about references to cells containing hyperlinks. I do not expect those cells to pick up the hyperlink "special functionality". The best comparison is to another function that has this kind of special functionality, STYLE. If I set C1 to =1+STYLE("heading") and A1 to =C1, then A1 gets C1's value, but not its style. That's consistent with the behavior of HYPERLINK, and it's fine. However, I can define a name "hdg" as STYLE("heading") and set C1 =1+hdg, and C1 is formatted as a heading. What I cannot do, and what this bug's about, is define a name "jumptoa1" as HYPERLINK("#A1"), set C1 =1+jumptoa1, and then have C1 be a link. So if I set C1 =1+hdg+jumptoa1, C1 gets the style from hdg but not the hyperlink from jumptoa1. I have to explicitly set C1 to =1+hdg+HYPERLINK("#A1"). That's what I mean by "HYPERLINK call in a name does not work". It isn't a matter of reference to a cell containing a hyperlink, it's a matter of it not working if the HYPERLINK call is in a name. I make heavy use of names as (non-parameterizable) macros If I set A1 =C1, it gets neither the hyperlink nor the style special functionality from C1. That's fine and makes perfect sense. -- 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
