How to get Drop Down List From Another or Different Calc Document Data Range?

[sv.thiyagarajan]

Hi Friends,
How to I get Data, using Drop Down List in One Calc Document ( Target-Calc Document ) From Another or Different Calc Document ( Source - Calc Document ) ? Like Excel Have …

[karolus]

By creating a formula link in your document like:

='file:///path/to/the/other_spreadsheet.ods'#$Sheet1.A3:A9

of course as [x]array-formula
and use this as source of →Data→Validate

[sv.thiyagarajan]

Thanks, Karolus… Done…