System and methods for building spreadsheet applications

• US 5,623,591 A
• Filed: 09/10/1993
• Issued: 04/22/1997
• 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
• Primary Examiner(s): Feild, Joseph H.
• Application Number:
  US08/120,329
• Time in Patent Office: 1,320 Days
• Field of Search: 395/148, 395/155, 395/159, 395/600, 395/161, 395/164
• US Class Current: 715/762
• 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 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). The system includes a spreadsheet application development module having a user interface (UI) builder. The UI builder provides "live" links between system objects. In particular, link commands are provided as statements a developer may attach to a control to indicate what should happen when an end-user activates or changes the control. Link commands usually specify three things: an event, an action, and an object. The event indicates what occurrence should trigger the link command; the action indicates what should happen. The object is what should be acted upon. One control can have many link commands. In operation, a link command can send a value to a cell in the notebook, run a macro, close a dialog box, change the zoom factor in the notebook, or the like.

Claims

1. In an electronic spreadsheet system having a memory and a storage device for storing data in a plurality of cell objects, each of said cell objects having a set of properties including a value property, each of the set of properties have associated values, a method for defining selected user interaction with a given cell object, the method comprising:

in response to first user input, generating a user interface object of a predefined type distinct from cell objects, said user interface object having a set of properties including a value property;

in response to second user input, linking said value property of the given cell object with said value property of said user interface ojbect;

displaying said user interface object with a value of said value property corresponding to the value of said value property of the given cell object; and

in response to end-user input that effects a change in the value of said value property of said user interface object, propagating the change to the given cell object so that the given cell object has its value of said value property set to said changed value of said value property of said user interface object.

2. The method of claim 1, wherein said predefined type of user interface object is one of a plurality of predefined types of user interface object, said plurality of types including an edit field, a scroll bar, and a screen button.

3. The method of claim 1, wherein said set of cell object properties includes a particular display-attribute property, the method further comprising:

in response to third user input, generating an additional user interface object of a predefined additional type distinct from cell objects, said additional user interface object having a set of properties including said display-attribute property;

linking said display-attribute property of an additional given cell object to that of said additional user interface object; and

in response to end-user input that specifies a change in value of the display-attribute property of said additional user interface object, propagating said change to the display-attribute property of said additional given cell object.

4. The method of claim 3, wherein:

said additional user interface object is a color control; and

said display-attribute property of an object includes the color of the object.

5. The method of claim 1, wherein:

said objects have inlets and outlets; and

inlets for an object include actions which are performed by the object.

6. The method of claim 1, wherein:

said objects have inlets and outlets; and

outlets for an object include events which occur at the object.

7. In a digital computer, a system for linking objects in an electronic spreadsheet together, the system comprising:

means for storing a plurality of objects, including at least one cell object and at least one user interface object distinct from cell objects;

means for storing for each object in the system a set of properties, inlets, and outlets, each cell object having a plurality of properties;

means for storing links between objects

means for generating user interface objects in response to user input, said user interface objects including at least first and second types having respective first and second ones of said plurality of properties that characterize each cell object;

said first and second types of user interface object being operable to set values for the respective first and second properties of cell objects to which said first and second types of user interface object are linked;

means, responsive to user input, for specifying a link between (a) a particular user interface object generated by said means for generating user interface objects, said particular user interface object having one of said first and second types, and (b) a particular cell object, said particular user interface object, so linked to said particular cell object expressing a value of the property corresponding to the value of the property for the particular cell object;

means for receiving input for changing the value of said particular user interface object'"'"'s property; and

means for communicating said change in said particular user interface object'"'"'s property to said particular cell object so that said particular cell object expresses a value of said particular cell object'"'"'s property corresponding to the value of said particular user interface object'"'"'s property, so changed.

8. The system of claim 7, further comprising:

means for receiving input for changing the value of said particular cell object'"'"'s property; and

means for communicating said change in said particular cell object'"'"'s property to said particular user interface object so that said particular user interface object expresses a value of its property corresponding to the value of said particular cell object'"'"'s property, so changed.

9. The system of claim 7, wherein said properties of an object include display attributes of the object.

10. The system of claim 7, wherein inlets for an object include actions which are performed by the object.

11. The system of claim 7, wherein outlets for an object include events which occur at the object.

12. The system of claim 7, wherein said particular user interface object is a selected one of a scroll bar, a radio button, and a check box.

13. In an electronic spreadsheet comprising a plurality of information cells, each information cell having a plurality of properties including a value property and a display-attribute property, which properties have associated values that are subject to being modified, a method for linking user interface controls to information cells, said user interface controls for receiving end-user input for said electronic spreadsheet, the method comprising:

receiving first user input for generating a user interface control of a selected one of a plurality of different types for receiving end-user input, the types of user interface control including first and second types, each characterized by a particular property, which is the value property for the first type and the display-attribute property for the second type;

in response to receiving said first user input, generating a user interface control of a desired one of the first and second types, as designated by the user input;

displaying the user interface control, so generated;

receiving second user input for linking the user interface control, so generated, to at least one desired information cell;

in response to receiving said second user input, linking the user interface control to a given information cell;

the user interface control, so linked to the given information cell, expressing a value of the interface control'"'"'s particular property corresponding to the value of the given information cell'"'"'s particular property, and further being operable to modify the value of the given information cell'"'"'s particular property;

receiving end-user input at the user interface control specifying a change in the value of the particular property expressed by the user interface control to a new value;

determining whether the user interface control has been linked to any information cells; and

updating all information cells determined to be linked to the user interface control, based on the end-user input received, so that the information cells, so updated, have their values of the particular property set to said new value.

14. The method of claim 13, wherein said types of user interface control include an edit field, a scroll bar, and a screen button.

15. The method of claim 13, wherein said end-user input comprises a selected one of keyboard input and pointing device input.

16. The method of claim 13, wherein said step of receiving second user input for linking the user interface control includes:

receiving user input for invoking a link command, said link command specifying an action to be performed by a particular user interface control in response to occurrence of a particular event.

17. The method of claim 16, wherein said particular event comprises an event of a type signifying that a value has changed.

18. The method of claim 16, wherein:

the electronic spreadsheet includes a spreadsheet macro; and

said link command is executed from the spreadsheet macro.