Bug 107470 - A hyperlink button cannot be deleted because right-click menu is missing and button cannot be selected
Summary: A hyperlink button cannot be deleted because right-click menu is missing and ...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.2.2 release
Hardware: x86 (IA32) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-04-27 04:51 UTC by Eric Conrad
Modified: 2017-04-27 15:25 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Eric Conrad 2017-04-27 04:51:02 UTC
Description:
There appears to be no way to delete a hyperlink button except to delete the entire sheet which contains it.  (1) A hyperlink button is missing a right-click context menu, so the button cannot be deleted using a right-click selection.  (2) Moreover, when the button is left-clicked, the button object is activated (calling up the requested web page) but not selected (the previously selected cell remains selected).  (3) Selecting a range of cells containing the button does not select the button object, so clearing formatting is ineffective.

Steps to Reproduce:
In a sheet you can delete...
1. Create a hyperlink button (a) From menu at top: Insert -> Link (b) In the popup, under form, select Button.  Enter URL (https://www.google.com) Text (Google) Data (Google) (c) Select OK to create the hyperlink.
2. Right-click the button.  (Nothing happens.)
3. Select the row containing the button.  Then right-click the row and select delete rows.  (The object remains after the row is deleted.)
4. Select the row containing the button.  Then from the menu at the top of the page, select Format -> Clear Direct Formatting.  (The button is unaffected.)
5. Right-click the sheet tab and select Delete Sheet.  (The sheet disappears along with the button.)


Actual Results:  
The button was completely unaffected by all operations except "Delete Sheet".

Expected Results:
In step (2) above, a right-click menu should have appeared containing options to modify and to delete the button.

In step (3) above, deleting the row containing the button should delete the button object.


Reproducible: Always

User Profile Reset: No

Additional Info:
I am using the PortableApps.com version of LibreOffice.


User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:53.0) Gecko/20100101 Firefox/53.0
Comment 1 Maxim Monastirsky 2017-04-27 06:42:56 UTC
Hi Eric,

To get the context menu or delete the button, you have to enable the "Design Mode". Just open the "Form Controls" toolbar (menu View > Toolbars > Form Controls), and click on the "Design Mode" button.

@Jay: Can we have the "Design Mode" entry also in the Edit menu, similar to Writer and Impress?
Comment 2 Yousuf Philips (jay) (retired) 2017-04-27 13:37:27 UTC
(In reply to Maxim Monastirsky from comment #1)
> @Jay: Can we have the "Design Mode" entry also in the Edit menu, similar to
> Writer and Impress?

Done - https://gerrit.libreoffice.org/37032
Comment 3 Eric Conrad 2017-04-27 15:25:25 UTC
Thank you -- Maxim's solution works.