Can't edit a url in a Calc cell

English
#1

LO Version: 7.5.0.3 (X86_64) / LibreOffice Community
Build ID: c21113d003cd3efa8c53188764377a8272d9d6de
CPU threads: 4; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-CA (en_CA); UI: en-US
Calc: CL threaded

Baffling. I enter a url in an LO Calc cell, “http://www.xyz.com”. LO highlights the url and displays a message to ctrl click to open the hyperlink. That’s fine, but when I try to edit the url in the formula bar by inserting an “s” after the p in http LO adds the “s” to the end of the url in the cell, so the cell looks like this “http://www.xyz.coms”. The formula bar looks right - the cell does not. Press enter in the formula bar and the url does not change to reflect the inserted “s” but does change to this “http://www.xyz.coms” in the cell.

#2

Just a tip:

CTRL-X - Paste Special - Unformatted text - Modify the URL in the cell - Right arrow to move the cursor to end of the URL - Enter
The LO will re-recognize the Clickable URL.

#3

Or you can Use the function

=HYPERLINK("http:...";"The text for the clickable label")
1 Like
#4

Unfortunately this is a known bug:
https://bugs.documentfoundation.org/show_bug.cgi?id=95600

#5

OK, thanks. I suspected as much but didn’t know how to investigate… Thanks for the link.

#6

Shocked to see that it’s been a known bug since 2015 though!

#7

Here is a macro to editing hyperlink(s) located in a cell:

Edit the URL and Representation of a hyperlink.ods (14.3 KB)

#8

Thanks Tibor, but likely simpler to just delete the URL and re-enter it.
Cheers,
Ted

#9

I found a quick and dirty solution to this.

  1. Select the cell containing the URL you want to edit.
  2. Click the “=” in the formula bar.
  3. Edit the formula bar contents.
  4. Hit enter.
    Problem solved!
    Don’t know why it works but it does.
1 Like
#10

Great! I added your solution to the bug report.

#11

Use Ctrl+K to create and edit hyperlinks in cells.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.