SYSTEM IN AN ELECTRONIC SPREADSHEET FOR PERSISTENTLY SELF-REPLICATING MULTIPLE RANGES OF CELLS THROUGH A COPY-PASTE OPERATION AND A SELF-REPLICATION TABLE

• US 20090037803A1
• Filed: 09/29/2008
• Published: 02/05/2009
• Est. Priority Date: 10/24/2000
• Status: Active Grant

• Current Assignee: Kyndryl Incorporated
• Original Assignee: International Business Machines Corporation
• Inventors: Bauchot, Frederic
• Granted Patent: US 8,250,461 B2
• Time in Patent Office: Days
• US Class Current: 715/214
• CPC Class Codes: G06F 3/0482 Interaction with lists of selectable items, e.g. menus
• CPC Class Codes: G06F 3/04842 Selection of displayed objects or displayed text elements G06F3/0482 takes precedence
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

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 to; identifying the ranges of cells belonging to the set; and pasting the content of the buffer in each of identified range of cells belonging to the set.

Claims

1. A system for persistently self-replicating multiple ranges of cells through a copy and paste operation, in a multi dimensional spreadsheet comprising a plurality of cells identified by a cell address along each dimension, a range of cells comprising one or a plurality of cells, the method comprising the steps of:

defining a set of ranges of cells, each range of cells having the same size;

each time the content of a range of cells belonging to said set is changed, automatically performing a self-replication operation, said self-replication operation comprising 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 to;

identifying the ranges of cells belonging to said set; and

pasting the content of the buffer in each of identified range of cells belonging to said set.

2. The system of claim 1 wherein the step of defining a set of ranges of cells further comprises the steps of:

adding a new range of cells to said set of ranges of cells, wherein said step of adding further comprises the steps of;

selecting a new range of cells; and

creating a link between the new range of cells with at least one range of cells belonging to said set of ranges of cells.

3. The system according to claim 1, wherein the step of defining a set of ranges of cells further comprises the step of:

performing a persistent copy operation on a first range of cells, wherein said persistent copy operation comprises the steps of;

selecting a first range of cells;

copying onto a buffer the selected first range of cells;

performing a persistent paste operation, wherein said persistent paste operation comprises the steps of;

Selecting at least one other range of cells; and

for each other selected range of cells;

copying the content of said buffer onto each other selected range of cells; and

creating a link between each other range of cells and the first range of cells.

4. The system according to claim 3, wherein the step of performing a persistent copy operation further comprises the step of:

invoking a persistent copy command; and

wherein the step of performing a persistent paste operation further comprises the step of;

invoking a persistent past command.

5. The system according to claim 1, wherein the step of defining a set of ranges of cells further comprises the steps of:

storing in a table a name for identifying said set of ranges of cells;

storing in said table means, preferably a name or an address, for identifying each range of cells belonging to said set; and

creating a link in said table between the name of the set and said means for identifying each range of cells belonging to said set.

6. The system according to claim 1, wherein the step of defining a set of ranges of cells further comprises the step of:

associating the ranges of cells belonging to said defined set with set dependent display attributes.

7. The system according to claim 5, wherein the step of associating the ranges of cells belonging to said defined set, further comprises the steps of:

associating a first variable with said set of ranges of cells;

setting said first variable to a set dependent value; and

displaying the ranges of cells of said set with display attributes according to the value of said first variable.

8. The system according to claim 4, wherein the step of storing in said table means for identifying each range of cells belonging to said set, further comprises the steps of:

for each range of cells belonging to said set;

determining current attributes of said range of cells;

storing in said table said current attributes; and

associating in said table the range of cells with the current attributes.

9. The system according to claim 7, wherein the step of storing in said table said current attributes, comprises the further step of:

associating a second variable with each range of cells; and

setting said second variable to a value associated with said current attributes.

10. The system according to claim 7, further comprising the step of removing a range of cells from the set of ranges of cells, wherein the step of removing further comprises the step of:

retrieving the current attributes associated with said range of cells; and

displaying said range of cells with said current display attributes.

11. In a system for persistently self-replicating multiple ranges of cells through a copy and paste operation in a multi dimensional spreadsheet comprising at least one page having a plurality of cells with content and identified by a cell address along each dimension, with the address of the top leftmost cell of said at least one page labelled A1, at least two self-replicating ranges (PSRR) of cells, each range containing at least one cell;

at least two of said ranges comprising a self-replicating set (PSRS) and having different addresses relative to the top leftmost cell A1 of the respective page on which each of said ranges is located;

wherein each time the content of a range of cells belonging to said set is updated, a self-replication operation is automatically performed, said self-replication operation comprising the steps of;

