Bug 121336 - Can not edit Cell text using Edit Bar if text contains auto-detected hyperlinks (result is different than shown in Edit Bar)
Summary: Can not edit Cell text using Edit Bar if text contains auto-detected hyperlin...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.2.0.0.alpha1+
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-11-10 18:35 UTC by Jim Avera
Modified: 2018-11-11 15:57 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
UneditableCellString.ods (15.07 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-10 18:36 UTC, Jim Avera
Details
UneditableCellString.ods (15.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-11-10 18:39 UTC, Jim Avera
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jim Avera 2018-11-10 18:35:21 UTC
Description:
If a cell contains a string and a sub-sequence in that string is auto-detected as a hyperlink, then subsequent attempts to edit the text appear to work in the Edit Bar but actually result in a corrupted result.

Please see the attached demo spreadsheet ("UneditableCellString.ods")

Steps to Reproduce:
1. Type "/aaa;\\bbb\ccc;\\ddd\eee" into a cell (sans quotes)
    (\\bbb\ccc and \\ddd\eee will be auto-detected as hyperlinks)
2. Click elsewhere, then re-select the cell
3. In the Edit Bar, change "bbb" to "xxx"
4. Click the green check icon

Actual Results:
The edit is corrupted: The "bbb" which was changed to "xxx" in the Edit Bar was not actually changed, and the "xxx" ended up at the end of the entire string.

Also, copy-and-paste of the text in the Edit Bar produces the corrupted result, not what you see in the Edit Bar.

Expected Results:
The cell text should be changed to exactly what is shown in the Edit Bar (i.e. what the user wanted).   

Any URL auto-detects should be uh-done and re-done around edits.


Reproducible: Always


User Profile Reset: No



Additional Info:
Version: 6.2.0.0.alpha1
Build ID: ff46ad24d1d3cbcea45895520483ed1fd4ff488b
CPU threads: 12; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: en-US (en_US.UTF-8); Calc: threaded
Comment 1 Jim Avera 2018-11-10 18:36:51 UTC
Created attachment 146527 [details]
UneditableCellString.ods
Comment 2 Jim Avera 2018-11-10 18:39:15 UTC
Created attachment 146528 [details]
UneditableCellString.ods
Comment 3 m_a_riosv 2018-11-11 01:48:33 UTC
The way to edit it's Menu/Inser/Hiperlink [Ctrl+K]

Not a bug.
Comment 4 Jim Avera 2018-11-11 15:57:40 UTC
They, why was the Edit Bar changed to allow you to edit those characters (seemingly)?   

In older releases the hyperlinks were immutable objects which you could select and delete, etc.

In 6.x, the Edit Bar lets you change characters and it SEEMS to work, i.e., you can over-type arbitrary characters.  But it does not actually work.

So I think this _is_ a bug.  A new bug, introduced recently.   IMO it would be far more helpful to the user to make editing arbitrary chars work as it now seems is intended, but if not then please revert back to the old behavior where the hyperlinks are shown as immutable objects which can not be internally edited.

So I request that this bug be re-opened.  Thanks.