Bug 51731 - EDITING: Referencing in a different sheet when freeze window used
Summary: EDITING: Referencing in a different sheet when freeze window used
Status: RESOLVED DUPLICATE of bug 47349
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-07-04 14:19 UTC by Julien Nabet
Modified: 2012-07-05 04:41 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Julien Nabet 2012-07-04 14:19:59 UTC
Problem description: (from IRC)
In sheet A if window freeze is used, referencing a cell in sheet B can't work in some conditions

Steps to reproduce: 1) new calc 2) click on B2 3) Window->Freeze 4) click on B3 5) hit '=' 6) select Sheet2 7) click anyway [focus is lost]
1. new calc file
2. click on B2
3. "Window" menu/"Freeze"
4. Click on B3
5. type '=' (without the quotes of course)
6. select Sheet2 (or add one sheet if needed)
7. click anyway in Sheet2
8. type Enter 

Current behavior:
The cell selected is referenced in B3

Expected behavior:
The cell selected should be referenced in B3
Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (X11; Linux x86_64; rv:10.0.5) Gecko/20100101 Firefox/10.0.5 Iceweasel/10.0.5
Comment 1 Julien Nabet 2012-07-04 14:22:37 UTC
Reproduced to on master sources updated today.

Another buggy case :
1) new calc 2) click on B2 3) Window->Freeze 4) click on C3 5) hit '=' 6) select Sheet2 7) click anywhere: focus is lost

An OK case :
1) new calc 2) click on B2 3) Window->Freeze 4) click on D3 5) hit '=' 6) select Sheet2 7) click anywhere: works !
Comment 2 Julien Nabet 2012-07-04 14:23:50 UTC
Added in cc the one in IRC who found the problem.
Good catch !
Comment 3 Sandro Santilli 2012-07-04 14:27:54 UTC
Thanks for filing the bug :)

I should mention that you can "workaround" the issue by clicking again in the formula input right before clicking on the target cell.

By all effect the bug seems to behave as if focus is lost when switching to a different sheet.

Only happens with the first 2 columns starting (and including) the one where the window freeze originates.
Comment 4 Rainer Bielefeld Retired 2012-07-05 04:25:43 UTC
My result short and simple  [Reproducible] with parallel installation of Master "LOdev " 3.7.0.0.alpha0+   - WIN7 Home Premium (64bit) ENGLISH UI [Build ID: 3985521]" (tinderbox: W2008R2@16-minimal_build, pull time 2012-06-24):

When I reference to cell in a different sheet from a cell in a "Frozen" sheet (outside the "Headings area" I will get a string "=" instead of reference to contents in different sheet.

So this one is DUP of "Bug 47349 - EDITING: Can't point and select cell from sheet with freeze window" the problem is the one I expect

@Julien Nabet:
What exactly is your problem? I can't see any difference between expected and actual behavior in your report. I think it's the "= String Problem"?

Please feel free to reopen this one I I got the wrong problem.

*** This bug has been marked as a duplicate of bug 47349 ***
Comment 5 Julien Nabet 2012-07-05 04:41:12 UTC
Rainer: you're right.
I meant :
"
Current behavior:
The cell selected isn't referenced in B3

Expected behavior:
The cell selected should be referenced in B3
"