Back to results
US 2012/0260153 A1Published application
Persistently self-replicating multiple ranges of cells through a table
AssigneeInternational Business Machines Corporation
InventorFrederic Bauchot
Life of this patent
Estimating the term…
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.
Claims20
A method for self-replicating ranges of cells in a spreadsheet, the method comprising:
- a central processor displaying a self-replication manager command within a graphical user interface spreadsheet editing menu to a user;
- the central processor displaying a self-replication manager menu within the graphical user interface to the user in response to the user invoking the self-replication manager command, wherein the self-replication manager menu comprises:
- a listing 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 sets comprises at least one of the ranges, and each of the ranges comprise a plurality of different cells of the spreadsheet;
- and
- a listing of at least one range of the plurality of the ranges that is assigned to one of the sets of ranges that is selected by a user input;
- and
- the central processor automatically entering an update entered by a user into one of the cells of the ranges of the selected set into all of the cells of all the ranges assigned to the selected set.
4 more elements
A method for providing a service for self-replicating ranges of cells in a spreadsheet, the method comprising:
- integrating computer-readable program code into a computer system comprising a central processor, a computer readable memory and a computer readable tangible storage device, wherein the computer readable program code is embodied on the computer readable tangible storage device and comprises instructions that, when executed by the central processor via the computer readable memory, cause the central processor to display a self-replication manager command within a graphical user interface spreadsheet editing menu to a user;
- display a self-replication manager menu within the graphical user interface to the user in response to the user invoking the self-replication manager command, wherein the self-replication manager menu comprises:
- a listing 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 sets comprises at least one of the ranges, and each of the ranges comprise a plurality of different cells of the spreadsheet;
- and
- a listing of at least one range of the plurality of the ranges that is assigned to one of the sets of ranges that is selected by a user input;
- and
- automatically enter an update entered by a user into one of the cells of the ranges of the selected set into all of the cells of all the ranges assigned to the selected set.
4 more elements
A system, comprising:
- a central processor in communication with a computer readable memory and a tangible computer-readable storage device;
- wherein the central processor, when executing program instructions stored on the tangible computer-readable storage device via the computer readable memory:
- displays a self-replication manager command within a graphical user interface spreadsheet editing menu to a user;
- displays a self-replication manager menu within the graphical user interface to the user in response to the user invoking the self-replication manager command, wherein the self-replication manager menu comprises:
- a listing 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 sets comprises at least one of the ranges, and each of the ranges comprise a plurality of different cells of the spreadsheet;
- and
- a listing of at least one range of the plurality of the ranges that is assigned to one of the sets of ranges that is selected by a user input;
- and
- automatically entering an update entered by a user into one of the cells of the ranges of the selected set into all of the cells of all the ranges assigned to the selected set.
6 more elements
An article of manufacture, comprising:
- a computer readable tangible storage device having computer readable program code embodied therewith, the computer readable program code comprising instructions that, when executed by a computer central processor, cause the computer central processor to:
- display a self-replication manager command within a graphical user interface spreadsheet editing menu to a user;
- display a self-replication manager menu within the graphical user interface to the user in response to the user invoking the self-replication manager command, wherein the self-replication manager menu comprises:
- a listing 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 sets comprises at least one of the ranges, and each of the ranges comprise a plurality of different cells of the spreadsheet;
- and
- a listing of at least one range of the plurality of the ranges that is assigned to one of the sets of ranges that is selected by a user input;
- and
- automatically enter an update entered by a user into one of the cells of the ranges of the selected set into all of the cells of all the ranges assigned to the selected set.
5 more elements
Dependencies are inferred from the claim text.