Issue 123431

Summary: Very slow to close, no editing
Product: Calc Reporter: MotherM <john.mahoney>
Component: save-exportAssignee: 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: ---
Description Flags
Calc spreadsheet 5 cols of data, 5 cols of =SUM x 6000 rows none

Description MotherM 2013-10-06 04:48:47 UTC
A particular spreadsheet takes 100 seconds to close, even if no editing is done. For the whole 100 seconds soffice.bin consumes a constant 25% of the CPU.  This issue appeared with version 4.0.0 and continues in 4.0.1.
The spreadsheet has around 7000 rows x 14 columns.  Five of the columns contain =SUM($E$5:E6912)
Comment 1 Edwin Sharp 2013-10-06 05:04:05 UTC
Please attach spreadsheet.
Comment 2 MotherM 2013-10-08 09:21:19 UTC
Created attachment 81725 [details]
Calc spreadsheet 5 cols of data, 5 cols of =SUM x 6000 rows
Comment 3 Edwin Sharp 2013-10-08 09:42:45 UTC
Thank you.

confirmed with
AOO410m1(Build:9750)  -  Rev. 1525015
Win 7
Comment 4 alahanco 2013-11-15 02:40:59 UTC
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.