Ask Your Question

[Calc] AutoInput values valid for any sheet? [closed]

asked 2019-11-11 15:56:20 +0100

Boggle gravatar image

updated 2020-07-20 14:56:11 +0100

Alex Kemp gravatar image


Currently, autoinput remembers values input on the current sheet only. So if I entered a word on Sheet 1, subsequent attempts to enter that word on that sheet would get an AutoInput prompt. I'd like that word to also get an autoinput prompt on OTHER sheets as well.

So if I enter "timecard" on SHEET 1, when I begin typing "timecard" on SHEET 2, I'd like autoinput to give me a prompt.

Is this possible to do?

EDIT: it appears that maybe it's not possible? Since it collects previously used words in that column . That seems very specific and not very useful...what if someone wants that feature in the same row? Anyway, here is the Screenshot from Librecalc guide:

(edit: activated screenshot)

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by erAck
close date 2019-11-12 19:52:04.655045


AutoInput does only work in same column. In that sense your statement ... that word on that sheet would get an AutoInput prompt is not correct.

Opaque gravatar imageOpaque ( 2019-11-11 16:03:41 +0100 )edit

That seems very specific and not very useful...

Personally I wouldn't want the name of an artist of a song from column Artists, when editing the title of a song in column Title. What I want to say: Usefulness may be a matter of the design of a sheet.

Opaque gravatar imageOpaque ( 2019-11-11 18:08:24 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-11-11 16:08:21 +0100

Opaque gravatar image


AFAIK this is not possible.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-11-11 15:56:20 +0100

Seen: 63 times

Last updated: Jul 20