| Summary: | Excel Document Locks When Dropdown Cell Activated | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Dave Richards <drichard> |
| Component: | Spreadsheet | Assignee: | 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 | ||
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. 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. 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. 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.
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.