<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc Freezes (Not Responding) When Referencing to Another Sheet with Column/Row Freeze Enabled (Repro steps in Comment 12)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106272#c13">Comment # 13</a> on <a class="bz_bug_link bz_status_UNCONFIRMED " title="UNCONFIRMED - Calc Freezes (Not Responding) When Referencing to Another Sheet with Column/Row Freeze Enabled (Repro steps in Comment 12)" href="https://bugs.documentfoundation.org/show_bug.cgi?id=106272">bug 106272</a> from <a class="email" href="mailto:francois.trahan@gmail.com" title="Francois <francois.trahan@gmail.com>"> Francois</a> <pre>Hi. I don't even need cross sheet references to make it crash. If I create the following spreadsheet: Hello;Bonjour Ni Hao;Guten Tag Then freeze the first row, any attempt to reference the top row from other rows (or other rows from the top row) freezes Calc. To be more precise, it freezes at selection time, not commit time. Here is the sequence: 1- Create the four cells suggested here (or anything else) 2- Freeze first row 3- go to an empty cell below top row 4- hit F2 5- Type "=" to start a formula 6- use the arrows to get to the top row 7- The freeze happens the moment the selection "touches" the top row, i.e. Notes: If I type the address of the cell instead (ex: "=B1"), then it works fine. Locking after entering the formula works fine. OS: Ubuntu 14.04.5 Libreoffice: Version: 5.4.0.3 Build ID: 1:5.4.0~rc3-0ubuntu0.14.04.1~lo2 CPU threads: 12; OS: Linux 4.4; UI render: default; VCL: gtk2; Locale: en-CA (en_CA.UTF-8); Calc: group This is a big problem for me, so I am more than willing to help fix it ! Here's my email: <a href="mailto:francois.trahan@gmail.com">francois.trahan@gmail.com</a></pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>