Bug 145529 - Auto Fill leaves zombie Text after input string no longer matches autofill "template prototype"
Summary: Auto Fill leaves zombie Text after input string no longer matches autofill "t...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.1.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, regression
Depends on:
Blocks:
 
Reported: 2021-11-03 16:15 UTC by Rainer Bielefeld Retired
Modified: 2022-05-29 12:28 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample Document (8.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-11-03 16:15 UTC, Rainer Bielefeld Retired
Details
LibreOffice Calc does not update autofill text example wrapped to multiple lines while input characters to a cell. (114.02 KB, application/vnd.oasis.opendocument.spreadsheet)
2022-05-27 09:46 UTC, jteera5
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Rainer Bielefeld Retired 2021-11-03 16:15:25 UTC
Created attachment 176095 [details]
Sample Document

STR for Installation of Version:7.2.1.2 (x64); Build ID: 87b77fad49947c1441b67c559c339af8f3517e22; CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win; Locale: de-DE (de_DE); UI: de-DE; Calc: threaded and my normal User Profile:

0. Launch LibO
1. Open Sample Document
2. Click into Cell C2 and start Typing "To"
   » As expected CALC adds " be or not to be, that is the question here."
3. Continue to type until "To be h"
   » Expected: autofill disappears because typed string no longer matches 
     with template in cell above.
     Actual: Autofill text still is visible when you continue typing until 
             finish "To Be honest, I am tired". The "ghost text" from autofill
             will not become cell contents after <Enter>, but 
             that's annoying                                            😥

Additional info:
----------------
a) Still REPRODUCIBLE REPRODUCIBLE with Server Installation of Version7.3.0.0.alpha1+ (x64)  |   Build ID b8d17d754830ab57099dcdfa72a96bfad404ab1a  |  CPU threads: 12; OS: Windows 10.0 Build 19042; UI render: Skia/Raster; VCL: win  |  Locale: de-DE (de_DE); UI: de-DE  |  Calc: CL  |  Special devUserProfile

b) Was still OK with Version: 6.4.7.2 (x64)  | Build-ID: 639b8ac485750d5696d7590a72ef1b496725cfb5 | CPU-Threads: 12; BS: Windows 10.0 Build 19042; UI-Render: GL; VCL: win; | Gebietsschema: de-DE (de_DE); UI-Sprache: de-DE | Calc: threaded
Comment 1 Jean-Baptiste Faure 2022-05-14 15:50:37 UTC
Not reproducible under Ubuntu 20.04 / Gnome with Version: 7.3.4.0.0+ / LibreOffice Community
Build ID: f668663d63d5b0f37d4727b54585c3b67ab92162
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Ubuntu_20.04_x86-64
Calc: threaded

Not reproducible with master: Version: 7.4.0.0.alpha1+ / LibreOffice Community
Build ID: c63b86501828d35c3a80aa5be2d70f992b4f1b23
CPU threads: 8; OS: Linux 5.13; UI render: default; VCL: gtk3
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Ubuntu_20.04_x86-64
Calc: threaded

Best regards. JBF
Comment 2 Rainer Bielefeld Retired 2022-05-15 06:07:57 UTC
Did a new test today with 7.3.3.2 (normal user profile) and 7.2.5.2 (dev. user profile), newly created calc doument and existing ones.  

Not reproducible. Strange, I will try somefurther investigation.
Comment 3 jteera5 2022-05-27 09:46:31 UTC
Created attachment 180424 [details]
LibreOffice Calc does not update autofill text example wrapped to multiple lines while input characters to a cell.

I encountered the same problem. The attached .ods file to show an example.

When a cell is formatted to wrap text automatically, and the first characters are input to the cell, Calc autofills the cell. If the autofill is wrapped to multiple lines, then a next character is input making it unmatched with the autofill, the rest of the line is cleared. But the autofill of the next line is still showed.

Product: LibreOffice Calc version 7.2.4.1 x86
OS: Windows 10 and Linux Mint 20.3

Steps to Reproduce
1. Edit => Select All
2. Format Cells => Properties => Wrap text automatically = YES
3. Input text that’s wrapped to another line. (Cell A1 = “aaaa bbbb [New Line] cccc dddd”)
4. Input text in another cell in the same column. For the first character ‘a’, it shows “aaaa bbbb [New Line] cccc dddd”.
5. As the unmatched character is input, in this case ‘b’, it shows “ab [New Line] cccc dddd”. It’s better to update immediately to “ab” so as not to confuse the user.
6. Finish the text. “cccc dddd” on the second line is cleared. Finally the correct text is displayed.
Comment 4 Martin Srdoš 2022-05-29 11:55:14 UTC
Reproducible in older version, but I can't reproduce in daily:
Version: 7.4.0.0.alpha1+ (x64) / LibreOffice Community
Build ID: bbec710bd25fc5da27636cde73fe4ab23c76904f
CPU threads: 8; OS: Windows 10.0 Build 19043; UI render: Skia/Vulkan; VCL: win
Locale: cs-CZ (cs_CZ); UI: en-GB
Calc: CL

Could you please try to reproduce it with a master build from https://dev-builds.libreoffice.org/daily/master/ ?
You can install it alongsidethe standard version.
I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the master build
Comment 5 Rainer Bielefeld Retired 2022-05-29 12:10:36 UTC
REPRODUCIBLE with 
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
Theme: Auto Colibre

No longer reproducible with
Version: 7.3.3.2 (x64) / LibreOffice Community
Build ID: d1d0ea68f081ee2800a922cac8f79445e4603348
CPU threads: 12; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded
Theme: Auto Colibre

Also not with 7.4.
I think problem is solved.