Bug 96544 - Text inserts in wrong place when cell contains a URL
Summary: Text inserts in wrong place when cell contains a URL
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Calc-Cells
  Show dependency tree / graph
 
Reported: 2015-12-16 15:35 UTC by richardjnz
Modified: 2023-03-06 18:25 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description richardjnz 2015-12-16 15:35:38 UTC 
I often type short textual notes into a Calc cell, and the text often includes a URL. If I then go back to the cell to insert (or paste-in) a few extra words the text gets inserted into the wrong position.

For example, open a new empty Calc sheet, then in cell A1 type this into the cell:

one http://www.libreoffice.org three four five six seven eight

and hit Enter.

Now use the MOUSE to click cell A1 to make it the current cell again. Then in the formula bar click just before the word "three" and type the word "two". You will notice as you type the characters in the cell are actually inserted immediately after the word "seven"!

So in the formula bar you see

one http://www.libreoffice.org two three four five six seven eight

but in the cell contents you see

one http://www.libreoffice.org three four five six seventwo  eight

then hit Enter. Now use the MOUSE to click the cell A1 again - you will see that the incorrect text has been stored. Now click in the formula bar somewhere AFTER the URL, and then try to delete some characters - you will see the wrong characters disappear in the cell contents! It's all a bit of a mess.

To get around this I usually have to copy the whole cell contents to notepad, insert any text I want and then paste the whole thing back into the calc cell again, which is a bit tedious.

Strangely if you use the CURSOR keys (instead of the mouse) to make A1 the current cell, then this problem is much less likely to happen.
Comment 1 Andreas B. 2015-12-19 13:02:10 UTC 
Confirmed With LO 5.0.3.2 on Linux.
Comment 2 QA Administrators 2017-01-03 19:46:02 UTC Comment hidden (obsolete)
Comment 3 richardjnz 2017-01-12 13:53:21 UTC 
I received an email from bugzilla asking me to check if this bug is present on a currently supported version of LibreOffice.

I just tested it on 5.2.4.2 of libre office (desktop computer running Windows 7) and can confirm that the bug DOES still exist. I ran through the instructions I original provided in the bug report and the incorrect behavior is the same.

I really knew this already as I run into the problem on a regular basis and it's a pain. Using the cursor key to navigate to the cell only helps SOMETIMES.
Comment 4 QA Administrators 2018-01-13 03:30:08 UTC Comment hidden (obsolete)
Comment 5 Xavier Van Wijmeersch 2018-01-13 18:50:12 UTC 
Following the steps from the description, the problem does still exist in

Version: 5.3.7.2
Build ID: 6b8ed514a9f8b44d37a1b96673cbbdd077e24059
CPU Threads: 8; OS Version: Linux 4.14; UI Render: default; VCL: kde4; Layout Engine: new; 
Locale: nl-BE (en_US.UTF-8); Calc: group

But seems to be fixed with

Version: 5.4.4.2
Build ID: 2524958677847fb3bb44820e40380acbe820f960
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group

Version: 6.1.0.0.alpha0+
Build ID: 085852e2e2779de1712cf18b5e67740cb7a4bcb6
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: nl-BE (en_US.UTF-8); Calc: group threaded
Comment 6 Thomas Lendo 2018-01-15 23:23:34 UTC 
I can reproduce the bug with

Version 6.1.0.0.alpha0+
Build ID: acb43c0b8efbfb841e7b40603d75a8432eb21f21
CPU threads: 4; OS: Linux 4.10; UI render: default; VCL: gtk2; 
TinderBox: Linux-rpm_deb-x86_64@70-TDF, Branch:master, Time: 2018-01-09_01:20:44
Locale: de-DE (de_DE.UTF-8); Calc: group threaded

and with

Version: 6.0.0.1
Build-ID: d2bec56d7865f05a1003dc88449f2b0fdd85309a
CPU-Threads: 4; BS: Linux 4.10; UI-Render: Standard; VCL: gtk2; 
Gebietsschema: de-DE (de_DE.UTF-8); Calc: group
Comment 7 QA Administrators 2019-01-16 03:55:07 UTC Comment hidden (obsolete)
Comment 8 QA Administrators 2021-01-16 04:18:47 UTC Comment hidden (obsolete)
Comment 9 Andreas Heinisch 2022-08-23 19:30:02 UTC 
Still in:
Version: 7.5.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: 0de37cdd0251a7fc080bc6b95ac8708833bd0552
CPU threads: 16; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: en-US
Calc: CL
Comment 10 Jean-Baptiste Faure 2022-10-09 20:50:04 UTC 
I do not reproduce the problem with 

Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: b9b184b3d4295464385df5714b8930e1a6b928da
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Ubuntu_20.04_x86-64
Calc: threaded

and with

Version: 7.4.3.0.0+ / LibreOffice Community
Build ID: 75fd9e5a6947bc370cf230afe32bbf755a91e2ea
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_20.04_x86-64
Calc: threaded

both used under Ubuntu 20.04 Gnome / Wayland

Best regards. JBF