Re: [SLUG] spreadsheet

From: Shawn J. Goff (shawn7400@gmail.com)
Date: Sun Jul 12 2009 - 20:31:04 EDT


On Sun, 12 Jul 2009 19:31:31 -0400 (EDT)
Eben King <eben01@verizon.net> wrote:

> 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.
>

I've had the same problem in the past. My solution was Excel. Sheets
that will completely hang your system in OO.o will be like nothing in
Excel; it's crazy.
-----------------------------------------------------------------------
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:31:06 EDT