Method for hiding and showing spreadsheet cells

• US 5,255,356 A
• Filed: 12/14/1992
• Issued: 10/19/1993
• Est. Priority Date: 05/31/1989
• Status: Expired due to Term

• Current Assignee: Microsoft Technology Licensing LLC (Microsoft Corporation)
• Original Assignee: Microsoft Corporation
• Inventors: Michelman, Eric H., Ben-Hur, Devin E.
• Primary Examiner(s): Herndon, Heather R.
• Application Number:
  US07/990,409
• Time in Patent Office: 309 Days
• Field of Search: 395/144-149, 395/155-161
• US Class Current: 715/217
• CPC Class Codes: G06F 40/177 of tables; using ruled lines
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174

Abstract

A method for hiding and showing spreadsheet cells of a worksheet being displayed on a computer system display means. The hiding and showing is based upon hierarchical relationships among the spreadsheet cells. This technique is implemented by first determining hierarchical relationships among cells based on cell indentation, content, and formulas. A group of contiguous cells having a common hierarchical relationship is then selected and hidden. Totals for the group of cells may then be shown in place of hidden cells. The hidden group of cells may be stored in a memory location other than main memory such as a magnetic or optical disk. The group of cells may then be retrieved from memory and shown on the display means.

Claims

1. In a computer having a display device, an entry device, and a processor for executing a spreadsheet program, the spreadsheet program causing a plurality of intersecting rows and columns to be displayed on the display device, some of the plurality of rows having a predefined relationship with other rows, the predefined relationship being either dominant or subordinate, a method of hiding selected ones of the plurality of rows comprising the steps of:

a) automatically identifying a dominant row having a dominant relationship to at least one subordinate row;

b) automatically selecting the at least one subordinate row having a subordinate relationship to the dominant row; and

c) hiding the selected at least one subordinate row such that the at least one subordinate row is not displayed on the display device.

2. The method of claim 1 wherein each of the plurality of rows has a ranked indentation level and the step of selecting the at least one subordinate row further comprises the step of comparing the ranked indentation levels of a subset of the plurality of rows with the ranked indentation level of the dominant row to determine if a subordinate relationship exists between the rows in the subset and the dominant row.

3. The method of claim 2 wherein each of the rows in the subset has a beginning and each contains at least one blank space and the step of comparing the ranked indentation levels comprises the steps of:

counting the number of blank spaces at the beginning of each of the rows in the subset;

assigning a ranked indentation level to each of the rows in the subset using the counted number of the blank spaces; and

comparing the ranked indentation level of the each of the rows in the subset to the indentation level of the dominant row.

4. The method of claim 2 wherein the step of comparing the ranked indentation levels comprises the steps of:

identifying the subset of the plurality of rows to be a group of contiguous rows displayed below the dominant row;

determining the indentation level of each of the rows in the subset; and

comparing the indentation level of each of the rows int he subset with the indentation level of the dominant row.

5. The method of claim 1 wherein each of the plurality of rows has a row label containing text and the step of automatically selecting the at least one subordinate row further comprises:

comparing the text contained in the row labels of a subset of the plurality of rows with the text contained in the row label of the dominant row to locate a row having a row label including the text contained in the row label of the dominant row and additional text indicating a total row or a summary row; and

identifying as the at least one subordinate row at least one of the rows displayed between the dominant row and the located row.

6. The method of claim 1 wherein the columns have column headers indicating time periods and the method further comprises the steps of:

automatically selecting at least one of the columns by examining the column headers to determine time-based groupings;

hiding the at least one selected column; and

displaying at least one summary column containing totals of the hidden columns.

7. The method of claim 6 further comprising the step of displaying the selected at least one column in response to a predefined signal from the entry device.

8. The method of claim 1 further comprising the step of displaying the hidden at least one subordinate row in response to a predefined signal from the entry device.

9. The method of claim 1 further comprising the steps of:

replacing the dominant row on the display device with a summary row containing totals of the at least one subordinate row; and

replacing the at least one subordinate row on the display device with rows that have not been hidden, thereby compressing the spreadsheet to create a summary view.

10. The method of claim 9 further comprising the step of constructing and displaying a label for the summary row from the label of the dominant row.

11. The method of claim 1 further comprising the steps of:

selecting a referring row not within the at least one subordinate row that contains a first formula, the first formula referring to a row within the at least one subordinate row;

storing the first formula of the selected referring row; and

