Description: When you delete rows in a cell with multiline text, the program fills the vacated rows with random data. Steps to Reproduce: Enter multiline text in the cell, for example, 11 22 33 44 55 Highlight rows 2 and 3 and press Del. Rows 4 and 5 will move up and take the place of the deleted rows, but their phantoms will remain in their place. It is not possible to move the cursor below the third line = no more physical lines. When editing is complete, the cell takes on the appearance of: 11 44 55 Actual Results: The empty rows are filled with random data. Expected Results: The empty rows must be cleared. Reproducible: Always User Profile Reset: No Additional Info: This bug appeared in Libre Office versions newer than 7.1.8 at all computers. Disabling SKIA and OpenCL does not fix the error. Locale: ru Module: SpreadsheetDocument OS: Windows 10, Windows 11 OS is 64bit: yes
Not with random but duplicating the last row. such dups are not saved in the cell. Version: 7.3.0.3 (x64) / LibreOffice Community Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3 CPU threads: 4; OS: Windows 10.0 Build 21390; UI render: Skia/Raster; VCL: win Locale: es-ES (es_ES); UI: en-US Calc: CL
(In reply to m.a.riosv from comment #1) > Not with random but duplicating the last row. In this example, yes. However, if more lines are deleted, duplicates are inserted in place of the deleted lines in random order. That's what I called random data. > such dups are not saved in the cell. I already said that in my report. Phantom strings interfere with editing because the contents of the cell are not true and confuse the user.
*** Bug 147026 has been marked as a duplicate of this bug. ***
Not reproduced. Do you still see this? Version: 7.4.3.2 (x64) / LibreOffice Community Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890 CPU threads: 2; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: fi-FI (fi_FI); UI: en-US Calc: threaded
*** Bug 145353 has been marked as a duplicate of this bug. ***
Created attachment 186457 [details] 1. select the lines to be deleted
Created attachment 186458 [details] 2. press the delete key
Created attachment 186459 [details] 3. press the enter key
I experienced a similar issue when deleting the last lines of a multiline cell (see previous attachements). Version: 7.2.7.2.M8 (x64) / LibreOffice Community Build ID: cf1bdbb7fdbe4cc2bde03370057fbbb79d316db5 CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: fr-FR (fr_FR); UI: fr-FR Calc: threaded
(In reply to Jérôme from comment #9) > I experienced a similar issue when deleting the last lines of a multiline > cell (see previous attachements). > > Version: 7.2.7.2.M8 (x64) / LibreOffice Community > Build ID: cf1bdbb7fdbe4cc2bde03370057fbbb79d316db5 > CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: > win > Locale: fr-FR (fr_FR); UI: fr-FR > Calc: threaded I was asking for retesting last year as I could not see it with 7.4. Can you test with 7.5?
I have no access to a 7.5 version on a Windows box. However, I can't see this bug on GNU/Linux : --- Version: 7.5.1.2 (X86_64) / LibreOffice Community Build ID: 81bce3cd17f5e01886721863a4fa0d99f91033a6 CPU threads: 4; OS: Linux 4.9; UI render: default; VCL: gtk3 Locale: fr-FR (fr_FR.utf8); UI: en-GB Calc: threaded ---