https://bugs.freedesktop.org/show_bug.cgi?id=76784
Priority: medium
Bug ID: 76784
Assignee: [email protected]
Summary: FILEOPEN: Sheet References Lost
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.2.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 96600
--> https://bugs.freedesktop.org/attachment.cgi?id=96600&action=edit
Example Problem File
(Note: the actual LO version I'm using is 4.2.2-2, installed on Arch Linux/xfce
with pacman -Syu 3/19/2014. Also note that this may be similar to Bugs #75846
and 75950, though in a later minor version and on a different OS.)
I briefly mentioned this problem in Bug #76411. The primary focus of that
report was recalculation which I resolved through the guidance of Eike Rathke
and m.a.riosv. Thank you both.
I opened this ticket because of that companion problem that I thought would go
away with the recalculation resolution, but it didn't. Here are the details:
The attached spreadsheet file, which I have been using for quite a long time,
has four sheets. The first sheet is named Overview. Cells A1 and A3 of the
other three sheets refer back to Overview for titling information as follows:
A1: =Overview.A1
A3: =Overview.A3
Additionally, the Recap sheet summarizes data from Journal with broad use of a
formula of the form:
C6: =SUMIF(Journal.$G$5:$G$13681,C$4&$B6,Journal.$E$5:$E$13681)
Since my 3/19/2014 upgrade to LO 4.2.2-2, Calc has had 'trouble remembering'
the sheet references between saving, closing, and reopening the file. On
reopening at various times I have seen:
A1: =A1
A3: =#REF!!.A3
C6: =SUMIF(#REF!!$G$5:$G$13681,C$4&$B6,#REF!!$E$5:$E$13681)
C6: =SUMIF( $G$5:$G$13681,C$4&$B6, $E$5:$E$13681)
I was no help in detailing this problem in the earlier report, due to my
reluctance to share the financial data in the file. I have, however, modified
the file to remove all personal references, while preserving the structure,
size, and data relationships of the various cells. This copy of the file
behaves in the same incorrect manner as my original: If I correct the two types
of sheet references, it's fine during the Calc session, including after saving.
If I save the file, close it, and reopen it, it reverts back to the
missing-sheet-reference condition.
In addition to the redacted spreadsheet file, I will also upload a screenshot
(.png) and a print image (.pdf) of the Recap sheet. These will give a picture
of what the sheet looks like when working correctly.
Many thanks for your guidance on this issue. I am happy to provide any other
information that may help.
--
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
