Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Very slow to close, no editing | ||||||
---|---|---|---|---|---|---|---|
Product: | Calc | Reporter: | MotherM <john.mahoney> | ||||
Component: | save-export | Assignee: | AOO issues mailing list <issues> | ||||
Status: | CONFIRMED --- | QA Contact: | |||||
Severity: | Major | ||||||
Priority: | P3 | CC: | alahanco, elish, issues, john.mahoney | ||||
Version: | 4.0.1 | ||||||
Target Milestone: | --- | ||||||
Hardware: | PC | ||||||
OS: | Windows, all | ||||||
Issue Type: | DEFECT | Latest Confirmation in: | --- | ||||
Developer Difficulty: | --- | ||||||
Attachments: |
|
Description
MotherM
2013-10-06 04:48:47 UTC
Please attach spreadsheet. Created attachment 81725 [details]
Calc spreadsheet 5 cols of data, 5 cols of =SUM x 6000 rows
Thank you. confirmed with AOO410m1(Build:9750) - Rev. 1525015 Rev.1525015 Win 7 Alan Hancock [November 14, 2013] AOO401m5(Build:9714) - Rev. 1524958 Windows 7 I was able to reproduce the bug by doing the following: 1. Download provided spreadsheet. 2. Open the spreadsheet without altering. 3. Close the spreadsheet, keeping track of time lapsed. I recorded a lapse of 45 seconds required for the spreadsheet to close. During this time, the process soffice.bin *32 consumes 25% of my CPU. I followed up to this report by deleting all but one of the columns including an =SUM function. The result was that closing the spreadsheet took 10 seconds and continued to consume 25% of my CPU during that time. I would hypothesize that further tests with additional similar columns would increase lapse time when closing the spreadsheet. This would imply a difficulty with dumping data that requires calculations in the spreadsheet. This has heavy implications for large spreadsheets that require calculations. I would consider this an alleviated priority because a quality service spreadsheet should be able to exit effectively regardless of the number of calculations. I see no reasonable workarounds for this issue other than avoiding calculations in a spreadsheet or separating the calculations among several different files. |