Hi to all,
I’m using calc on Linux and I’m trying to join various columns to make a path to a cell in another document. For that I’m using CONCATENATE() function but the result of that function is not processed as a formula.
example:
In A1: file:///home/user/Dropbox/
In A2: 2016/1/
In A3: test.ods’
In A4: =CONCATENATE("=’";A1;A2;A3;"#$’";“sheet1’.E4”
the result in A4 is:
=‘file:///home/unkuiri/Dropbox/2016/1/test.ods’#$‘sheet1’.E4
Is there any way to process this result as a formula and give the result of E4?
Thanks in advance