System and methods for improved spreadsheet interface with user-familiar objects

• US 5,463,724 A
• Filed: 03/14/1995
• Issued: 10/31/1995
• Est. Priority Date: 04/08/1992
• Status: Expired due to Term

• Current Assignee: Borland Software Corporation (Open Text Corporation)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Cseri, Istvan, Low, Murray K., Liaw, Weikuo, Bush, Alan M., Anderson, Charles R., Warfield, Robert W.
• Primary Examiner(s): Herndon, Heather R.
• Assistant Examiner(s): FEILD, JOSEPH H
• Application Number:
  US08/405,663
• Time in Patent Office: 231 Days
• Field of Search: 395/148, 395/157-159, 395/155, 395/160-161, 395/149, 364/401, 345/24-25
• US Class Current: 715/209
• CPC Class Codes: G06F 3/0481 based on specific properties of the displayed interaction object or a metaphor-based environment, e.g. interaction with desktop elements like windows or icons, or assisted by a cursor's changing behaviour or appearance
• CPC Class Codes: G06F 3/0483 Interaction with page-structured environments, e.g. book metaphor
• CPC Class Codes: G06F 40/10 Text processing natural language analysis G06F40/20; semantic analysis G06F40/30; processing or translation of natural language G06F40/40
• CPC Class Codes: G06F 40/103 Formatting, i.e. changing of presentation of documents automatic justification G06F40/189; automatic line break hyphenation G06F40/191
• CPC Class Codes: G06F 40/117 Tagging; Marking up details of markup languages G06F40/143; Designating a block; Setting of attributes style sheets, e.g. eXtensible Stylesheet Language Transformation [XSLT], G06F40/154
• CPC Class Codes: G06F 40/12 Use of codes for handling textual entities
• CPC Class Codes: G06F 40/18 of spreadsheets form-filling G06F40/174
• CPC Class Codes: G06F 8/38 for implementing user interfaces
• CPC Class Codes: G06F 9/451 Execution arrangements for user interfaces
• CPC Class Codes: Y10S 715/973 Scroll tool, e.g. window scroll bar

Abstract

An electronic spreadsheet system of the present invention includes a notebook interface having a plurality of notebook pages, each of which may contain a spread of information cells, or other desired page type (e.g., Graphs page). Methods are provided for rapidly accessing and processing information on the different pages, including displaying a plurality of page identifiers for selecting individual pages, and further including a preferred syntax for referencing information. Additional methods are provided for editing cells and blocks of cells.

Claims

1. In a computer system comprising a processor coupled to a storage device, a display, and an input device, a method of processing three-dimensional spreadsheet information comprising the steps, performed by the computer system, of:

displaying a first page array of rows and columns of cells on said display, said cells for displaying data values stored in said storage device and for displaying calculated values from spreadsheet formulas based on data values stored in said storage device, each cell having a unique cell address formed from a page, a row, and a column location for the cell, said first page array obscuring a plurality of other page arrays including second and third page arrays, said first, second, and third page arrays being stored in a single disk file;

while displaying said first page array, displaying first, second, and third page identifiers identifying said first, second, and third page arrays, respectively, with said first page identifier appearing as a notebook tab and having a user-settable page name label for identifying said first page array, and said second and third page identifiers appearing as notebook tabs and each having a user-settable page name label for identifying said second and third page arrays, respectively, said first page array having a spreadsheet formula storing a cell address for a given cell located on said second page array, said stored cell address comprising said user-settable page name label for said second page array and row and column locations for said given cell;

selecting said second page array of cells in response to input from said user input device; and

in response to said selecting step, displaying said second page array of cells while simultaneously displaying said first, second, and third page identifiers, with said second page array obscuring said first and third page arrays, said second page identifier appearing as a notebook tab for identifying said second page array, and said first and third page identifiers appearing as notebook tabs for identifying said first and third page arrays, respectively.

2. The method of claim 1, wherein said displaying first, second, and third page identifiers step includes:

displaying said first, second, and third page identifiers along one side of said first page array.

3. The method of claim 2, wherein said step of displaying said first, second, and third page identifiers along one side of said first page array includes:

displaying said first, second, and third page identifiers along a horizontal side of said first page array.

4. The method of claim 2, wherein said step of displaying said first, second, and third page identifiers along one side of said first page array includes:

displaying said first, second, and third page identifiers along a bottom side of said first page array.

5. The method of claim 1, wherein said user-settable page name label associated with said second page identifier includes a default name.

6. The method of claim 5, wherein said default name comprises a single alphabetic character.

7. The method of claim 5, further comprising the step, performed by said computer system in response to user input, of receiving user input for changing said default name associated with said second page identifier to a user-supplied name.

8. The method of claim 1, wherein said user-settable page name label associated with said second page identifier comprises alphanumeric information describing contents of said second page array.

9. The method of claim 7, further comprising the step, performed by said computer system in response to receiving user input for changing said default name associated with said second page identifier, of updating said stored cell address so that said user-settable page name label for said second page array comprises said user-supplied name.

10. The method of claim 1, wherein said calculated values displayed on said first page array are calculated at least in part from values corresponding to cells in others of said page arrays.

11. The method of claim 10, wherein said stored cell address for a cell located on said second page array comprises a cell reference having a general format of:

<

name of second page array>

;

<

cell column>

<

cell row>

.

12. The method of claim 1, wherein a notebook tab for a given page array has displayed thereon an icon indicative of the contents of the given page array.

13. The method of claim 1, further comprising the step, performed by said computer system, of distinguishing a visual representation of said notebook tab of said first page array from said notebook tabs of said second and third page arrays while displaying said first page array.

14. The method of claim 13, wherein said distinguishing step includes displaying said notebook tab of said first page array as an extension of said first page array and displaying said notebook tabs of said second and third page arrays as if extending out from under said first page array.

15. The method of claim 13, wherein said distinguishing step includes displaying said notebook tab of said first page array with a different color from said notebook tabs of said second and third page arrays.

16. The method of claim 1, further comprising the step of displaying a plurality of additional page identifiers in addition to said first, second, and third page identifiers, wherein said first, second, and third page identifiers are distributed among said plurality of additional page identifiers.

17. The method of claim 1, further comprising the step, performed by said computer system in response to user input, of modifying values displayed in cells in said second page array when displaying said second page array.

18. The method of claim 1, further comprising the step, performed by said computer system in response to user input, of grouping together desired ones of said page arrays, so that a spreadsheet operation in any one page array of the group propagates to other page arrays of the group.