(1) automatically copying the changed range of cells onto a buffer;

(2) automatically defining the set of ranges of cells to which the changed range of cells belongs;

(3) automatically identifying the ranges of cells belonging to said set;

(4) establishing a self replication table containing a PSRR address, a PSRR pattern, a PSRS name, a set and range indices, and having a top record;

(5) setting the top record of the self replication table as the current record; and

(6) comparing the current record of the self replication table with the address of the range of cells that is updated;

the step of automatically updating all other PSRRs within a persistent self replicating set (PSRS) by;

a) detecting a PSRR content update;

b) retrieving the address of the updated PSRR; and

c) pasting the updated range of cells into the range of cells pointed by the PSRR address field of the current record of the self replication table.

13. The system according to claim 13, wherein the step of defining a set of ranges of cells further comprises the step of:

performing a persistent copy operation on a first range of cells, wherein said persistent copy operation comprises the steps of;

selecting a first range of cells;

copying the selected first range of cells onto a buffer;

performing a persistent paste operation, wherein said persistent paste operation comprises the steps of;

selecting at least one other range of cells; and

for each other selected range of cells, copying the content of said buffer onto each other'"'"'s others'"'"' selected range of cells; and

creating a link between each other range of cells and the first range of cells.

12. The system according to claim 13 further including the steps of adding a new range of cells to said set of ranges of cells, wherein said step of adding comprises selecting a new range of cells;

and

creating a link between the new range of cells with at least one range of cells belonging to said set of ranges of cells.

14. The system according to claim 13, wherein the step of performing a persistent copy operation further comprises the step of invoking a persistent copy command;

and wherein the step of performing a persistent paste operation further comprises the step of invoking a persistent paste command.

15. The system according to claim 13, wherein the step of defining a set of ranges of cells further comprises the steps of:

storing in a table a name for identifying said set of ranges of cells;

storing in said table, means for identifying each range of cells belonging to said set; and

creating a link in said table between the name of the set and said means for identifying each range of cells belonging to said set.

16. The system according to claim 15 wherein the step of defining a set of ranges of cells further comprises the step of associating the ranges of cells belonging to said defined set with set dependent display attributes.

17. The system according to claim 16, wherein the step of associating the ranges of cells belonging to said defined set, further comprises the steps of:

associating a first variable with said set of ranges of cells;

setting said first variable to a set dependent value; and

displaying the ranges of cells of said set with current attributes according to the value of said first variable.

18. The system according to claim 17, wherein the step of storing an identifying name in said table includes means for identifying each range of cells belonging to said set, and further comprises includes, for each range of cells belonging to said set, the steps of:

determining current attributes of said range of cells;

storing in said table said current attributes; and

associating in said table the range of cells with the current attributes.

19. The system according to claim 17, wherein the step of storing in said table said current attributes, comprises the further steps of:

associating a second variable with each range of cells; and

setting said second variable to a value associated with said current attributes.

20. The system according to claim 17, further comprising a step of removing a range of cells from the set of ranges of cells, wherein the step of removing said range of cells further comprises the steps of:

retrieving the current attributes associated with said range of cells; and

displaying said range of cells with said current display attributes.

21. A system of implementing a software product for a client, the software product capable of persistently self-replicating multiple ranges of cells through a copy and paste operation, in a multi dimensional spreadsheet comprising at least one page having a plurality of cells with content and identified by a cell address along each dimension, with the address of a top leftmost cell of each page labelled A1, a range of cells comprising one or a plurality of cells, comprising:

providing first instruction code for defining a set of ranges of cells, each range of cells having the same size, and at least two of said ranges having different addresses relative to the top leftmost cell A1 of the respective page on which each of said ranges are located; and

providing second instruction code for detecting each time the content of a range of cells belonging to said set is changed, and automatically performing a self-replication operation, said self-replication operation comprising the steps of;

automatically copying the changed range of cells onto a buffer;

automatically determining the set of ranges of cells to which the changed range of cells belongs;

automatically identifying the ranges of cells belonging to said set; and

automatically inserting the content of the buffer in each of identified range of cells belonging to said set by;

a) detecting a PSRR content update;

b) retrieving the address of the updated PSRR; and

c) pasting the updated range of cells into the range of cells pointed by the PSRR address field of the current record of the self replication table; and

utilizing a common repository to record data required to create, delete or rename a PSRS, to add a PSRR to a PSRS, or to suppress a PSRR from a PSRS, the recorded data including five fields comprising a PSRS name, a PSRR address, a PSRR pattern, a set index and a range index.