Ask Your Question
0

calc dropdown list

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

richramik@yahoo.com 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 close merge delete

1 Answer

Sort by » oldest newest most voted
0

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

Comments

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.

richramik@yahoo.com gravatar imagerichramik@yahoo.com ( 2019-07-29 20:10:13 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 70 times

Last updated: Jul 28