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

• US 5,502,805 A
• Filed: 06/16/1993
• Issued: 03/26/1996
• 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, Anderson, Charles R., Liaw, Weikuo, Warfield, Robert W., Bush, Alan M., Low, Murray K.
• Primary Examiner(s): Herndon, Heather R.
• Assistant Examiner(s): Feild, Joseph H.
• Application Number:
  US08/078,877
• Time in Patent Office: 1,014 Days
• Field of Search: 395/145, 395/148, 395/149, 395/156-160, 395/600, 395/155, 395/161, 340/710, 340/711, 345/163, 364/401
• 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 including a processor, a storage device storing an electronic spreadsheet having a plurality of two-dimensional information-cell matrices, referred to as pages, that define a three-dimensional information-cell matrix, a screen device, and a pointing device for generating a first set of at least one signal designating locations on the screen device and a second set of at least one signal indicating at least one type of event at the designated screen location, a method for allowing a computer user to inspect and modify values corresponding to properties of objects displayed on the screen device, the method comprising operating the computer system to perform the steps of:

displaying said three-dimensional information-cell matrix on the screen device as a selected one of the plurality pages and a row of page identifiers for each of at least some of the other pages, wherein selecting a displayed page identifier causes the corresponding page to be displayed;

any given page of information cells in the three-dimensional matrix having a first set of properties with corresponding values;

any given selected block having a second set of properties with corresponding values, the second set of properties having at least one property that is not in said first set of properties;

in response to signals that-include a given type of event, if that given type of event is within a particular page identifier, displaying a dialog box that includes a first list containing the first set of properties, each property on the first list being selectable, and a dialog pane containing elements for indicating and setting values corresponding to the selected property in the first list; and

in response to signals that include the same given type of event, if that same given type of event is within a particular selected block of information cells, displaying a dialog box that includes a second list containing the second set of properties, each property on the second list being selectable, and a dialog pane containing elements for indicating and setting values corresponding to the selected property in the second list.

2. The method of claim 1, wherein said selected property is displayed on a tab extending from an edge of the dialog pane.

3. The method of claim 1, wherein the pointing device is a mouse device, and further comprising the step of displaying a cursor on the screen device to provide a visible indication of the designated location.

4. The method of claim 1, wherein said first set of properties includes page name.

5. The method of claim 1, wherein said second set of properties includes format, font, and color.

6. The method of claim 1, wherein:

said pointing device is a mouse device;

said second set of at least one signal includes at least first and second types of signals in response to at least two respective types of user activation of said mouse device;

said first and second types of signals indicate said given type of event and an additional type of event; and

the method further includes invoking actions for an object of interest in response to said additional type of event.

7. The method of claim 1, further comprising:

changing values corresponding to properties for the object of interest by entering new values for selected ones of the values associated with the properties.