Re: Large test spreadsheets
- From: "Morten Welinder" <mwelinder gmail com>
- To: "Leonard Mada" <discoleo gmx net>
- Cc: gnumeric-list gnome org
- Subject: Re: Large test spreadsheets
- Date: Tue, 10 Jun 2008 16:11:05 -0400
In an effort to move away from puting the burden on the developers, I began
designing functions that would compute intrinsically faster by expanding
existing functions to array functions:
- PERCENTILE():
http://lists.oasis-open.org/archives/office-comment/200806/msg00011.html
- LOOKUP() and OFFSET()-functions will follow when I have some more time
I went another route with VLOOKUP/HLOOKUP/MATCH in very
recent versions of Gnumeric. Basically, if the range is shared --
and that is quite common -- then lots of preprocessing of the range
is shared between cells.
I do not think there is a need to bother the user of the spreadsheet
with this. If we discover (real-life) sheets where such repetitive
formulas using a common table cause serious problems, then it is
not hard to fix.
Morten
[
Date Prev][
Date Next] [
Thread Prev][
Thread Next]
[
Thread Index]
[
Date Index]
[
Author Index]