Issue 109832 - Can't grab cell reference from another sheet in particular document in particular cells
Summary: Can't grab cell reference from another sheet in particular document in partic...
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1.1
Hardware: PC Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: needhelp, oooqa
: 108792 (view as issue list)
Depends on:
Reported: 2010-03-05 01:01 UTC by ts1653
Modified: 2013-01-29 21:40 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

ScreenCaptures and Step-by-Step description (447.87 KB, application/vnd.oasis.opendocument.text)
2010-03-05 01:04 UTC, ts1653
no flags Details
SpreadSheet used (40.00 KB, application/
2010-03-05 01:05 UTC, ts1653
no flags Details
Test Case 2 (552.77 KB, application/vnd.oasis.opendocument.text)
2010-03-05 18:07 UTC, ts1653
no flags Details
Reconstituted Spresdsheet (45.50 KB, application/
2010-03-05 18:08 UTC, ts1653
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description ts1653 2010-03-05 01:01:51 UTC
The application does not grab cell reference from another tab. This is what I 

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 "=" 
Comment 1 ts1653 2010-03-05 01:04:04 UTC
Created attachment 68161 [details]
ScreenCaptures and Step-by-Step description
Comment 2 ts1653 2010-03-05 01:05:35 UTC
Created attachment 68162 [details]
SpreadSheet used
Comment 3 Rainer Bielefeld 2010-03-05 07:16:56 UTC
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?

What is the difference here to your report in Issue 108792?
Comment 4 ts1653 2010-03-05 18:07:25 UTC
Created attachment 68173 [details]
Test Case 2
Comment 5 ts1653 2010-03-05 18:08:35 UTC
Created attachment 68174 [details]
Reconstituted Spresdsheet
Comment 6 ts1653 2010-03-05 18:20:51 UTC
It is not a circular reference problem, which is AtoB&BtoA; but this is 

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 

YOu can ignore 108792; it did not have enough details.
Comment 7 Rainer Bielefeld 2010-04-18 10:12:28 UTC
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.
Comment 8 Rainer Bielefeld 2010-04-18 10:13:28 UTC
*** Issue 108792 has been marked as a duplicate of this issue. ***