Bug 78476 - EDITING: Calc fails to do automatic reference in cell edit mode when the window is frozen.
Summary: EDITING: Calc fails to do automatic reference in cell edit mode when the wind...
Status: RESOLVED DUPLICATE of bug 47349
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: Other Windows (All)
: medium minor
Assignee: Not Assigned
Whiteboard: BSA
Depends on:
Blocks: Cell-Reference
  Show dependency treegraph
Reported: 2014-05-09 09:05 UTC by A
Modified: 2019-01-30 09:07 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

sample sheet to ilustrate the problem (40.01 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-05-09 09:05 UTC, A

Note You need to log in before you can comment on or make changes to this bug.
Description A 2014-05-09 09:05:52 UTC
Created attachment 98737 [details]
sample sheet to ilustrate the problem

Problem description: 
problem also described in 
As above. I think, that problem concerns some specific worksheets. 
This bug still occures in calc 4.1 and 

Steps to reproduce:
1. Open attached file 
2. Select sheet "err_sh"
3. Select cell "C3"
4. Press "=" on keyboard
5. Select another sheet "sh1"
6. Pick with mouse cell "B23"
7. Press "enter" to complete the formula.

Current behavior:
In sheet err_sh the formula does not appear properly and contains only "="

Expected behavior:
There should be created a formula like: "=sh1.B23" in the edited cell in "err_sh"

Interesting info:
When I start the formula in sheet "sh1" or "st1" everything works OK. It works ok also if I start in the first row or colum (locked) on sheet "err_sh". Only unlocked area in "err_sh" seems to be affected with that bug.
Operating System: Windows 7
Version: release
Comment 1 GerardF 2014-05-09 09:52:17 UTC

Related to Windows > Freeze.
If I remove Freeze column/row, it is working.
Comment 2 Kohei Yoshida 2014-05-09 16:11:33 UTC
I see this in 4.1.1, and 3.5.7.  Must be an old bug.
Comment 3 QA Administrators 2015-06-08 14:42:41 UTC Comment hidden (obsolete)
Comment 4 Buovjaga 2015-08-02 10:22:46 UTC
Repro with sample sheet.

Win 7 Pro 64-bit Version:
Build ID: 902255645328efde34ddf62227c8278e8dd61ff0
TinderBox: Win-x86@39, Branch:master, Time: 2015-07-30_03:52:07
Locale: en-US (fi_FI)
Comment 5 QA Administrators 2016-09-20 10:21:33 UTC Comment hidden (obsolete)
Comment 6 Aurimas Fišeras 2019-01-30 09:07:17 UTC

*** This bug has been marked as a duplicate of bug 47349 ***