Created attachment 113615 [details]
Examples of hyperlinks added to cells containing formula and number.
The Hyperlink Window GUI feature of CALC does not permit adding a hyperlink to a cell containing a Number/Formula. The only way to achieve this is manual entry of the =HYPERLINK() formula, which is time consuming and error-prone where numerous cells are involved. I'm in the process of trying to migrate spreadsheets from Excel to CALC (which contain hundreds of price cells each linked to a unique web page), and quickly discovered this problem.
Excel's Hyperlink feature seems to associate the hyperlink with the whole cell (regardless of contents), and allows the cells to continue to be used in any calculations e.g. =SUM().
Could CALC's Hyperlink Window functionality be enhanced to allow Text OR Formula/Number to be used in a cell and match the =HYPERLINK formula feature?
Perhaps a radio button could be added to the Hyperlink Window "Further Settings", to allow the user to specify whether the cell contents should be treated as Text or a Formula/Number. Another improvement would be to place by default, existing cell content into the "data input box".
My present workaround is to use the =HYPERLINK(() formula manually, however access via the Hyperlink Window would be much preferred. Examples of use are:
For Text: =HYPERLINK("http://www.acmeco.com", "acme")
For Number/Formula: =HYPERLINK("http://www.acmeco.com", 45.00*TAX), then format the cell with currency etc.
Setting as NEW, enhancement
Oops, I forgot to mention that all the hyperlinked "price" cells inherited from the Excel sheet look and and function ok, BUT the URL cannot be edited in CALC.
Also the cell content can't be selected directly to edit. You have to click on any unused/empty cell in the sheet, then navigate to the price cell using the keyboard arrow keys and edit the price or formula using the Input Line.
It's probably easier to delete the cell completely and re-enter in CALC, however this is labourious with hundreds of cells involved!
Perhaps I should raise this as a separate and more serious bug?
(although it is interlinked with the CALC cell formula hyperlink issue)