Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

File name link concatenation

Hello

Using the following I can, of course, call in data into my current spreadsheet file:

='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

However, I'd like to be able to reference the last two digits, "22", from another cell, say A1, in my current spreadsheet file, something like this:

=CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))

Where the value in cell A1 is "22".

Unfortunately, as you'll know, this simply results in a cell displaying the following, but not the data contained in the remote file's cell:

'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

The method is eluding me, despite much searching.

I'd be most grateful if someone could help.

Thank you.

File name link concatenation

Hello

Using In Calc, using the following I can, of course, call in data into my current spreadsheet file:

='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

However, I'd like to be able to reference the last two digits, "22", from another cell, say A1, in my current spreadsheet file, something like this:

=CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))

Where the value in cell A1 is "22".

Unfortunately, as you'll know, this simply results in a cell displaying the following, but not the data contained in the remote file's cell:

'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

The method is eluding me, despite much searching.

I'd be most grateful if someone could help.

Thank you.

File name link concatenation

Hello

In Calc, using the following I can, of course, call in data into my current spreadsheet file:

='file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

However, I'd like to be able to reference the last two digits, "22", from another cell, say A1, in my current spreadsheet file, something like this:

=CONCAT("'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))

or

=CONCAT("=","'file:///home/jamesb/Documents/List.ods'#$'R&D'.H",N(A1))

Where the value in cell A1 is "22".

Unfortunately, as you'll know, this simply results in a cell displaying the following, but not the data contained in the remote file's cell:

'file:///home/jamesb/Documents/List.ods'#$'R&D'.H22

The method is eluding me, despite much searching.

I'd be most grateful if someone could help.

Thank you.