Bug 122376 - EDITING Calc locks up when selecting cells for formula across "freeze" boundary
Summary: EDITING Calc locks up when selecting cells for formula across "freeze" boundary
Status: RESOLVED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.7.3 release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-12-30 06:24 UTC by James Harkins
Modified: 2019-07-30 03:19 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
demo file (8.52 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-12-30 13:26 UTC, Oliver Brinzing
Details

Note You need to log in before you can comment on or make changes to this bug.
Description James Harkins 2018-12-30 06:24:18 UTC
This sequence of events reliably locks up LibO Calc for me.

1. Set up a sheet like this:

Name		Values
A		1	2	3
B		4	5	6
C		7	8	9

2. Go to C2 (value 1).

3. View > Freeze Cells > Freeze Rows and Columns.

4. Go to B2 (empty). This is to the left of the "Freeze Columns" boundary.

5. Type "=sum(" and right-arrow to C2 (which is to the right of the boundary). It will probably lock up here. If it doesn't, try shift-right-arrow to E3.

At some point during the key sequence in step 5, LibO enters an infinite loop. The interface locks up and the only option is to kill the program (and hope that document recovery works -- which it did, actually).

I saw this issue repeatedly in LibO 6.0.4.2. I just upgraded to 6.0.7.3 to see if it had been fixed, and it's still a problem in this version. I haven't tried the 6.2 RC (and I'm not a heavy enough LibO user to a lot of time into installing many versions).
Comment 1 Oliver Brinzing 2018-12-30 13:26:56 UTC
Created attachment 147899 [details]
demo file

i can not reproduce this issue with 

Version: 6.1.4.2 (x64)
Build-ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc:
Comment 2 Oliver Brinzing 2018-12-30 13:29:34 UTC
To be certain the reported issue is not
related to corruption in the user profile, could you please reset your
Libreoffice profile ( https://wiki.documentfoundation.org/UserProfile ) and
re-test?

I have set the bug's status to 'NEEDINFO'. Please change it back to
'UNCONFIRMED' if the issue is still present

and could you please give us some information about your hard/software
(Linux version etc.)?
Comment 3 QA Administrators 2019-06-29 02:59:01 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2019-07-30 03:19:43 UTC
Dear James Harkins,

Please read this message in its entirety before proceeding.

Your bug report is being closed as INSUFFICIENTDATA due to inactivity and
a lack of information which is needed in order to accurately
reproduce and confirm the problem. We encourage you to retest
your bug against the latest release. If the issue is still
present in the latest stable release, we need the following
information (please ignore any that you've already provided):

a) Provide details of your system including your operating
   system and the latest version of LibreOffice that you have
   confirmed the bug to be present

b) Provide easy to reproduce steps – the simpler the better

c) Provide any test case(s) which will help us confirm the problem

d) Provide screenshots of the problem if you think it might help

e) Read all comments and provide any requested information

Once all of this is done, please set the bug back to UNCONFIRMED
and we will attempt to reproduce the issue. Please do not:

a) respond via email 

b) update the version field in the bug or any of the other details
   on the top section of our bug tracker

Warm Regards,
QA Team

MassPing-NeedInfo-FollowUp