Description: Make Calc's autoinput behave like autocompletion in Bash. Refer the section "Calc auto-complete behavior changes" in https://lists.freedesktop.org/archives/libreoffice/2021-October/087911.html for context. Steps to Reproduce: Consider an example of the following data in a column: ABCD123xyz ABCD345qwel ABCD123pqr ABCD123xyz PQR Currently on master, if the user types A in an empty cell in the same column it does not show any suggestion and the only way to enter the text "ABCD123pqr" using autocomplete is to type "ABCD123p". Actual Results: Currently on master, if the user types A in an empty cell in the same column it does not show any suggestion and the only way to enter the text "ABCD123pqr" using autocomplete is to type "ABCD123p". Expected Results: If the user types A it should show the partial completion BCD (common prefix). If the user accepts that types 1 it should show the next partial suggestion 23. If the user accepts again and types p it should show the final completion of qr. Reproducible: Always User Profile Reset: No Additional Info: Version: 7.3.0.0.alpha0+ / LibreOffice Community Build ID: ebd45a80a8024c1f4fd435cedc74d60ccdec6d87 CPU threads: 8; OS: Linux 5.11; UI render: default; VCL: gtk3 Locale: en-IN (en_IN); UI: en-US Calc: threaded
Dennis Francis committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/4cfa840ecaa5a094a32a60a60b295858980109df tdf#145198: Bash like autocompletion for Calc autoinput It will be available in 7.3.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
The Calc's autoinput function is great, but it can be a little frustrating to get it to do what you want. This post will teach you how to use the shell and its autocompletion https://bestwritingsclues.com/reviews/papernow-review/ features, so that you can make your life easier with autoinput!
Reviewing 7.3 release notes. Verified in: Version: 7.3.0.1 / LibreOffice Community Build ID: 840fe2f57ae5ad80d62bfa6e25550cb10ddabd1d CPU threads: 4; OS: Linux 5.4; UI render: default; VCL: gtk3 Locale: en-AU (en_AU.UTF-8); UI: en-US Calc: threaded
Is it possible to switch between old and new auto-completion behaviour? Because this new behaviour is worse for me.
Good tips! I can give you some suggestions like how to screenshot on mac: https://howtoscreenshot.co/how-to-take-a-screenshot-on-your-mac
Praise the Lords of Codes! Thanks so much!
After migrating to Linux Mint 21.2 I found myself stuck with LO 7.3.7(.2?). I found this bug and bug 142214 today. Just now, I added the LO PPA and updated to 7.6.3.2, but to me it seems the auto-complete behaviour hasn't changed. Example: A 1 Ox 2 Office When I type O in A3 nothing happens. Shouldn’t there be something appearing, or am I understanding this thread and that of bug 142214 wrong? I would expect Calc to auto-complete to Office. Looks like the bug is back.
(In reply to foubug from comment #7) > Shouldn’t there be something appearing, > or am I understanding this thread and that of bug 142214 wrong? I would > expect Calc to auto-complete to Office. Looks like the bug is back. You are misunderstanding the (inefficient) modification imposed by Dennis. Indeed, as many other users noticed, the behavior since LO 7.3 is less efficient and does not immediately auto-complete; users need additional steps (in comparison to the older behavior) in order to trigger the auto-complete suggestion.
Doesn’t his commit state otherwise? https://git.libreoffice.org/core/commit/4cfa840ecaa5a094a32a60a60b295858980109df
(In reply to foubug from comment #9) > Doesn’t his commit state otherwise? > https://git.libreoffice.org/core/commit/4cfa840ecaa5a094a32a60a60b295858980109df No. Taking your example: A 1 Ox 2 Office In cell A3, type-in "O" (without quotation marks) and (with the newer bash-like auto-complete) you will find _no_ suggestion (yet). Now add one more letter, "Of" (without quotation marks), and you will get the first suggestion. IOW, to be able to get some auto-complete suggestion, the typed-in characters must offer some kind of uniqueness while they must match a prior entry in the same (data) column. If the already typed-in characters are equal to one unique (prior) value (in the column), then the full-cell content suggestion is offered to the user for auto-complete. Using "bash-like" methods, you could have part-cell content suggestions. As many users mentioned before, the new algorithm is not better. But since this report is closed now and the bash-like behavior has been implemented for several versions by now, there is no point on continuing adding comments here. If you need assistance with this behavior, or alternative methods for introducing (repeating) values/data, I would suggest first carefully reading the related reports (such as bug 142214 and others "see also" reports), and then you might want to open a new topic on <https://ask.libreoffice.org>. If all that is not enough, you might want to open a new enhancement request report.
(In reply to ady from comment #10) > No. Taking your example: > > A > 1 Ox > 2 Office > > In cell A3, type-in "O" (without quotation marks) and (with the newer > bash-like auto-complete) you will find _no_ suggestion (yet). Now add one > more letter, "Of" (without quotation marks), and you will get the first > suggestion. Ok, so it’s a bug, because: »1. When user types A, it will show the partial suggestion BCD.« > If you need assistance with this behavior, or alternative methods for > introducing (repeating) values/data, I would suggest first carefully reading > the related reports (such as bug 142214 and others "see also" reports), and > then you might want to open a new topic on <https://ask.libreoffice.org>. If > all that is not enough, you might want to open a new enhancement request > report. Sorry, no time for endless discussions. I’ll have to live with the fact that, once more, one of the best software options has deteriorated somewhat in quality.
In order to avoid misleading other readers, I am compelled to reply, unfortunately. (In reply to foubug from comment #11) > Ok, so it’s a bug, because: > > »1. When user types A, it will show the partial suggestion BCD.« You are misunderstanding, again. That quote is relevant for the following data set: ABCD123xyz ABCD345qwel ABCD123pqr ABCD123xyz PQR ...in which _all_ the values that start with the same initial characters that were introduced ("A" in this case), continue with the same set of characters ("BCD" in this case). The first character that differentiates the values (i.e. after the "ABCD" initial characters in this example) stops the auto-complete and so the user is required to type-in additional characters. > > If you need assistance with this behavior, or alternative methods for > > introducing (repeating) values/data, I would suggest first carefully reading > > the related reports (such as bug 142214 and others "see also" reports), and > > then you might want to open a new topic on <https://ask.libreoffice.org>. If > > all that is not enough, you might want to open a new enhancement request > > report. > > Sorry, no time for endless discussions. I’ll have to live with the fact > that, once more, one of the best software options has deteriorated somewhat > in quality. Then please avoid additional comments in this bug report, unless there is something relevant to it.