Not quite what we're looking for.
So I get the link detail only when I copy from a (range of) cells from an on line sheet and perform a special (link) paste into another on line sheet.
The result is a function in the target cell that has a URL which points precisely to the source range of cells.
So far so good.
But: I cannot paste the same URL into a link I am setting up in the laptop Apps: Word, Excel, etc.
The Use Case we're needing to have supported is this:
I have a sharepoint located (on line) sheet listing data. The data consists of records, each record having some kind of significance.
Now I am writing an e-mail or Word docuument. Or I am creating a PPT. And I want to say: "... for this topic see such-and-such in the Record Log on Sharepoint."
And now I want the words 'such-and-such' to be the text of a web link with the link being the URL pointing to the (range of) cells in the sharepoint sheet.
The functionality developed so far, does not support this Use Case and for me, it is largely useless.