To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=68961
Issue #|68961
Summary|Calc-Import hangs when importing Excel-File with Form-
|Controlls referring whole columns
Component|Spreadsheet
Version|OOo 2.0.3
Platform|All
URL|
OS/Version|All
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|leguff
------- Additional comments from [EMAIL PROTECTED] Fri Aug 25 07:23:41 -0700
2006 -------
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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
