Ubuntu
openoffice.org package

DATA VALIDITY

Asked by Ivan Matic

I have problem with linking cell range from second spreadsheet file to first spreadsheet cell
in list box (data validity).

I type link of cell range from second spreadsheet but don't work. Always give me message "Invalid value"...
I type next link 'file:///home/ivanmatic/DOKUMENTACIJA/Podaci.ods'#SifraKupca

SifraKupca is defined cell range in spreadsheet Podaci.ods (second spreadsheet, from where I want use defined cell range)

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
GercoKees
Solved:
Last query:
Last reply:
Revision history for this message
GercoKees (gercokees) said : 		#1

hi,
Please try the following:
open both sheets,
now goto sheet A.xls, goto your desired cell and press "=" (which starts formula editing)...
now goto Window and select your other sheet (use your mouse).
point to your desired cell and press enter...
the cell in A.xls should now show something like:

='file:///home/yourname/A.xls'#$Sheet1.A1

Success,
Let me know when you still have problems...

Revision history for this message
Best GercoKees (gercokees) said : 		#2

by the way,
You can copy paste the above line to your own sheet and adjust the reference as you like...

Revision history for this message
Ivan Matic (ivan-s-matic) said : 		#3

Yes, that work.

Thank you.

Generally I have problem with linking cell range from second spreadsheet file to first spreadsheet cell
in list box (data validity).

I type link of cell range from second spreadsheet but don't work. Always give me message "Invalid value"...
I type next link file:///home/ivanmatic/DOKUMENTACIJA/Podaci.ods'#SifraKupca

SifraKupca is defined cell range in spreadsheet Podaci.ods

Revision history for this message
GercoKees (gercokees) said : 		#4

...I type next link file:///home/ivanmatic/DOKUMENTACIJA/Podaci.ods'#SifraKupca...

Do not forget the ' and the $ and the celladdress (A1)
='file.......'#$Si....ca.A1