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

• US 5,784,545 A
• Filed: 04/10/1995
• Issued: 07/21/1998
• Est. Priority Date: 04/08/1992
• Status: Expired due to Fees

• Current Assignee: Borland Software Corporation (Open Text Corporation)
• Original Assignee: Borland International, Inc. (Open Text Corporation)
• Inventors: Liaw, Weikuo, Bush, Alan M., Anderson, Charles R., Warfield, Robert W., Cseri, Istvan, Low, Murray K.
• Primary Examiner(s): Zimmerman, Mark K.
• Assistant Examiner(s): Feild, Joseph H.
• Application Number:
  US08/420,522
• Time in Patent Office: 1,198 Days
• Field of Search: 395/148, 395/149, 395/155, 395/157, 395/158, 395/159, 395/160, 395/161, 395/600, 364/400-408
• 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 an electronic spreadsheet system for storing and manipulating information, a computer-implemented method of representing a three-dimensional spreadsheet on a screen display, the method comprising:

displaying on said screen display a first spreadsheet page from a plurality of spreadsheet pages, each of said spreadsheet pages comprising an array of information cells arranged in row and column format, at least some of said information cells storing user-supplied information and formulas operative on said user-supplied information, each of said information cells being uniquely identified by a spreadsheet page identifier, a column identifier, and a row identifier, said plurality of spreadsheet pages being stored in a single disk file;

while displaying said first spreadsheet page, displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page, each said spreadsheet page identifier being displayed as an image of a notebook tab on said screen display and indicating a single respective spreadsheet page, wherein at least one spreadsheet page identifier of said displayed row of spreadsheet page identifiers comprises at least one user-settable identifying character;

receiving user input for requesting display of a second spreadsheet page in response to selection with an input device of a spreadsheet page identifier for said second spreadsheet page;

in response to said receiving user input step, displaying said second spreadsheet page on said screen display in a manner so as to obscure said first spreadsheet page from display while continuing to display at least a portion of said row of spreadsheet page identifiers; and

receiving user input for entering a formula in a cell on said second spreadsheet page, said formula including a cell reference to a particular cell on another of said spreadsheet pages having a particular spreadsheet page identifier comprising at least one user-supplied identifying character, said cell reference comprising said at least one user-supplied identifying character for said particular spreadsheet page identifier together with said column identifier and said row identifier for said particular cell.

2. The method of claim 1, wherein said displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page step includes:

displaying said row of spreadsheet page identifiers along a horizontal side of said first spreadsheet page.

3. The method of claim 1, wherein said displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page step includes:

displaying said row of spreadsheet page identifiers along a bottom side of said first spreadsheet page.

4. The method of claim 1, wherein said at least one user-settable identifying character for said first spreadsheet page is initially set by said system to a default name.

5. The method of claim 1, further comprising the step, performed by said computer system in response to receiving user input, of changing said at least one user-settable identifying character for the spreadsheet page identifier of said first spreadsheet page to a user-supplied page name label describing contents of said first spreadsheet page.

6. The method of claim 5, wherein a particular formula stored on said second spreadsheet page includes a cell reference to a cell on said first spreadsheet page, and wherein said method further comprises the step, performed by said system in response to changing said at least one user-settable identifying character for the spreadsheet page identifier of said first spreadsheet page to a user-supplied page name label, of changing the page identifier for the cell reference of said particular formula to said user-supplied page name label.

7. The method of claim 6, wherein said particular formula stores said cell reference to the cell on said first spreadsheet page with a general format of:

space="preserve" listing-type="tabular">______________________________________ <

page name label of first spreadsheet page>

;

<

cell column>

<

cell ______________________________________ row>

.

8. The method of claim 1, further comprising:

receiving user input for selecting one of said plurality of spreadsheet pages; and

indicating to the user a currently-selected spreadsheet page by displaying the notebook tab for said selected spreadsheet page with a difference appearance than notebook tabs for others of said plurality of spreadsheet pages.

9. The method of claim 8, wherein said indicating step includes displaying said notebook tab of said selected spreadsheet page as an extension of said selected spreadsheet page and displaying notebook tabs for others of said plurality of spreadsheet pages as if extending out from under said selected spreadsheet page.

