IT University of Copenhagen
Sheet-Defined Functions in Spreadsheets
to millions of users because they are
declarative and non-iterative. However, the absence of
facilities leads to models that are unwieldy, slow,
and difficult to maintain.
should be able to define new functions within the familiar
paradigm, without resorting to external languages such as
Excel, and with speed comparable to built-in functions.
We present a
prototype spreadsheet implementation that achieves these
based on the concept of sheet-defined function. Type analysis
continuation-based compilation are used to generate efficient .NET
from such sheet-defined functions at runtime. Thanks to the
just-in-time compiler the implementation is very fast.
We give several
examples of useful functions definable this way. We
higher-order and recursive sheet-defined functions have
uses. For instance, the Goal Seek numerical equation solver,
several other built-in functions from Excel, can be user-defined
In future work,
we expect to support functions with a carefully
form of state, and possibly to exploit the near-explicit
of spreadsheet models.
Corina Bardasuc <email@example.com>
Wednesday, May 27, 2009
of Programming Seminars