I have a cell that looks for a value in another file. When I save the file, it changes the address of the reference I placed and doesn't bring the value.
If I write the reference every time I need it, it brings it ok, unless I change the value in the origin reference. It brings the previous value.
IE 1: ORIGINAL AND CORRECT CELL REFERENCE 'file:///home/andres/Dropbox/creditos/resumen prestamos.xls'#$Real.D7+1
SAME CELL AFTER SAVING, CLOSING AND OPENING AGAIN =real!d7+1
And it doesn't work
IE 2: cell value moment 1 = 366. Pasting the cell reference brings '366' as value. If the 366 value changes, and I paste again the cell reference, it keeps bringing '366', even though I even edit the cell, press F9, save, etc. If I close and open again, and paste the cell reference, it works
Steps to Reproduce:
1.reference a value to another .xlsx file.
2.save and close both files
3.open file, and the reference is 'crooked' and doesn't work
reference doesn't work. It doesn't matter if the referenced file is opened or closed
reference to external files should work
User Profile Reset: No
Build ID: 1:6.0.6-0ubuntu0.18.04.1
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3;
Locale: es-AR (en_US.UTF-8); Calc: group
Your files seems to be ms format, then maybe it's a dup of:
yes, it's .xlsx format. But, shouldn't it work anyway?
Yes, but seems the same issue already reported tdf#76047
Sorry for not testing this, but I'll mark duplicate.
Andres, if you disagree, please explain and set back to Unconfirmed.
*** This bug has been marked as a duplicate of bug 76047 ***