Issue 18202 - slow saving of large spreadsheet
Summary: slow saving of large spreadsheet
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.1 RC3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: frank
QA Contact: issues@sc
URL:
Keywords:
: 25169 (view as issue list)
Depends on:
Blocks:
 
Reported: 2003-08-13 22:54 UTC by jspitz
Modified: 2013-08-07 15:15 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Spreadsheet causing unreasonable delay when saving (4.10 MB, application/octet-stream)
2003-08-13 23:01 UTC, jspitz 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description jspitz 2003-08-13 22:54:05 UTC 
I have a quite huge spreadsheet document(4 MB SXC, uncompressed XML about 100 MB).
When I save it, then OOo does some invisible work. This phase lasts about 1
hour. After that appears the progressbar "Saving" - this phase lasts about 10
minutes. During this second phase the document is writed to the disk. I think
that the one-hour delay is buggy. Similar delay appears, when I save the
document in Excel format. However, when I save it as a StarOffice 5 file (SDC),
then the file is writed immediately.

HW: Celeron 660 MHz, 256 MB RAM.
OS: MS Windows 2000 Czech, Mandrake Linux 9.1 - both OSes have the same problem.
OOo: 1.1RC3 Czech, problem exists also with English version

I had similar problem with loading of this document - there was the delay even 4
hours. This problem existed in all versions 1.0.x and older. Starting version
1.1beta this problem disappeared and loading lasts some 10 minutes.
Comment 1 jspitz 2003-08-13 23:01:31 UTC 
Created attachment 8444 [details]
Spreadsheet causing unreasonable delay when saving
Comment 2 frank 2003-08-14 10:38:32 UTC 
Hi Sascha,

one for you.

Cause of problem probably the hard coded formattings of small cell
ranges and the ammount of cells formatted in a useless manner, e.g.
formats down from row 1000 to 32000.

Frank
Comment 3 sascha.ballach 2003-08-14 12:50:21 UTC 
I take it.
Comment 4 frank 2004-02-06 15:41:05 UTC 
*** Issue 25169 has been marked as a duplicate of this issue. ***
Comment 5 oc 2004-06-25 13:06:46 UTC 
see also 117214 (with bugdoc)
Comment 6 sascha.ballach 2004-10-13 14:28:54 UTC 
thank you for taking over
Comment 7 niklas.nebel 2004-11-17 16:34:17 UTC 
Fixed on CWS "calc26", changed: cellsuno.cxx 1.87.82.1.
The collecting of formatted cell ranges is now faster. For the total save time
this is about a 25% improvement.
It's much faster than in OOo 1.1, but that's unrelated to this change.
Comment 8 niklas.nebel 2004-12-03 14:34:31 UTC 
reopening to reassign
Comment 9 niklas.nebel 2004-12-03 14:34:46 UTC 
reassigning to QA for verification
Comment 10 oc 2004-12-16 10:24:29 UTC 
reset resolution to fixed
Comment 11 oc 2004-12-16 10:26:32 UTC 
verified in internal build cws_calc26
Comment 12 frank 2005-02-01 09:48:02 UTC 
found integrated in master src680m75