Bug 143960 - CALC AutoFill "autocompletion" is broken in 7.2
Summary: CALC AutoFill "autocompletion" is broken in 7.2
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.1 rc
Hardware: All All
: high critical
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisected, bisected
: 143910 143970 144100 144212 144251 144323 144345 144489 144550 (view as bug list)
Depends on:
Blocks:
 
Reported: 2021-08-19 20:32 UTC by Viktor
Modified: 2023-09-28 01:15 UTC (History)
13 users (show)

See Also:
Crash report or crash signature:

Attachments
LO7.1.5.2_OK.gif (88.20 KB, image/gif)
2021-08-19 20:32 UTC, Viktor 		Details
LO7.2.0.4_FAILURE.gif (112.20 KB, image/gif)
2021-08-19 20:33 UTC, Viktor 		Details
Testfile.ods (10.60 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-08-19 20:33 UTC, Viktor 		Details
Example attached (15.23 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-09-16 15:17 UTC, Getafix 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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)