Bug 89572 - Enhancement request: HYPERLINK Window to include cell containing a formula/numeric value to be linked
Summary: Enhancement request: HYPERLINK Window to include cell containing a formula/nu...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: All All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function Hyperlink-Dialog Hyperlink-Calc
  Show dependency treegraph
Reported: 2015-02-23 00:10 UTC by bugzilla
Modified: 2018-10-12 09:40 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Examples of hyperlinks added to cells containing formula and number. (18.25 KB, application/vnd.oasis.opendocument.spreadsheet)
2015-02-23 00:10 UTC, bugzilla

Note You need to log in before you can comment on or make changes to this bug.
Description bugzilla 2015-02-23 00:10:20 UTC
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.
Comment 1 raal 2015-02-23 07:43:13 UTC
Setting as NEW, enhancement
Comment 2 bugzilla 2015-02-23 09:48:05 UTC
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)