[SLUG] spreadsheet

From: Eben King (eben01@verizon.net)
Date: Sun Jul 12 2009 - 19:31:31 EDT


I have an 1800+-line spreadsheet in OpenOffice Calc. Each line has a few
calculated cells, and then there are two more pages with ~100K comparisons
each. There are also three graphs. It totally can not handle a dataset of
this size. I'm talking lots of memory (2 1/3 GiB), the system's swapping
like mad, and everything's laggy. Is there another spreadsheet I can use,
or maybe some techniques to make it usable with large datasets?

I have a log of 52000+ points (and growing) that I graph in gnuplot. It
takes about 12 MiB RAM and 0.7 seconds to draw the plot, so it is possible
for a program to be miserly with RAM and runtime at the expense of
interface.

-- 
-eben      QebWenE01R@vTerYizUonI.nOetP      royalty.mine.nu:81

A neutrino enters a bar. The bartender asks "Can I get you anything?" The neutrino replies "Nope, just passing through." -- rdu_voyager on Fark ----------------------------------------------------------------------- This list is provided as an unmoderated internet service by Networked Knowledge Systems (NKS). Views and opinions expressed in messages posted are those of the author and do not necessarily reflect the official policy or position of NKS or any of its employees.



This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:30:55 EDT