Methods and systems are provided for formulaically redirecting and
modifying formula set operations in a spreadsheet application. A
spreadsheet application may link the contents of one spreadsheet cell to
other spreadsheet cells so that changes in one cell are reflected in
linked cells. Three spreadsheet functions are provided which allow for
formulaically redirecting and modifying formula set operations in a
spreadsheet application. A first spreadsheet function, SETATREF,
redirects a formula set in one spreadsheet cell to another spreadsheet
cell. The SETATREF function may also allow a formula set to one
spreadsheet cell to be redirected to and modified in a second spreadsheet
cell. A second spreadsheet function, SETATREFEXPR, redirects a formula
set to a formulaic location within a spreadsheet cell. A third function,
SETATREFEVAL, allows for an evaluation of a formula at formula set-time.