10. The method of claim 8, wherein said indicating step includes displaying said notebook tab of said selected spreadsheet page with a first screen background color and displaying said notebook tabs of others of said plurality of spreadsheet pages with a second screen background color.

11. The method of claim 10, wherein said first screen background color is white, and wherein said second screen background color is gray.

12. The method of claim 1, wherein said displaying a row of spreadsheet page identifiers step includes displaying, at any given time, only spreadsheet page identifiers for some of said plurality of spreadsheet pages.

13. The method of claim 12, further comprising:

receiving user input for displaying a particular spreadsheet page identifier which is not currently displayed and, thereupon, displaying said particular spreadsheet page identifier.

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

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

16. The method of claim 15, wherein said group step comprises:

receiving user input for selecting a first spreadsheet page;

receiving user input for selecting a second spreadsheet page, the user input defining a selection of spreadsheet pages spanning from said first selected spreadsheet page to said second selected spreadsheet page;

receiving user input for instructing the system to group together spreadsheet pages; and

grouping together all spreadsheet pages spanning from said first selected spreadsheet page to said second selected spreadsheet page.

17. The method of claim 16, wherein said receiving user input for selecting a first spreadsheet page comprises receiving user input for selecting the notebook tab for said first selected spreadsheet page.

18. An electronic spreadsheet system for storing and manipulating information comprising:

a computer having a processor and a memory, said memory storing said information in a three-dimensional spreadsheet;

a screen display for presenting said three-dimensional spreadsheet as a plurality of spreadsheet pages, each of said spreadsheet pages comprising an array of information cells arranged in row and column format, at least some of said information cells storing user-supplied information, each of said information cells being uniquely identified by a spreadsheet page identifier, a column identifier and a row identifier;

a storage device for storing said plurality of spreadsheet pages in a single disk file;

means for displaying a first spreadsheet page on said screen device and simultaneously displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page, each said spreadsheet page identifier being displayed as an image of a notebook tab on said screen display and indicating a single respective spreadsheet page, wherein at least one spreadsheet page identifier of said displayed row of spreadsheet page identifiers comprises at least one user-settable identifying character;

a first input means for receiving user input for requesting display of a second spreadsheet page in response to selection with said first input means of a spreadsheet page identifier for said second spreadsheet page;

means, responsive to said first input means, for displaying said second spreadsheet page on said screen display in a manner so as to obscure said first spreadsheet page from display while continuing to display at least a portion of said row of spreadsheet page identifiers; and

a second input means for receiving user input for entering a formula in a cell on said second spreadsheet page, said formula including a cell reference to a particular cell on another of said spreadsheet pages having a particular spreadsheet page identifier comprising at least one user-supplied identifying character, said cell reference comprising said at least one user-supplied identifying character for said particular spreadsheet page identifier together with said column identifier and said row identifier for said particular cell.

19. The system of claim 18, wherein said means for displaying a first spreadsheet page on said screen device and simultaneously displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page includes:

means for displaying said row of spreadsheet page identifiers along a horizontal side of said first spreadsheet page.

20. The system of claim 18, wherein said means for displaying a first spreadsheet page on said screen device and simultaneously displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page includes:

means for displaying said row of spreadsheet page identifiers along a bottom side of said first spreadsheet page.

21. The system of claim 18, wherein said at least one user-settable identifying character for said first spreadsheet page is initially set by said system to a default name.

22. The system of claim 18, further comprising:

means, responsive to user input, for changing said at least one user-settable identifying character for the spreadsheet page identifier of said first spreadsheet page to a user-supplied page name label describing contents of said first spreadsheet page.

23. The system of claim 22, wherein a particular formula stored on said second spreadsheet page includes a cell reference to a cell on said first spreadsheet page, and wherein said system further comprises:

means, responsive to changes of said at least one user-settable identifying character for the spreadsheet page identifier of said first spreadsheet page to a user-supplied page name label, for changing the page identifier for the cell reference of said particular formula to said user-supplied page name label.

24. The system of claim 23, wherein said particular formula stores in said memory said cell reference to the cell on said first spreadsheet page with a general format of:

