When you make a right-click on a cell, then a context menu appears with the command 'Format Cells...' at its end.
But if you do this right-click on a hyperlink, then this cell format command is missing and the hyperlink-related context menu is popping up.
This is no problem if only a part of the cell content contains a hyperlink. But if the whole content is a hyperlink, you can't open the 'Format Cells...' command with a right-click.
You can test it in attachment 153875 [details].
Possible solution could be to add the 'Format Cells...' to the hyperlink-related context menu. But I don't know where this context menu also is used and if this leads to a false behavior elsewhere.
Steps to reproduce:
1. Open a new Calc document.
2. Write text in a cell that is as long as the cell is wide.
3. Select the cell (not the string in it) and click the 'Insert Hyperlink' command. Insert a web address or something else.
4. Right-click on this cell with a hyperlink.
If you want to edit the whole cell and not the content/hyperlink, it's not possible anymore. Right-clicking on a hyperlink brings you the hyperlink context menu and not the cell context menu.
If I'm not wrong Context Menus can be edit through Menu/Tools/Customize/Context Menus - (Target) Cell Edit
(In reply to m.a.riosv from comment #1)
> If I'm not wrong Context Menus can be edit through
> Menu/Tools/Customize/Context Menus - (Target) Cell Edit
Right. But I'm writing this report not for me but for all users from Benjamin to Eve. 
confirm wrong behavior when we use right-click on hyperlink in the Calc cell. We see hyperlink context menu instead cell context menu.
We can make cell wider and then right click on empty space in the cell and then we'll see normal cell context menu
ID сборки: 2bed8af91fc2654b9ed2432f969d32d5741a529b
Потоков ЦП: 4; ОС:Linux 5.2; Отрисовка ИП: по умолчанию; VCL: gtk3;
TinderBox: Linux-rpm_deb-x86_64@86-TDF, Branch:master, Time: 2019-08-21_09:30:10
Локаль: ru-RU (ru_RU.UTF-8); Язык интерфейса: ru-RU
Samuel, any opinion?
Ah the problem seems to be that when right clicking on a cell with a hyperlink beneath, the cell edit mode is activated and so the context menu for the hyperlink appears.
Instead, the behavior should be that when right clicking on a cell, always the cell context menu should appear, even when a hyperlink is below the cursor.
(In reply to Samuel Mehrbrodt (CIB) from comment #4)
> Ah the problem seems to be that when right clicking on a cell with a
> hyperlink beneath, the cell edit mode is activated and so the context menu
> for the hyperlink appears.
> Instead, the behavior should be that when right clicking on a cell, always
> the cell context menu should appear, even when a hyperlink is below the
Yes, but I assume the current behavior is based on another enhancement request that resulted in what we see now. So the maximum demand won't be the best for UX maybe. Because of this I suggested to only add this one command. Maybe other cell format commands should be added too.
I agree with the summary, the cell formatting context is expected independently from the content. Probably because hyperlinks are handled by the edit engine a single click goes into the edit mode (in order to activate the link) so the edit context is active.
The simple solution is to not open links per right click, which is the fact right now, but also to not go into the edit mode, as we on cells without links.
Let's just replace Character... (.uno:FontDialog) by Format Cells... (.uno:FormatCellDialog) in sc/uiconfig/scalc/popupmenu/celledit.xml
Looks like not as easy as just changing uno commands. RightMouseButton activates EditMode, which now need to be changed. Perhaps just a test missing which button was pressed? Needs some digging.
(In reply to Thorsten Behrens (allotropia) from comment #8)
> RightMouseButton activates EditMode...
Not for me.
It does activate TextEdit when here is
(1) either a link
(2) or a wrong-spelled word (which gets also selected, and the context menu shows SpellCheck & alternatives)
Where (2) is probably wanted (Heiko?) but (1) definitely not.
o see, just right-click, close popup-menu with ESC and use cursor keys o navigate in activated TextEdit :-)
Exactly because this is so special it will be hard to find - there must be some pretty crude code to do that :-(
taking a deeper look, debugging into UI actions (always tricky...) using SAL_NO_MOUSEGRABS...
There are different mechanisms if EditMode is already active or not, we need to check here for not-yet-active. Also extra-stuff when active - blocks when debugging, but not interested in. As expected, have to fight with debugging & interactive stuff, will add SAL_WARN and activate trace output...
Identified action/acivation in ScGridWindow::MouseButtonDown in sc/source/ui/view/gridwin.cxx, so can fix it now.
Question is now (for the last Time) - is this by purpose or not?
It *is* triggered on nCode == MouseSettings::GetContextMenuCode() in ImplHandleMouseEvent in vcl/source/window/winproc.cxx, so this is by purpose (outside calc) and thus on right-mouse-down. Checked git history, but it did not change for a long time, so found no hints hat this was added as an option by purpose.
Will thus change it now - if this was an option it can be re-added by reverting the fix.
(In reply to Armin Le Grand from comment #10)
> It does activate TextEdit when here is...
True, these are something special. And yes, we do want the interaction with hyperlinks and misspelled words. But now I'm totally confused what is expected and what is possible. Thomas, your ticket...
Have a fix now that prevents text edit activation on right-click on link, still behaves the same for the rest - especially spell check does still work as (i guess is) intended. Will propose this for now
Armin Le Grand (Allotropia) committed a patch related to this issue.
It has been pushed to "master":
tdf#127341 Do not activate TextEdit at right-klick on URL in calc
It will be available in 7.4.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Now it seems to work right (at least for me). Right-click on a cell shows the default cell options. After you double-clicked into a cell you can edit the content with spell checking or hyperlinks.
Version: 188.8.131.52.alpha0+ (x64) / LibreOffice Community
Build ID: 52443996eff721e612ac4afc1eb1a53bb8a3e06f
CPU threads: 12; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: de-AT (de_AT); UI: de-DE
Thank you very much, Armin!