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
Created attachment 146527 [details] UneditableCellString.ods
Created attachment 146528 [details] UneditableCellString.ods
The way to edit it's Menu/Inser/Hiperlink [Ctrl+K] Not a bug.
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.