https://bugs.freedesktop.org/show_bug.cgi?id=64883
Priority: medium
Bug ID: 64883
Assignee: [email protected]
Summary: multiple INDIRECTs result in spurious #REF
Severity: major
Classification: Unclassified
OS: Mac OS X (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.0.3.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 79685
--> https://bugs.freedesktop.org/attachment.cgi?id=79685&action=edit
test doc - does INDIRECT to fileb
I have a chain of files using INDIRECT to refer to each other filea -> fileb ->
filec. See attached files. (You will need to adjust a pathname in filea and
fileb for your situation)
When you open fileb you get the "This file contains links to other files.
SHould they be updated?" dialog. No matter if you choose Yes or No -- the cell
A1, which contains the INDIRECT, will be "#REF!".
Strangely if you select C1 and do Tools > Detective > Trace Precedents then the
value appears.
Now close fileb (without saving) and open file. A similar problem appears, but
Trace Precedents won't fix it.
[I can usually get things to work only by opening all the documents (about a
dozen in the real case) and doing various Trace/Cut/Undo operations. And then
I have to do it all again next time I reopen one of them.]
This may be related to fdo#45532 but it's not the same.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
