Created attachment 130801 [details] Spreadsheet showing fault On 5.2.5.1 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 5.2.5.1. Mac OS X 10.11.6
Seems to work fine with Version: 5.4.0.0.alpha0+ 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
No repro for me with Version: 5.2.5.1 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.
Peter: could you try Help - Restart in Safe Mode with 5.3?
Setting to NEEDINFO until we get feedback from Peter
(In reply to Buovjaga from comment #3) > Peter: could you try Help - Restart in Safe Mode with 5.3? I have: 1. Restarted 5.3.0.3 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.
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
I can confirm that the bug is present in Version: 5.3.1.2 (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
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 4.5.0.0 alpha and 5.2.5.1 that was reported as no repro, but I think that was a misunderstanding Version: 6.1.0.0.alpha0+ 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 Version: 5.2.5.1 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 ***