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.
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?
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.
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 ?
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.
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.