Ask Your Question

calc dropdown list [closed]

asked 2019-07-27 19:22:24 +0100 gravatar image

Hey Gang:

How do I use data for a drop down list that resides in an external file? I.e., FILE A looks into FILE B for a list of cities.

Thanks, Rich Ramik

edit retag flag offensive reopen merge delete

Closed for the following reason duplicate question by
close date 2020-07-23 20:37:00.990469

1 Answer

Sort by » oldest newest most voted

answered 2019-07-28 14:58:13 +0100

Pete of Ebor gravatar image

updated 2019-07-28 14:59:13 +0100

Just to clarify, are you using 'Data Validity' and a wishing to have drop-down selection list - with the selections held in another file ? Is that file completely seperate to LO calc or part of LO calc ? As far as I know (..and no doubt someone will be along to correct me if I'm wrong..) the data for the drop down list must appear on the same sheet as the original cell. If you have the data file on another LO calc sheet, you could copy that sheet into LO then set some cells on your current sheet to mirror the required data cells on the new sheet. If it's not a LO calc sheet, then other then copy/paste -ing the data to the LO sheet, then I don't know.

edit flag offensive delete link more


It would be in a separate sheet (LO calc file). I should have explained more fully. I have a list of cities and zipcodes. I want to share this "list" (file) with other spreadsheets. gravatar ( 2019-07-29 20:10:13 +0100 )edit

Question Tools

1 follower


Asked: 2019-07-27 19:22:24 +0100

Seen: 204 times

Last updated: Jul 28 '19