Bug 105652 - EDITING: Can't point and select cell from other sheet with freeze window
Summary: EDITING: Can't point and select cell from other sheet with freeze window
Status: RESOLVED DUPLICATE of bug 47349
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
Depends on:
Reported: 2017-01-31 18:52 UTC by Peter Johnson
Modified: 2018-03-17 11:41 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Spreadsheet showing fault (8.67 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-01-31 18:52 UTC, Peter Johnson

Note You need to log in before you can comment on or make changes to this bug.
Description Peter Johnson 2017-01-31 18:52:33 UTC
Created attachment 130801 [details]
Spreadsheet showing fault

On and 5.3 RC3 the fault reported as bug 47349 seems to have reappeared. Creating a formula on a sheet that references another sheet is broken if row or column headings are frozen on the destination sheet. See the attached, created with

Mac OS X 10.11.6
Comment 1 Alex Thurgood 2017-02-03 11:19:26 UTC
Seems to work fine with

Build ID: 6c4310cc176c02624f5fa94fb50fec6050ce904b
CPU Threads: 2; OS Version: Mac OS X 10.12.2; UI Render: default; 
Locale: fr-FR (fr_FR.UTF-8); Calc: group
Comment 2 Alex Thurgood 2017-02-03 11:26:24 UTC
No repro for me with 

Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22
Threads CPU : 2; Version de l'OS :Mac OS X 10.12.2; UI Render : par défaut; 
Locale : fr-FR (fr_FR.UTF-8); Calc: group

Using your test file:

C7 =Sheet2.B8-Sheet2.B11
C8 =PRODUCT(Sheet2.B8:Sheet2.B11)
C9 =(Sheet2.B11*3,14)

All seem to be calculated correctly.
Comment 3 Buovjaga 2017-02-06 08:12:01 UTC
Peter: could you try Help - Restart in Safe Mode with 5.3?
Comment 4 Xisco Faulí 2017-02-06 09:25:29 UTC
Setting to NEEDINFO until we get feedback from Peter
Comment 5 Peter Johnson 2017-02-06 10:18:22 UTC
(In reply to Buovjaga from comment #3)
> Peter: could you try Help - Restart in Safe Mode with 5.3?

I have: 

1. Restarted in safe mode.  Same error with same file.
2. Restarted in safe mode and reset all settings to factory default.  Same error with same file.  Created new file: Sheet 1 has some values; Create sheet 2, set View -> Freeze Cells -> Freeze Rows and Columns; formula =Sheet1.[Cell Ref] is correct in frozen areas (top left, left cols, top rows), but still returns just "=" in non-frozen area.

Am not ready to switch to OS 10.12 yet, so can't test that.
Comment 6 Buovjaga 2017-02-06 15:10:13 UTC
Could not repro with master~2017-02-06_00.04.37_LibreOfficeDev_5.4.0.0.alpha0_MacOS_x86-64.dmg                06-Feb-2017 01:30
macOS 10.12.2
Comment 7 Carlos 2017-04-04 20:00:11 UTC
I can confirm that the bug is present in
Version: (x64)
Build ID: e80a0e0fd1875e1696614d24c32df0f95f03deb2
CPU Threads: 4; OS Version: Windows 6.19; UI Render: default; Layout Engine: new; 
Locale: en-US (en_US); Calc: group
Comment 8 eisa01 2018-03-17 11:41:49 UTC
This is still present, and also on Windows

It's important to type the formula in the column C where the equal signs are, the test case is slightly confusing in that it's somehow natural to use column D

Setting as duplicate of original bug, as I don't think that ever was fixed (tried alpha and that was reported as no repro, but I think that was a misunderstanding

Build ID: 8e8dd8f320a3ff59ff8a16c1a7a867888ce80700
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-13_23:59:29
Locale: de-DE (de_NO.UTF-8); Calc: group

Build ID: 0312e1a284a7d50ca85a365c316c7abbf20a4d22
CPU Threads: 2; OS Version: Mac OS X 10.12.6; UI Render: default; 
Locale: en-US (en_US.UTF-8); Calc: group

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