Ask Your Question

Choose a different autocomplete option in Calc

asked 2018-05-21 17:09:52 +0100

Carlyle gravatar image

updated 2018-05-21 17:17:13 +0100

I'm working in a column where many values start with the same pattern, like "First", "First but goes after second", "First and third", "Sixth, "Sixth and eleventh", etc. Only some of those values are frequent, let's say "First" and "Sixth" appear in multiple cells, while the others are unique cases. However, Calc's autocomplete always suggests the wrong option; so if I start typing "First" it suggests "First but goes after second", forcing me to delete the extra text each time, all because a previous cell happened to use it once.

Is there a way to choose a different option, like with a drop down menu or something similar, or to make the autofill not suggest certain values?

For clarification: I do not want to disable autocomplete, I want to continue using it but I want it to autofill the correct value.

edit retag flag offensive close merge delete


Perhaps the combination of keys Ctrl+Tab will solve your problem?

JohnSUN gravatar imageJohnSUN ( 2018-05-21 17:46:56 +0100 )edit

@JohnSUN It does help, thank you! Any way to delete unwanted suggestions though?

Carlyle gravatar imageCarlyle ( 2018-05-21 18:03:18 +0100 )edit

Well, if you can accurately explain to us which ones are unwanted - we can try together to explain the same for Calc :-)

JohnSUN gravatar imageJohnSUN ( 2018-05-21 19:00:30 +0100 )edit

@JohnSUN Well, as I explained in my example, if I have "First", "First but goes after second" and "First and third", only "First" is a wanted suggestion and I'd like to remove the others.

Carlyle gravatar imageCarlyle ( 2018-05-22 15:31:12 +0100 )edit

In other words, do you need the shortest of variant? Does Calc not offer the first exactly this - the shortest of the options for substitution?

JohnSUN gravatar imageJohnSUN ( 2018-05-22 16:07:05 +0100 )edit

If you press Alt+Down Arrow (as recommended here), will the list be sorted alphabetically?

JohnSUN gravatar imageJohnSUN ( 2018-05-22 16:39:54 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-04-18 18:21:21 +0100

ferenczy gravatar image

I just would like to summarize suggestions from comments here.

When an auto-completion suggestion is shown inside a cell (after a character is typed, suggested text is selected):

  • Ctrl + Tab cycles through all auto-completion values for the cell, on every key press, selected suggested text is replaced with the next suggestion
  • Alt + Down shows a pop-up select box under the cell with all auto-completion suggestions sorted alphabetically
edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2018-05-21 17:09:52 +0100

Seen: 2,060 times

Last updated: Apr 18 '19