Ask Your Question
0

Is there a way to delete certain Autofill entries in Calc without turning it off completely?

asked 2019-10-01 12:12:45 +0100

evbo gravatar image

For example, I'm working on a spreadsheet where the vast majority of cells have the word 'called' - normally as soon as I type 'c' it suggests an autofill of 'called', as expected. In one cell, once, I entered 'called, on holiday, call back next week' and now every time I press 'c' it prompts me to autofill to 'called, on holiday, call back next week'.

Is there a way to remove this suggestion and still keep Autofill?

6.2.4.2

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2019-10-01 12:21:23 +0100

Opaque gravatar image

updated 2019-10-01 12:24:13 +0100

Hello

short answer: no, that's not possible.

Autofill (the term in LibreOffice for the function you are talking about in fact is AutoInput) is dynamically created from the values of the current column without any filtering against some black list. To restrict allowed values you need to use Data -> Validity.

edit flag offensive delete link more

Comments

Ah thanks, guess I'll have to insert a new column and re-enter the values I do want and rename the unwanted one to start with a different letter.....

And yes of course, AutoInput

evbo gravatar imageevbo ( 2019-10-01 12:25:55 +0100 )edit

Find & Replace the unwanted ?

And please click the check mark (✔) next to the answer, if you consider your question being answered

Opaque gravatar imageOpaque ( 2019-10-01 12:27:44 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2019-10-01 12:12:45 +0100

Seen: 24 times

Last updated: Oct 01