Bug 76535 - [LOCALHELP] FORMCONTROLS: Enhancement: Help file in Calc needs to show How to edit hyperlinks
Summary: [LOCALHELP] FORMCONTROLS: Enhancement: Help file in Calc needs to show How to...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Documentation (show other bugs)
(earliest affected) release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Whiteboard: BSA target:6.4.0
Depends on:
Blocks: HelpGaps-NewFeatures
  Show dependency treegraph
Reported: 2014-03-24 03:19 UTC by bugquestcontri
Modified: 2019-08-09 13:15 UTC (History)
0 users

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description bugquestcontri 2014-03-24 03:19:19 UTC
Problem description: 
i searched the help file in Calc for information on how to edit/delete a hyperlink button but did not find any hint. 

Searching AskLibO I found:  

and there the  important information:

Open the Form Design of Form Controls toolbar (Menu/View/Toolsbar)   
The second button change design mode on/off, change to on and I hope you can select and edit the button.

Operating System: All
Version: release
Comment 1 A (Andy) 2014-10-25 13:12:17 UTC
Tested with LO, Win 8.1:
For me this seems to be reasonable, but I am not sure where/in which section of the LO help.  Maybe in the help section for INSERT -> HYPERLINK -> Help button (?)
Comment 2 bugquestcontri 2014-11-04 02:09:31 UTC
I had again a look in Calc (Lib on XP) and did:
- Help 
- Search term: hyperlink
- Selected: Edit Hyperlinks

Result: I got the correct description for Writer however nothing for Calc.

As an overall result I still don't know how to edit a hyperlink in Calc because the explanation mariosv gave in AskLibO ( see link in my first report) did not help me.  

Editing a hyperlink in Calc means always delete the cell and a new hyperlink.

In respect to the question on where to put the information I would say 
Edit > Hyperlink
Comment 3 Olivier Hallot 2016-02-09 12:09:47 UTC
Changed title as this is a help content issue, and blocks bug 80430.
Comment 4 Vipul Gupta 2019-05-14 08:10:56 UTC
To edit an existing link, select the cell containing the link and click the Hyperlink icon on
the Standard toolbar. The Hyperlink dialog opens. If the Hyperlink is in button form, the spreadsheet must have Design Mode on in order
to edit the Hyperlink. Make your changes and click Apply. If you need to edit several hyperlinks,
you can leave the Hyperlink dialog open until you have edited all of them. Be sure to click Apply
after each one. When you are finished, click Close.

To, on the Design mode, go to view and then toolbar and select form control. Now you can turn design mode on or off by clicking on it.

Above description worked for me.

Operating system: All
Version: 6.2.3 release
Comment 5 Commit Notification 2019-08-09 12:06:01 UTC
Vipul Gupta committed a patch related to this issue.
It has been pushed to "master":


tdf#76535 Clarify hyperlink button edition.