Bug Hunting Session
Bug 47349 - EDITING: Can't point and select cell from sheet with freeze window
Summary: EDITING: Can't point and select cell from sheet with freeze window
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 51731 78476 105652 106133 (view as bug list)
Depends on:
Blocks: Cell-Formula Cell-Freeze
  Show dependency treegraph
 
Reported: 2012-03-15 05:11 UTC by mail
Modified: 2019-01-30 09:07 UTC (History)
13 users (show)

See Also:
Crash report or crash signature:


Attachments
Test case (9.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-03-17 11:45 UTC, eisa01
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mail 2012-03-15 05:11:02 UTC
Problem description: 

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
Comment 1 sasha.libreoffice 2012-06-08 00:30:24 UTC
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
Comment 2 Rainer Bielefeld Retired 2012-07-05 04:25:43 UTC
*** Bug 51731 has been marked as a duplicate of this bug. ***
Comment 3 Rainer Bielefeld Retired 2012-07-05 04:37:15 UTC
[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.
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

@Spreadsheet Team:
Please set Status to ASSIGNED and add yourself to "Assigned To" if you accept this Bug
Comment 4 Sandro Santilli 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)
Comment 5 mail 2012-07-05 10:02:07 UTC
That is correct.  Only the first 2 columns are affected.  Seems to be immaterial which row.

This is on LO 3.5.4.2, OS X 10.7.4

On 5 Jul 2012, at 06:52, bugzilla-daemon@freedesktop.org wrote:

> https://bugs.freedesktop.org/show_bug.cgi?id=47349
> 
> --- Comment #4 from strk@keybit.net 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.
Comment 6 QA Administrators 2015-01-05 17:51:49 UTC Comment hidden (obsolete)
Comment 7 Buovjaga 2015-01-23 16:42:51 UTC
No problem anymore.

Win 7 Pro 64-bit Version: 4.5.0.0.alpha0+
Build ID: 07e84cae983c08afdba03018413a19d01abb3006
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-19_06:15:38
Comment 8 eisa01 2018-03-17 11:41:49 UTC
*** Bug 105652 has been marked as a duplicate of this bug. ***
Comment 9 eisa01 2018-03-17 11:45:26 UTC
Created attachment 140671 [details]
Test case
Comment 10 eisa01 2018-03-17 11:48:00 UTC
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
Comment 11 Holger Klene 2018-04-03 22:27:48 UTC
*** Bug 106133 has been marked as a duplicate of this bug. ***
Comment 12 Aurimas Fišeras 2019-01-30 09:07:17 UTC
*** Bug 78476 has been marked as a duplicate of this bug. ***