Patent ID: 8112701

Claim:
A method for inserting a reference into a formula in a spreadsheet table, comprising: entering a formula into a first header cell of a plurality of header cells, wherein the header cells are header row cells or header column cells of a spreadsheet table and the spreadsheet table additionally contains a plurality of body cells; inserting into the formula being entered into the first header cell a reference to a second header cell that belongs to the same spreadsheet table, wherein the first and second header cells are either both header row cells or both header column cells; in the event that the first and second header cells comprise header row cells, populating body cells of a column associated with the first header row cell with the results of the formula, wherein each body cell of the column associated with the first header row cell is populated with the result of the formula computed using a value of a corresponding body cell of a column associated with the second header row cell; and in the event that the first and second header cells comprise header column cells, populating body cells of a row associated with the first header column cell with the results of the formula, wherein each body cell of the row associated with the first header column cell is populated with the result of the formula computed using a value of a corresponding body cell of a row associated with the second header column cell.