replacing the first formula of the selected referring row with a second formula that uses a constant to replace the reference to the row within the at least one subordinate row.

12. The method of claim 11 further comprising the steps of:

retrieving the at least one subordinate row;

retrieving the stored first formula; and

replacing the second formula of the selected referring row with the retrieved first formula.

13. The method of claim 1 wherein the step of automatically identifying a dominant row comprises the step of identifying a parent row in response to a predefined signal from the entry device.

14. In a computer having a processing unit, an entry device coupled to the processing unit, a display device coupled to the processing unit, and a spreadsheet program being executed by the CPU, the spreadsheet program having a plurality of rows, the rows including at least one parent row and at least one child row, the child row having a predefined relationship to the parent row, the rows having row labels, the spreadsheet program causing a portion of the rows to be displayed on the display device, a method of hiding selected rows comprising the steps of:

a) identifying the parent row;

b) automatically selecting the at least one child row by comparing each of the row labels of a subset of the rows with the row label of the parent row to determine if the predefined relationship between the parent row and the child row exists; and

c) hiding the selected at least one child row such that the selected at least one child row is not displayed on the display device.

15. The method of claim 14 wherein the row labels have ranked indentation levels and the step of automatically selecting the at least one child row further comprises the step of comparing the indentation levels of each row label of a subset of the rows with the indentation level of the row label of the parent row to determine if the predefined relationship exists.

16. The method of claim 15 wherein at least one of the plurality of rows has a blank row label and the step of comparing indentation levels comprises assigning a maximum indentation level to at least one of the plurality of rows having a blank row label.

17. The method of claim 14 wherein the row labels contain text and the step of automatically selecting the at least one child row further comprises the steps of:

comparing the text contained in each row label of a subset of the rows with the text contained in the row label of the parent row to locate a row having a row label including the text contained in the row label of the parent row and additional text indicating a total row or a summary row; and

identifying as the selected child row at least one of the rows displayed between the parent row and the located row.

18. The method of claim 14, the spreadsheet having a plurality of columns intersecting the rows, the plurality of columns having column headers indicating time periods, the method further comprising the steps of:

selecting at least one of the plurality of columns by examining the column headers to determined time-based groupings;

hiding the selected at least one column; and

displaying at least one summary column containing totals of the hidden columns.

19. The method of claim 14 further comprising the step of displaying the hidden at least one child row in response to a predefined signal from the entry device.

20. The method of claim 14 further comprising the steps of:

replacing the parent row on the display device with a summary row containing totals of the selected at least one child row; and

replacing the selected at least one child row on the display device with rows that have not been selected, thereby compressing the spreadsheet display to create a summary view.

21. The method of claim 20 further comprising the step of constructing and displaying a label for the summary row from the label of the parent row.

22. The method of claim 14 further comprising the steps of:

selecting a referring row not within the selected at least one child row that contains a first formula, the first formula referring to a cell within the group of children rows;

storing the first formula of the selected referring row; and

replacing the first formula of the selected referring row with a second formula that uses a constant to replace the reference to the row within the selected at least one child row.

23. The method of claim 22 further comprising the steps of:

retrieving the selected at least one child row;

retrieving the stored first formula; and

replacing the second formula of the selected referring row with the retrieved first formula.

24. In a computer having random access memory (RAM), a processing unit coupled to the RAM, an entry means coupled to the processing unit, a display means coupled to the processing unit, and a spreadsheet program being executed by the processing unit, the spreadsheet program having a plurality of rows, the plurality of rows including at least one parent row, at least one child row, and at least one total row, the child row having a predefined relationship to the parent row, the total row containing a formula indicative of the predefined relationship of the child row to the parent row, the spreadsheet program causing a portion of the plurality of rows to be displayed on the display means, a method of hiding selected rows comprising the steps of:

a) identifying the parent row;

b) automatically identifying the total row by examining the contents of a subset of the plurality of rows to locate a row containing a formula indicative of the predefined relationship of the child row to the parent row;

c) automatically selecting the at least one child row by selecting at least one of the rows displayed between the parent row and the total row; and

d) hiding the selected at least one child row such that the selected at least one child row is not displayed on the display means.

25. The method of claim 24 further comprising the steps of:

replacing the parent row on the display means with the total row; and

replacing the selected at least one child row on the display device with rows that have not been selected, thereby compressing the spreadsheet to create a summary view.