Bug 114403 - deleting URL inconsistent (cell vs text input field)
Summary: deleting URL inconsistent (cell vs text input field)
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.3.4.2 release
Hardware: All Linux (All)
: medium minor
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
 
Reported: 2017-12-11 02:18 UTC by Pierre Fortin
Modified: 2021-11-17 18:02 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
side by side samples of both delete methods (38.68 KB, image/jpeg)
2017-12-11 02:18 UTC, Pierre Fortin
Details
Spreadsheet to illustrate the problem (11.56 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-12-20 04:36 UTC, Pierre Fortin
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Pierre Fortin 2017-12-11 02:18:54 UTC
Created attachment 138358 [details]
side by side samples of both delete methods

Pasted some text from a web page into an empty sheet.  Some of the text contained URL links.  Deleting the URL text occurs differently depending on how it's deleted.

Deleting with Delete key while cursor in:

* cell works as expected.

* text field deletes entire URL from cell; but only one character at a time in text field where eyes are focused. This tricks the user into needing more Delete key strokes which actually deletes the URL, then more text not intended to be deleted.  See "Invalid display" in attached image.
Comment 1 Buovjaga 2017-12-19 14:25:03 UTC
By "Delete key" you apparently mean "Backspace key" judging by the screenshots.

I copied "Created attachment 138358 [details]" from your description to Calc and I can only delete the whole URL. I never delete one character at a time.
By "Text field" I take it you mean "Formula input field".
I tried everything, but could not reproduce the "one char at a time" behaviour you observed.

To ensure the chosen input matches, can you please confirm you get the problem with the "Created attachment 138358 [details]" block?

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: c3764c6848bd5ce0bbea2a82bedc3f0d55f01dce
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on December 19th 2017

Version: 6.1.0.0.alpha0+ (x64)
Build ID: 0bb0299b29960c3a27427eba5d5fc34e5e913a8b
CPU threads: 4; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2017-12-09_00:15:04
Locale: fi-FI (fi_FI); Calc: group threaded
Comment 2 Pierre Fortin 2017-12-20 04:36:04 UTC
Created attachment 138542 [details]
Spreadsheet to illustrate the problem

Sorry; yes, Backspace.

Here's a spreadsheet reduced to several cells copy/pasted from a browser page.

Select a cell (only a portion will be visible in the Input Line); then click at the end of the Input Line, and watch what happens each time you hit Backspace...

Examples (each BS deletes 1 character; but not where expected):
 cell A2: it deleted "cor" of "Host Record" so that it reads "Host Red"
 cell A4: same as A2
 cell A8: it deleted "ut" of "Email Routing:..." => "Email Roing"
 cell A8: same as A2
 cell A10: it deleted "ce" of "Service" => "Servi"
 cell A12: same as A2

Cells A8 and A10 don't follow the same deletion pattern as the others. Weird!

This is with:
Version: 5.3.4.2
Build ID: 5.3.4.2-3.mga6
CPU Threads: 8; OS Version: Linux 4.9; UI Render: default; VCL: gtk3; Layout Engine: new; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 3 Buovjaga 2017-12-20 08:03:21 UTC
(In reply to Pierre Fortin from comment #2)
> Created attachment 138542 [details]
> Spreadsheet to illustrate the problem

Ok, with this file I can reproduce for some reason.
It is weird because the structure is the same in the XML:

<text:a xlink:href="https://my.bluehost.com/hosting/help/713" xlink:type="simple">What&apos;s this?</text:a>
<text:a xlink:href="http://bugs.documentfoundation.org/attachment.cgi?id=138358" xlink:type="simple">attachment 138358 [details]</text:a>

Yet my copied attachment link does not behave like that with backspace.

Arch Linux 64-bit
Version: 6.1.0.0.alpha0+
Build ID: c3764c6848bd5ce0bbea2a82bedc3f0d55f01dce
CPU threads: 8; OS: Linux 4.14; UI render: default; VCL: kde4; 
Locale: fi-FI (fi_FI.UTF-8); Calc: group threaded
Built on December 19th 2017
Comment 4 QA Administrators 2019-10-28 03:28:51 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2021-10-28 04:14:46 UTC Comment hidden (obsolete)
Comment 6 Pierre Fortin 2021-11-17 18:02:14 UTC
Seems OK on:
Version: 7.2.2.2
Build ID: 20(Build:2)
CPU threads: 8; OS: Linux 5.10; UI render: default; VCL: gtk3
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded