Description: Pressing the Formula button ("=" icon near the input line) selects part of an email address, sometime all the address becomes selected, and some other strange behaviors Steps to Reproduce: 0. Open a new spreadsheet 1. Enable URL Recognition 2. Type in a cell an email address: i.e., abcd@e.e, accept (it may be with F9, with Enter and Arrow Up, with Enter and click...) 3. While the cell is active, click the = button near the formula bar 4. Click at the right of the text in the formula bar 5. Add and delete a space 6. Enter Second test: 3.1. Press Right Arrow a few times 3.2. End, Home Actual Results: After 3. The first character of the address is selected. After 6. The second character of the address is deleted, and the space remains at the right. After 3.1.: Cursor advances only one position. Expected Results: The address remains as before. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.6.2.1 (X86_64) / LibreOffice Community Build ID: 60(Build:1) CPU threads: 1; OS: Linux 5.14; UI render: default; VCL: gtk3 Locale: es-MX (en_US.UTF-8); UI: en-US Calc: threaded
Use [Ctrl+K] Menu/Insert/Hyperlink, to edit it.
I can confirm with Version: 24.2.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: 55097433ed766a2ced6b87021a71c8a31cde9d99 CPU threads: 4; OS: Linux 6.2; UI render: default; VCL: gtk3 Locale: cs-CZ (cs_CZ.UTF-8); UI: en-US Calc: threaded
As I was completing Bug 103447 ...because I had this issue (from Bug 103447), it may be correlated to your bug.
There is positive consequence of the use of the equal sign with URL/emails, which is a workaround for bug 103447: (In reply to ady from bug 103447 comment #16) > FWIW (url/hyperlink/email address)... > > From: > > https://ask.libreoffice.org/t/cant-edit-a-url-in-a-calc-cell/98712/9 > > With minor rewording: > > 1. Focus on the cell containing the URL you want to edit. > 2. Click the "=" icon in the formula bar. > 3. Edit the URL text in the formula bar. > > Step 2 is key.