Bug 68154

Summary: Excel Document Locks When Dropdown Cell Activated
Product: LibreOffice Reporter: Dave Richards <drichard>
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: lgodard.libre, mariosv
Version: 4.1.0.4 release   
Hardware: Other   
OS: Linux (All)   
Whiteboard:
i915 platform: i915 features:
Attachments: Document that deadlocks LO

Description Dave Richards 2013-08-15 15:33:06 UTC
Created attachment 84104 [details]
Document that deadlocks LO

In the attached documented, in the sheet labeled "Overlay Wishlist Form", if you select the drop down cell next to "OST Agency Name" the busy symbol appears and then it never opens.  This puts your mouse into an odd state from which it never returns.  LO has to be forced killed.

This document fails in LO 4.0 and 4.1 but seems to work in OpenOffice.

Tested only on Linux.
Comment 1 m.a.riosv 2013-08-16 01:07:44 UTC
Hi Dave, thanks for reporting.

The range for dropdow is "OST_Agency" = $'CCC Use Only'.$A$1:$A$1048576, the all column rows, a very long range for a dropdow list.

I have not excel to verify but maybe the issue is that the range is defined in excel as a column, and as LibreOffice does not support ranges defined only by their column/row, they are imported in LibreOffice as ranges addressed to the all rows/columns.

I think the workaround is change the range definition to a short range e.g.:
$'CCC Use Only'.$A$1:$A$500
which must work in both programs.
Comment 2 Dave Richards 2013-08-16 13:01:29 UTC
These documents are built by outside agencies and downloaded from their site by our employees.  We don't have control over the way they are built or work unfortunately.

This should just work, especially if it goes in OpenOffice.  This is a regression.

Thank you for the work around; it should assist us with this currently downloaded document.  But a long term fix is needed.
Comment 3 Dave Richards 2013-08-16 17:51:03 UTC
Our support staff indicated:

I changed .$A$1:$A$1048576 to .$A$1:$A$500 Same result Click on the drop down and it is blank except the first item then the document locks.
I have to keep killing myself out of libre.  The same thing happens with the libre office version on the pc.  Open Office works well
with the document.  The openoffice v 3.4.1.
Comment 4 m.a.riosv 2013-08-16 22:38:40 UTC
Hi Dave,
seems to work with only a little delay to show the list marking the sorting option in validity (Menu/Data/Validity - Criteria), and does not show blank cells.
Also changing the definition range to a formula:
OFFSET($'CCC Use Only'.$A$1;1;1;COUNTA($'CCC Use Only'.$A$1:$A$1048576);1)
even disable the sort option in validity, works nice. 

In any case the issue is reproducible with:
Win7x64i3Ultimate
Version: 4.1.1.0.0+ Build ID: c1f0f890f5065f88164add33707228f8c6d5755
TinderBox: Win-x86@6-debug, Branch:libreoffice-4-1, Time: 2013-08-10_15:58:51

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.