Patent US6701485B1 successfully refreshed from Google Patents.
US6701485B1
Expired / Lapsed
US
⏱️ 0.0 years remaining
Binding spreadsheet cells to objects
Assignee: Microsoft Technology Licensing LLC
•
Filing: 1999-06-15
•
Granted: 2004-03-02
•
Expires: 2019-06-15
Abstract
Abstract Spreadsheet cells are bound to external objects using a direct communication scheme having little processing overhead. A spreadsheet cell is bound to an object external to the spreadsheet, exposing a property or method of the object. The exposed property or method can then be used to update the value of the spreadsheet cell, either automatically when the exposed property changes, or in response to a request from the spreadsheet. The spreadsheet is preferably a spreadsheet COM control, which is embedded in a web page that is preferably browsed with a Microsoft INTERNET EXPLORER™ browser. The external object is also preferably embedded in the web page and may include an automatic control that is used to acquire data over a network such as the Internet.
Inventors
- 👤 Mark S. Igra
- 👤 Eric L. Matteson
- 👤 Andrew M. P. Milton
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-11-02 02:52
CPC Classifications
G; G06; G06F; G06F40/00; G06F40/10; G06F40/166; G06F40/177; G06F40/18
Claims Analysis
Total Claims: 34
Claim 1
Independent Claim
131 words
A method of binding a cell in a spreadsheet to an external object that is not included on the spreadsheet, comprising the steps of: (a) referencing the external object and a property of the external object in a formula within the cell of the spreadsheet; (b) parsing the formula to extract a reference to the external object and its property; (c) establishing a property change notice link between the spreadsheet and the external object based on the reference to the external object and its property; (d) forwarding a property change notice to the spreadsheet when the external object's property changes; (e) extracting the changed property from the external object and forwarding it to the spreadsheet; and (f) recalculating the formula in the cell using the changed property of the external object.
Claim 2
Independent Claim
131 words
A method of binding a cell in a spreadsheet to an external object that is not included on the spreadsheet, comprising the steps of: (a) referencing the external object and a property of the external object in a formula within the cell of the spreadsheet; (b) parsing the formula to extract a reference to the external object and its property; (c) establishing a property change notice link between the spreadsheet and the external object based on the reference to the external object and its property; (d) forwarding a property change notice to the spreadsheet when the external object's property changes; (e) extracting the changed property from the external object and forwarding it to the spreadsheet; and (f) recalculating the formula in the cell using the changed property of the external object.
Claim 3
Dependent Claim
31 words
The method of claim 1 , wherein the external object is associated with a function that automatically forwards the property change notice to the spreadsheet when the external object's property changes.
Claim 4
Dependent Claim
25 words
The method of claim 1 , further comprising the step of using a value calculated from the formula in the cell to recalculate the spreadsheet.
Claim 5
Dependent Claim
22 words
The method of claim 1 , wherein the property change notice is established by registering the spreadsheet as a change notification sink.
Claim 6
Dependent Claim
24 words
The method of claim 1 , wherein the external object is contained within a document, and the reference to the object identifies the document.
Claim 7
Dependent Claim
19 words
The method of claim 5 , wherein the spreadsheet comprises a spreadsheet control that is embedded in the document.
Claim 8
Dependent Claim
13 words
The method of claim 5 , wherein the document comprises a web page.
Claim 9
Dependent Claim
21 words
The method of claim 5 , wherein the external object comprises an automatic control that communicates data across a computer network.
Claim 10
Dependent Claim
15 words
A computer-readable medium having computer-executable instructions for performing the steps recited in claim 1 .
Claim 11
Independent Claim
129 words
A method for binding a cell in a spreadsheet to an external object that is not included on the spreadsheet, comprising the steps of: (a) creating a formula in the cell, said formula referencing an identity of the external object and a method or property exposed by the external object, wherein the external object comprises functional compiled code; (b) parsing the formula to extract the identity of the external object and the method or property exposed by the external object; and (c) binding the external object to the cell by establishing a link from the cell to the external object, so that the method exposed by the external object is executed or the property exposed by the external object is retrieved when a recalculation is performed on the cell.
Claim 12
Independent Claim
129 words
A method for binding a cell in a spreadsheet to an external object that is not included on the spreadsheet, comprising the steps of: (a) creating a formula in the cell, said formula referencing an identity of the external object and a method or property exposed by the external object, wherein the external object comprises functional compiled code; (b) parsing the formula to extract the identity of the external object and the method or property exposed by the external object; and (c) binding the external object to the cell by establishing a link from the cell to the external object, so that the method exposed by the external object is executed or the property exposed by the external object is retrieved when a recalculation is performed on the cell.
Claim 13
Dependent Claim
30 words
The method of claim 10 , wherein the external object is contained in or allowed access to a top-level document, and the formula includes an identification of the top-level document.
Claim 14
Dependent Claim
27 words
The method of claim 11 , wherein the top-level document references an identifier for the external object and the method or property exposed by the external object.
Claim 15
Dependent Claim
74 words
The method of claim 11 , wherein the step of binding the external object to the cell comprises the steps of: (a) obtaining an identifier for the method or property exposed by the external object, by accessing an interface for the top-level document; and (b) invoking interface for the top-level document with the identifier to access the method or property exposed by the external object in response to a request to recalculate the cell.
Claim 16
Dependent Claim
14 words
The method of claim 11 , wherein the top-level document comprises a web page.
Claim 17
Dependent Claim
20 words
The method of claim 14 , wherein the spreadsheet comprises a spreadsheet control that is embedded in the web page.
Claim 18
Dependent Claim
25 words
The method of claim 15 , wherein the spreadsheet control is viewed with a browser that displays a value for the cell after the recalculation.
Claim 19
Dependent Claim
34 words
The method of claim 11 , wherein the external object comprises an automatic control that is contained in the top-level document, the automatic control being able to automatically retrieve data from external data sources.
Claim 20
Dependent Claim
15 words
A computer-readable medium having computer-executable instructions for performing the steps recited in claim 10 .
Claim 21
Independent Claim
172 words
A system for binding a cell in a spreadsheet to an external object that is not included on the spreadsheet, comprising: (a) a memory in which are stored a plurality of machine instructions; and (b) a processor, coupled to the memory, for implementing a plurality of functions when executing the machine instructions stored in the memory, said plurality of functions including: (i) enabling a user to reference the external object and a property of the external object in a formula within the cell of the spreadsheet; (ii) parsing the formula to extract a reference to the external object and its property; (iii) establishing a property change notice link between the spreadsheet and the external object based on the reference to the external object and its property; (iv) forwarding a property change notice to the spreadsheet when the external object's property changes; (v) extracting the changed property from the external object and forwarding it to the spreadsheet; and (vi) recalculating the formula in the cell using the changed property of the external object.
Claim 22
Independent Claim
172 words
A system for binding a cell in a spreadsheet to an external object that is not included on the spreadsheet, comprising: (a) a memory in which are stored a plurality of machine instructions; and (b) a processor, coupled to the memory, for implementing a plurality of functions when executing the machine instructions stored in the memory, said plurality of functions including: (i) enabling a user to reference the external object and a property of the external object in a formula within the cell of the spreadsheet; (ii) parsing the formula to extract a reference to the external object and its property; (iii) establishing a property change notice link between the spreadsheet and the external object based on the reference to the external object and its property; (iv) forwarding a property change notice to the spreadsheet when the external object's property changes; (v) extracting the changed property from the external object and forwarding it to the spreadsheet; and (vi) recalculating the formula in the cell using the changed property of the external object.
Claim 23
Dependent Claim
31 words
The system of claim 19 , wherein the external object is associated with a function that automatically forwards the property change notice to the spreadsheet when the external object's property changes.
Claim 24
Dependent Claim
31 words
The system of claim 19 , wherein execution of the machine instructions further implements the function of using a value calculated from the formula in the cell to recalculate the spreadsheet.
Claim 25
Dependent Claim
22 words
The system of claim 19 , wherein the property change notice is established by registering the spreadsheet as a change notification sink.
Claim 26
Dependent Claim
40 words
The system of claim 19 , wherein a plurality of data and machine instructions comprising a document are stored in the memory, the external object is contained within the document, and the reference to the external object identifies the document.
Claim 27
Dependent Claim
44 words
The system of claim 23 , wherein the spreadsheet comprises a spreadsheet control comprising data and machine instructions that are embedded in the document, execution of the machine instructions comprising the spreadsheet control enabling said control to provide a spreadsheet functionality within the document.
Claim 28
Dependent Claim
28 words
The system of claim 23 , wherein the document comprises a web page, and the machine instructions further comprise a browser application program for viewing the web page.
Claim 29
Dependent Claim
41 words
The system of claim 23 , wherein the processor is connected to a computer network, and the external object includes an automatic control comprising machine instructions stored in the memory that cause the processor to communicate data across the computer network.
Claim 30
Independent Claim
179 words
A method of binding a cell in a spreadsheet to an external object that is not within the spreadsheet, said external object being associated with one or more properties, comprising the steps of: (a) providing the external object that is not within the spreadsheet, the external object comprising compiled code, internal data, and being associated with a property that provides a service to the spreadsheet; (b) referencing the external object and the property of the external object in a formula within the cell of the spreadsheet; (c) parsing the formula to extract a reference to the external object and its property; (d) establishing a property change notice link between the spreadsheet and the external object based on the reference to the external object and its property; (e) forwarding a property change notice to the spreadsheet when the external object's property changes, resulting in a changed property; (f) obtaining the changed property from the external object and forwarding the changed property to the spreadsheet; and (g) recalculating the formula in the cell using the changed property of the external object.
Claim 31
Independent Claim
179 words
A method of binding a cell in a spreadsheet to an external object that is not within the spreadsheet, said external object being associated with one or more properties, comprising the steps of: (a) providing the external object that is not within the spreadsheet, the external object comprising compiled code, internal data, and being associated with a property that provides a service to the spreadsheet; (b) referencing the external object and the property of the external object in a formula within the cell of the spreadsheet; (c) parsing the formula to extract a reference to the external object and its property; (d) establishing a property change notice link between the spreadsheet and the external object based on the reference to the external object and its property; (e) forwarding a property change notice to the spreadsheet when the external object's property changes, resulting in a changed property; (f) obtaining the changed property from the external object and forwarding the changed property to the spreadsheet; and (g) recalculating the formula in the cell using the changed property of the external object.
Claim 32
Dependent Claim
42 words
The method of claim 27 , wherein the step of referencing the external object and the property of the external object in the formula within the cell of the spreadsheet comprises the step of referencing a default property of the external object.
Claim 33
Dependent Claim
46 words
The method of claim 27 , wherein the step of referencing the external object and the property of the external object in the formula within the cell of the spreadsheet comprises the step of referencing a specific property included in a table of properties, by name.
Claim 34
Dependent Claim
132 words
The method of claim 27 , wherein: (a) the step of referencing the external object and a property of the external object in a formula within the cell of the spreadsheet comprises the step of referencing the property of the external object by referencing a type of the property, and (b) the step of establishing the property change notice link between the spreadsheet and the external object comprises the steps of: (i) querying the external object to determine each property of the external object; (ii) comparing each property of the external object with the type of property referenced in the formula; and (iii) establishing a property change notice link between the spreadsheet and the property of the external object that most closely corresponds to the type of property referenced in the formula.
References Cited (Backward Citations)
US5255363A
Cited
US5883623A
Cited
US5708827A
Cited
US5485617A
Cited
US6034681A
Cited
US5911066A
Cited
US5581677A
Cited
US5721847A
Cited
US6199082B1
Cited
US6157934A
Cited
US5768158A
Cited
US6122649A
Cited
US6401099B1
Cited
US5983268A
Cited
US6192379B1
Cited
US6292809B1
Cited
US6301590B1
Cited
US6256649B1
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 2007-03-02 | 2007-09-01 | 2008-03-02 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2011-03-02 | 2011-09-01 | 2012-03-02 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2015-03-02 | 2015-09-01 | 2016-03-02 | $7700.00 | Window Closed / Lapsed |