Description: In Calc, Autofill does not allow to edit the letter case of a cell if another cell with the same text exists. Also, autofill won't use the suggested content when editing cells containing multiple versions of the same text only differentiated by the letter case. Steps to Reproduce: 1. Open a new sheet in Calc 2. In cell A1 and A2 enter "banana peel" 3. Try to edit cell A2 to enter "Banana peel" => it gets replaced by "banana peel" 4. Play around by entering things like "banana Peel" or "Banana Peel" in cells A3 and A4, then try to edit the letter case in any of A1-A4 cells. Notice how sometimes autofill suggests a replacement but does not use it (ie it suggests "Banana Peel" but will fill the cell with "banana peel" if you press enter or an arrow key) 5. After some time of editing, you might lose ALL case variations and end up with cells A1-A4 all containing the same text... Actual Results: Autofill completely messes up the cell contents. Expected Results: Autofill should use the text it itself suggests to be inserted ! What you see should be what you get ! ^_^ Manual editing should get the priority other autofill when the cell content already exists in the sheet, to allow creating cells with same text BUT different letter case. Reproducible: Always User Profile Reset: No Additional Info: Has been happening in Windows and Linux for years... Current version I use is : Version: 6.2.8.2 Build ID: 1:6.2.8~rc2-0ubuntu0.18.04.1 Threads CPU : 4; OS : Linux 5.3; UI Render : par défaut; VCL: gtk3; Locale : fr-FR (fr_FR.UTF-8); Langue IHM : fr-FR Calc: threaded
Thank you for reporting the bug. I can reproduce the bug in Version: 6.4.0.0.alpha1+ (x86) Build ID: ec7374ff84c71edfbb30d6e4dc5b486b6df7107f CPU threads: 2; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; TinderBox: Win-x86@42, Branch:master, Time: 2019-11-10_21:37:30 Locale: en-US (en_US); UI-Language: en-US Calc: threaded
If you don't like disable the option, try with Undo [Ctrl+Z] after intro.
I absolutely do not wish to disable autofill/autoinput, as it can be a very useful feature for my work. I frequently need to duplicate a cell or change a few words in cells with very similar texts, and things usually go smoothly in this situation... But the problem occurs when I need to change the letter case.
And after [Enter] with the auto-input, undo [Ctrl-Z] doesn't recover you wanted input?
Oh, I see what you mean now... It wouldn't have occurred to me to use CTRL+Z, as from my point of view, it would have cleared the cell's content (and according to bug entry https://bugs.documentfoundation.org/show_bug.cgi?id=79404, it used to do it !). So if I understand correctly, autoinput is a intermediary action that gets added to the "undoable actions list" after I enter text in the cell. Thus it can get cancelled, and I get the content I really wanted in the cell. This is a bit of a "cheat code level" action, but... it works. I checked the LO Help and noticed nothing is said about CTRL+Z in the autoinput and autocorrect entries. The CTRL+Z trick appears in a different section which I didn't link to these functions at first sight... Clearly adding the CTRL+Z info in the autoinput and autocorrect entries would probably be relevant... Thanks for your help anyway ! ;)