space="preserve" listing-type="tabular">______________________________________ <

page name label of first spreadsheet page>

;

<

cell column>

<

cell ______________________________________ row>

.

25. The system of claim 18, further comprising:

means for receiving user input for selecting one of said plurality of spreadsheet pages; and

means for indicating to the user a currentlyselected spreadsheet page, said indicating means including means for displaying the notebook tab for said selected spreadsheet page with a different appearance than notebook tabs for others of said plurality of spreadsheet pages.

26. The system of claim 25, wherein said indicating means includes:

means for displaying said notebook tab of said selected spreadsheet page as an extension of said selected spreadsheet page; and

means for displaying notebook tabs for others of said plurality of spreadsheet pages as if extending out from under said selected spreadsheet page.

27. The system of claim 25, wherein said indicating means includes:

means for displaying said notebook tab of said selected spreadsheet page with a first screen background color; and

means for displaying said notebook tabs of others of said plurality of spreadsheet pages with a second screen background color.

28. The system of claim 27, wherein said first screen background color is white, and wherein said second screen background color is gray.

29. The system of claim 18, wherein said means for displaying a row of spreadsheet page identifiers includes:

means for displaying, at any given time, only spreadsheet page identifiers for some of said plurality of spreadsheet pages.

30. The system of claim 29, further comprising:

means for receiving user input for displaying on said screen display a particular spreadsheet page identifier which is not currently displayed; and

means, responsive to said means for receiving user input for displaying a particular spreadsheet page identifier which is not currently displayed, for displaying said particular spreadsheet page identifier.

31. The system of claim 18, further comprising:

means, responsive to user input, for modifying values displayed in cells in said second spreadsheet page while displaying on said screen display said second spreadsheet page.

32. The method of claim 18, further comprising:

means, responsive to user input, for grouping together desired ones of said spreadsheet pages, so that a spreadsheet operation in any one spreadsheet page of the group propagates to other spreadsheet pages of the group.

33. The system of claim 32, wherein said grouping means comprises:

means for receiving user input for selecting a first spreadsheet page;

means for receiving user input for selecting a second spreadsheet page, the user input defining a selection of spreadsheet pages spanning from said first selected spreadsheet page to said second selected spreadsheet page;

means for receiving user input for instructing the system to group together spreadsheet pages; and

means for grouping together all spreadsheet pages spanning from said first selected spreadsheet page to said second selected spreadsheet page.

34. The system of claim 33, wherein said means for receiving user input for selecting a first spreadsheet page comprises:

means for receiving user input for selecting the notebook tab for said first selected spreadsheet page.

35. In an electronic spreadsheet system for storing and manipulating information, a method of representing a three-dimensional spreadsheet on a screen display, the method comprising:

(a) displaying on said display a first spreadsheet page from a plurality of spreadsheet pages, each of said spreadsheet pages comprising an array of information cells arranged in row and column format, at least some of said information cells storing user-supplied information and formulas operative on said user-supplied information, each of said information cells being uniquely identified by a row, a column, and a spreadsheet page identifier;

(b) while displaying said first spreadsheet page, displaying a row of spreadsheet page identifiers along one side of said first spreadsheet page, each said spreadsheet page identifier being displayed as an image of a notebook tab on said screen display and indicating a single respective spreadsheet page, wherein;

i) each of said notebook tabs comprises at least one user supplied identifying character, said user supplied identifying character used as said spreadsheet page identifier for cells on spreadsheet pages associated with their respective notebook tabs,

ii) said user supplied information in said rows and columns of information cells for each of said plurality of spreadsheet pages is stored in a single disk file, and

iii) each of said plurality of said spreadsheet pages in said three-dimensional spreadsheet is associated with a unique one of said spreadsheet identifiers;

(c) requesting display of a second spreadsheet page in response to selection with an input device of a spreadsheet page identifier for said second spreadsheet page;

(d) in response to said requesting step, displaying said second spreadsheet page from said single disk file on said screen display in a manner so as to obscure said first spreadsheet page from display while continuing to display at least a portion of said row of spreadsheet page identifiers; and

(e) using said spreadsheet page identifiers to identify a cell in a desired spreadsheet page when entering said formulas.