Spreadsheet program which implements alternative range references

• US 5,371,675 A
• Filed: 06/03/1992
• Issued: 12/06/1994
• Est. Priority Date: 06/03/1992
• Status: Expired due to Term

• Current Assignee: International Business Machines Corporation
• Original Assignee: Lotus Development Corporation (International Business Machines Corporation)
• Inventors: Landsman, Richard A., Balaban, Robert, Greif, Irene
• Primary Examiner(s): Envall, Jr., Roy N.
• Assistant Examiner(s): SHINGALA, GITA
• Application Number:
  US07/893,084
• Time in Patent Office: 916 Days
• Field of Search: 364/419, 364/419.1, 364/419.12, 364/419.18, 364/419.19, 364/419.07, 395/161, 395/148, 395/152
• US Class Current: 715/220
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A computer programmed to represent a spreadsheet that can be displayed to a user, the spreadsheet including an array of cells for storing user entered data, the programmed computer including programmed logic for designating a group of one or more cells within the spreadsheet, the group of one or more cells containing a first set of user entered data; programmed logic for creating an alternative for the group of one or more cells, said alternative containing a second set of user entered data that is different from the first set of user entered data; and programmed logic for enabling the user to select between the group of one or more cells and the alternative as the source of the data that is used in a corresponding group of cells within the spreadsheet.

Claims

1. A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising:

computer implemented means for designating a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data, said range containing less than all of the cells of said spreadsheet;

computer implemented means for creating an alternative for said range of one or more cells in said spreadsheet, said alternative containing a second set of user entered data that is different from said first set of user entered data; and

computer implemented means for displaying a list of alternative sources of data that are available for said range in said spreadsheet, said list of alternative sources of data including said alternative;

computer implemented means for designating said alternative on said list of alternative sources of data; and

computer implemented means for selecting the designated alternative as the source of the data that is used in the range of one or more cells within said spreadsheet.

2. The programmed computer of claim 1 wherein said group of one or more cells is a range of contiguous cells within said spreadsheet.

3. The programmed computer of claim 2 further comprising means for generating one or more event objects that are linked to said alternative, said one or more event objects containing historical information about said alternative.

4. The programmed computer of claim 3 wherein said historical information includes a date of creation of said alternative and a name of a user who created said alternative.

5. The programmed computer of claim 3 further comprising means for modifying said alternative and wherein said historical information includes a date of modification of said alternative and a name of a user who modified said alternative.

6. The programmed computer of claim 2 further comprising means for generating a note object that is linked to said alternative, said note object containing userentered annotations.

7. A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising:

computer implemented means for designating a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data elements, said range containing less than all of the cells of said spreadsheet;

computer implemented means for generating a plurality of alternatives for said range of one or more cells in said spreadsheet, each alternative of said plurality of alternatives containing a corresponding set of user entered data elements that is different from said first set of user entered data elements and from the set of user entered data elements for the other of said plurality of alternatives; and

computer implemented means for displaying a list of said plurality of alternatives;

computer implemented means for designating any alternative among the displayed list; and

computer implemented means for selecting the designated alternative as a source of data that is used in said range of one or more cells within said spreadsheet.

8. The programmed computer of claim 7 wherein said group of one or more cells is a range of contiguous cells within said spreadsheet.

9. The programmed computer of claim 7 further comprising means for generating an ordered list for storing the user entered data elements of all the plurality of alternatives.

10. The programmed computer of claim 9 further comprising means for generating a hash value for the user entered data elements of the plurality of alternatives and wherein the user entered data elements for the plurality of alternatives is stored in the ordered list in order of the generated hash values.

11. The programmed computer of claim 10 wherein the list includes a plurality of entries each of which stores a unique data element of said user entered data elements of said plurality of alternatives and having a hash value derived for the data element stored therein, the entries in said list being sequentially ordered by said hash values.

12. A computer programmed to represent a spreadsheet that is displayed to a user, said spreadsheet comprising an array of cells storing user entered data, said programmed computer comprising:

computer implemented means for designating a plurality of ranges within said spreadsheet, each of said plurality of ranges in said spreadsheet being a corresponding plurality of cells from said array of cells, each of said plurality of ranges of cells containing an associated set of user entered data, each of the ranges of said plurality of ranges in said spreadsheet containing less than all of the cells of said spreadsheet;

computer implemented means for creating an alternative for each of said plurality of ranges in said spreadsheet, each of said alternatives containing an associated set of user entered data that is different from the user entered data associated with the range to which that alternative corresponds;

computer implemented means for enabling the user to designate a subset of said plurality of alternatives to form a scenario; and

computer implemented means for displaying a list of alternative sources of data that are available for use in said spreadsheet, said list of alternative sources of data including said scenario;

computer implemented means for designating said scenario on said list of alternative sources of data; and

computer implemented means for selecting the designated scenario as the source of data that is used in said plurality of ranges in said spreadsheet.

13. The programmed computer of claim 12 further comprising means for generating one or more event objects that are linked to said scenario, said one or more event objects containing historical information about said scenario.

14. The programmed computer of claim 13 wherein said historical information includes a date of creation of said scenario and a name of a user who created said scenario.

15. The programmed computer of claim 13 further comprising means for modifying said scenario and wherein said historical information includes a date of modification of said scenario and a name of a user who modified said scenario.

16. The programmed computer of claim 12 further comprising means for generating a note object that is linked to said scenario, said note object containing user-entered annotations.

17. A computer programmed to store a plurality of data elements, wherein at least some of said data elements in said plurality of data elements are duplicates, said programmed computer comprising:

computer implemented means for generating a hash value for each of said plurality of data elements; and

computer implemented means for generating a list of entries, said list of entries storing all of said plurality of data elements, each of said entries holding a unique one of said plurality of data elements and having an associated hash value derived from that corresponding data element by said generating means, the entries in said list being sequentially ordered by said associated hash values.

18. The programmed computer of claim 17 wherein said list is a linked list.

19. The programmed computer of claim 18 wherein said list is a doubly linked list.

20. A computer implemented method of representing a spreadsheet, said spreadsheet comprising an array of cells storing user entered data, said computer implemented method comprising:

using a computer input device to designate a range of one or more cells within said spreadsheet as a group of one or more cells, said group of one or more cells containing a first set of user entered data;

using the computer to create an alternative for said group of one or more cells, said alternative containing a second set of user entered data that is different from said first set of user entered data, said group of one or more cells and said alternative representing user selectable alternative sources of the data that is used in said range of one or more cells within said spreadsheet; and

using the computer to store both said spreadsheet and said alternative in a memory as part of a single computer readable file.