Bug 161593

Summary:	Autoinput stale entries
Product:	LibreOffice	Reporter:	SY <sy>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEEDINFO ---
Severity:	normal	CC:	stephane.guillou
Priority:	medium
Version:	24.2.3.2 release
Hardware:	All
OS:	All
Whiteboard:
Crash report or crash signature:		Regression By:

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!