Bug 144323 - Auto-fill feature in Calc works incorrectly
Summary: Auto-fill feature in Calc works incorrectly
Status: RESOLVED DUPLICATE of bug 143960
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.2.0.4 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-09-06 08:09 UTC by p.loretz@posnet.com
Modified: 2021-09-07 08:38 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description p.loretz@posnet.com 2021-09-06 08:09:40 UTC
Description:
When typing in cell the auto-fill feature misses some data typed in the same column above. Sometimes you have to type the whole word, despite the same word was typed above. In the previous version of Calc (7.0) the auto-fill feature worked better, even with short two-character words - these were auto-filled correctly. 

Steps to Reproduce:
1.type words in several cells in the same column (especially short random abrevation as an ex. "AP", "PL", "RP").
2.save the file and reopen
3.in the same column type some same words used above




Actual Results:
Auto-fill works incorrectly, sometimes you have to manually fill the word used above, what makes auto-fill pointless. Auto-fill seems to work ok with words typed in the same session, but badly with words typed in the previous sessions or typed in a distant row. The auto-fill do not work after a typing a single character.

Expected Results:
Auto-fill should works as in the previous version of Calc. Even when a single character is typed the auto-fill should work.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: pl
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Comment 1 p.loretz@posnet.com 2021-09-06 08:24:16 UTC
Additional info:
auto-fill do not work when there is an empty cell in column. It seems the auto-fill range is up to the gap only. It range should be the whole column and gaps should be ignored.
Comment 2 p.loretz@posnet.com 2021-09-06 08:27:54 UTC
When typing the first character in two-character words, auto-fill works only when use the ctrl-tab key combination. It should work from the fist char. instantly, and ctrl-tab should switch between similar words.
Comment 3 Buovjaga 2021-09-06 08:29:03 UTC
Changes were intentional. Further discussion happening at bug 142214
Comment 4 Ming Hua 2021-09-07 08:38: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 ***