Prevent opening hyperlinks in single click

Do you want to: Suggest a feature | Ask a how-to question
For feature suggestions, describe the result you would like to achieve in detail: Open links with only with CTRL + Right-click
Community Server/Control Panel version: ONLYOFFICE Desktop Editors version 7.1.0.215
OS: Manjaro KDE
Browser version: Firefox 104.0.2 (64-bit)

I’m new to OnlyOffice. How to open hyperlinks with CTRL+Right-click? I’m working on Spreadsheet right now, and it’s annoying when clicking a cell with hyperlinks, it opens the link instead of just selecting the cell.

Click-and-holding just breaks the functionality of using a mouse.

1 Like

Hello @snich
We are checking the situation. We need some time to discuss it internally. I will update this thread when we have something to share.

We have checked described situation. This is expected behavior. If you want to choose a cell with a link, please try to hold left-click on the cell till the cursor changes.

Hi Alexandre, we see our users of OnlyOffice are getting tripped by the current hyperlink cell click implementation. Almost every time a new user arrives to the platform, coming from other spreadsheet software, they visit a URL by accident. The expectation that clicking anywhere in a spreadsheet cell selects that cell is not met resulting in an inconsistent user experience. Some users went as far as comparing the current implementation to a form of clickjacking.

The unmet expectation has multiple origins but primarily inconsistency with other spreadsheet platforms where clicking a cell always translates to selecting the cell. As snich mentioned above, it is more common to have the “visit URL” behaviour not be the default when working with a spreadsheet. Ctrl+click being one of the possible alternative interactions.

Another unexpected situation is when the cell contains more than one URL. The correct behaviour is unclear resulting in confusion.

Being new to this forum I’m not sure what the procedure to request a new feature or a feature change is but, could you consider modifying this implementation or, at the very least, provide a setting to change the interaction mode globally? Specifically, could you make cell selection the default and have hyperlink visit require a modifier key?

1 Like

Hello @renato.alves
We need some time to discuss the situation internally. I will update this thread when we have something to share.

Hello @renato.alves
We have added a suggestion to our internal tracksystem (internal number - 61845). We have started working on it.

1 Like

Thanks @Alexandre . This is great to hear. We look forward to future improvements.

1 Like

Hello @Alexandre ! Is there any progress on this issue? As of today with actual version 7.4.1 clicking cells still opens embedded hyperlinks

Hello @SetazeR
We are still working on the mentioned suggestion. I will update this thread when we have something to share.
Sorry for inconvenience.

Upvoting this request - it’s really difficult to use the Spreadsheet feature with initial-click being to open any hyperlink in the cell. Also as mentioned above there’s a big problem when a cell contains more than one hyperlink.

Hello @RogerYes
Thank you, your message has been received. We are working on the described behavior.

Hi Alexandre !
How’s suggestion n° 61845 ?
I’m working with a spreadsheet full of link and its really annoying that the link open so easily.
It’s also super annoiying to have to click for a long time to edit the cell.
Is it now possible to edit this behavior in the preferences ?

Many thanks

Hello, @jund :handshake:

We have noted your inquiry. Thank you for participating in the project.

We are aware of this behavior and continue to improve our product. Unfortunately, I cannot provide specific timelines for resolution at the moment.

At the moment, such a capability is not available. We are working on it.

Hi. How is this feature coming along? We work with large sheets which contain a lot of E-Mail addresses and constantly having “Compose message” windows pop up while going through the data slows us down a lot.
Also entering E-Mail Adresses like mail@example.com in a sheet causes OnlyOffice to create a link to http://mail@example.com instead of a mailto: Link so behaviour is not even consistent.

Is there any other solution in the meantime, like bulk removing all hyperlinks at once in a document? Or can we globally disable hyperlinks? We don’t need them to be clickable at all in any document.

Hello @oehedv

I’ve tested latest version - pasting mails creates a link with mailto:. Please specify version of Document Server/Desktop Editors that you are using.

You can disable them in AutoCorrect options: from File tab go to Advanced Settings > Proofing section > AutoCorrect options > AutoFormat as you type > Replace as you type and uncheck Internet and network paths option, then close the window and press Apply button to save changes. That way pasting a and address or email won’t replace with hyperlink.

Hello constantine, I do not have this proposition. When I click on Advanced Settings > Proofing section > AutoCorrect options I get only a table with automath abbreviations
Is there an alternative method to remove hyperlinks ?
Thanks
M.

Hello @marie

Please specify version of used Document Server, you can find it in About tab on the left toolbar.

Hello Constantine
Onlyoffice 6.0.2 is installed in the dropbox I am using at the moment
Thanks !
M

Hi Nikolas and Alexandre,

Pinging on this request. Seeing all the productivity slowdowns described by other users in this thread. Please add an option to disable mouse left-click on a hyperlinked cell to automatically redirect to the link, and replace with Ctrl + mouse left-click to go to the link. Thank you.

Hello @marie and @micpha

Onlyoffice 6.0.2 is installed in the dropbox I am using at the moment

This is extremely old version of Document server. Please update your installation to the latest one (v.8.0.1).

Please add an option to disable mouse left-click on a hyperlinked cell to automatically redirect to the link, and replace with Ctrl + mouse left-click to go to the link. Thank you.

We have collected your request and we will update this thread once we have something to share. The work on the mentioned suggestion is still in progress.