Ask Your Question
0

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

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

Boggle gravatar image

updated 2019-11-11 16:00:21 +0100

LibreCalc

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: https://i.imgur.com/IyrR8OW.png

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

Comments

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
1

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
0

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

Opaque gravatar image

Hello,

AFAIK this is not possible.

edit flag offensive delete link more

Question Tools

1 follower

Stats

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

Seen: 18 times

Last updated: Nov 11