Bug 53576 - EDITING: Matrix sheet with lookup becomes unresponsive in 3.6.0.4, worked in 3.5.x.
Summary: EDITING: Matrix sheet with lookup becomes unresponsive in 3.6.0.4, worked in ...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.6.0.4 release
Hardware: x86 (IA32) Windows (All)
: medium major
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2012-08-16 08:35 UTC by mondane.woodworker
Modified: 2015-02-03 19:10 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments
Spreadsheet which makes LibO 3.6.0.4 unresponsive (291.34 KB, application/vnd.oasis.opendocument.spreadsheet)
2012-08-16 08:35 UTC, mondane.woodworker
Details

Note You need to log in before you can comment on or make changes to this bug.
Description mondane.woodworker 2012-08-16 08:35:24 UTC
Created attachment 65634 [details]
Spreadsheet which makes LibO 3.6.0.4 unresponsive

Problem description:

I have a spreadsheet with 12 sheets with a grid of days and descriptions and one sheet where I input dates and one of those descriptions.

Next to the date I choose a description from a list by entering the first character. Before, in 3.5.x, I could choose the description and, without having to wait, I could enter a start time (begintijd)

Since 3.6.0.4, after choosing the description, calc goes unresponsive and I have to wait several seconds before calc is responsive again and I can enter the start time.

In an earlier version of OpenOffice, I believe 3.2, there was another regression concerning matrix functions which I reported (https://bugs.freedesktop.org/show_bug.cgi?id=38028), maybe there is a new bug conceirning these matrix functions?

Steps to reproduce:
1. Open the attached test document.
2. Go to cell B2257.Invoer
3. Type the character A and TAB to leave the cell
4. Since sometimes calc is response immediately, repeat step 3 in cells below B2257

Current behavior:

After leaving cell B2257, calc becomes unresponsive for several seconds.

Expected behavior:

After leaving cell B2257, calc should be resonsive immediately for entering a start time and/or fill other cells.

Platform (if different from the browser): 

Browser: Mozilla/5.0 (Windows NT 5.1) AppleWebKit/537.1 (KHTML, like Gecko) Chrome/21.0.1180.79 Safari/537.1
Comment 1 A (Andy) 2012-12-26 12:56:43 UTC
reproducible with LO 3.6.4.3. (Win7 Home, 64bit, i5, 4 GB)

This seems also to be a general performance issue.  But of course, I have to admit that this file is already a rather advanced file, but nevertheless this performance issue is a little bit annoying.
I tested it and it takes already several seconds to switch from one sheet to another sheet.  If you go to the sheet "Invoer" and type into the cell B2257 the character "A" and afterwards the TAB key to leave the cell then it takes more than 5 seconds (sometimes even longer) until LO is responding again.  In the meantime LO hangs-up.  But this delay occurs apparently only for the first item entered.  If you enter an "A" in the next line then it does not take so long (maximum 1 second).  But if you switch to another sheet and then back to the sheet "Invoer" this occurs again.  But not always it takes the same time.  Sometimes it takes longer and sometimes not so long until LO is responding.
Therefore, this issue has probably to be analysed more deeply.
Comment 2 QA Administrators 2015-01-05 17:51:22 UTC
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of LibreOffice (4.3.5 or later): https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior

If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System

Please DO NOT

Update the version field
Reply via email (please reply directly on the bug tracker)
Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case)

Thank you for your help!

-- The LibreOffice QA Team
Comment 3 Buovjaga 2015-01-20 14:14:56 UTC
No problems here -> WFM.

Win 7 Pro 64-bit Version: 4.5.0.0.alpha0+
Build ID: 07e84cae983c08afdba03018413a19d01abb3006
TinderBox: Win-x86@62-TDF, Branch:MASTER, Time: 2015-01-19_06:15:38
Comment 4 mondane.woodworker 2015-02-03 19:09:26 UTC
I could not reproduce this problem anymore in 

Versie: 4.4.0.3 
Build ID: 40m0(Build:3)
Locale: nl_NL

So I consider it fixed.