Bug 158475 - EDITING an email address with URL Recognition enabled
Summary: EDITING an email address with URL Recognition enabled
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.6.2.1 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Formula-Bar
  Show dependency treegraph
 
Reported: 2023-11-30 22:46 UTC by LeroyG
Modified: 2024-05-11 23:21 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description LeroyG 2023-11-30 22:46:52 UTC
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
Comment 1 m_a_riosv 2023-12-01 00:31:21 UTC
Use [Ctrl+K] Menu/Insert/Hyperlink, to edit it.
Comment 2 raal 2023-12-01 16:49:48 UTC
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
Comment 3 loic_dupont 2024-05-11 22:25:44 UTC
As I was completing Bug 103447 ...because I had this issue (from Bug 103447), it may be correlated to your bug.
Comment 4 ady 2024-05-11 23:21:41 UTC
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.