[prev in list] [next in list] [prev in thread] [next in thread] 

List:       koffice
Subject:    Kspread 1.4.1 problems
From:       Ville Herva <vherva () v ! iki ! fi>
Date:       2005-08-28 18:36:00
Message-ID: 20050828183600.GA8921 () v ! iki ! fi
[Download RAW message or body]

I noticed kspread 1.4.1 no longer has the option not to recalculate the
spreadsheet everytime a change is made. Automatic recalculation renders the
(imho fairly small) 400-line spreadsheet almost unworkable although it only
has maybe ten simple sum and average columns in addition to bare numbers. 

Also, recent Fedora devel has broken koffice:
http://marc.theaimsgroup.com/?l=fedora-test-list&m=112422066108432&w=2

So, although I'm generally satisfied with koffice/kspread, I decided to give
OOo OOcalc a shot.

This turned out to be no so simple. OOcalc will not open ksp. I tried to
export the spreadsheet as OpenDocument and then as OpenOffice spreadsheet. These
both options ran out of memory - it took me over ten minutes to
regain control over the trashing system. 

I tried .xls export, but it immediately gave an error.

I then culled all the formulas out of the spreadsheet (which was really
painstaking, I ended up copying the data parts to an empty spreadsheet in
small pieces). Then I was able to export OpenOffice format. It also imported
just fine into OpenOffice (I'm using 2.0 beta).

Unfortunately, OpenOffice crashed writing the spreadsheet back to disk. 

I tried gnumeric export from kspread, but that failed to import into
gnumeric (even just the data parts): I only got a couple of the top most
cells and some garbage.

Finally I found out that OpenOffice exported MSWord 95 .xls just fine (even
though it crashed saving its own format), and gnumeric imports that
flawlessly. gnumeric is also able to work with the spreadsheet with all the
formulas, even when I imported 700 more (similar) lines from another
spreadsheet. And it is even agile and easy on memory.

Question: is my 1.4GHz / 512MB machine just too slow to run kspread? I'd
think the spreadsheet is quite modest in size and should not require a speed
demon to work with it. 

Do the export filters generally work? I've tried them about a year ago, and
I think I got more or less exactly the same problems.

I've posted about the performance/filters problem in past:
http://bugs.kde.org/show_bug.cgi?id=86251
The test case should be relevant still.


-- v -- 

v@iki.fi

____________________________________
koffice mailing list
koffice@kde.org
To unsubscribe please visit:
https://mail.kde.org/mailman/listinfo/koffice

[prev in list] [next in list] [prev in thread] [next in thread]