Bug 145198 - Bash like autocompletion for Calc's autoinput
Summary: Bash like autocompletion for Calc's autoinput
Status: CLOSED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.3.0.0 alpha0+
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: target:7.3.0 inReleaseNotes
Keywords:
Depends on:
Blocks: AutoCorrect-Complete
  Show dependency treegraph
 
Reported: 2021-10-18 09:16 UTC by Dennis Francis
Modified: 2023-09-03 10:26 UTC (History)
2 users (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 Dennis Francis 2021-10-18 09:16:56 UTC
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
Comment 1 Commit Notification 2021-10-18 11:21:20 UTC
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.
Comment 2 Felicia Medina 2021-11-15 05:53:53 UTC Comment hidden (spam)
Comment 3 Stéphane Guillou (stragu) 2022-01-01 11:38:35 UTC
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
Comment 4 bugzilla2 2022-07-01 17:33:51 UTC
Is it possible to switch between old and new auto-completion behaviour? Because this new behaviour is worse for me.
Comment 5 galvindai 2022-09-08 08:41:38 UTC Comment hidden (spam)
Comment 6 Jax 2023-09-03 10:26:34 UTC
Praise the Lords of Codes!

Thanks so much!