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
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 !
Added in cc the one in IRC who found the problem. Good catch !
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.
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 ***
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 "