Open a calc spreadsheet and save it. On the Sheet1, enter some text in a cell.
Insert Sheet2 in spreadsheet. Goto Insert > Hyperlink > Document > Path and select the current spreadsheet.
In Same Hyperlink Dialog > Further settings > Text > input the anchor text. Click Apply > Close.
Now We want to be able to set the *cell contents* itself as hyperlink like excel does, without needing separate anchor text.
and be able to edit the anchor text of the hyperlink in the cell itself, like excel allows it.
see also closely related Bug 87957
Ok, set to enhancement.
Win 7 Pro 64-bit Version: 22.214.171.124.alpha0+
Build ID: b13534de022972131b46f93f5ada90af155eec9e
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-02-19_00:21:37