[Libreoffice-bugs] [Bug 106272] Calc Freezes (Not Responding) When Referencing to Another Sheet with Column/Row Freeze Enabled ( Repro steps in Comment 12)

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=106272

--- Comment #13 from Francois <francois.trahan at gmail.com> ---
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: francois.trahan at gmail.com

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170817/97d96f5f/attachment-0001.html>