Apache OpenOffice (AOO) Bugzilla – Issue 68961
Freeze when setting large linked source range at combobox in Calc
Last modified: 2013-08-07 15:14:03 UTC
Try this: - create a new empty excel document (I used Excel 2000, but it should also happen with 97, XP, ...) - insert a ComboBox-Form-Element by using the "Form" Toolbar - "format" the ComboBox by using right mouse button - go to tab "Control" - enter a whole column as list range (for example Table2!$B:$B) - associate an arbitrary cell for output - save the excel file - import it into OOo2.x or SO8PPx - soffice-process consumes all CPU time it can get Workarround: Instead of given a whole column as list range, associate only the number of cells you really need and everything works fine. Remark: When importing the file into OOo1.1.x/SO7PPx a dialog shows up: "The maximum number of rows has been exceeded. Excess rows were not imported!" But at least the file will be imported and works fine. I'll upload an example excel file for easier reproduction of the behaviour.
Created attachment 38775 [details] Example file: import this with OOo2.x or SO8PPx and the soffice-process hangs
Created attachment 38776 [details] this file was slightly changed to refer only the necessary rows => import works fine
Hi Daniel, one for you I think. Frank
DR->FS: Reproducible without Excel file: Insert a combo box and enter A1:A65536 as source range.
train model -> target 2.x instead of 2.1 fs->dr: What do you expect to happen in such a situation? You told the control to feed the content of 65536 cells into its list - this might take a while ... :-\ How does excel handle this? Will it automatically stop at the last cell which is not empty?
accepting
fixed in CWS dba23a: extensions/source/propctrlr/standardcontrol.cxx 1.24.98.1 toolkit/source/awt/vclxwindows.cxx 1.60.50.1 find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba23a
*** Issue 75215 has been marked as a duplicate of this issue. ***
targeting to 2.3, since the fix is part of a CWS aiming for this release
fs-> oc: please verify in CWS dba23a
It's mine, taking over. Frank
verified in CWS dba23a find more information about this CWS, like when it is available in the master builds, in EIS, the Environment Information System: http://eis.services.openoffice.org/EIS2/cws.ShowCWS?Path=SRC680%2Fdba23a
found integrated on master OOG680m1 using Linux, Solaris and Windows build