Bug 143960

Summary: CALC AutoFill "autocompletion" is broken in 7.2
Product: LibreOffice Reporter: Viktor <sorix>
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: critical CC: andis.lazdins, aron.budea, dennisfrancis.in, fios, franco_fuochi, gba776, gurvender.bahia, ilmari.lauhakangas, michael.warner.ut+libreoffice, p.loretz, rich.holtman, vasvg, xiscofauli
Priority: high Keywords: bibisected, bisected
Version: 7.2.0.1 rc   
Hardware: All   
OS: All   
See Also: https://bugs.documentfoundation.org/show_bug.cgi?id=142214
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: LO7.1.5.2_OK.gif
LO7.2.0.4_FAILURE.gif
Testfile.ods
Example attached

Description Viktor 2021-08-19 20:32:26 UTC 
Description:
In versions <7.2 the auto-completion worked cleanly.
Since version 7.2 this is only usable to a very limited range.
► have a look on the two GIF and give a try.

Steps to Reproduce:
1. have a look on the GIF and the Testfile I have provided

Actual Results:
not really useable for some kind of daily work

Expected Results:
working as in Versions 7.1.5.2


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
█ Tested under █
Version: 7.2.0.4 (x64) / LibreOffice Community
Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b
CPU threads: 12; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL

█ AND wqorking under █
Version: 7.1.5.2 (x64) / LibreOffice Community
Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5
CPU threads: 12; OS: Windows 10.0 Build 22000; UI render: Skia/Vulkan; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: CL
Comment 1 Viktor 2021-08-19 20:32:49 UTC 
Created attachment 174433 [details]
LO7.1.5.2_OK.gif
Comment 2 Viktor 2021-08-19 20:33:03 UTC 
Created attachment 174434 [details]
LO7.2.0.4_FAILURE.gif
Comment 3 Viktor 2021-08-19 20:33:33 UTC 
Created attachment 174435 [details]
Testfile.ods
Comment 4 Getafix 2021-08-23 14:18:52 UTC 
Duplicate reporting in 
113499, 143960, 143970
Comment 5 Xisco Faulí 2021-08-24 14:40:35 UTC 
Regression introduced by:

https://cgit.freedesktop.org/libreoffice/core/commit/?id=ca2ec443893731093970914feb750b31ea13e47f

author	Dennis Francis <dennis.francis@collabora.com>	2021-05-07 16:32:52 +0530
committer	Dennis Francis <dennis.francis@collabora.com>	2021-05-13 16:23:46 +0200
commit ca2ec443893731093970914feb750b31ea13e47f (patch)
tree 840c2980d6f7e73c0b68284008dc2dc3ad3c4ed4
parent f8039c6d645acb015a6c4e45000bbfd1311bfea3 (diff)
tdf#142214: autocomplete: do not search across empty blocks

Bisected with: bibisect-linux64-7.2

Adding Cc: to Dennis Francis
Comment 6 Xisco Faulí 2021-08-24 14:42:01 UTC 
*** Bug 143970 has been marked as a duplicate of this bug. ***
Comment 7 Buovjaga 2021-08-24 15:03:06 UTC 
Not a bug, intentional. Possible tweaks are being discussed in bug 142214
Comment 8 Ming Hua 2021-08-29 03:49:51 UTC 
*** Bug 144100 has been marked as a duplicate of this bug. ***
Comment 9 Xisco Faulí 2021-09-07 07:54:54 UTC 
*** Bug 144345 has been marked as a duplicate of this bug. ***
Comment 10 Xisco Faulí 2021-09-07 07:56:03 UTC 
FYI: the commit introducing the new behaviour has been reverted in master, libreoffie-7-2 and libreoffice-7-2-1 branches, thus the problem reported here won't be reproducible in the upcoming LibreOffice 7.2.1 version
Comment 11 Ming Hua 2021-09-07 08:34:56 UTC 
*** Bug 144251 has been marked as a duplicate of this bug. ***
Comment 12 Ming Hua 2021-09-07 08:36:26 UTC 
*** Bug 144212 has been marked as a duplicate of this bug. ***
Comment 13 Ming Hua 2021-09-07 08:37:29 UTC 
*** Bug 143910 has been marked as a duplicate of this bug. ***
Comment 14 Ming Hua 2021-09-07 08:38:29 UTC 
*** Bug 144323 has been marked as a duplicate of this bug. ***
Comment 15 Ming Hua 2021-09-14 13:11:53 UTC 
*** Bug 144489 has been marked as a duplicate of this bug. ***
Comment 16 Getafix 2021-09-16 15:16:16 UTC Comment hidden (obsolete)
Comment 17 Getafix 2021-09-16 15:17:44 UTC 
Created attachment 175078 [details]
Example attached

AutoCompletion or AutoFill or AutoInput  STILL NOT WORKING properly in 7.2.1 Final version as it used to work in 7.1.x


Earlier (7.1.x) it started to AutoFill from first letter, now (7.2.1 final) it will start autofill/autoinput from where it finds the word is Unique



Auto Fill / AutoFill / AutoInput used to work fine till 7.1.5 (havent cheched 7.1.6)
It was completely broken in 7.2.0
Now its partially working in 7.2.1



It used to work perfectly in 7.1.x, from first letter it used to autofill and gave you live options as you kept typing


Autofill / AutoInput / AutoCompletion should work exactly like it used to work in 7.1.x

This is a really make or break deal in Calc

Thanks in advance
Comment 18 Buovjaga 2021-09-16 15:23:18 UTC 
Please be patient and refer to bug 142214 comment 34.
Comment 19 Buovjaga 2021-09-16 15:27:07 UTC 
*** Bug 144550 has been marked as a duplicate of this bug. ***
Comment 20 Getafix 2021-09-16 16:40:33 UTC Comment hidden (abusive)