Red Hat Bugzilla – Bug 198788
calc cannot save huge files
Last modified: 2007-11-30 17:11:37 EST
Description of problem:
I have a CSV file with ~40,000 lines and 36 columns (~15MB).
I can open it in calc, and I can do some statistics on it, but I cannot save it.
any attempt to save it fails with calc hanging forever taking 100% CPU
and not modifying the disk.
strace and ltrace reveal nothing (no calls).
Version-Release number of selected component (if applicable):
this is Linux 2.6.17-1.2139_FC5 #1 Fri Jun 23 12:40:16 EDT 2006 i686 i686 i386
Steps to Reproduce:
1. open CSV file.
2. create a new sheet, do some stats there.
3. try to save ("save as", Ctrl-S &c)
4. agree to the ods format and file name.
the second way:
1. create an ods file
2. create a new sheet which is a "link" to the CSV file
3. try to save (Ctrl-S)
calc hangs forever taking 100% CPU
openoffice people cannot reproduce this.
Created attachment 132380 [details]
huge CSV file that exhibits the bug
I'd say upstream is telling fibs, or has some super computer :-) I see this, and
it seems to be that ScRangeList is ultra-slow with this big document. Perhaps we
can re-implement it in terms of one of the stl containers
Well, that didn't work. Some discussion around this at
This needs a calc specialist to look at it. Currently upstream this is now
assigned to nn, the calc team lead and so is out of the original bogus
"worksforme, fedora f*cked it up" state