https://bugs.documentfoundation.org/show_bug.cgi?id=120845
Bug ID: 120845
Summary: link to other worksheets don't work well
Product: LibreOffice
Version: 6.0.6.2 release
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
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 =[2]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
Actual Results:
reference doesn't work. It doesn't matter if the referenced file is opened or
closed
Expected Results:
reference to external files should work
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.0.6.2
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
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
