Bug 144345

Summary:	LibreOffice 7.2 AUTOINPUT scans only nearest clumped strings
Product:	LibreOffice	Reporter:	Gerald Aycardo <gba776>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	xiscofauli
Priority:	medium
Version:	7.2.0.4 release
Hardware:	All
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description Gerald Aycardo 2021-09-07 02:36:55 UTC

Description:
When I type any text, autoinput usually offers similar strings written on several cells on the same column even if there are blank cells between them. But now at LO 7.2, it only offers the nearest similar strings if clumped together (just like Microsoft Excel). 

Steps to Reproduce:
1. Cell A1 - type AAAA
2. Cell A2 - type BBBB
3. Cell A3 - type CCCC
3. Cell A4 - type A (AAAA is displayed as an option) then select option AAAA
4. Cell A10 - type A (does not offer AAAA as an option)

Actual Results:
After typing on cell A10, it does not offer a similar string found several cells before it unless no blank cells exist.

Expected Results:
When typing A on cell A10, the string AAAA should be displayed as an option.


Reproducible: Always


User Profile Reset: No



Additional Info:
AUTOINPUT (Help Menu)
Switches the AutoInput function on and off, which automatically completes entries, based on other entries in the same column. The column is scanned up to a maximum of 2000 cells or 200 different strings.

Comment 1 Xisco Faulí 2021-09-07 07:54:54 UTC

Thanks for reporting this issue.
This is a duplicate of bug 143960

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