Apache OpenOffice (AOO) Bugzilla – Issue 109832
Can't grab cell reference from another sheet in particular document in particular cells
Last modified: 2013-01-29 21:40:48 UTC
The application does not grab cell reference from another tab. This is what I did: 1 Click a cell 2 Type in "=" to start writing formula 3 Click on other Tab to go to another sheet 4 Click to grab a reference cell and press the Enter key 5 The screen returns to the original sheet and moves down to the next cell without adding the reference cell to the formula. See attached copies of the spreadsheet and screen captures. It works only if I first click in the formula window after entering the "=" sign.
Created attachment 68161 [details] ScreenCaptures and Step-by-Step description
Created attachment 68162 [details] SpreadSheet used
I checked "BudgetTemplate.xls", it seems to eb a circular reference problem: In 'E17' there is a reference to 'D17' Grabbing will work without problems from Cell B50 ro to cells in "Budget 2011" from "Budget 2010". I believe this issue is INVALID? @ts1653 What is the difference here to your report in Issue 108792?
Created attachment 68173 [details] Test Case 2
Created attachment 68174 [details] Reconstituted Spresdsheet
It is not a circular reference problem, which is AtoB&BtoA; but this is AtoB&BtoC. Further testing narrowed down the problem; the problem is between Columns C&D of Budget2010/Budget2011 and Tab AnnuityFactors. It works if I mouse-click once in the formula window after the "=" sign and then go to the AnnuityFactors Tab. See attached pictures, FormulaScreenCaptures2.odt. It works fine in MS Excel. I then reconstitued BudgetTemplate and it works -- there might be some thing in Columns C&D of Budget2010/Budget2011 that OO does not like. See Budget_Template2.xls. YOu can ignore 108792; it did not have enough details.
I did some further tests with 3.1.1 and 3.3 Dev and found out: Grabbing will work if you open a second new window for sheet "AnnuityFactors". Steps to reproduce: 0. Open sample document 1. Menu 'Window -> New Window' 2. Change to old window (<alt>+<tab>) 3. Click 'D17' 4. Press Key "=" "=" appears 5. change to other document window for sheet "AnnuityFactors" 6. click 'E14' 7. <Enter> Formula "=AnnuityFactors.E14" will be taken to sheet 'Budget 1001 - D17' and result "0.01"will be shown. If you change back to other document window between step 6 and step 7 for a look you will see formula in 'E14' No Idea why this works in this way and what the reason for the problem might be (I can't reproduce the problem with own doucuments), but I believe it is a bug.
*** Issue 108792 has been marked as a duplicate of this issue. ***