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

List:       koffice
Subject:    Re: kspread - unlimited table size
From:       Philipp =?iso-8859-1?q?M=FCller?= <philipp.mueller () gmx ! de>
Date:       2002-10-04 15:31:58
[Download RAW message or body]

Hello El,

yes I plan to have "unlimited" rows and columns.

Trust me, I personally drop each week in my normal work in the 65k limitation 
of the most commonly used spreadsheet application and I hate it for this).
So making KSpread here better than the competitors is one of my personal 
goals.

Unlimited means here a value where I don't hear any user anymore complaining 
about such a limit. But we still need to limit it.
And as long as computers have memory and performance limitations, we will 
limit it in a reasonable way.

We are not a database and will never be, so keep in mind that we will never be 
so much performant and memory optimized as a database and we always need to 
keep the whole data in memory (maybe several times, when we e.g. have a pivot 
table).

Currently the limitation isn't rather a principle technical issue (you can 
enhance the limit by just changing 3 numbers), it's just that the current 
implementation is to memory consumptive and the perfomance isn't usable 
anymore.

Norbert is hardly working on design changes for the biggest block of memory 
consumption and I'm working/will work on the performance issues.
Both are intrusive, so there is no way to enhance it shortly, even not for the 
bugfix release 1.2.1, whenever it will be released.

So expect a limitation which should fit your needs with the release of KOffice 
1.3.

Just for some room of discussion:
What is a reasonable limit?
I think of 2 Mio rows and 65k columns.
Rows because of some databases have this limit and columns as I really don't 
know of any usage of more columns (with copy-paste special-transpond, for 
what will you use it?). Where will you get the data to fill in more than 65k 
columns?

So any comments/ideas/wishes on limitation?

Philipp


Am Donnerstag, 3. Oktober 2002 15:12 schrieb John Dailey:
> Yes, there are plans for this, though I'm not sure of the details.  I
> belive Phillip Müller was working on this and he can probably provide
> details on what plans there are and how soon those will be implemented in
> KSpread. There might be some discussions on this in the koffice-devel
> mailing list archives -- search for Phillip's name.
>
> I would guess that there is a good chance of this being finished for the
> next release, but since KOffice 1.2 was just recently released, it will be
> many months before another release.
>
> -John
>
> > hi,
> >
> > are there any plans to create a table size with
> > an unlimited number (or lots) of rows (and columns?)?
> > maybe a million or more?
> > i could need that urgently, but have found
> > closed source software only so far.
> > if you know anything about such plans,
> > or could else give me a pointer,
> > PLEASE reply.
> >
> > thanks
> >
> > el
____________________________________
koffice mailing list
koffice@mail.kde.org
To unsubscribe please visit:
http://mail.kde.org/mailman/listinfo/koffice
[prev in list] [next in list] [prev in thread] [next in thread]