Description: When I'm typing words that already exist in a Calc sheet new space LibreOffice used to autocomplete but no does not. there is no Autocomplete option on the Tools menu for me to toggle on.off. Steps to Reproduce: 1.Start typing a word in a Calc cell 2. No autofill suggestions appear 3. Complete typing word Actual Results: Nothing Expected Results: Expected a word to be autocompleted before completing entry of word Reproducible: Always User Profile Reset: Yes Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no
Can not confirm. The "toggle" *is* on the Tools menu. Look again Tools -> AutoInput And note that the function in Calc applies match to existing cell content held in the same column as current cursor focus. The input "match" will not check adjacent columns. =-testing-= Version: 7.3.6.1 (x64) / LibreOffice Community Build ID: 92b673af3a5e8f7cf4716be88dfaca424612f244 CPU threads: 8; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win Locale: en-US (en_US); UI: en-US Calc: threaded
Thanks for your reply. I do have that toggle checked. Yes, I have seen it for quite a while and recently it disappeared, so I know how it is supposed to function. It just isn't doing so.
Maybe you have eliminated it, inadvertently Menu/Tools/Customize - Menus
If you read my prior comment I wrote that it is there (on the menu) and selected but not operating.
There is stanza in the Tools -> Options 'Open Expert Configuration' that also will toggle. And is reset when you clear (delete or rename) your user profile. org.openoffice.Office.Calc ---> Input property AutoInput boolean true | false but change there should be mirrored in the GUI. Beyond that can't fathom the issue as it WFM.
Seems with 7.3 there was a change for the autocompletion of the AutoInput in calc, the UI now implements bash style completion. Which changes the AutoInput completion and requires users to adjust their workflow--should be more efficient once you do. see also enhancement bug 145198 to implement discussion of ESC in [1] If that is issue this seems a dup of bug 150664 =-ref-= [1] https://lists.freedesktop.org/archives/libreoffice/2021-October/087911.html * Calc auto-complete behavior changes (Kendy)
Thank you!! Yes, the cited bug report sounds very similar to my experience. I'm not clear on whether there was any further action to resolve this or identify the issue. Your earlier comment makes it sound like you think the "new" behavior is more efficient?
(In reply to not4877 from comment #7) > Thank you!! Yes, the cited bug report sounds very similar to my experience. > I'm not clear on whether there was any further action to resolve this or > identify the issue. Your earlier comment makes it sound like you think the > "new" behavior is more efficient? Well, the autoinput completion does work--just differently--and users will have to rework muscle memory to take advantage of the "feature". But with than and if you also work in use of the "<Alt><Down>" listbox completion for your input/edit process you should be well served. Seems like there is additional refactoring to be done--in meanwhile it should be functional.
*** Bug 150644 has been marked as a duplicate of this bug. ***