Bug 161593 - Autoinput stale entries
Summary: Autoinput stale entries
Status: NEEDINFO
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
24.2.3.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2024-06-15 22:34 UTC by SY
Modified: 2024-07-01 14:57 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 SY 2024-06-15 22:34:53 UTC
Description:
Sometimes Autoinput inserts cell data that no longer exists in the column.

Steps to Reproduce:
1.  Enter `0,` in a cell
2.  Change the cell to `0,0,0`
3.  Type `0` in a cell in the same column


Actual Results:
Autoinput inserts stale entry: `0,`

Expected Results:
Autoinput inserts `0,0,0`


Reproducible: Couldn't Reproduce


User Profile Reset: No

Additional Info:
When pressing Alt + Down, the list of items does not contain the stale entry.  I can cycle between stale and correct entries using CTRL + Tab.
Comment 1 SY 2024-06-15 22:39:53 UTC
To clarify: this behavior happens 100% of the time in affected spreadsheets, but I wasn't able to find specific steps to reproduce it with a new spreadsheet.
Comment 2 Stéphane Guillou (stragu) 2024-07-01 14:57:18 UTC
Couldn't reproduce in:

Version: 24.2.4.2 (X86_64) / LibreOffice Community
Build ID: 51a6219feb6075d9a4c46691dcfe0cd9c4fff3c2
CPU threads: 8; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: CL threaded

(In reply to SY from comment #1)
> To clarify: this behavior happens 100% of the time in affected spreadsheets,
> but I wasn't able to find specific steps to reproduce it with a new
> spreadsheet.
Any chance you can share a (sanitised) sample document?

Please also share the full info copied with the button in Help > About LibreOffice.
Thank you!