Bug 76784

Created attachment 96600 [details]
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.