Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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, I think no.

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 think no.don't know.