Bug 145353 - Editing within a CALC Cell with wordwrap .. does not remove deleted characters from next line in the cell!
Summary: Editing within a CALC Cell with wordwrap .. does not remove deleted character...
Status: RESOLVED DUPLICATE of bug 147222
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-27 21:20 UTC by V.S. Umamaheswaran
Modified: 2023-01-06 14:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Contains screen captures showing the problem along with a Readme file. (126.32 KB, application/x-zip-compressed)
2021-10-28 23:50 UTC, V.S. Umamaheswaran
Details
Steps used in creating the samples for the bug report (2.61 KB, text/plain)
2021-10-31 18:47 UTC, V.S. Umamaheswaran
Details

Note You need to log in before you can comment on or make changes to this bug.
Description V.S. Umamaheswaran 2021-10-27 21:20:03 UTC
I have a CALC 9 rows X 9 cols each .. filled with 'space 1 space', 'space 2 space' .... 'space 9 space'.  The cell and row width are adjusted to show 3 numbers in each line within each cell - the content in the cell is 'line wrapped'.

When I edit the cell to remove for example 'space 3 space'  in the first line within the cell,  the 'space 4 space' from next line appears at the end of the first line, as expected.  But, during the editing action, the 'space 4 space' and the rest of the cell lines remain visible ..  unwrapped.  When I 'ENTER'  after the editing, the result is as expected.

I had to get used to this behaviour and continue with EDITing within a cell in all other CALC tables I have as well.

Not sure if this is what the expected behaviour is, or there is some setting that I should adjust or set that I am not aware of.

If this is  BUG, please fix it.  If it is something I am not doing right please let me know.  It would be a big help.   This behaviour started a few updates of Libre Office ago.  I thought it may disappear over following updates .. but it continues.

Thanks for your attention.

V.S. Umamaheswaran
bhanudorai@rogers.com
Comment 1 Xisco Faulí 2021-10-28 09:57:00 UTC
Thank you for reporting the bug. Please attach a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' once the requested document is provided.
(Please note that the attachment will be public, remove any sensitive information before attaching it. 
See https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F for help on how to do so.)
Comment 2 V.S. Umamaheswaran 2021-10-28 23:50:54 UTC
Created attachment 175981 [details]
Contains screen captures showing the problem along with a Readme file.

I have attached samples showing (what I think is a) Bug, as requested.
Comment 3 Ankur Khandelwal 2021-10-31 02:24:43 UTC
Thanks for reporting the bug and attaching the screenshots. I would request you to write the exact steps to reproduce the bug as a numbered list as this would make it easier to verify the bug.

Please refer to https://wiki.documentfoundation.org/QA/BugReport#Description_and_attachments 

Changing the status to NEEDINFO.
Comment 4 V.S. Umamaheswaran 2021-10-31 18:47:42 UTC
Created attachment 176047 [details]
Steps used in creating the samples for the bug report

As requested, I am attaching a .txt file with the steps used in creating the samples in the figures attached earlier.
Comment 5 Joshua Coppersmith 2021-11-13 18:04:31 UTC
I can replicate this in Calc 7.2.2.2.

Here is a simpler explanation:

In the edit line (formula bar), when deleting early text in a cell with auto-wrapping, if the deletion would cause the last line to move up a line a ghost image of the last line remains where it had been.

Example:

If an auto-wrap cell looks like

One
Two
Three

and the user edits the cell using the edit line by deleting the word One, then the cell will look like

Two
Three
Three

until Enter is pressed.

It seems like the window for the edit shrinks according to the new, two-line font metrics so no mechanism is there to clear the old lower part of the former, taller window.
Comment 6 Andras 2021-11-21 07:40:37 UTC
I can replicate Joshuas example in Calc 7.2.2.2 with Windows 10. On the same PC but Linux Mint 20.2 and again LO 7.2.2.2 not ghost image line.
Comment 7 Ian Nicholson 2021-11-29 19:03:37 UTC
I'm seeing the same behavior on v7.2.2.2 on Windows 11. I believe the first time I noticed the odd rendering was after installing v7.2.1.2; I'm not sure what version I was running before that but it was likely a few months old.

The way I notice it occurring is opening a spreadsheet with multi-line cells, and typing a character that matches the first character of a higher cell. Auto-complete kicks in, and it tries to fill with a suggestion from above. If I type another character that doesn't match the 2nd character of any of the higher cells, the suggestion is cancelled and I'm left with my two characters alone on the first line. HOWEVER, the 2nd and subsequent lines of the suggestion are not cleared below my cursor, as if they were still valid. Once I finish what I'm typing and either press ENTER or TAB to a different cell, the "ghost" text vanishes and things look back to normal.
Comment 8 Nadie Nada Nunca 2022-03-11 12:14:41 UTC
I've been seeing this behaviour for a long time and it still happens in LO 7.2. The "ghost line" is cosmetic, as the text is actually deleted but still shown until you finish the edit. 

Unrelated to the bug: 

> I have a CALC 9 rows X 9 cols each .. filled with 'space 1 space', 'space 2
> space' .... 'space 9 space'.  The cell and row width are adjusted to show 3
> numbers in each line within each cell - the content in the cell is 'line
> wrapped'.

If I understand correctly, you should consider just pressing Ctrl+Enter after each number so you have actual lines in your cell and forget about micromanaging spaces and widths. It would make your life easier.
Comment 9 Buovjaga 2023-01-06 14:02:31 UTC

*** This bug has been marked as a duplicate of bug 147222 ***