US5883623A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and methods for building spreadsheet applications
Assignee: Borland Software Corp
•
Filing: 1997-04-21
•
Granted: 1999-03-16
•
Expires: 2017-04-21
Abstract
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). 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.
Inventors
- 👤 Istvan Cseri
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 12:48
CPC Classifications
G; G06; G06F; G06F8/00; G06F8/30; G06F8/38; G06F3/00; G06F3/01; G06F3/048; G06F3/0481; G06F3/0483; G06F40/00; G06F40/10; G06F40/103; G06F40/117; G06F40/12; G06F40/166; G06F40/177; G06F40/18; G06F9/00; G06F9/06; G06F9/44; G06F9/451; Y; Y10; Y10S; Y10S715/00; Y10S715/973
Claims Analysis
Total Claims: 22
Claim 1
Independent Claim
196 words
In a computer system having a memory and a storage device for storing data in a plurality of cell objects, a method for linking user interface objects to other objects, the method comprising: (a) providing a plurality of user interface objects, each user interface object being associated with at least one event; (b) defining for each object in the system a set of properties and a set of link objects, each link object for storing information for characterizing a link between a source object and a destination object, and wherein at least some objects maintain lists of links for determining what objects they are linked to; (c) in response to user input, linking an event of a particular user interface object to a particular property of at least one other object through use of a particular link object, wherein said link object stores information characterizing a particular linkage between the objects; and (e) upon occurrence of the linked event associated with the particular user interface object, determining all other objects linked to the particular user interface object and triggering an automatic change in value to the property of said at least one other object being linked.
Claim 2
Dependent Claim
196 words
In a computer system having a memory and a storage device for storing data in a plurality of cell objects, a method for linking user interface objects to other objects, the method comprising: (a) providing a plurality of user interface objects, each user interface object being associated with at least one event; (b) defining for each object in the system a set of properties and a set of link objects, each link object for storing information for characterizing a link between a source object and a destination object, and wherein at least some objects maintain lists of links for determining what objects they are linked to; (c) in response to user input, linking an event of a particular user interface object to a particular property of at least one other object through use of a particular link object, wherein said link object stores information characterizing a particular linkage between the objects; and (e) upon occurrence of the linked event associated with the particular user interface object, determining all other objects linked to the particular user interface object and triggering an automatic change in value to the property of said at least one other object being linked.
Claim 3
Dependent Claim
22 words
The method of claim 1, wherein said user interface objects include selected ones of an edit field, scroll bar, and screen button.
Claim 4
Dependent Claim
17 words
The method of claim 1, wherein said properties of an object include displayed attributes of the object.
Claim 5
Dependent Claim
24 words
The method of claim 1, wherein events for a user interface object include events triggered as a result of action performed by the object.
Claim 6
Dependent Claim
21 words
The method of claim 1, wherein events for user interface object include events triggered as a result of input from user.
Claim 7
Dependent Claim
41 words
The method of claim 1, wherein said change in value to the property of said at least one object linked comprises a change in value to a property of said at least one object being linked other than an object's value.
Claim 8
Dependent Claim
40 words
The method of claim 1, wherein said linking an event of a particular user interface object to a particular property of at least one object includes: displaying a dialog listing events which can occur at said particular user interface object.
Claim 9
Dependent Claim
32 words
The method of claim 1, wherein step (e) includes: upon occurrence of the linked event associated with the particular user interface object, determining all objects which have been linked to the event.
Claim 10
Dependent Claim
19 words
The method of claim 1, wherein properties for objects comprise attribute values other than values stored by the objects.
Claim 11
Dependent Claim
127 words
In a computer system having a memory and a storage device for storing data in a plurality of objects, a method for linking properties of objects together, the method comprising: (a) providing a plurality of objects, each object having a set of display properties affecting how the object is displayed (b) displaying a dialog for connecting a particular property of one object to respective properties of an arbitrary number of other objects; (c) in response to user input, linking the particular property of said one object to a corresponding property for each of the other objects; and (e) upon occurrence of a change in value to particular property of said one object, automatically propagating changes to values of the corresponding property for each of the other objects.
Claim 12
Dependent Claim
127 words
In a computer system having a memory and a storage device for storing data in a plurality of objects, a method for linking properties of objects together, the method comprising: (a) providing a plurality of objects, each object having a set of display properties affecting how the object is displayed (b) displaying a dialog for connecting a particular property of one object to respective properties of an arbitrary number of other objects; (c) in response to user input, linking the particular property of said one object to a corresponding property for each of the other objects; and (e) upon occurrence of a change in value to particular property of said one object, automatically propagating changes to values of the corresponding property for each of the other objects.
Claim 13
Dependent Claim
14 words
The method of claim 10, wherein said one object comprises a user interface control.
Claim 14
Dependent Claim
27 words
The method of claim 10, wherein said occurrence of a change in value to particular property of said one object occurs as a result of user input.
Claim 15
Dependent Claim
61 words
The method of claim 10, further comprising: (f) selecting a property of a first object to monitor; (g) linking a corresponding property of at least one second object to that of the first object; and (h) upon change in value of the property of the first object, propagating said change to the property of all said at least one second object.
Claim 16
Dependent Claim
126 words
In a computer system, a method for linking objects together comprising: storing a plurality of objects; storing for each object in the system a set of properties, inlets, and outlets, wherein inlets for an object include actions which may be performed by the object, and wherein outlets for an object include events which may occur at the object; storing a set of link objects, each link object for storing information for characterizing a link between a source object and a destination object; storing for each object a list of other objects linked to said each object; receiving input for changing at least one object; and using said link objects, updating a change in the one object to other objects which are linked to said one object.
Claim 17
Dependent Claim
126 words
In a computer system, a method for linking objects together comprising: storing a plurality of objects; storing for each object in the system a set of properties, inlets, and outlets, wherein inlets for an object include actions which may be performed by the object, and wherein outlets for an object include events which may occur at the object; storing a set of link objects, each link object for storing information for characterizing a link between a source object and a destination object; storing for each object a list of other objects linked to said each object; receiving input for changing at least one object; and using said link objects, updating a change in the one object to other objects which are linked to said one object.
Claim 18
Dependent Claim
18 words
The method of claim 14, wherein said plurality of objects include user interface objects for receiving user input.
Claim 19
Dependent Claim
17 words
The method of claim 14, wherein said properties of an object include display attributes of the object.
Claim 20
Dependent Claim
12 words
The method of claim 14, wherein said objects include user interface objects.
Claim 21
Dependent Claim
22 words
The method of claim 14, wherein events for an object include events triggered as a result of actions performed by the object.
Claim 22
Dependent Claim
21 words
The method of claim 14, wherein events for an object include events triggered as a result of input from a user.
References Cited (Backward Citations)
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2002-03-15 | 2002-09-14 | 2003-03-16 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2006-03-15 | 2006-09-14 | 2007-03-16 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2010-03-15 | 2010-09-14 | 2011-03-16 | $7700.00 | Window Closed / Lapsed |