Computer system that can make a first spreadsheet cell behave similarly to a second cell by indirection through a ditto function

A computer system executing a set of instructions that when executed provide to a user a spreadsheet application that accepts inputs from the user to enter data and one or more formulas in cells in a spreadsheet document, the spreadsheet application encoded with computer executable instructions that when executed cause the computer system to:

• accept from the user a ditto function in a first cell of the spreadsheet document, wherein the ditto function accepts one or more arguments, where one argument of the arguments in the ditto function references a second cell;
• accept from the user a formula in the second cell of the spreadsheet document, the formula comprising a function with one or more arguments, the one or more arguments including one or more relative arguments, wherein each relative argument of the relative arguments in the formula refers to a cell in the spreadsheet document that is positioned a relative distance from the second cell;
• cause the first cell to calculate its result value by evaluating the formula of the second cell, where each argument in the formula of the second cell is transposed to be relative to the first cell to cause the first cell and the second cell to be isomorphic;
• where a transposed argument has a relative distance from the first cell that is the same as the relative distance of the corresponding argument in the second cell from the second cell.