Persistently self-replicating cells
First Claim
1. A computer-implemented method for self-replicating ranges of cells in a spreadsheet, the method comprising executing on a central processor the steps of:
- presenting, within a graphical user interface, a plurality of unique set names that are each assigned to one each of a plurality of different sets of ranges of cells of a spreadsheet, wherein each of the unique set names are assigned to at least one of the ranges, and each of the ranges of cells comprise a plurality of different cells of the spreadsheet;
in response to a selection of one of the presented unique set names via an input to the graphical user interface, listing at least one range of the plurality of the ranges that is assigned to the selected unique set name; and
in response to an update of one of the cells of the listed at least one range of the plurality of the ranges that is assigned to the selected unique set name via the graphical user interface, automatically entering the update into all other ones of the cells of the ranges that are assigned to the set of the selected unique set name by;
establishing a top record within a self replication table containing an address field of the unique set name, a pattern of the cells of the ranges assigned to the selected unique set name, and set and range indices of the cells of the ranges assigned to the selected unique set name;
setting the top record of the self replication table as the current record; and
updating the all other ones of the cells of the ranges assigned to the selected unique set name set by retrieving the address field of the unique set name from the top record of the self replication table set as the current record and pasting the update entered by the user into the one of the cells into the all other ones of the cells of the ranges assigned to the selected unique set name that are pointed to by the retrieved address field.
2 Assignments
0 Petitions
Accused Products
Abstract
The present invention includes a method and system for persistently self-replicating multiple ranges of cells through a copy-paste operation, in a multi-dimensional spreadsheet. A set of ranges of cells is defined, wherein each range of cells has the same size. Each time the content of a range of cells belonging to this set is changed, a self-replication operation is performed automatically. The self-replication operation includes the steps of copying the changed range of cells onto a buffer; determining the set of ranges of cells to which the changed range of cells belongs; identifying the ranges of cells belonging to the set; and pasting the content of the buffer in each of the identified range of cells belonging to the set.
-
Citations
19 Claims
-
1. A computer-implemented method for self-replicating ranges of cells in a spreadsheet, the method comprising executing on a central processor the steps of:
-
presenting, within a graphical user interface, a plurality of unique set names that are each assigned to one each of a plurality of different sets of ranges of cells of a spreadsheet, wherein each of the unique set names are assigned to at least one of the ranges, and each of the ranges of cells comprise a plurality of different cells of the spreadsheet; in response to a selection of one of the presented unique set names via an input to the graphical user interface, listing at least one range of the plurality of the ranges that is assigned to the selected unique set name; and in response to an update of one of the cells of the listed at least one range of the plurality of the ranges that is assigned to the selected unique set name via the graphical user interface, automatically entering the update into all other ones of the cells of the ranges that are assigned to the set of the selected unique set name by; establishing a top record within a self replication table containing an address field of the unique set name, a pattern of the cells of the ranges assigned to the selected unique set name, and set and range indices of the cells of the ranges assigned to the selected unique set name; setting the top record of the self replication table as the current record; and updating the all other ones of the cells of the ranges assigned to the selected unique set name set by retrieving the address field of the unique set name from the top record of the self replication table set as the current record and pasting the update entered by the user into the one of the cells into the all other ones of the cells of the ranges assigned to the selected unique set name that are pointed to by the retrieved address field. - View Dependent Claims (2, 3, 4, 5, 6, 7)
-
-
8. A system, comprising:
-
a processor; a computer readable memory in circuit communication with the processor; and a computer-readable storage device in circuit communication with the processor; wherein the processor executes program instructions stored on the computer-readable storage device via the computer readable memory and thereby; presents, within a graphical user interface, a plurality of unique set names that are each assigned to one each of a plurality of different sets of ranges of cells of a spreadsheet, wherein each of the unique set names are assigned to at least one of the ranges, and each of the ranges of cells comprise a plurality of different cells of the spreadsheet; in response to a selection of one of the presented unique set names via an input to the graphical user interface, lists at least one range of the plurality of the ranges that is assigned to the selected unique set name; and in response to an update of one of the cells of the listed at least one range of the plurality of the ranges that is assigned to the selected unique set name via the graphical user interface, automatically enters the update into all other ones of the cells of the ranges that are assigned to the set of the selected unique set name by; establishing a top record within a self replication table containing an address field of the unique set name, a pattern of the cells of the ranges assigned to the selected unique set name, and set and range indices of the cells of the ranges assigned to the selected unique set name; setting the top record of the self replication table as the current record; and updating the all other ones of the cells of the ranges assigned to the selected unique set name set by retrieving the address field of the unique set name from the top record of the self replication table set as the current record and pasting the update entered by the user into the one of the cells into the all other ones of the cells of the ranges assigned to the selected unique set name that are pointed to by the retrieved address field. - View Dependent Claims (9, 10, 11, 12, 13)
-
-
14. An article of manufacture, comprising:
-
a computer readable hardware storage device having computer readable program code embodied therewith, the computer readable program code comprising instructions for execution by a computer central processor that cause the computer central processor to; present, within a graphical user interface, a plurality of unique set names that are each assigned to one each of a plurality of different sets of ranges of cells of a spreadsheet, wherein each of the unique set names are assigned to at least one of the ranges, and each of the ranges of cells comprise a plurality of different cells of the spreadsheet; in response to a selection of one of the presented unique set names via an input to the graphical user interface, list at least one range of the plurality of the ranges that is assigned to the selected unique set name; and in response to an update of one of the cells of the listed at least one range of the plurality of the ranges that is assigned to the selected unique set name via the graphical user interface, automatically enter the update into all other ones of the cells of the ranges that are assigned to the set of the selected unique set name by; establishing a top record within a self replication table containing an address field of the unique set name, a pattern of the cells of the ranges assigned to the selected unique set name, and set and range indices of the cells of the ranges assigned to the selected unique set name; setting the top record of the self replication table as the current record; and updating the all other ones of the cells of the ranges assigned to the selected unique set name set by retrieving the address field of the unique set name from the top record of the self replication table set as the current record and pasting the update entered by the user into the one of the cells into the all other ones of the cells of the ranges assigned to the selected unique set name that are pointed to by the retrieved address field. - View Dependent Claims (15, 16, 17, 18, 19)
-
Specification