[libreoffice-users] Serious memory issues in Calc

I am using Ubuntu 10.10 64bit, fully updated etc. on two machines with
each 3GB RAM, one with a 3-core AMD processor, the other with an Intel
Core Duo. For a research project, I needed to handle a large
tab-separated text file with 6 columns and approximately 600000 rows
(approx. 85MB as txt, about 35.7MB as ods). This raised the following
problems:

- it takes forever to open it in LibreOffice.org Calc and automatic
column-wise replacements killed the system repeatedly - but when I do
the exact same thing in my Windows 7 virtual box, which I gave 1.5GB
of RAM, that takes about ten seconds and it's done.

- Then I want to copy and paste the file from a spreadsheet into a
text file (the saving caused problems with text delimiters, don't
ask). First, highlighting the whole data and press CTRL-C makes
LibreOffice go down for minutes; the virtual box with Excel doesn't
even flinch, does it right away. Second, so I copy from Excel and want
to paste into gedit. Doesn't do it for 2 minutes or so - in the
virtual box, I open Notepad++, paste it, 5 seconds later, done!

- Then I open the file in gedit for some cleaning up. Everything, like
replacing double spaces by single ones, takes forever. Right now I
have been waiting 10 minutes for a replacement of "\r\n" by "\n" and
gedit is just dead in the water (yes, System Monitor says it's still
working, but jeses, how long is that gonna take).

Seriously, I am the most ardent defender of open source etc. but this
is ridiculous. I remember doing all this stuff on Win XP (I moved to
Linux when Vista came) in no time at all, now, a few years later, with
a computer that has 3 times as much RAM as I had back then, and a
brand new open source OS, I have to go back to some frakking virtual
box with Windows 7 to get some text processing and spreadsheet stuff
done??

-- 
Unsubscribe instructions: E-mail to users+help@libreoffice.org
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted