[Libreoffice-bugs] [Bug 95600] Modify a cell that contains URL in Calc; unable to modify hyperlink in formula bar

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=95600

John <creamin at icloud.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |ASSIGNED

--- Comment #14 from John <creamin at icloud.com> ---
In response to email request, I confirm that I am NOT able to edit a hyperlink
in Calc without deleting it and re-writing it.

I note from my Calc document that it only becomes a hyperlink if http://www. or
www. is in front of the URL. It becomes a hyperlink normally after I leave the
cell or press return.

I am currently using a MacBook Pro mid 2015 Retina display with installed OS
11.5.2 with About LibreOffice 7.1.4.2 build a529a4fab45fefc5b62266... with CPU
threads: 8; Mac OS X 10.16 

<To test for this issue resulted in a different problem I have had with he
current and previous two version of Calc: I tried typing in a URL, then tired
to replace it, but the previous url stayed - I often encounter an issue now
that means whatever I type into my old spreadsheet when edited is not saved as
edited and sometimes becomes a jumble of characters with some missing from my
attempt to edit it.

I chose another cell and it only converted to a link when I used the Command
key when pressing the return key. The first time I did this when I returned to
it I found it had changed to the url http://www. with he remainder left as
plain text!>

I chose another cell and demonstrated it only converts to a URL with
Command-Return, provided it is preceded by www or more. It is not editable in
the cell, but is editable in the formulae bar. So I think the issue has been
resolved. 

I have other issues not yet reported by me, mainly corrupted text entries in
Calc as indicated above between the brackets < and > when I add or amend
current entries, I think solved by not deleting the cell content and not saving
the Calc file, then retrying.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210911/bb322c42/attachment-0001.htm>