Bug 143910 - Auto complete value is not functioning properly in Calc
Summary: Auto complete value is not functioning properly in Calc
Status: RESOLVED DUPLICATE of bug 143960
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.2 rc
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-08-17 04:53 UTC by andis.lazdins
Modified: 2021-09-07 08:37 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
Auto complete not working properly in 7.2.0.3 (8.18 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-08-17 04:55 UTC, andis.lazdins 		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 andis.lazdins 2021-08-17 04:53:06 UTC 
Description:
Auto complete text / values function is working properly only if there are no blank cells above / below cells to be filled. Previously blank cells were ignored and values from the whole column could appear in auto complete.

Steps to Reproduce:
1.Open attached file.
2.Go to cell A6
3.Type 'a'

Actual Results:
No auto complete options appears.

Expected Results:
Auto complete option 'abc' appears in the cell and can be selected by hitting Enter.


Reproducible: Always


User Profile Reset: Yes


OpenGL enabled: Yes

Additional Info:
Version: 7.2.0.3 / LibreOffice Community
Build ID: 2a7ea282da28d665a7dc086360567b4aea27bf08
CPU threads: 8; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: lv-LV (en_US.UTF-8); UI: en-US
Calc: CL
Comment 1 andis.lazdins 2021-08-17 04:55:52 UTC 
Created attachment 174332 [details]
Auto complete not working properly in 7.2.0.3

Auto complete is not working properly in 7.2.0.3 if there empty cells between the list of values and the cell to be filled. In 7.1.6 auto complete is working properly and blank cells are ignored.
Comment 2 Mike Kaganski 2021-08-17 05:37:22 UTC 
This is not a bug - the behavior has been changed in tdf#142214.
Comment 3 Ming Hua 2021-09-07 08:37:29 UTC 
Note that although bug 143960 is marked as NOTABUG, the relevant change has been reverted in both master and 7.2 branch, and the upcoming 7.2.1 release will no longer have this issue.

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