> 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 _______________________________________________ gnumeric-list mailing list [email protected] http://mail.gnome.org/mailman/listinfo/gnumeric-list
