GNOME Bugzilla – Bug 128534
Unable To Access URL Actions From a Referencing Cell
Last modified: 2009-12-30 22:45:39 UTC
When I set up a reference to a cell on another sheet, or the same sheet for that matter, that is set up to go to a URL (or a mailto: which is what I really want), I would like to be able to click on the referencing cell and have it take the same action as the referenced cell would take if I clicked on it directly. P.S. This is my first bug report. Be gentle.
An interesting idea, but I'm not clear on the semantics. What would happen with expressions that involve the link ? =cell_with_link+1
That's a good question. I've never tried to use a URL in any kind of cell formula. I suppose that one way would be to handle URLs as absolute references but I don't know if that would be appropriate in all cases. Can you suggest a formula where that would not work?
I think we should extend CELL such that CELL("url",address) returns the url attached to the cell at address. Then if hyperlink were working correctly (see bug 81718) =hyperlink(CELL("url",address)) would cause this cell to have the same url action as the cell at address.
I have added GET.LINK (in analogy to GET.FORMULA). So in theory =hyperlink(get.link(address)) would attach the link from address to the current cell. Of course thanks to bug 81718 this does not work yet. *** This bug has been marked as a duplicate of bug 81718 ***