Description: 1) Edit a cell already containing a Url with parameters. For example, https://www.mersenne.org/report_exponent/?exp_lo=77230000&exp_hi=77230411&full=1 Click on cell to edit, go to edit line, click on position to edit at (after the 4), delete one character with backspace key, type one replacement character ("2"), click on the green check mark to accept the changed displayed content in the edit line (https://www.mersenne.org/report_exponent/?exp_lo=77230000&exp_hi=77230211&full=1), the entire modified URL is displayed in edit line, but only the new typed character "2" is displayed and stored in the cell _afterward_. Steps to Reproduce: 1. Follow the description step by step 2. It does not matter if the cell is formatted "number general" or "text" 3. Click undo to recover from the loss of the entire URL from the cell. Actual Results: 2 Expected Results: https://www.mersenne.org/report_exponent/?exp_lo=77230000&exp_hi=77230211&full=1 Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: I don't recall how many releases have had this issue. I vaguely recall ~v4.x being ok in this regard. It's tedious to copy URLs out to edit in another application and then paste them back into another cell after edit, then delete the original cell's contents. Pasting them back into the problem cell does not work either. Problem is also reproducible in Calc safe mode, not a user profile issue apparently.
Created attachment 181287 [details] snapshot of calc during issue
earliest affected version of Libre Office Calc uncertain, certainly v6.x or earlier. Updates to 7.1.1 and to 7.3.4.2 did not resolve. Observed on Windows 10 x64 version. Not tried on other OSes.
You can't edit hyperlinks in the normal editor. You can edit an existing hyperlink by pressing Ctrl-K or going to Insert - Hyperlink. Can you confirm this was with linkified text and not pure text? You can disable the linkification from Tools - AutoCorrect Options - Options - URL Recognition.
Dear kkriesel, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Yes it was a linkified text and a proper usable URL, like the examples above and below it in the screen shot provided last year, until it was improperly converted to a mere "2". It's kind of a nuisance that by default the software linkifies them on its own, thereby leading to the editing problem and data loss upon edit.
[Automated Action] NeedInfo-To-Unconfirmed