Re: Large test spreadsheets

["Morten Welinder" <mwelinder gmail com>]

> 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