On a multi-sheet spreadsheet, when Window:Freeze is set on a sheet, Calc does not register the address of a cell in another sheet when inputting a formula.
Steps to reproduce:
1. Set Window-Freeze
2. Start entering a formula in a cell. Press "=" and click the tab of another sheet, then click a cell in that sheet. The input bar does not show the clicked address.
3. Press Return. The formula cell contains only "="
To avoid this, unfreeze the window and enter the formula.
Platform (if different from the browser):
Browser: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_5_8) AppleWebKit/534.50.2 (KHTML, like Gecko) Version/5.0.6 Safari/533.22.3
This is in LibO 3.5.1 RC2
Thanks for bugreport
reproduced in 3.3.4 and 3.5.4 on Fedora 64 bit (Windows not tested)
Changing version to 3.3.4 as most early reproduced
*** Bug 51731 has been marked as a duplicate of this bug. ***
[Reproducible] with parallel installation of Master "LOdev " 126.96.36.199.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.
Problem only appears in the first 2 columns right from "freeze line"
Same when 'Split Window'
No problem when I open a second Window for the document (for second referenced sheet) and switch to second window after "=" for reference.
Already reproducible with OOo 3.2, so inherited from OOo
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug
If this is the same as bug #51731 you should only get this problem with cells which are 2 columns from the one from which Window-Freeze was started.
Can you confirm this ? (ie: 3rd column off the freeze it is fine)
Also bug #51731 lists another workaround: clicking in the formula input widget before selecting the target cell (to reset proper focus)
That is correct. Only the first 2 columns are affected. Seems to be immaterial which row.
This is on LO 188.8.131.52, OS X 10.7.4
On 5 Jul 2012, at 06:52, email@example.com wrote:
> --- Comment #4 from firstname.lastname@example.org 2012-07-05 05:52:37 UTC ---
> If this is the same as bug #51731 you should only get this problem with cells
> which are 2 columns from the one from which Window-Freeze was started.
> Can you confirm this ? (ie: 3rd column off the freeze it is fine)
> Also bug #51731 lists another workaround: clicking in the formula input widget
> before selecting the target cell (to reset proper focus)
> Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.
** Please read this message in its entirety before responding **
To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.
There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.
If you have time, please do the following:
Test to see if the bug is still present on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/
If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior
If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System
Please DO NOT
Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)
Thank you for your help!
-- The LibreOffice QA Team
No problem anymore.
Win 7 Pro 64-bit Version: 184.108.40.206.alpha0+
Build ID: 07e84cae983c08afdba03018413a19d01abb3006
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-19_06:15:38
*** Bug 105652 has been marked as a duplicate of this bug. ***
Created attachment 140671 [details]
Reopening this as I don't think it ever was fixed (see comment on bug 105652)
Attached is a test case from bug 105652, but with clearer repro instructions.
Use the keyboard to start the formula entry, do not use the formula bar as that does not expose the bug
*** Bug 106133 has been marked as a duplicate of this bug. ***
*** Bug 78476 has been marked as a duplicate of this bug. ***
Still an issue - see also question on https://ask.libreoffice.org/en/question/223897/calc-transpose-fails-if-freeze-rows-columns-set/