To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95038 Issue #|95038 Summary|sCalc.exe, soffice.bin, soffice.exe hangs after copyin |g cell data to Clipboard Component|Spreadsheet Version|OOO300m9 Platform|PC URL| OS/Version|Windows XP Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|editing Assigned to|spreadsheet Reported by|rpesq
------- Additional comments from [EMAIL PROTECTED] Thu Oct 16 21:25:45 +0000 2008 ------- (My chosen 'Subcomponent' choice may be wrong. Issue does not seem to fit any of those categories) Background: XP SP3, 512 Ram, large HD. Occurs even with fresh XP install, and with NO software installed except for OO. Occurs whether running as Admin Account or Limited User account. This bug has occurred for at least 1 year, the last version that I remembered that did NOT have this problem was approx 2.0.1, possible 2.0 release. Every version since has this bug. Brief description: Load spreadsheet, select somewhat large amount of cell data and choose EDIT-COPY. Then try to exit Calc. Exiting will cause scalc.exe, soffice.bin, and soffice.exe to hang and PC will consuming 100% cpu until tasks are killed. Before OO version 3.0, only Soffice.bin and Soffice.exe hanged. As of OO 3.0, one instance of Scalc.exe also hangs. The problem seems to be soffice.bin, as the PC does not become responsive until that process is killed. Killing scalc.exe and soffice.exe does not help. None of these processes will exit without Task Manager force killing. Steps to recreate -- in opening this bug report, I found a simpler way to illustrate the problem, so I will give both. I will start with the "difficult" method, because I wrote this scenario first before discovering a simpler method to recreate. Skip down to Example #2 if you do not have time to read Example #1, but example #1 is the exact situation how I use Open Office, and how it yields problem every time. EXAMPLE #1 -- the exact situation which has caused this problem for me: 1) Double-click on a large CSV file, which will launch Open Office assuming you have .csv associated with it. In my example, once a month I download a large CSV created by EBAY, each field separated by commas, and the file contains all of my EBAY sales for the prior month. A typical month's file will contain 35 Columns and approx 150 to 250 rows. Cell data is only numbers, dates, email address, street addresses (including streets and city and zip codes separated by commas), dollar amounts (including the '$'-sign), and text. No pics, no formulas, nothing fancy. OO will ask you to verify that the cells are separated by Comma, then proceed to load. 2) Either open a new spreadsheet file, or load a previous spreadsheet file that you plan to copy the CSV data into it. You now have 2 Calc windows open (CSV, and new/existing spreadsheet). 3) Go to the CSV window. In my example, since row 1 is just a header, I skip it. I hold down SHIFT, and mouse click the "2" for Row 2. While holding down SHIFT, I use the mouse to scroll down to the last row in the CSV spreadsheet, in this month's example it is Row 197 (I always choose one blank row in addition to the last row that contained data, because I want a blank between each month's entry). While still holding down SHIFT, mouse click on row 197. This will highlight all rows from 2 to 197. Go to MENU - EDIT - COPY. 4) Go to New/Existing Spreadsheet Window. Mouse click to choose the first empty cell in whatever row you want to paste the data into. For example, a new spreadsheet, you might click into Column 1 of Row 1. An existing spreadsheet, I might click into Column 1 of Row 1,500. 5) Keyboard: CTRL-V to paste your data, or edit-paste via Edit Menu. (Paste-Special does not help any, same issue). 6) Save this new/existing spreadsheet as a normal ODS file. 7) Click X to Exit both spreadsheet windows. Does not matter which order you close them. 8) Watch the processes hang and require Task Manager killing. PC is unusable until the soffice.bin task is killed, which may require several attempts to kill. 9) As previously noted, before OO 3.0, only the soffice.bin and soffice.exe tasks hung. Now with oo 3.0, I see that one instance of scalc.exe also hangs. ************** EXAMPLE #2 -- What I discovered today while trying to investigate to best report this problem to you: Steps: 1) Double click to open any somewhat large spreadsheet into Calc. I used the same EBAY CSV file as an example. 35 columns filled with data, 198 rows, as described above. (I also tried first saving the CSV file as an ODS file, closing Calc, then reopening Calc. Did not make any difference.) The physical size of CSV file is small, only 63,374 bytes. 2) Use same method to copy cell contents to clipboard. 3) Do nothing with the data, and just Exit Calc. Watch processes hang. NOTES: - Due to privacy issues, I cannot upload the Ebay CSV file, as it contains names and physical addresses and email addresses of customers. - Problem also existed with XP SP2. Have not tested under other platforms. - This problem definitely did NOT exist with the 2.0 Beta (I think it was called 1.9xx ?), and I do not remember the 2.0 initial release having the problem. --------------------------------------------------------------------- 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]