Bug 198788

Summary: calc cannot save huge files
Product: [Fedora] Fedora Reporter: Sam Steingold <sds>
Component: openoffice.orgAssignee: Caolan McNamara <caolanm>
Status: CLOSED UPSTREAM QA Contact:
Severity: medium Docs Contact:
Priority: medium    
Version: 6   
Target Milestone: ---   
Target Release: ---   
Hardware: i386   
OS: Linux   
URL: http://www.openoffice.org/issues/show_bug.cgi?id=67203
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2007-04-13 15:48:15 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:
Attachments:
Description Flags
huge CSV file that exhibits the bug none

Description Sam Steingold 2006-07-13 15:38:53 UTC
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
GNU/Linux
openoffice.org-calc-2.0.2-5.12.2.i386.rpm

How reproducible:
always

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)

neither works.
  
Actual results:
calc hangs forever taking 100% CPU

Expected results:
file saved

Additional info:
openoffice people cannot reproduce this.
http://www.openoffice.org/issues/show_bug.cgi?id=67203

Comment 1 Sam Steingold 2006-07-13 15:38:55 UTC
Created attachment 132380 [details]
huge CSV file that exhibits the bug

Comment 2 Caolan McNamara 2006-07-18 13:02:48 UTC
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

Comment 3 Caolan McNamara 2006-07-21 11:29:29 UTC
Well, that didn't work. Some discussion around this at
http://sc.openoffice.org/servlets/ReadMsg?list=dev&msgNo=1784

Comment 4 Caolan McNamara 2007-04-13 15:48:15 UTC
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